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: Senior Database Engineer
Job Title: Systems Analyst VII
Agency: Health & Human Services Comm
Department: Chief Technology Office EI 3b
Posting Number: 20002
Closing Date: 10/10/2026
Posting Audience: Internal and External
Occupational Category: Computer and Mathematical
Salary Range: $8,488.33- $11,666.66
Pay Frequency: Monthly
Salary Group: TEXAS-B-29
Shift: Day
Additional Shift: Days (First)
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
This position is open to U.S. Citizens and permanent residents.This onsite role requires the selected candidate to work from an HHS office in Austin, Texas.Performs complex computer systems analysis work for the CTO team, with a focus on supporting AI and modernization initiatives across enterprise applications, databases, and technical platforms. Work involves analyzing database and application requirements, developing automation scripts, supporting AI-enabled solution patterns, executing database migration activities, validating data quality, and modernizing technical processes across legacy and cloud-based environments. The position supports SQL development, scripting, ETL/ELT activities, schema analysis, data reconciliation, migration testing, automation of repeatable operational tasks, documentation of data dictionaries and technical workflows, issue resolution, and coordination with application, data, cloud, security, and business teams. Works under general supervision, with limited latitude for the use of initiative and independent judgment.
Essential Job Functions (EJFs):Executes structured database migration queries, develops and maintains scripts to support automation, handles data transformations, and extracts and loads large datasets from legacy storage tables into modernized database and cloud environments. 45%
Validates database migrations, automation outputs, and AI-assisted processing results to confirm data integrity, relationship indexes, volume requirements, and business rules align with source systems and target platform expectations.35%
Reviews computer logs, error prints, automation run results, AI-generated outputs, and complex data schemas to locate anomalies, troubleshoot failures, and correct discrepancies by updating scripts, mappings, or database logic.15%
Maintains data dictionaries, schema updates, automation documentation, script inventories, database connection inventory files, and technical runbooks. Performs related work as assigned.5%
Knowledge, Skills and Abilities (KSAs):- Thorough knowledge of relational database management systems (RDBMS), such as Oracle and Microsoft SQL Server, data normalization, and indexing.
- Knowledge and implementation experience with NoSQL databases is preferred.
- Thorough knowledge of modern cloud datastores (e.g., Azure SQL, AWS RDS, PostgreSQL) and distributed schema designs.
- Thorough knowledge of industry ETL/ELT construction patterns, data type conversion constraints, and bulk data ingestion frameworks.
- Knowledge of automation approaches, scripting practices, AI-assisted development concepts, and operational use cases that improve repeatable technical and business processes beyond traditional data pipelines.
- Knowledge of agile project execution, short-cycle sprint deliveries, and schema version control frameworks.
- Strong skill in drafting, optimizing, and running complex, high-volume SQL scripts, stored procedures, and schema generation queries.
- Strong skill in tracking database schema changes and using transformation tools to convert legacy tables into normalized modern structures.
- Strong skill in parsing runtime log outputs, tracking query execution bottlenecks, and debugging transactional row failures.
- Strong skill in developing, modifying, and troubleshooting scripts used for database migration, automation, file processing, validation, scheduling, and system integration activities.
- Skill in applying AI-enabled tools responsibly to accelerate analysis, documentation, testing, code review, and process improvement while maintaining human review and quality control.
- Ability to perform systematic data audits on migrated datasets to verify row counts and relationship index accuracy.
- Ability to synthesize clear data dictionaries, schema documentation, and database maps.
- Ability to identify opportunities to use automation and AI-enabled capabilities to improve efficiency, reduce manual effort, strengthen validation, and support modernization activities across applications, databases, and operational workflows.
- Ability to communicate current migration risks and data validation drift to the systems engineering lead.
Registrations, Licensure Requirements or Certifications:None
Initial Screening Criteria:- Graduation from an accredited four-year college or university with major coursework in computer science, database administration, information systems, or a related field. Experience may substitute for education on a year-for-year basis.
- Minimum of 5 years of experience in database programming, ETL development, or data migrations.
- Must have experience with scripting
- Must have experience with SQL
Additional Information:Any employment offer is contingent upon available budgeted funds. The offered salary will be determined in accordance with budgetary limits and the requirements of HHSC Human Resources Manual.
Selected candidates must be legally authorized to work in the U.S. without sponsorship.
Selected candidate must be willing to commute to the office on the required days.
#LI-MH1
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-. 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.
Never miss an opportunity! Create an alert based on the job you applied for.
