JOB DESCRIPTION
Job Title: Lead Database Engineer

Job Summary

We are looking for a Lead Database Engineer with robust 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, inde

📌 Lead Database Engineer (Pune)
🏢 Fulcrum Digital
📍 Pune