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.