Senior DB Migration Engineer: Oracle to PostgreSQL on AWS

Mactores

United States

Remote

USD 120,000 - 170,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Mactores is a leading AWS modernization firm focused on delivering production-ready migrations and cloud-native architectures. We are seeking an experienced Senior Database Developer to lead Oracle to PostgreSQL/Aurora PostgreSQL migrations, including SQL refactoring, schema conversion, DMS operations, and performance tuning.

You will work closely with cloud engineers and application teams to ensure a smooth and compliant transition.

Qualifications

  • Bachelor's degree in Computer Science or related field.
  • 5+ years as Oracle/PostgreSQL DBA and database developer.
  • Strong Oracle and PostgreSQL/Aurora PostgreSQL experience.
  • Hands-on Oracle to PostgreSQL migration.
  • Advanced SQL and query performance tuning.
  • Experience with AWS SCT and AWS DMS.
  • Knowledge of Flyway/Liquibase or similar tools.
  • PostgreSQL internals: indexing, statistics, execution plans.
  • AWS services: RDS/Aurora, CloudWatch, IAM (preferred).

Responsibilities

  • Refactor and convert Oracle SQL/PLSQL to PostgreSQL-compatible SQL/PLpgSQL.
  • Analyze and remediate AWS SCT findings and limitations.
  • Manage Flyway migration codebase (scripts, migrations, rollbacks).
  • Identify, troubleshoot, and fix database-related application bugs.
  • Perform query optimization for PostgreSQL (execution plans, indexing).
  • Support and monitor AWS DMS during full load and CDC phases.
  • Data validation and reconciliation between Oracle and PostgreSQL.
  • Collaborate with application teams to align SQL behavior and performance.

Skills

Oracle to PostgreSQL migration
PostgreSQL/Aurora PostgreSQL
SQL optimization
AWS DMS
Flyway/Liquibase
Schema conversion
AWS SCT
PL/SQL
Performance tuning

Education

Bachelor's degree in Computer Science

Tools

Flyway
Liquibase
AWS SCT
AWS DMS
RDS/Aurora

Job description

Mactores is a leading AWS modernization firm focused on delivering production-ready migrations and cloud-native architectures. We are seeking an experienced Senior Database Developer to lead Oracle to PostgreSQL/Aurora PostgreSQL migrations, including SQL refactoring, schema conversion, DMS operations, and performance tuning.

You will work closely with cloud engineers and application teams to ensure a smooth and compliant transition.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Database Developer (Oracle & PostgreSQL)
Senior Database Developer (Oracle & PostgreSQL)

Mactores • United States

Remote
USD 120,000 - 170,000
Remote Senior Data Migration Engineer - Aurora PostgreSQL
Remote Senior Data Migration Engineer - Aurora PostgreSQL

Slalom • Baltimore (MD)

Remote
USD 110,000 - 124,000
401(k) match
Health, dental & vision coverage
Adoption and fertility assistance
+2
Senior DBA - Oracle to AWS PostgreSQL Migration Lead
Senior DBA - Oracle to AWS PostgreSQL Migration Lead

Leidos • Baltimore (MD)

On-site
USD 108,000 - 195,000
Senior DB Migration Engineer - AI-Driven Cloud Migrations
Senior DB Migration Engineer - AI-Driven Cloud Migrations

Slalom • San Antonio (TX)

Remote
USD 110,000 - 124,000
Time off & holidays
401(k) match
Health coverage
+4
Database Developer - PostgreSQL & Oracle Migration Expert
Database Developer - PostgreSQL & Oracle Migration Expert

Netrist Solutions, LLC. • United States

Remote
USD 90,000 - 130,000
Paid Time Off
Health benefits
Vision benefits
+4
PostgreSQL Database Engineer - Oracle-to-Postgres Migration
PostgreSQL Database Engineer - Oracle-to-Postgres Migration

CGS Federal • Chicago (IL)

On-site
USD 110,000 - 160,000
Health, Dental, and Vision
Life Insurance
401k
+2
AWS PostgreSQL DBA & Dev: Cloud Migrations & Automation
AWS PostgreSQL DBA & Dev: Cloud Migrations & Automation

Peraton • United States

Remote
USD 90,000 - 130,000
Cloud PostgreSQL DBA/Developer: AWS & Migration
Cloud PostgreSQL DBA/Developer: AWS & Migration

Peraton • Herndon (VA)

On-site
USD 86,000 - 138,000
Medical Insurance
Dental & Vision
401(k)
+1
Senior DBA - Cloud Data Migration & AWS PostgreSQL Lead
Senior DBA - Cloud Data Migration & AWS PostgreSQL Lead

Leidos • Baltimore (MD)

On-site
USD 108,000 - 195,000
PostgreSQL DB Admin/Developer - AWS & Migrations
PostgreSQL DB Admin/Developer - AWS & Migrations

Peraton • Reston (VA)

On-site
USD 86,000 - 138,000
Medical, dental, vision
401(k)
PTO and holidays
+1