AWS Data Migration Specialist

Role Overview

• An experienced minimum 15 years AWS Database Migration Specialist to lead and execute database migration projects to AWS.
• The ideal candidate will have deep expertise in AWS Database Migration Service DMS, AWS Schema Conversion Tool (SCT), and related AWS services, ensuring secure, efficient, and low downtime migrations.
• Should have successfully executed at least 5 Database Migration projects.

• Design and implement database migration strategies for on premises and cloud environments (both non-production and production)
• Configure and manage AWS DMS replication instances, endpoints, and tasks.
• Perform schema conversion using AWS SCT for homogeneous and heterogeneous migrations.
• Optimize migration performance and troubleshoot issues during full load and CDC (Change Data Capture)
• Validate migrated data and ensure compliance with security and governance standards.
• Collaborate with DBAs, cloud architects, and application teams to ensure smooth migration.
• Document migration processes and provide post-migration support.

• Perform pre-migration checks (constraints, indexes, triggers).
• Design and implement database migration strategies primarily for on‑premises and cloud environments (both non‑production and production).
• Assess existing database environments (primarily SQL Server and DB2, Oracle, MySQL, Postgre
  
  SQL).
• Design migration strategies (homogeneous and heterogeneous).
• Define cutover plans and rollback strategies for risk mitigation.

• Configure and manage AWS DMS replication instances, endpoints, and tasks.
• Perform schema conversion using AWS SCT for heterogeneous migrations (primarily SQL Server and DB2).
• Validate schema mapping and resolve incompatibilities.
• Apply custom transformations where needed.
• Optimize migration performance and troubleshoot issues during full load and CDC (Change Data Capture).
• Ensures data integrity, minimal downtime, and compliance during migrations from on‑premises.

• Conduct data validation and reconciliation post‑migration.
• Ensure compliance with security standards (IAM roles, encryption, SSL). Enable encryption in transit and at rest (SSLTLS, KMS).
• Validate migrated data and ensure compliance with security and governance standards.
• Document migration processes for auditing and future reference and provide post‑migration support.

• Collaborate with DBAs, cloud architects, and application teams to ensure smooth migration.
• Communicate migration progress and risks to stakeholders.
• Provide post‑migration support and performance tuning.

• Hands‑on experience with AWS DMS, SCT, primarily Redshift, RDS and Aurora.
• Strong SQL skills and scripting knowledge (Python, Bash).
• Hands‑on AWS CLI for command‑line operations.

• Experience with relational databases (primarily SQL Server and DB2, Oracle, MySQL, Postgre
  
  SQL).
• Understanding of homogeneous and heterogeneous migrations and CDC.

• Familiarity with AWS networking (VPC), IAM, and security best practices.
• Certifications:
  
  AWS Certified Solutions Architect and AWS Database Specialty (preferred).

• Large‑scale Database migration projects (at least
  5) involving multi‑terabyte databases.
• Working knowledge of ETL tools and data transformation processes.
• Exposure to Dev Ops practices and automation for Database migration workflows.