Cloud Data Migration Engineer

Benefits:

• Competitive salary

Location
Austin, TX


Experience Level
Senior Level (8 or more years of experience)


Role Overview
The Cloud Data Migration Engineer (Systems Analyst 3) leads the migration of on-premises Oracle workloads to AWS using AWS Database Migration Service (DMS). Operating in a hybrid cloud environment, this role designs secure cloud-native infrastructure, builds robust ETL/ELT pipelines, and implements automated data streaming and Change Data Capture (CDC) architectures. The engineer collaborates with cross-functional stakeholders to perform system analyses, develop migration and cutover plans, minimize system downtime, and modernize legacy IT configurations.


Key Responsibilities


Cloud Infrastructure & Database Migration
• Lead the planning, design, and execution of complex database migrations from on-premises Oracle workloads to AWS using AWS Database Migration Service (DMS).
• Configure, manage, and secure AWS infrastructure and networking architectures, including VPCs, subnets, routing tables, security groups, VPNs, and Direct Connect.
• Deploy and manage core cloud-native services (such as EC2, RDS, S3, IAM, and Lambda) utilizing Infrastructure as Code (IaC) tools like Terraform or CloudFormation.
• Support hybrid cloud-to-on-premises connectivity and lead legacy system modernization initiatives.


Data Pipeline & Ingestion Engineering
• Design and implement batch and real-time data ingestion pipelines, supporting full loads, Change Data Capture (CDC), and streaming architectures.
• Build, optimize, and validate robust ETL/ELT processes and data integration methodologies within cloud migration lifecycles.
• Automate infrastructure provisioning, data synchronization, and operational tasks using scripting languages such as Python, Bash, or PowerShell.


Strategy, Monitoring, & Governance
• Develop comprehensive data migration and cutover runbooks, including technical rollback strategies designed to minimize production downtime.
• Design and configure cloud-native logging, auditing, and observability frameworks using AWS CloudWatch and CloudTrail.
• Perform detailed requirements gathering, analyze operational procedures, identify system limitations, and perform cost/benefit analyses of alternative solutions.
• Document and maintain technical designs, system diagrams, and data-flow specifications.


Required Qualifications
• 8 or more years of experience in IT supporting the design, development, deployment, or delivery of enterprise technology solutions.
• 8 or more years of hands-on experience using AWS Database Migration Service (DMS) to migrate database workloads from Oracle to AWS.
• 8 or more years of experience with batch and real-time data ingestion, including full loads, Change Data Capture (CDC), and streaming architectures.
• 8 or more years of experience designing and implementing AWS cloud infrastructure, networking topologies, VPCs, subnets, and routing protocols.
• 8 or more years of experience utilizing core AWS services (such as EC2, RDS, S3, IAM, and Lambda) and Infrastructure as Code (IaC) tools like Terraform or CloudFormation.
• 8 or more years of experience with ETL/ELT processes and data integration methodologies within enterprise cloud migration projects.
• 8 or more years of experience scripting and automating system workflows using Python, Bash, or PowerShell.
• 8 or more years of experience configuring and managing cloud network security architectures, including VPNs, Direct Connect, and security groups.
• 8 or more years of experience configuring and utilizing cloud monitoring and logging tools, including AWS CloudWatch and CloudTrail.
• 8 or more years of experience developing comprehensive data migration, cutover, and rollback plans designed to minimize business downtime.
• 8 or more years of experience communicating technical designs, drafting technical documentation, and authoring migration runbooks.
• 8 or more years of experience establishing hybrid cloud-to-on-premises connectivity and modernizing legacy IT systems.
• Must currently reside in the State of Texas and be local to the Austin area, living within a 50-mile radius of the primary work location.


Preferred Qualifications
• AWS certifications, such as AWS Certified Solutions Architect or AWS Certified Database – Specialty.
• 1 or more years of experience working in public sector or state government environments.


Core Skills & Attributes
• Excellent written, verbal, and technical documentation skills to bridge technical data architectures and business needs.
• Outstanding analytical, critical-thinking, and system-level troubleshooting capabilities.
• Proactive, self-motivated approach to managing complex, cross-functional datasets and resolving workload issues.
• Strong collaborative capability to work effectively with data engineers, database administrators, security teams, and business partners.

Flexible work from home options available.