Senior Database Migration Engineer (Oracle & PostgreSQL)
RemoteFull-time5–9 yrsPosted open since jan 2026
Senior software engineering role at Mactores. Needs 5+ years and a B.Sc, B.Tech or B.E.. Remote.
About the role
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'll do
- 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
What you need
- PostgreSQL
- SQL
- AWS
- Oracle Database
- CI/CD
- Reconciliation
Good to have
- IAM
- Ansible
- Puppet
- Terraform