This is the sharp end of our Application & Database Modernization pillar. Enterprise customers are moving off Oracle and SQL Server — license renewals coming due, stored-procedure layers nobody fully understands, onto PostgreSQL and Aurora PostgreSQL. You'll own those heterogeneous migrations end to end: run the AWS DMS and SCT toolchain, then do the part the tools can't, rebuild procedural business logic in PL/pgSQL when SCT flags a gap it can't close on its own. You ship the runbook, you run the cutover, you validate the result. When the migration lands, it's yours.

What you'll do?
- Lead end-to-end database migration initiatives: assessment, planning, schema conversion, execution, and post-migration validation.
- Design, configure, and manage AWS DMS and SCT environments and own migration quality, performance, and reliability.
- Author the migration runbooks the cutover lives or dies by: execution procedures, validation checkpoints, rollback plans, operational readiness.
- Perform migration assessments, dependency analysis, compatibility reviews,



and migration strategy recommendations.
- Work with infrastructure, application, security, and platform teams to land migration outcomes.
- Drive migration testing: functional validation, performance testing, failover testing, production readiness reviews.
- Provide technical leadership to migration teams and hold the line on AWS migration best practices and governance standards.
- Lead conversion and refactoring of procedural database code — Oracle PL/SQL (packages, procedures, functions, triggers, cursors) and SQL Server T-SQL (stored procedures, functions, triggers), into PostgreSQL/Aurora PostgreSQL PL/pgSQL, resolving the semantic and behavioral differences SCT identifies.

What we're looking for?
- 8–12 years of skilled experience in database architecture and migration delivery
- Hands-on expertise in AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT) for enterprise-scale database migra

📌 Lead Database Migration Engineer (India)
🏢 Mactores
📍 India