JOB DESCRIPTION

Job Title: Lead Database Engineer

Job Summary

We are looking for a
Lead Database Engineer
with solid 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 settings.
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

📌 Lead Database Engineer Pune Division
🏢 Fulcrum Digital
📍 Pune