TechDigital Group
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.
Migration 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 & Qualifications Technical 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.
#J-18808-Ljbffr
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.
Migration 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 & Qualifications Technical 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.
#J-18808-Ljbffr