Cloud Data Migration Engineer
Hybrid - US
Cloud Data Migration Engineer
Full Time • Hybrid - US
Benefits:
- Competitive salary
Location
Austin, TX
Austin, TX
Experience Level
Senior Level (8 or more years of experience)
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.
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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
Established in 2004, Smart Tech Skills is a top technology and professional services firm specializing in innovative technologies.
Headquartered in Marlborough, MA, the company effectively addresses clients’ technology needs nationwide, making advanced technology management easier.
Headquartered in Marlborough, MA, the company effectively addresses clients’ technology needs nationwide, making advanced technology management easier.
(if you already have a resume on Indeed)