Senior Database Developer (Oracle & PostgreSQL)

Mactores

United States

Remote

USD 120,000 - 170,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

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 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.
Life at Mactores

We care about creating a culture that makes a real difference in the lives of every Mactorian.

Our 10 Core Leadership Principles that honor Decision‑making, Leadership, Collaboration, and Curiosity drive how we work.

  1. 1. Be one step ahead
  2. 2. Deliver the best
  3. 3. Be bold
  4. 4. Pay attention to the detail
  5. 5. Enjoy the challenge
  6. 6. Be curious and take action
  7. 7. Take leadership
  8. 8. Own it
  9. 9. Deliver value
  10. 10. Be collaborative
Recruitment Process
  • Pre‑Employment Assessment: A series of evaluations of your technical proficiency and suitability for the role.
  • Managerial Interview: The hiring manager engages with you in multiple discussions, 30 minutes to an hour each, covering technical skills, hands‑on experience, leadership potential, and communication.
  • HR Discussion: During this 30-minute session, you'll have the opportunity to discuss the offer and next steps with a member of the HR team.

Mactores provides equal opportunities in all employment practices. We don't discriminate based on race, religion, gender, national origin, age, disability, marital status, military status, genetic information, or any other category protected by federal, state, and local laws. This applies to every part of the employment relationship, recruitment, compensation, promotions, transfers, disciplinary action, layoff, training, and social and recreational programs.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior DB Migration Engineer: Oracle to PostgreSQL on AWS
Senior DB Migration Engineer: Oracle to PostgreSQL on AWS

Mactores • United States

Remote
USD 120,000 - 170,000
Remote AWS Database Engineer (Oracle & PostgreSQL)
Remote AWS Database Engineer (Oracle & PostgreSQL)

System One, Inc. • McLean (VA)

Remote
USD 130,000 - 170,000
Oracle Database Migration Specialist
Oracle Database Migration Specialist

Dynamo Technologies, LLC • United States

On-site
USD 120,000 - 155,000
Mid-Level Database Developer
Mid-Level Database Developer

Netrist Solutions, LLC. • United States

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

Dynamo • United States

Hybrid
USD 120,000 - 155,000
100% Paid Medical Benefits
Health Savings Account
401K with Company Match
+3
PostgreSQL Database Administrator/Developer
PostgreSQL Database Administrator/Developer

Peraton • Herndon (VA)

On-site
USD 86,000 - 138,000
Medical Insurance
Dental & Vision
401(k)
+1
PostgreSQL Database Administrator/Developer
PostgreSQL Database Administrator/Developer

Peraton • Reston (VA)

On-site
USD 86,000 - 138,000
Medical, dental, vision
401(k)
PTO and holidays
+1
Slalom Flex (Project Based)- Data Migration Engineer
Slalom Flex (Project Based)- Data Migration Engineer

Slalom • California

Remote
USD 110,000 - 124,000
401(k) match
Health insurance
Dental coverage
+4
Aurora PostgreSQL DBA - Migration, Tuning & HA Expert
Aurora PostgreSQL DBA - Migration, Tuning & HA Expert

TechDigital Group • Norfolk (VA)

On-site
USD 110,000 - 160,000
AWS Database Engineer
AWS Database Engineer

Guidehouse Inc. • McLean (VA)

On-site
USD 120,000 - 180,000