Collaborated on an asynchronous ETL application (Extract Transform Load) to routinely migrate financial transactions for a government entity handling statewide financial data

Features:

• Orchestrated multiple SSIS packages to asynchronously migrate ~1M financial and transactional records daily
• Indexed relevant columns and followed best practices in table normalization to optimize query performance
• Configured Change-Data-Capture (CDC) to monitor data changes and replace existing triggers impacting performance
• Created user functions and staging tables to accommodate time zone differences in UTC and to track changes
• Collaborated with Database Administrators to implement High Availability and Disaster Recovery (HADR) redundancy