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: MonthlySalary 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):

• 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 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.

• 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 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.