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.
- Robust exp

📌 Senior Database Developer (Mumbai)
🏢 Mactores
📍 Mumbai