About this role.
This Database Migration Engineer supports Oracle-to-PostgreSQL/Aurora and SQL Server-to-PostgreSQL modernization engagements. The role focuses on SQL and stored-procedure conversion, AWS SCT findings, Flyway migration management, AWS DMS monitoring, and source-to-target data reconciliation. Working under lead and senior engineers, the hire will troubleshoot application and database issues, tune PostgreSQL queries, and help prepare reliable cutovers. It suits a database engineer with 3–5 years of experience who wants deeper hands-on exposure to cloud database migration delivery. The environment is delivery-oriented, with fixed migration dates and close collaboration with customers, application teams, and cloud engineers.
Role DNA
A quick view of the complexity, pace, ownership and collaboration implied by the job description.
Job Complexity
4/5Pace & Pressure
4/5Autonomy Level
3/5Communication Load
4/5Salary analysis
Estimated compensation compared with the broader US market for similar roles.
Core skills
Skills and capabilities most closely associated with this opportunity.
Sample interview questions
I would first inventory dependencies, inputs, outputs, transaction behavior, exception handling, and Oracle-specific functions. I would convert the logic incrementally to PL/pgSQL, replace unsupported constructs with PostgreSQL equivalents, and add unit and integration tests using representative data. Finally, I would validate results and performance against the source behavior, escalating ambiguous business logic or complex SCT findings early.
I would compare row counts by table, validate primary-key uniqueness, reconcile aggregates such as counts and sums, and investigate tables with mismatches. For critical entities, I would use checksums or sampled record-level comparisons while accounting for expected transformations and datatype differences. I would document exceptions, confirm CDC lag and error status, and obtain sign-off before cutover.
I would begin with EXPLAIN ANALYZE to identify expensive scans, joins, sorts, inaccurate estimates, or poor row-count assumptions. I would review indexes, statistics, query predicates, join order, datatype casts, and any SQL patterns that changed from the source engine. I would test targeted indexing or query rewrites in a representative environment and measure the improvement before promoting changes.
I would use clearly named, versioned migrations for ordered schema changes and repeatable migrations only for objects that should be recreated, such as views or routines. Each change would be reviewable, idempotent where appropriate, tested in lower environments, and accompanied by a documented rollback or forward-fix strategy. I would also ensure the Flyway schema history is protected and deployment execution is integrated with the release process.
I would review the flagged object to determine whether it is a syntax issue, unsupported feature, behavioral difference, or undocumented business rule. I would propose PostgreSQL-compatible alternatives, test them against expected source results, and clearly record assumptions and risks. For high-impact or ambiguous logic, I would escalate promptly to the senior engineer and application stakeholders rather than making an unverified conversion.
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.
As our Database Migration Engineer, you’ll 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; you’ll handle the conversion, testing, and reconciliation tasks directly, and work closely with senior engineers on the more complex SCT findings and performance edge cases. You’ll 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 you’ll 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 before cutover.
What you’ll bring?
- 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.
You’ll be preferred if you’ve:
- 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).
How we work?
Aedeon absorbs the discovery, mapping, and validation grind — the 60–70% of hours a traditional consulting engagement of equivalent scope staffs for. Your hours go where the tools stop: conversion judgment, cutover strategy, and the procedural-code gaps only an engineer can close. We commit to fixed delivery dates and absorb the overage cost for delays inside our control, so the runbook you write and the cutover you run carry real weight. You embed with the customer’s team and own the outcome — not a workstream, the outcome.
Compensation
Additional Information
Life at Mactores
We care about creating a culture that makes a real difference in the lives of every Mactorian. Our 10 Core Leadership Principles that honor Decision-making, Leadership, Collaboration, and Curiosity drive how we work.
1. Be one step ahead
2. Deliver the best
3. Be bold
4. Pay attention to the detail
5. Enjoy the challenge
6. Be curious and take action
7. Take leadership
8. Own it
9. Deliver value
10. Be collaborative
We would like you to read more details about the work culture on https://mactores.com/careers
The Path to Joining the Mactores Team
At Mactores, our recruitment process is structured around three distinct stages:
Pre-Employment Assessment:
A series of evaluations of your technical proficiency and suitability for the role.
Managerial Interview: The hiring manager engages with you in multiple discussions, 30 minutes to an hour each, covering technical skills, hands-on experience, leadership potential, and communication.
HR Discussion: During this 30-minute session, you’ll have the opportunity to discuss the offer and next steps with a member of the HR team.
Mactores provides 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.
Note: Please answer as many questions as possible with this application to accelerate the hiring process.
Annual salary information is not provided for this position. Explore salary ranges for similar roles in our Salary Directory ›
Upload your resume now
- To unlock remote work opportunities and be discovered by global employers.
This job listing has been manually reviewed by the Jobicy Trust & Safety Team for compliance with our posting guidelines, including verification of the company's legitimacy, accuracy of job details, clarity of remote work policy, and absence of misleading or fraudulent content.
