What you'll do?
- 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 Oracle PL/SQL (packages, procedures, functions, triggers,



cursors) and SQL Server T-SQL (stored procedures, functions, triggers) into PostgreSQL/Aurora PostgreSQL PL/pgSQL, resolving semantic and behavioral differences identified by SCT.

What we're looking for?
- 8 to 12 years of qualified 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 migrations.
- Deep proficiency in Oracle, SQL Server, PostgreSQL, and Aurora PostgreSQL environments, including migration planning, execution, and optimization.
- Proven background in delivering heterogeneous database migrations across on-premises, cloud, and AWS environments.
- Knowledge of production database operations, including backup and restore strategies, parameter tuning, performance optimization, and failover testing.
- Skills in authoring and executing migration runbo

📌 Mactores - Lead Database Migration Engineer - PostgreSQL (Kolkata Metropolitan Area)
🏢 Mactores
📍 Kolkata Metropolitan Area