Systems Analyst 3

Texas Health and Human Services Commission requires the services of 1 Systems Analyst 3, hereafter referred to as Candidate(s), who meets the general qualifications of Systems Analyst 3, Applications/Software Development and the specifications outlined in this document for the Texas Health and Human Services Commission.

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.
 

Required Experience

• 8 years: Experience in IT supporting the design, development, deployment, or delivery of technology solutions.
• 8 years: Experience using AWS Database Migration Service (DMS) to migrate data from Oracle to AWS.
• 8 years: Experience with batch and real-time data ingestion, including full loads, Change Data Capture (CDC), and streaming architectures.
• 8 years: Experience with AWS cloud services, specifically designing and implementing infrastructure and networking (VPCs, subnets, security groups, and routing).
• 8 years: Experience with core AWS services (EC2, RDS, S3, IAM, and Lambda) and infrastructure-as-code tools such as CloudFormation or Terraform.
• 8 years: Experience with ETL/ELT processes and data integration methodologies in cloud migration projects.
• 8 years: Experience with scripting and automation using Python, Bash, or PowerShell.
• 8 years: Experience configuring and managing cloud network security, including VPNs, AWS Direct Connect, and security groups.
• 8 years: Experience with monitoring and logging tools such as AWS CloudWatch and AWS CloudTrail.
• 8 years: Experience developing data migration and cutover plans, including rollback strategies and minimizing downtime.
• 8 years: Excellent verbal and written communication skills, including experience documenting technical designs and migration runbooks.
• 8 years: Experience with hybrid cloud/on-premises connectivity and legacy system modernization.

Preferred Experience

• 4 years: AWS certification(s), such as AWS Certified Solutions Architect or AWS Certified Database – Specialty.
• 1 year: Experience working in public sector or state government environments.