Senior AWS Database Migration Architect / Engineer

We are currently seeking a Senior AWS Database Migration Architect / Engineer to join our team in Charlotte, North Carolina (US-NC), United States (US).

Day to Day job Duties: (what this person will do on a daily/weekly basis)

Database Discovery, Assessment and Planning

• Assess database size, growth, workloads, utilization, dependencies, interfaces, availability requirements, and operating characteristics.

• Analyze schemas, stored procedures, functions, triggers, extensions, scheduled jobs, security models, and application dependencies.

• Classify databases by compatibility, migration complexity, business criticality, and recommended migration approach.

• Select target platforms across Amazon RDS for PostgreSQL, RDS for MySQL, Aurora PostgreSQL, and Aurora MySQL.

• Produce capacity and sizing recommendations covering compute, memory, storage, IOPS, throughput, availability, backup, and recovery.

• Identify prerequisites, remediation needs, risks, and technical dependencies; develop migration waves, sequencing, runbooks, rollback procedures, and cutover plans.

• Apply and refine the existing migration framework, reusable patterns, standards, templates, scripts, and automation.

AWS Architecture and Infrastructure

• Design secure, highly available, and resilient Amazon RDS and Amazon Aurora architectures.

• Configure and support VPCs, subnets, route tables, security groups, IAM, KMS, Secrets Manager, CloudWatch, and DNS connectivity.

• Design Multi-AZ, read replica, backup and restore, snapshot, encryption, monitoring, disaster recovery, and high-availability patterns.

• Design hybrid connectivity using AWS Direct Connect, VPN, Transit Gateway, and VPC networking.

• Partner with cloud infrastructure and security teams to meet enterprise security, connectivity, and operational requirements.

Database Migration Engineering

• Plan and execute homogeneous and heterogeneous migrations using AWS Database Migration Service (AWS DMS), AWS Schema Conversion Tool (AWS SCT), or equivalent capabilities.

• Implement full-load and change-data-capture patterns to reduce application downtime.

• Perform schema conversion, data migration, database configuration, performance optimization, and post-migration remediation.

• Troubleshoot compatibility, connectivity, replication, performance, and cutover issues.

• Develop repeatable procedures that support factory-style migration across large database estates.

Database Administration and Engineering

• Provide hands-on PostgreSQL and MySQL database administration and engineering expertise.

• Analyze configuration, indexing, query performance, execution plans, connections, locking, replication, and resource utilization.

• Define backup, restore, maintenance, monitoring, patching, and operational procedures.

• Identify differences between on-premises implementations and AWS-managed database services and define required remediation.

• Perform performance benchmarking and tuning before and after migration.

Testing, Validation, DevOps and Automation

• Define validation strategies for data integrity, schema, application connectivity, functionality, performance, security, backup and recovery, and operational readiness.

• Establish reconciliation controls for row counts, data completeness, schema objects, and business-critical data.

• Define acceptance criteria, go/no-go checkpoints, rollback criteria, and production validation steps; support integration testing, UAT, cutover rehearsals, and production migration.

• Automate infrastructure and database provisioning using Terraform and/or AWS CloudFormation.

• Develop reusable automation with Python, Bash, PowerShell, SQL, or similar technologies.

• Integrate migration activities into CI/CD pipelines using GitHub Actions, GitLab CI/CD, Jenkins, AWS CodePipeline, or comparable tooling.

• Maintain infrastructure code, migration scripts, configuration, and runbooks in Git-based source control and contribute reusable components to the established migration framework.

• Minimum 10 years of experience in database engineering, database administration, cloud engineering, or infrastructure engineering, including leadership of complex database migrations.

• Minimum 7 years of hands-on experience administering and engineering PostgreSQL and/or MySQL databases.

• Minimum 5 years of experience designing, building, or operating database solutions on AWS, including Amazon RDS and/or Amazon Aurora.

• Minimum 5 years of experience assessing, planning, or executing migrations of on-premises relational databases to AWS.

• Minimum 3 years of hands-on experience with AWS DMS, including full load, change data capture, monitoring, troubleshooting, and cutover.

• Minimum 3 years of experience with schema conversion and compatibility analysis using AWS SCT or equivalent tooling.

NTT DATA provides a reasonable range of compensation for U.S.-based positions. The starting pay range for this role is $116,000-154,000 . Actual compensation will depend on a number of factors, including the candidate’s relevant experience, technical skills, and other qualifications.

This position may also be eligible for incentive compensation based on individual and/or company performance.

This position is eligible for company benefits that will depend on the nature of the role offered. Company benefits may include medical, dental, and vision insurance, flexible spending or health savings account, life and AD&D insurance, short and long term disability coverage, paid time off, employee assistance, participation in a 401k program with company match, and additional voluntary or legally-required benefits.

NTT DATA is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100. We are committed to accelerating client success and positively impacting society through responsible innovation. We are one of the world’s leading AI and digital infrastructure providers, with unmatched capabilities in enterprise-scale AI, cloud, security, connectivity, data centers and application services. our consulting and Industry solutions help organizations and society move confidently and sustainably into the digital future. As a Global Top Employer, we have experts in more than 50 countries. We also offer clients access to a robust ecosystem of innovation centers as well as established and start-up partners. NTT DATA is a part of NTT Group, which invests over $3 billion each year in R&D.