Sign upLog in
See more jobs

AWS Data Migration Specialist

TechDigital

  • Torrance, CA
  • 2 days ago

    Highlights

    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. Role Overview An experienced minimum 15 years AWS Database Migration Specialist to lead and execute database migration projects to AWS.

    Numbers & Facts

    LocationTorrance, CA
    IndustryOther/Not Classified
    Company Size100 to 499 employees

    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.
    Detailed Key Responsibilities
    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.

    Similar Jobs