Lead Database Migration Engineer

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) 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.