Lead Database Migration Engineer
New
Mumbai, MHFull-TimeLead
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 8–12 years
- Required Skills
- PostgreSQLMicrosoft SQL ServerOracle
Requirements
- 8–12 years of professional experience in database architecture and migration delivery.
- Hands-on expertise in AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT).
- Deep proficiency in Oracle, SQL Server, PostgreSQL, and Aurora PostgreSQL environments.
- Proven background in delivering heterogeneous database migrations across on-premises and cloud environments.
- Knowledge of production database operations, including backup, restore, parameter tuning, and failover testing.
- Skills in authoring and executing migration runbooks, validation plans, and cutover procedures.
- Strong understanding of AWS database services and integration with cloud migration programs.
- Experience engaging directly with enterprise customers and architecture teams.
- Strong hands-on experience converting Oracle PL/SQL and SQL Server T-SQL business logic to PL/pgSQL.
- Ability to identify and remediate SCT action items and manual conversion gaps in procedural code.
Responsibilities
- Lead end-to-end database migration initiatives, including assessment, planning, schema conversion, execution, and post-migration validation.
- Design, configure, and manage AWS DMS and SCT environments while ensuring migration quality, performance, and reliability.
- Author comprehensive migration runbooks that define execution procedures, validation checkpoints, rollback plans, and operational readiness activities.
- Perform database migration assessments, dependency analysis, compatibility reviews, and migration strategy recommendations.
- Collaborate with infrastructure, application, security, and platform teams to ensure successful migration outcomes.
- Drive migration testing activities, including functional validation, performance testing, failover testing, and production readiness reviews.
- Provide technical leadership and guidance to migration teams while ensuring adherence to AWS migration best practices and governance standards.
- Lead conversion and refactoring of procedural database code into PostgreSQL/Aurora PostgreSQL PL/pgSQL.
View Full Description & ApplyYou'll be redirected to the employer's site
