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 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

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