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 a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 700+ clients, LTM brings extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomes in a converging world. Powered by nearly 90,000 talented and entrepreneurial professionals across more than 30 countries, LTM a Larsen & Toubro Group company combines the industry-acclaimed strengths of erstwhile Larsen and Toubro Infotech and Mindtree in solving the most complex business challenges and delivering transformation at scale. For more information, please visit www.ltm.com

Title: AWS Data Migration Architect

Location: Irving, Tx (Remote)

Key Responsibilities

• Design and execute migrations of relational databases (Oracle, SQL Server, PostgreSQL) to AWS (Aurora PostgreSQL, RDS, ODB@AWS).
• Perform schema and PL/SQL conversion/refactoring; plan and run migration waves (assessment → cutover → validation → tuning).
• Produce target-state data models, migration runbooks, ADRs, and guidance for application teams.
• Ensure migrated databases meet security and compliance requirements (least‑privilege IAM, KMS encryption at rest/in transit).

Must Have

• Relational databases (Level 400): Deep hands‑on with at least two of Oracle, SQL Server, PostgreSQL; advanced SQL and PL/SQL.
• Database migration to AWS (Level 300‑400): Proven delivery migrating production databases to Aurora PostgreSQL / RDS, using AWS DMS and SCT (Schema Conversion Tool).
• Core AWS data stores (Level 300): RDS / Aurora PostgreSQL, S3, IAM, KMS.

Should Have

• Programming: Python for data processing and migration automation.
• PL/SQL conversion at scale (Oracle → PostgreSQL) and heterogeneous migration experience.
• IaC: Terraform. (CDK not required.)
• Agile / Jira (Level 200): Manage own user stories within the sprint.
• Nice to Have
• Agentic AI / Amazon Bedrock for data accelerators (code analysis/conversion, data‑domain tagging) — differentiator, not a gate.
• Data‑lake / lakehouse exposure (Glue, Lake Formation, Athena, Redshift).
• Legacy source familiarity (Exadata, Sybase, DB2, mainframe).
• GenAI coding assistants (Q Developer, Kiro).
• AWS certifications: Database Specialty or Solutions Architect (Associate/Pro).

Benefits/perks listed below may vary depending on the nature of your employment with LTM (LTIM):

Benefits and Perks:

• Medical Plan Covering Medical, Dental, Vision
• Term and Long-Term Disability Coverage
• Plan with Company match.
• Insurance
• Paternity and Maternity Leave

The range displayed on each job posting reflects the minimum and maximum salary target for the position across all US locations. Within the range, individual pay is determined by work location and job level and additional factors including job-related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation may be provided as part of overall compensation like an annual performance-based bonus, sales incentive pay and other forms of bonus or variable compensation.

Disclaimer:

The compensation and benefits information provided herein is accurate as of the date of this posting.

LTM is an equal opportunity employer that is committed to diversity in the workplace. Our employment decisions are made without regard to race, color, creed, religion, sex (including pregnancy, childbirth or related medical conditions), gender identity or expression, national origin, ancestry, age, family-care status, veteran status, marital status, civil union status, domestic partnership status, military service, handicap or disability or history of handicap or disability, genetic information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation or preference, or any other characteristic protected by applicable federal, state, or local law, except where such considerations are bona fide occupational qualifications permitted by law.

Safe return to office:

In order to comply with LTM s company COVID-19 vaccine mandate, candidates must be able to provide proof of full vaccination against COVID-19 before or by the date of hire. Alternatively, one may submit a request for reasonable accommodation from LTM s COVID-19 vaccination mandate for approval, in accordance with applicable state and federal law, by the date of hire. Any request is subject to review through LTM s applicable processes.