Mactores is an agent-native AWS modernization firm focused on delivering production-ready systems, retiring legacy infrastructure, and ensuring measurable outcomes. Unlike traditional consulting, Mactores leverages Aedeon, an agent platform that automates 60–70% of repetitive engagement work (e.g., discovery, dependency mapping, validation, test generation), allowing forward-deployed engineers to focus on architecture, judgment, and cutover. The Database Migration Engineer role involves hands-on migration work (e.g., Oracle-to-PostgreSQL/Aurora, SQL Server-to-PostgreSQL) within the Application & Database Modernization pillar, addressing complex conversion, validation, and reconciliation tasks with support from senior engineers. The role emphasizes delivering migrations that perform reliably post-go-live, with fixed delivery dates and accountability for outcomes.
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.
- Work with application teams to align SQL behavior and performance expectations before cutover.
Requirements
- 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.
Nice to have
- 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).
Additional details
- 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.
- Mactores' 10 Core Leadership Principles: Be one step ahead, Deliver the best, Be bold, Pay attention to the detail, Enjoy the challenge, Be curious and take action, Take leadership, Own it, Deliver value, Be collaborative.
- Recruitment process includes: Pre-Employment Assessment (technical proficiency and suitability), Managerial Interview (technical skills, hands-on experience, leadership potential, communication), HR Discussion (offer and next steps).
- 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.
- Originally posted on Himalayas.
Zobhira
