Lead Database Migration Engineer

About the role

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.

This is the sharp end of our Application & Database Modernization pillar. Enterprise customers are moving off Oracle and SQL Server license renewals coming due, stored-procedure layers nobody fully understands onto PostgreSQL and Aurora PostgreSQL. You'll own those heterogeneous migrations end to end: run the AWS DMS and SCT toolchain, then do the part the tools can't rebuild procedural business logic in PL/pgSQL when SCT flags a gap it can't close on its own. You ship the runbook, you run the cutover, you validate the result. When the migration lands, it's yours.

What you'll do? - Lead end-to-end database migration initiatives: assessment, planning, schema conversion, execution, and post-migration validation.

- Design, configure, and manage AWS DMS and SCT environments and own migration quality, performance, and reliability.

- Author the migration runbooks the cutover lives or dies by: execution procedures, validation checkpoints, rollback plans, operational readiness.

- Perform migration assessments, dependency analysis, compatibility reviews, and migration strategy recommendations.

- Work with infrastructure, application, security, and platform teams to land migration outcomes.

- Drive migration testing: functional validation, performance testing, failover testing, production readiness reviews.

- Provide technical leadership to migration teams and hold the line on AWS migration best practices and governance standards.

- Lead conversion and refactoring of procedural database code Oracle PL/SQL (packages, procedures, functions, triggers, cursors) and SQL Server T-SQL (stored procedures, functions, triggers) into PostgreSQL/Aurora PostgreSQL PL/pgSQL, resolving the semantic and behavioral differences SCT identifies.

What we're looking for? - 8–12 years of professional experience in database architecture and migration delivery.

- Hands-on expertise in AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT) for enterprise-scale database migrations.

- Deep proficiency in Oracle, SQL Server, PostgreSQL, and Aurora PostgreSQL environments migration planning, execution, and optimization.

- Proven background delivering heterogeneous database migrations across on-premises, cloud, and AWS environments.

- Knowledge of production database operations: backup and restore strategies, parameter tuning, performance optimization, failover testing.