Senior Database Migration Engineer (Oracle & PostgreSQL)

Job description

Mactores is the agent-native AWS modernization firm. Most modernization work doesn't ship, it stalls in pilots, slips a year, or lands at three times the budget. We exist to ship it: production systems running, legacy retired, outcomes measured. Our delivery is built on Aedeon, the agent platform built by Mactores' founders' sister company, which absorbs the repetitive 60–70% of engagement work, discovery, dependency mapping, validation, test generation, that traditional consulting bills human hours against. Forward-deployed engineers own the rest: architecture, judgment, and cutover, on dates we commit to in the contract. We are seeking an experienced Senior Database Developer to lead and support Oracle to PostgreSQL/Aurora PostgreSQL migration initiatives. The role involves deep hands-on work across SQL refactoring, schema conversion, DMS operations, performance tuning, and post–go-live stabilization. The candidate will work closely with application teams, cloud engineers, and stakeholders to ensure a smooth, performant, and compliant migration. ### What you will do? - Refactor and convert Oracle SQL, PL/SQL, and database objects to PostgreSQL-compatible SQL/PLpgSQL. - Analyze and remediate AWS SCT (Schema Conversion Tool) findings and limitations. - Manage and maintain Flyway migration codebase (versioned scripts, repeatable migrations, rollbacks). - Identify, troubleshoot, and fix database-related application bugs. - Perform query optimization for PostgreSQL (execution plans, indexing strategies, query rewrites). - Support and monitor AWS DMS during full load and CDC phases. - Diagnose and resolve DMS data and performance issues. - Perform data validation and reconciliation between Oracle and PostgreSQL. - Collaborate with application teams to align SQL behavior and performance expectations. ### What are we looking for? - Bachelor's degree in Computer Science or a related field. - 5+ years of experience as an Oracle/PostgreSQL DBA and database developer. - Strong experience with Oracle Database and PostgreSQL / Aurora PostgreSQL. - Hands-on expertise in Oracle to PostgreSQL migration. - Advanced SQL and query performance tuning skills. - Experience with AWS SCT and AWS DMS. - Knowledge of Flyway/Liquibase or similar schema migration tools. - PostgreSQL internals: indexing, statistics, execution plans. - AWS services: RDS/Aurora, CloudWatch, IAM (preferred). ### You will be preferred if: - Familiarity with automation and configuration management tools, such as Ansible, Chef, or Puppet. - Familiarity with IAAC tools such as Terraform, CloudFormation. - Familiarity with CI/CD implementation tools like Liquibase/Flyway. - AWS Certified Database – Specialty. - AWS Certified Solutions Architect.