Source description
About the role
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 migration planning, execution, and optimization.
Proven background delivering heterogeneous database migrations across on-premises, cloud, and AWS environments.
Knowledge of production database operations: backup and restore strategies, parameter tuning, performance optimization, failover testing.
Skills 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 delivery outcomes.
Strong hands-on experience converting Oracle PL/SQL and SQL Server T-SQL business logic to PL/pgSQL — 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 (DBMS_* packages, UTL_* utilities, SQL Server system procedures, dynamic SQL, nested/recursive procedure calls) and validate converted logic through functional and regression testing.
More at Mactores