Systems Analyst VI

FALL CREEK FARM & NURSERY; Austin (TX); On-site; USD 83,000 - 99,000; Full time

Benefits offered by this job

Health insurance

Pension plan

Generous time off

Job summary

The Health & Human Services Commission (HHSC) seeks a Systems Analyst VI in Austin to perform advanced Oracle database development for Medicaid/CHIP systems. You will lead design, coding, and tuning of SQL/PL/SQL, ensuring data security, integrity, and high performance across enterprise applications.

You will coordinate with IT Applications and CMS data processes, manage complex data requirements, and provide technical guidance to junior staff while supporting critical agency systems.

Qualifications

• Strong Oracle database development skills.
• Hands-on experience designing, developing, testing, tuning, and supporting complex database solutions.
• Experience with TIERS data, CMS data quality issues, and audit-ready data processing.

Responsibilities

• Perform advanced systems analysis and Oracle database development for enterprise applications.
• Design, develop, tune, and maintain database structures, security, and recovery capabilities.
• Support production operations, troubleshoot defects, and ensure performance and data integrity.

Skills

Oracle

SQL

PL/SQL

Stored procedures

Triggers

Database tuning

SQL Developer

Tools

SQL Developer

PL/SQL Developer

Job description

Posting ID21491-Posted09/14/2026-Health & Human Services Comm-MMIS Staff APD Internal 90/10-Computer and Mathematical- Other Locations (1) -d. $7000 - $8999 per month

Join the Texas Health and Human Services Commission (HHSC) and be part of a team committed to creating a positive impact in the lives of fellow Texans. At HHSC, your contributions matter, and we support you at each stage of your life and work journey. Our comprehensive benefits package includes 100% paid employee health insurance for full-time eligible employees, a defined benefit pension plan, generous time off benefits, numerous opportunities for career advancement and more. Explore more details on the Benefits of Working at HHS webpage .

Functional Title: Systems Analyst VI

Job Title: Systems Analyst VI

Agency: Health & Human Services Comm

Department: MMIS Staff APD Internal 90/10

Posting Number: 21491

Closing Date: 12/13/2026

Posting Audience: Internal and External

Occupational Category: Computer and Mathematical

Salary Range: $8,151.00-$8,151.00

Pay Frequency: Monthly

Salary Group: TEXAS-B-27

Shift: Day

Additional Shift: None

Regular/Temporary: Regular

Full Time/Part Time: Full time

FLSA Exempt/Non-Exempt: Exempt

Job Location City: AUSTIN

Job Location Address: 701 W 51ST ST

Other Locations: Austin

MOS Codes: 0171,8848,8858,181X,182X,1D7X1,255A,255S,25B,25D,25H,26B,62E,681X,682X,781X,CTI,CTM,CTR,CYB10,CYB11ISM,IT,Z Prefix

Brief Job Description:

The Systems Analyst VI position reports to the Manager, IT Applications, Medicaid/CHIP Systems (IT-MCS) and performs advanced systems analysis and Oracle database development work for enterprise-level applications supporting Medicaid/CHIP systems, including the T-MSIS file process and Eligibility Data Quality activities for the Centers for Medicare and Medicaid Services (CMS). The position works under minimal supervision, with considerable latitude for the use of initiative and independent judgment, and is responsible for analyzing system and data requirements, designing and maintaining Oracle database solutions, developing and tuning SQL and PL/SQL code, supporting production operations, troubleshooting defects, and improving database reliability, security, integrity, and performance.

The successful candidate must possess strong Oracle database development skills and hands-on experience designing, developing, testing, tuning, and supporting complex database solutions in integrated application environments. The position works with Texas Integrated Eligibility Redesign System (TIERS) data and related processes to reconcile CMS data quality issues, analyze eligibility data, support CMS file processing, and ensure database solutions meet performance, security, recovery, and service level requirements. Tools and technologies may include Oracle, SQL, PL/SQL, stored procedures, triggers, database monitoring and tuning utilities, SQL Developer, PLSQL Developer, and other similar database analysis, development, monitoring, and support tools.

The candidate must be able to process technical and data information logically, analyze complex database, data quality, and system issues, prepare system and technical specifications, communicate effectively with technical and business stakeholders, work independently with limited direction, manage multiple priorities, and meet tight deadlines while supporting critical agency systems. The position may provide technical guidance, knowledge transfer, and coordination for systems analysts, database developers, data analysts, and support staff on database design, development, integration, conversion, testing, tuning, and production support activities.

The candidate must have scheduling flexibility and be willing to work periodically after hours to support critical system updates and manage batch processes.

Essential Job Functions (EJFs):

• 1. Performs advanced systems analysis and Oracle database development work for assigned applications by owning day-to-day application-specific database design efforts; designing, developing, tuning, and maintaining database structures, behaviors, performance, security, and recovery capabilities; writing and debugging complex SQL, PL/SQL, stored procedures, and triggers; and providing database architecture expertise to meet application performance, data integrity, data security, and recovery requirements. Supports T