AWS Data Migration Specialist

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - 1 Month(s)

Skills

Amazon RDS
Amazon Redshift
Amazon Web Services
Analytical Skill
Auditing
Bash
Change Data Capture
Cloud Computing
Collaboration
Command-line Interface

Job Details

We are looking for AWS Data Migration Specialist for our client in Torrance, CA
Job Title: AWS Data Migration Specialist
Job Location: Torrance, CA
Job Type: Contract
Job Description:
Pay Range: $70hr - $75hr
  • The AWS Data Migration Specialist will be responsible for planning, executing, optimizing, and validating database migrations across on-premises and cloud environments.
  • The role ensures data integrity, security compliance, and seamless transition while collaborating with cross-functional teams.
Responsibilities:
  • Design and implement database migration strategies for on-premises and cloud environments.
  • Perform pre-migration checks including constraints, indexes, and triggers.
  • Assess existing database environments such as SQL Server, DB2, Oracle, MySQL, and PostgreSQL.
  • Define cutover plans and rollback strategies.
  • Configure and manage AWS DMS replication instances, endpoints, and tasks.
  • Perform schema conversion using AWS SCT for homogeneous and heterogeneous migrations.
  • Validate schema mapping and resolve compatibility issues.
  • Apply custom data transformations as needed.
  • Optimize migration performance and troubleshoot issues during full load and CDC.
  • Conduct data validation and reconciliation after migration.
  • Ensure compliance with security standards including IAM, encryption, and SSL/TLS.
  • Document migration procedures for auditing and future use.
  • Collaborate with DBAs, cloud architects, and application teams.
  • Communicate migration progress and risks.
  • Provide post-migration support and performance tuning.
Requirement/Must Have:
  • Hands-on experience with AWS DMS, SCT, Redshift, RDS, and Aurora.
  • Strong SQL skills and knowledge of scripting (Python, Bash).
  • Experience using AWS CLI.
  • Experience with relational databases including SQL Server, DB2, Oracle, MySQL, and PostgreSQL.
  • Understanding of homogeneous and heterogeneous migrations and CDC.
  • Familiarity with AWS networking, IAM, and security best practices.
Experience:
  • Experience with large-scale database migration projects involving multi-terabyte databases.
  • Experience with ETL tools and data transformation processes.
  • Exposure to DevOps practices and automation for migration workflows.
Skills:
  • Strong analytical, troubleshooting, and problem-solving skills.
  • Ability to work collaboratively with cross-functional teams.
  • Strong communication and documentation skills.
  • Ability to handle multiple tasks and meet project deadlines.
Qualification And Education:
  • Relevant technical degree preferred.
  • AWS Certified Solutions Architect or AWS Database Specialty certification preferred.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.