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 runbooks, validation plans, cut

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