Lead Database Engineer

Urgent !! Immediate joiner - Lead database engineer - Fulcrum digital - Hinjewadi P 3

Job Summary

Lead Database Engineer

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

• 1012 years

  of database/data engineering experience with at least 4

  end-to-end production data migrations

  .
• Expert knowledge of

  Azure SQL, 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 mandatory.