Oracle to PostgreSQL Migration Architect

Overview In this role you lead strategic Oracle-to-PostgreSQL migrations, designing cloud-ready database architectures and minimizing downtime. You collaborate with cross-functional teams to map dependencies and drive secure, scalable schema conversions. You will optimize performance and ensure data integrity during migration, leveraging cloud services and migration tools. This position offers impact by enabling reliable database modernization in a cloud-first environment. ResponsibilitiesAssessment & Strategy: plan migration roadmap, analyze TCO, map application dependenciesMigration Design: craft scalable PostgreSQL schemas, convert PL/SQL objects to PL/pgSQLTechnical Execution: perform data migrations with SCT/DMS, Ora2Pg, pgloaderPerformance Optimization: tune PostgreSQL, optimize indexes and queriesTroubleshooting & Support: resolve data-type mismatches, replication issues, post-migration support Key requirementsOracle Database Administration proficiencyPL/SQL and SQL performance tuningPostgreSQL internals, PL/pgSQLExperience with SCT, DMS, Ora2PgCloud platform knowledge (AWS RDS/Aurora or Azure)Python, Bash, or Perl scripting for automation10+ years Oracle DBADM experience with 3+ years in Oracle-to-PostgreSQL migrationExcellent communicationStakeholder managementProblem-solvingOracle PL/SQLPostgreSQL PL/pgSQLAWS SCT