Every database migration has a layer the tools cant finish. AWS SCT converts what it can and flags the rest, the SQL that ran fine on the source engine and behaves differently on the target, the logic no one documented. Senior engineers own the hardest of those calls; this role is where you build toward that, working through the conversion, validation, and reconciliation work with support from senior team members on the calls that need more judgment.

As our Database Migration Engineer, youll work inside our Application Database Modernization pillar, supporting hands-on migration work across engagements (Oracle-to-PostgreSQL/Aurora and SQL Server-to-PostgreSQL, depending on project). Aedeon and AWS tooling absorb the repeatable conversion and regression work; youll handle the conversion, testing, and reconciliation tasks directly, and work closely with senior engineers on the more complex SCT findings and performance edge cases. Youll work with application teams, cloud engineers, and customer stakeholders under the guidance of a lead engineer to land migrations that perform, reconcile,



and hold up after go-live.

What youll do
- Convert SQL, stored procedures, and database objects to PostgreSQL-compatible SQL/PLpgSQL, escalating complex or ambiguous cases to a senior engineer.
- Work through AWS SCT (Schema Conversion Tool) findings, flagging limitations that need senior review.
- Maintain the Flyway migration codebase: versioned scripts, repeatable migrations, rollbacks.
- Identify and troubleshoot database-related application bugs, with support on the harder cases.
- Support query optimization for PostgreSQL: execution plans, indexing, query rewrites.
- Monitor AWS DMS during full load and CDC phases and flag issues to the lead engineer.
- Assist in diagnosing DMS data and performance issues.
- Validate and reconcile data between source and target databases, proof, not confidence.
- Work with application teams to align SQL behavior and performance expectations bef

📌 Database Migration Engineer (Mumbai)
🏢 Mactores Cognition
📍 Mumbai