Systems Analyst 3

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: Systems Analyst 3

Location(s): Austin, TX


Job Summary
We are seeking an experienced Cloud Data Migration Engineer to lead and support Oracle-to-AWS data migration initiatives. The ideal candidate will have extensive hands-on experience with AWS Database Migration Service (DMS), cloud infrastructure, networking, ETL/ELT processes, and hybrid cloud environments. This role involves designing, implementing, and executing secure, scalable migration solutions while minimizing downtime and ensuring successful cutover.

Key Responsibilities

• Design and implement Oracle-to-AWS data migration solutions using AWS Database Migration Service (DMS).
• Support full-load, Change Data Capture (CDC), and real-time streaming data migration architectures.
• Design and configure AWS infrastructure, including VPCs, subnets, route tables, security groups, VPNs, and Direct Connect.
• Deploy and manage AWS services including EC2, RDS, S3, IAM, Lambda, and related cloud-native services.
• Build and maintain infrastructure using Infrastructure as Code (Terraform or AWS CloudFormation).
• Develop and execute ETL/ELT processes to support cloud migration projects.
• Create automation scripts using Python, Bash, or PowerShell.
• Develop migration strategies, cutover plans, rollback procedures, and downtime mitigation approaches.
• Configure cloud monitoring and logging using AWS CloudWatch and CloudTrail.
• Collaborate with infrastructure, application, and database teams to modernize legacy on-premises environments.
• Produce technical documentation, architecture diagrams, migration runbooks, and implementation guides.
• Troubleshoot migration issues and optimize migration performance.

Required Qualifications

• 8+ years of IT experience supporting the design, development, deployment, or delivery of technology solutions.
• 8+ years of hands-on experience migrating Oracle databases to AWS using AWS Database Migration Service (DMS).
• Strong experience with:
  • Full-load, CDC, batch, and real-time streaming data migrations.
  • AWS networking, including VPCs, subnets, routing, security groups, VPNs, and Direct Connect.
  • AWS services including EC2, RDS, S3, IAM, and Lambda.
  • Infrastructure as Code using Terraform or AWS CloudFormation.
  • ETL/ELT processes and cloud data integration.
  • Python, Bash, or PowerShell scripting and automation.
  • AWS CloudWatch and CloudTrail monitoring.
  • Migration planning, cutover execution, rollback strategies, and minimizing production downtime.
  • Hybrid cloud connectivity and legacy system modernization.
• Excellent verbal and written communication skills with experience producing technical documentation and migration runbooks.

Preferred Qualifications

• AWS Certified Solutions Architect or AWS Certified Database – Specialty certification.
• Experience supporting public sector or state government projects.

Desired Technical Skills

• AWS Database Migration Service (DMS)
• Oracle Database
• AWS EC2
• Amazon RDS
• Amazon S3
• AWS Lambda
• IAM
• VPC
• VPN
• Direct Connect
• CloudFormation
• Terraform
• ETL/ELT
• Change Data Capture (CDC)
• Python
• Bash
• PowerShell
• CloudWatch
• CloudTrail
• Hybrid Cloud
• Data Migration
• Infrastructure Automation
• Legacy System Modernization

This role is best suited for senior cloud migration engineers with deep AWS infrastructure expertise and extensive Oracle-to-AWS migration experience, particularly those experienced with enterprise-scale data migration and hybrid cloud modernization.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.