Database Analyst in Austin, TX

Description

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: Database Analyst 
Job Title: Systems Analyst VI 
Agency: Health & Human Services Comm 
Department: Applications - HHS Systems 
Posting Number: 15178 
Closing Date: 09/21/2026 
Posting Audience: Internal and External 
Occupational Category: Computer and Mathematical 
Salary Range: $7,015.16 - $9,250.08 
Pay Frequency: Monthly
Salary Group: TEXAS-B-27 
Shift: Day 
Additional Shift:  
Telework:  
Travel:  
Regular/Temporary: Regular 
Full Time/Part Time: Full time 
FLSA Exempt/Non-Exempt: Exempt 
Facility Location:  
Job Location City: AUSTIN 
Job Location Address: 701 W 51ST ST 
Other Locations:  
MOS Codes: 0171,8848,8858,181X,182X,1D7X1,255A,255S,25B,25D,25H,26B,62E,681X,682X,781X,CTI,CTM,CTR,CYB10,CYB11 
ISM,IT,Z Prefix 
 
 

Brief Job Description:

The Database Analyst (Systems Analyst VI) focuses on Oracle database administration and development functions in support of web-based applications used statewide in various stages of design, implementation, enhancement, and maintenance. Work involves automating processing, troubleshooting, customer support, SQL performance tuning, planning, analyzing user requirements, procedures, and problems to maintain existing functionality as well as programming to implement new functionality on existing systems. The position will provide solutions for critical cross-agency business process analysis projects for Health and Human Services Commission (HHSC) agencies, as well as perform analysis and development of complex business processes through proven or creative system solutions. Work is performed in an Agile environment and creativity is encouraged. Mentorship of junior team members will also be a key requirement of this role.

The Database Analyst reports to the HHSC IT Admin Applications Director of Application Development.

Must be willing to work from an HHS office designated by the hiring manager 3, or more, days per week located in Austin, TX.

Essential Job Functions:         
    
Attends work on a regular and predictable schedule in accordance with agency attendance and leave policy and performs other duties as assigned.

Oversees the architecture for HHSC IT functional projects that support internal and external processes, functions and operations, upgrades, patches, statewide and interagency interfaces, state and federal audits, data analysis applications for integrated systems; manages work plans, schedules, daily project tasking as well as overall system design. (30%)

Provides senior level analysis of and advanced Oracle database administration functions for highly integrated and complex systems used for, administrative data, cross-agency business processes, and functional requirements for HHSC agencies and other state and federal partners to meet strict mandates. May perform advanced level Crystal Reports Development and/or Business Objects Universe maintenance by consulting with the users to gather information about program needs, objectives, functions, features, and input-output. Converts information gathered from clients into functioning solutions. (30%)

Leads the development of functional specifications of enterprise business processes, fixes and enhancements for Commission IT applications. (20%)

Leads the work efforts of functional analysts/developers to accomplish system design needs, development, implementation, SQL performance tuning, debugging, performance enhancement and ongoing system maintenance. Provides technical oversight and mentorship to junior team members. (10%)

Formulates business policies, procedures, and standards consistent with the agency standardization efforts within HHSC and provides on-going communications and coordination with HHSC agency project managers and subject matter experts to resolve issues or potential issue while promoting adherence to sound development standards and solution. (10%) 

Registrations, Licensure Requirements or Certifications:
None 

Knowledge Skills Abilities:          

Knowledge of Software Development Lifecycle (SDLC) process for report development.
Knowledge of industry standards for databases such as Oracle and/or SQLServer.
Knowledge of Agile Methodologies.
Knowledge of Query Optimization.
Skill in information technology equipment and computer systems.
Skill in oral and written communications that convey technical analysis and data results in common business terms that management, executive, and non-technical customers can understand.
Skill in troubleshooting, performance tuning, and problem solving.
Skill in consulting with users to gather information about program needs, objectives, functions, features, and input-output requirements.
Ability to provide technical assistance by responding to inquiries from others regarding errors, problems, or questions about programs.
Ability to independently facilitate meetings and build consensus across multiple teams and working with teams located in different geographic locations.
Ability to effectively train and mentor other team members.
Ability to provide excellent customer service.
Ability to learn and quickly comprehend new concepts.
Ability to perform Root Cause Analysis.
Ability to break down tasks into sub-tasks and estimating required effort.

Initial Screening Criteria:            
Graduation from a four-year college or university with major coursework in business, communications, computer science, computer information systems, management information systems, or a related field is preferred. Equivalent experience may be substituted on a year-for-year basis.

Minimum of 8 (eight) years of experience working with large data sets in an Oracle environment.
Minimum of 8 (eight) years of experience programming - writing complex stored procedures using SQL.
Minimum of 8 (eight) years of experience in database design such as Queries, Cursors and Triggers.
Minimum of 5 (five) years of experience supporting, maintaining and monitoring of multi-tier, mission-critical Enterprise systems.
Minimum of 5 (five) years of experience SQL performance tuning in Enterprise Oracle databases.
Minimum of 5 (five) years of experience with Software Development Lifecycle (SDLC) process, coding standards, change control, and version management.
Minimum of 2 (two) years of experience with Agile methodologies – (Scrum, for example).

Preferred 8 (eight) years of experience as a senior Oracle database administrator.
Preferred 2 (two) years of experience with GoldenGate 11.x or above.
Preferred experience with OEM and RAC.
Preferred experience with Crystal Reports.
Preferred experience with Business Objects.
Preferred experience with Web Intelligence Reports.  

Review our Tips for Success when applying for jobs at DFPS, DSHS and HHSC.

Active Duty, Military, Reservists, Guardsmen, and Veterans:

Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include, but not limited to those listed in this posting. All active-duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified to fill this position. For more information please see the Texas State Auditor's Job Descriptions, Military Crosswalk and Military Crosswalk Guide at Texas State Auditor's Office - Job Descriptions.

ADA Accommodations:

In compliance with the Americans with Disabilities Act (ADA), HHSC and DSHS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. If you need assistance completing the on-line application, contact the HHS Employee Service Center at 1-888-894-4747. If you are contacted for an interview and need accommodation to participate in the interview process, please notify the person scheduling the interview.

Pre-Employment Checks and Work Eligibility:

Depending on the program area and position requirements, applicants selected for hire may be required to pass background and other due diligence checks.

HHSC uses E-Verify. You must bring your I-9 documentation with you on your first day of work. Download the I-9 Form

Telework Disclaimer:

This position may be eligible for telework.  Please note, all HHS positions are subject to state and agency telework policies in addition to the discretion of the direct supervisor and business needs.