Database Migration Engineer

Mactores; Mumbai; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Mactores is seeking a database migration engineer to convert SQL and database objects to PostgreSQL-compatible SQL/PLpgSQL, working with AWS SCT findings, Flyway migrations, and data reconciliation. You will identify performance bottlenecks, assist in data validation, and coordinate with application teams to ensure smooth cutover.

The role emphasizes hands-on migration work and collaboration with senior engineers on complex decisions, with opportunities to grow toward senior-level

Qualifications

• Bachelor's degree in Computer Science or a related field is required.

Responsibilities

• 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 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 before cutover.

Skills

SQL proficiency

Query optimization

Migration experience

PostgreSQL fundamentals

Oracle/SQL Server experience

AWS services familiarity

IaC basics

Education

Bachelor's degree in Computer Science or related field

Tools

AWS SCT

AWS DMS

Flyway

Liquibase

Terraform or CloudFormation

Ansible/Chef/Puppet

Job description

About Mactores

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.

Every database migration has a layer the tools can't 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.

Responsibilities

• 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 before cutover.

Qualifications

• A Bachelor's degree in Computer Science or a related field.
• 3–5 years of experience as a database developer/engineer, with exposure to migration work.
• Working experience with at least one of: Oracle, Microsoft SQL Server, and PostgreSQL / Aurora PostgreSQL.
• Some hands‑on exposure to database migration projects (Oracle-to-PostgreSQL or SQL Server-to-PostgreSQL).
• Solid SQL skills and a working understanding of query performance tuning.
• Familiarity with AWS SCT and AWS DMS (hands‑on exposure preferred, not required).
• Awareness of schema migration tools such as Flyway or Liquibase.
• Working knowledge of PostgreSQL fundamentals: indexing, execution plans.
• Familiarity with AWS services: RDS/Aurora, CloudWatch, IAM.
• Familiarity with automation/config tools such as Ansible, Chef, or Puppet.
• Familiarity with IaC tools such as Terraform or CloudFormation.
• AWS Certified Database – Specialty or AWS Certified Solutions Architect (nice to have, not required).

We provide 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.