Lead Database Engineer

We are looking for a Lead Database Engineer with strong experience in database migration consolidation and data engineering. The role will lead the migration of multiple legacy databases into a unified target schema while ensuring data integrity reconciliation performance and production readiness.

• Lead end-to-end migration and consolidation of multiple legacy databases into a single target schema.
  
• Perform data profiling source-to-target mapping transformation and master data/entity resolution.
  
• Develop and execute full-load incremental delta and CDC-based migration processes.
  
• Design reconciliation processes covering row counts checksums control totals financial balancing and exception reporting.
  
• Develop migration runbooks rollback plans rehearsal strategies and production cutover plans.
  
• Execute migrations across DEV QA UAT and Production environments.
  
• Develop and optimize complex T-SQL stored procedures functions triggers indexes and queries.
  
• Work with SQL Server/MSSQL IBM DB2 PostgreSQL and Oracle databases.
  
• Utilize Azure SQL Azure Data Factory SSIS Azure Storage Azure Key Vault DMA and Azure Database Migration Service.
  
• Implement database CI/CD using SSDT/DACPAC Flyway/Liquibase Azure DevOps or GitHub Actions.
  
• Ensure database security data masking encryption RBAC and audit requirements.
  
• Assess the impact of schema changes on Power BI SSRS batch interfaces and downstream applications.
  
• Use Python/PowerShell and AI-assisted tools for migration automation reconciliation and engineering productivity.
  
• Provide technical leadership and communicate migration risks data issues and reconciliation results to stakeholders.
  

• 812 years of database/data engineering experience with at least 2 end-to-end production data migrations.
  
• Expert knowledge of SQL Server 2016 T-SQL database internals performance tuning indexing execution plans statistics and partitioning.
  
• Mandatory experience consolidating multiple independent databases into a single target schema.
  
• Strong experience in ETL data migration data reconciliation master data management entity resolution and data quality.
  
• Hands-on experience with SQL Server/MSSQL IBM DB2 PostgreSQL and Oracle databases.
  
• Strong experience with Azure SQL Azure Data Factory SSIS Azure Storage and Azure Key Vault.
  
• Experience with DMA and Azure Database Migration Service is preferred.
  
• Experience with database DevOps CI/CD schema-as-code and version control.
  
• Strong scripting skills in Python and/or PowerShell.
  
• Good understanding of database security encryption data masking RBAC and data privacy.
  
• Strong communication documentation troubleshooting and stakeholder management skills.
  
• Practical experience using AI-assisted coding/data tools for SQL mappings migration scripts and documentation.
  

• Experience in Insurance F&I vehicle service contracts warranty claims billing or dealer remittance.
  
• Experience with multi-tenant data models and complex business rules.
  
• Exposure to Azure Synapse Databricks or Microsoft Fabric.
  
• Experience with Redgate ApexSQL dbForge or similar database comparison tools.
  
• Ability to understand Angular/.NET application code and trace data access paths.
  
• DP-300 or DP-203 certification.