Cloud Data Migration Engineer- W2

Job Description

Job Description

Working Title: Systems Analyst 3 Title/Level: Systems Analyst 3

Category: Applications/Software

Development Full Time

Seeking a Cloud Data Migration Engineer with hands-on experience migrating Oracle workloads to AWS using AWS DMS, supporting full-load, CDC, and real-time streaming data migration architectures. The ideal candidate will have strong expertise in AWS infrastructure and networking (VPCs, subnets, security groups,

VPNs, Direct Connect), cloud-native services (EC2, RDS, S3, IAM, Lambda), and Infrastructure as Code using Terraform or CloudFormation. Experience with ETL/ELT processes, migration planning, cutover and rollback strategies, automation using Python/Bash/PowerShell, and monitoring through CloudWatch and CloudTrail is required. Strong communication skills and experience modernizing legacy on-premises systems in hybrid cloud environments are highly desirable.

II. CANDIDATE SKILLS AND QUALIFICATIONS

Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

Years Required/Preferred Experience

8 Required Experience in IT, supporting the design, development, deployment, or delivery of technology solutions.

8 Required Experience using AWS Database Migration Service (DMS) to migrate data from Oracle to AWS.

8 Required Experience with batch and real-time data ingestion, including full loads, Change Data Capture (CDC), and streaming architectures.

8 Required Experience with AWS cloud services, specifically designing and implementing infrastructure and networking (VPC, subnets, security groups, routing).

8 Required Experience with core AWS services (EC2, RDS, S3, IAM, Lambda) and infrastructure-as-code tools (CloudFormation or Terraform).

8 Required Experience with ETL/ELT processes and data integration methodologies in cloud migration projects.

8 Required Experience with scripting and automation using Python, Bash, or PowerShell.

8 Required Experience configuring and managing cloud network security, including VPNs, Direct Connect, and security groups.

8 Required Experience with monitoring and logging tools (e.g., AWS CloudWatch, CloudTrail).

8 Required Experience developing data migration and cutover plans, including rollback strategies and minimizing downtime.

8 Required Excellent communication skills, both verbal and written, including documenting technical designs and migration runbooks.

8 Required Experience with hybrid cloud/on-premises connectivity and legacy system modernization.

4 Preferred AWS certification(s) such as AWS Certified Solutions Architect or AWS Certified Database – Specialty.

1 Preferred Experience working in public sector or state government environments.