David Kirk

Experience

• 

  United States Marine Corps

  Jun 1996 - May 1999

  Field artillery

  Specialized in the use of the Built Trumpeter 1/35 US Army M198 155mm Towed Howitzer

• 

  CDK Global

  May 2018 - Oct 2023

  • Orchestrated the development of an automated ETL pipeline for Heavy Equipment DMSSOR, streamlining data extraction processes and increasing data accuracy by 90%. • Led the maintenance, support, and development efforts for DMSSOR environments and ETL import/export processes, resulting in a 20% reduction in system downtime.• Engineered and implemented a complex database architecture featuring 100+ tables, 200+ columns, and indexes to optimize data warehouse infrastructure.• Integrated foreign key constraints to bolster data relationships, resulting in a 35% decrease in query execution time and a 20% enhancement in data retrieval efficiency.• Designed and managed SSIS packages for seamless data movement among 37 SQL Servers, increasing data transfer speed by 80% and enhancing overall database efficiency.• Improved a streamlined process to analyze and cross-reference data from import files to the data archive, resulting in a 100% increase in data accuracy and efficiency.• Constructed and administered SQL Agent Jobs to facilitate automated database updates, performance tracking, and notification mechanisms, optimizing data management processes and minimizing downtime risks.• Crafted detailed Runbooks for error handling and Knowledge Transfer, resulting in a 90% increase in team collaboration and knowledge sharing.• Streamlined troubleshooting procedures and documentation, leading to a 30% reduction in average resolution time and enhancing overall system stability during non-business hours.• Directed and executed a planned data transfer operation involving SQL servers, leveraging SSIS packages, SQL Agent jobs, and custom SQL code during designated Sunday maintenance windows.• Developed Data Archival processes to process, publish, and store RAW data from imported records. Show less • Orchestrated the optimization of SQL Server Database environments and ETL import and export processes, enhancing system performance by 40% and reducing data processing time by 25% through automation tools.• Orchestrated the engineering and optimization of database performance by formulating business rules to refine, convert, and filter data fields for the data warehouse. • Devised database triggers to automate processes, elevating query speed by 40% and diminishing data errors by 25%.• Implemented an on-call support system for ETL processes and DMSSOR outages, reducing system downtime by 25% and ensuring seamless operations during non-business hours.• Engineered and deployed advanced SSIS packages and SQL code during scheduled maintenance windows, streamlining data migration between SQL servers for Customer based business needs.environment. Show less

  • Software Engineer

    Jan 2019 - Oct 2023

  • Junior SQL ETL Engineer

    May 2018 - Dec 2018