Senior Database Engineer

Date:
Aug 11, 2026

Location:

AUSTIN, TX

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: ,X,182X,1D7X1,255A,255S,25B,25D,25H,26B,62E,681X,682X,781X,CTI,CTM,CTR,CYB
10,CYB
11

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)

• Knowledge:
• Thorough knowledge of relational database management systems (RDBMS), such as Oracle and Microsoft SQL Server, data normalization, and indexing.
• Knowledge and implementation experience with No
  
  SQL databases is preferred.
• Thorough knowledge of modern cloud data stores (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.
• Skills:
• 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.
• Abilities:
• Ability to perform systematic data audits on migrated datasets to verify row counts and relationship…