Mactores - Lead Database Migration Engineer - PostgreSQL

Mactores; Kolkata District; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Mactores is seeking a senior Database Migration Architect to lead end-to-end migrations using AWS DMS and SCT. You will convert Oracle PL/SQL and SQL Server T-SQL to PostgreSQL, design runbooks, and collaborate with cross-functional teams to ensure production-ready deployments.

8–12 years of experience in database architecture and migration delivery, with deep knowledge of heterogeneous migrations across on-premises, cloud, and AWS environments.

Qualifications

• Hands-on expertise with AWS DMS and SCT for enterprise-scale migrations.
• Proficient in Oracle, SQL Server, PostgreSQL, and Aurora PostgreSQL migration planning and execution.
• Experience delivering heterogeneous migrations across on-premises, cloud and AWS.
• Knowledge of backup/restore strategies, performance optimization and failover testing.

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 ensuring quality, performance and reliability.
• Author migration runbooks with execution steps, validations, rollback plans and readiness activities.
• Perform assessments, dependency analysis, compatibility reviews and migration strategy recommendations.
• Collaborate with infra, application, security and platform teams to ensure successful outcomes.
• Drive migration testing activities including functional validation, performance and failover testing.
• Provide technical leadership and governance aligned with AWS migration best practices.
• Lead conversion and refactoring of Oracle PL/SQL and SQL Server T-SQL to PostgreSQL/Aurora PostgreSQL PL/pgSQL, addressing semantic differences.

Skills

AWS DMS

AWS SCT

Oracle to PostgreSQL

PL/SQL to PL/pgSQL

T-SQL to PL/pgSQL

Migration governance

Leadership

Performance tuning

Job description

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 professional 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, cutover procedures, rollback strategies, and post-migration stabilization activities.
• Strong understanding of AWS database services, migration best practices, and integration with broader cloud migration programs.
• Experience engaging directly with enterprise customers, architecture teams, and migration stakeholders to drive successful delivery outcomes.
• Strong hands-on experience converting Oracle PL/SQL and SQL Server T-SQL business logic to PL/pgSQL, including handling of exception handling models, cursor semantics, autonomous transactions, sequences/identity columns, implicit data type conversions, and proprietary built-in packages/functions with no native PostgreSQL equivalent.
• Ability to identify and remediate SCT action items and manual conversion gaps in procedural code (e.g., DBMS_- packages, UTL_- utilities, SQL Server system procedures, dynamic SQL, and nested/recursive procedure calls) and validate converted logic through functional and regression testing.

You’ll Be Preferred If You

• Have tuned production database performance, backup and restore strategy, and failover testing in high-stakes environments.
• Have led migration teams or mentored engineers through complex conversions.
• Bring experience with broader AWS cloud migration programs beyond the database layer.