Senior AWS Database Migration Architect / Engineer

Req ID: 396308 

NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.

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. 

Basic Qualifications: 

• 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.

About NTT DATA

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.

Whenever possible, we hire locally to NTT DATA offices or client sites. This ensures we can provide timely and effective support tailored to each client’s needs. While many positions offer remote or hybrid work options, these arrangements are subject to change based on client requirements. For employees near an NTT DATA office or client site, in-office attendance may be required for meetings or events, depending on business needs. At NTT DATA, we are committed to staying flexible and meeting the evolving needs of both our clients and employees. NTT DATA recruiters will never ask for payment or banking information and will only use @nttdata.com, @nttdatafed.com and @talent.nttdataservices.com email addresses. If you are requested to provide payment or disclose banking information, please submit a contact us form, https://us.nttdata.com/en/contact-us.

NTT DATA endeavors to make https://us.nttdata.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here. If you'd like more information on your EEO rights under the law, please click here. For Pay Transparency information, please click here.