Senior AWS Data Migration Architect

LTM; Irving (TX); Hybrid; USD 130,000 - 190,000; Full time

Benefits offered by this job

Medical Plan Covering Medical, Dental,

Disability Coverage

Company match insurance

Paternity and Maternity Leave

Job summary

LTM is seeking an AWS Data Migration Architect to design and execute migrations of relational databases to AWS, including schema conversion and cutting over to Aurora PostgreSQL or RDS. Role focuses on secure, scalable data migrations for enterprise workloads.

Responsibilities include producing data models, runbooks, and guidance for application teams, while ensuring compliance with security controls like IAM and KMS. Remote-friendly based in the US, with a hybrid work model possible.

Qualifications

• Deep hands-on with at least two of Oracle, SQL Server, PostgreSQL; advanced SQL and PL/SQL.
• Proven delivery migrating production databases to Aurora PostgreSQL / RDS, using AWS DMS and SCT.
• Core AWS data stores: RDS / Aurora PostgreSQL, S3, IAM, KMS.

Responsibilities

• Design and execute migrations of relational databases to AWS.
• Perform schema and PL/SQL conversion/refactoring; plan and run migration waves.
• Produce migration runbooks, ADRs, and guidance for application teams.
• Ensure migrated databases meet security and compliance requirements (least-privilege IAM, KMS).

Skills

Relational databases

Oracle

SQL Server

PostgreSQL

AWS DMS

Schema Conversion Tool

RDS

Aurora PostgreSQL

IAM

KMS

Python

Terraform

Jira

Agile

Tools

Terraform

AWS DMS

Schema Conversion Tool

Jira

Job description

LTM is seeking an AWS Data Migration Architect to design and execute migrations of relational databases to AWS, including schema conversion and cutting over to Aurora PostgreSQL or RDS. Role focuses on secure, scalable data migrations for enterprise workloads.

Responsibilities include producing data models, runbooks, and guidance for application teams, while ensuring compliance with security controls like IAM and KMS. Remote-friendly based in the US, with a hybrid work model possible.