The customer is modernizing a large, legacy relational database estate on AWS. You will lead the migration and modernization of complex Oracle, SQL Server, and PostgreSQL workloads to AWS - primarily to Aurora PostgreSQL and, where applicable, Oracle Database @AWS (ODB@AWS) - including schema/PL SQL conversion, cutover, and validation.
Key Responsibilities:
Design and execute migrations of relational databases (Oracle, SQL Server, PostgreSQL) to AWS (Aurora PostgreSQL, RDS, ODB@AWS).
Perform schema and PL/SQL conversion/refactoring; plan and run migration waves (assessment cutover validation tuning).
Produce target state data models, migration runbooks, ADRs, and guidance for application teams.
Ensure migrated databases meet security and compliance requirements (least privilege IAM, KMS encryption at rest/in transit).
Must Have
Relational databases (Level 400): Deep hands on with at least two of Oracle, SQL Server, PostgreSQL; advanced SQL and PL/SQL.
Database migration to AWS (Level 300 400): Proven delivery migrating production databases to Aurora PostgreSQL / RDS, using AWS DMS and SCT (Schema Conversion Tool).