Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Mactores

Senior Database Developer - Oracle DB & PostgreSQL

Posted Updated

Description

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 postgo-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.

Skills

What Senior Software Engineering jobs ask for — and how much of it you have →
Apply

See also

Software Engineering jobs by country — openings, pay and top skills →