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.
Key Responsibilities- 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.
Detailed Key ResponsibilitiesMigration Strategy Planning- 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, PostgreSQL).
- Design migration strategies (homogeneous and heterogeneous).
- Define cutover plans and rollback strategies for risk mitigation.
Execution Optimization- 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.
Validation & Compliance- 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.
Collaboration- 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.
Required Skills & QualificationsTechnical Expertise:- 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.
Database Knowledge:- Experience with relational databases (primarily SQL Server and DB2, Oracle, MySQL, PostgreSQL).
- Understanding of homogeneous and heterogeneous migrations and CDC.
Cloud Skills:- Familiarity with AWS networking (VPC), IAM, and security best practices.
- Certifications: AWS Certified Solutions Architect and AWS Database Specialty (preferred).
Preferred Experience- Large-scale Database migration projects ( at least 5) involving multi-terabyte databases.
- Working knowledge of ETL tools and data transformation processes.
- Exposure to DevOps practices and automation for Database migration workflows.