Lead Database Migration Engineer

Ovii's Interpretation of the Role

Lead Database Migration Engineer responsible for end‑to‑end heterogeneous database migrations from Oracle and SQL Server to PostgreSQL/Aurora PostgreSQL, using AWS DMS and SCT and rebuilding procedural logic in PL/pgSQL. Provides technical leadership, authoring runbooks, and coordinating with cross‑functional teams to ensure reliable cutovers and post‑migration validation.

Role Snapshot

• Lead end‑to‑end database migrations
• Design and manage AWS DMS/SCT pipelines
• Convert Oracle/SQL Server logic to PL/pgSQL
• Author migration runbooks and execute cutovers
• Guide migration teams and ensure quality

Must-Have Requirements

• AWS Database Migration Service (DMS)
• AWS Schema Conversion Tool (SCT)
• Oracle PL/SQL
• SQL Server T‑SQL
• PostgreSQL / Aurora PostgreSQL
• PL/pgSQL
• Database performance tuning
• Backup & restore
• Failover testing
• Migration runbook authoring
• database architecture
• migration delivery

Nice-to-Have Signals

• Leading migration teams or mentoring engineers
• Broader AWS cloud migration program experience
• leading migration teams
• broader AWS cloud migration
• AWS cloud migration

Work Setup

• Location: Mumbai, India
• Work mode: REMOTE
• Remote scope: UNSPECIFIED
• Employment type: Full-Time

Application Requirements

• Coding test mentioned
• Assessment mentioned

Not Specified in JD

• Salary range
• Visa sponsorship
• Remote eligibility details
• Travel requirements

What You'll Likely Work On

• Lead full‑cycle migration initiatives, from assessment through post‑migration validation
• Configure and operate AWS DMS and SCT environments to ensure performance and reliability
• Create detailed migration runbooks covering execution steps, validation checkpoints, and rollback plans
• Perform migration assessments, dependency analysis, and compatibility reviews to shape migration strategy
• Collaborate with infrastructure, application, security, and platform teams to align migration outcomes
• Drive functional, performance, and failover testing to certify production readiness
• Provide technical guidance to migration teams and enforce AWS migration best practices
• Refactor Oracle PL/SQL and SQL Server T‑SQL business logic into PL/pgSQL, addressing gaps identified by SCT

Good Fit If You Have

• Experience leading migration teams or mentoring engineers
• Hands‑on involvement in broader AWS cloud migration programs
• Proven ability to tune production database performance and manage failover testing