What are the responsibilities and job description for the Cloud Data Migration Engineer position at ArnAmy, Inc.?
Cloud Data Migration Engineer
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.
Responsibilities:
- Understand business objectives and problems, identify alternative solutions, perform studies and cost/benefit analysis of alternatives.
- Analyze user requirements, procedures, and problems to automate processing or improve existing computer systems.
- Confer with personnel of organizational units involved to analyze current operational procedures and identify problems.
- Write detailed descriptions of user needs, program functions, and steps required to develop or modify computer programs.
- Review computer system capabilities, specifications, and scheduling limitations to determine feasibility of requested program or program changes.
- Migrate Oracle workloads to AWS using AWS DMS, supporting full-load, CDC, and real-time streaming data migration architectures.
- Implement and manage AWS infrastructure and networking components.
- Design and implement ETL/ELT processes and data integration methodologies in cloud migration projects.
- Develop data migration and cutover plans, including rollback strategies and minimizing downtime.
- Document technical designs and migration runbooks.
Requirements:
| 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. |
Salary : $60 - $65