AWS Data Migration Specialist

TechDigital Group; Torrance (CA); On-site; USD 130,000 - 160,000; Full time

Job summary

A leading tech firm in California is seeking an experienced AWS Database Migration Specialist with at least 15 years of experience. The ideal candidate will have extensive knowledge of AWS services and must have successfully completed at least 5 database migration projects. Responsibilities include designing migration strategies, optimizing performance, and ensuring compliance with security standards. Competitive compensation package offered.

Qualifications

• Minimum 15 years of experience in database migration.
• Executed at least 5 database migration projects successfully.
• Hands-on experience with AWS DMS and SCT.

Responsibilities

• Lead and execute database migration projects to AWS.
• Design and implement database migration strategies.
• Optimize migration performance and troubleshoot issues.

Skills

AWS Database Migration Service (DMS)

Strong SQL skills

Scripting knowledge (Python, Bash)

AWS CLI

Understanding of relational databases

Education

AWS Certified Solutions Architect

AWS Database Specialty

Job description

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.