Data Migration Specialist

8 hours ago

Torrance, California, United States Raas Infotek Full time

Position-AWS Data Migration Specialist

Location-Torrance, CA (Onsite)

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.

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.

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.

  • Infrastructure Project Manager

    2 weeks ago

    Torrance, California, United States Adept Solutions Full time

    Job Description Responsibilities:Infrastructure (network, system, storage)Data Migration from Office 365 to CloudManage all aspects of large scale, global, complex strategic projects from inception to deliveryDetailed oriented and strong organizational skillsAble to manage large complex projects independently and lead multiple projects...

  • Infrastructure Project Manager

    2 days ago

    Torrance, California, United States Adept Solutions Full time

    Job Description Responsibilities:Infrastructure (network, system, storage)Data Migration from Office 365 to CloudManage all aspects of large scale, global, complex strategic projects from inception to deliveryDetailed oriented and strong organizational skillsAble to manage large complex projects independently and lead multiple projects...

  • AWS Data Architect

    2 weeks ago

    Torrance, California, United States Ajna Infotech Full time $150,000 - $250,000 per year

    Job DescriptionNeed 15+ years of experienceNeed 15+ years of experienceNeed 15+ years of experiencePlease do not send me profiles with 10 or less years of experience.Read the job description caraefully before applyingRole: AWS Data ArchitectLocation: Toorance CA - OnsiteType: ContractKey skillThe role requires specific skills around developing CDM...

  • ERP Specialist

    2 days ago

    Torrance, California, United States PolyPeptide US Full time $72,000 - $87,000

    ERP Specialist – Manufacturing OperationsLocation: Onsite - Torrance, CA | Employment Type:Full-TimeDrive operational excellence through technology We're looking for an ERP Specialist to support and optimize our ERP system, ensuring seamless production, inventory, and supply-chain workflows. This role bridges Operations and IT to improve efficiency, data...

  • Injury Prevention Specialist

    1 week ago

    Torrance, California, United States ATI Physical Therapy Full time $28 - $38

    OverviewTitle: Injury Prevention Specialist/Athletic TrainerLocation:    Torrance, CAStatus: Full TimeHours: M-F 3rd shift - 10:00 pm - 6:30 amNew Grads Welcome |Competitive SalaryATI is a multi-service healthcare company that specializes in MSK health across the entire spectrum of care.  With our data-driven approach and expertly trained team members, we...

  • Clinical Documentation Integrity Specialist II

    1 week ago

    Torrance, California, United States Torrance Memorial Medical Center Full time $51 - $86

    The Clinical Documentation Integrity Program Specialist II facilitates accurate, complete and consistent clinical documentation within the inpatient health record to support reporting of high-quality healthcare data and coding.Core CompetenciesAssesses patients' clinical conditions and risks compared to the physicians' documentation in accordance with...

  • Financial Planning Specialist

    2 weeks ago

    Torrance, California, United States AFC Franchise Corp Full time $40,000 - $80,000 per year

    Financial Planning SpecialistWe're hiring AFCFC is seeking a highly motivated Financial Planning Specialist to join our teamAbout UsSince 1986, we've been redefining fresh and convenient dining as North America's largest franchisor of supermarket-based food service counters featuring sushi and other authentic Asian-inspired cuisine. Our well-loved brands,...

  • Injury Prevention Specialist

    6 days ago

    Torrance, California, United States ATI Worksite Solutions Full time

    OverviewTitle:Injury Prevention Specialist/Athletic TrainerLocation:Torrance, CAStatus:Full TimeHours:M-F 2nd shift - 3:30 pm - 12:00 amNew Grads Welcome |Competitive SalaryATI is a multi-service healthcare company that specializes in MSK health across the entire spectrum of care. With our data-driven approach and expertly trained team members, we are...

  • Sourcing Specialist

    22 hours ago

    Torrance, California, United States Castelion Corporation Full time

    About CastelionCastelion is bringing a new approach to defense development and production: one that focuses on short, iterative design cycles, rapid testing in development, and modern commercial manufacturing strategies for production at scale. Were designing, building, and testing next generation long range strike weapons systems to give America and its...

  • Sales & Operations Specialist

    2 weeks ago

    Torrance, California, United States Singer Vehicle Design Full time $68,000 - $80,000 per year

    Join Our Relentless Pursuit of ExcellenceAtSinger Vehicle Design, we believeEverything is Important.That's why every nut, bolt, stitch, and finish matters when we restore and reimagine Porsche 911s into some of the most beautiful and respected cars in the world.We're looking for aSales & Operations Specialistto bring their passion, precision, and...