Senior AWS Database Migration Architect​/Engineer

Req : 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, Cloud Watch, 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, Dev Ops 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 Cloud Formation.

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

• Integrate migration activities into CI/CD pipelines using Git Hub Actions, Git Lab CI/CD, Jenkins, AWS Code Pipeline, 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…