Lead Database Engineer

JOB DESCRIPTION Job Title: Lead Database Engineer Job Summary 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. Key Responsibilities - 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. Required Skills & Experience - 8–12 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. Good to Have - 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.