Kevin Picklesimer Email & Phone Number

United States

Boston, Massachusetts, Us

Boston, Massachusetts, Us

Boston, Massachusetts, Us

Louisville, Kentucky, Us

• Led two engineering teams: one of Java developers focused on data-driven backend applications, and one of Database Reliability Engineers (continuation of previous position) building and maintaining PostgreSQL and Oracle infrastructure at scale• Proposed and drove business-wide initiative to consolidate disparate data sources into a cloud EDW for faster, more cost-effective, and accessible reporting• Streamlined and categorized incoming work requests so a smaller team could manage as effectively• Improved employee engagement and motivation (and therefore productivity) by focusing on 1-on-1’s and protecting what engineers find most important for their work• Managed annual budget, cost analyses, capacity planning, and vendor licensing and relationships• Implemented and maintained security best practices at hardware, software and user layers

Louisville, Kentucky, Us

• Led operations team toward a cloud-first, automation-first mentality aligned with department vision• Adapted processes to maintain availability and reliability for a rapidly growing number of flexible data stores that serve data-driven events and notifications• Reevaluated and tuned critical alert rules, resulting in reduction of after-hours pages to DBA’s by 80%• Used change management methods to integrate new team responsibilities following company re-orgs• Used project management methods and Atlassian tools to ensure IT projects were delivered efficiently• Implemented KanBan board for team workflow as part of an initiative to adopt Agile methodologies• Ensured compliance with various standards: HIPAA, PCI, CJIS, NIST, SOC 2

Louisville, Kentucky, Us

• Worked on a team of DBA’s to provide day-to-day 24x7 mission-critical operational support and maintenance for 100 Oracle and PostgreSQL databases• Administered all aspects of database instances including configuration, installation, upgrades, patches and migrations according to business and application requirements• Maintained logical and physical replication solutions for Disaster Recovery. Regularly tested recovery of backup solutions.• Developed database packages, procedures and functions with PL/SQL and PL/pgSQL• Developed shell scripts to automate all routine maintenance, maintaining changes in the code with Apache Subversion• Collaborated with application teams to migrate on-premises PostgreSQL databases to AWS RDS• Utilized PostgreSQL triggers and table inheritance to design a robust partitioning system that handles millions of application audit records per day• Implemented log monitoring with SumoLogic and developed alerts and reports to fulfill HIPAA requirements• Provided database and feature support as requested by software engineers, data analysts, the BI team and others across the enterprise• Utilized exceptional analytical skills to quickly troubleshoot issues• Administered and utilized Oracle Enterprise Manager Cloud Control (11g, 12c, 13c) for centralized database performance monitoring across the enterprise. Developed User-Defined Metrics and Metric Extensions for custom early-warning alerts at the application and database layers. Used native EDK to develop plugin for monitoring PostgreSQL.

• Independently researched, designed and developed predictive proprietary algorithms that had a direct impact on the company’s revenue stream• Utilized WAMP stack and Oracle to integrate historical data from diverse sources with near-term statistics to facilitate in-depth analysis• Developed dynamic web-based user interfaces that allowed employees with limited computer skills to easily query data sets and analyze and visualize what-if scenarios• Designed and implemented tools to extract and convert information from public web-based databases• Designed and maintained extensive local relational databases to back-test and optimize models• Employed data mining techniques to analyze data sets to recognize and extract patterns and correlations• Continually upgraded the quality, functionality, and sophistication of all tools and models to better leverage the available data and support the user base

Bachelor Of Science - Bs, Business Administration

Computer Science, Mechanical Engineering