Database Administrator IV - Senior

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 Administrator IV - Senior
Job Title: Database Administrator IV
Agency: Health & Human Services Comm
Department: Behavioral Health Services-425
Posting Number: 11666
Closing Date: 06/02/2026
Posting Audience: Internal and External
Occupational Category: Computer and Mathematical
Salary Group: TEXAS-B-27
Salary Range: $7,015.16 - $9,439.83
Pay Frequency: Monthly
Shift: Day
Additional Shift:
Telework: Eligible for Telework
Travel: Up to 5%
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: 0670,0671,0679,6046,6049,8846,8848,181X,182X,1D7X1,255A,25B,26B,5C0X1S,681X,682X,781X,782X,CTI,CTT
CYB10,CYB11,ISM,IT,ITS,Z Prefix

Brief Job Description:

Works under the supervision of the IDD Behavioral Health Services Application Software Development Manager or their designee. Performs highly advanced (senior-level) data analysis, modeling, and development work in support of mission-critical applications. This position is responsible for the design, implementation, maintenance, and optimization of Oracle 19c+/MS SQL Server databases, ETL processes (Informatica and/or equivalent), and enterprise data warehouses.

Works under limited supervision, with considerable latitude for independent judgment and initiative supporting the HHS Division for Intellectual and Developmental Disability & Behavior Health Services.

Responsibilities include: (a)Provide application and database operations triage support to troubleshoot and resolve functional and performance issues encountered in production, development, and test environments. (b) Design, recommend, and implement procedures necessary to save, retrieve, and recover databases from hardware and software failures. (c) Develop to the architectural standards, guidelines, policies, and procedures designed to ensure the integrity of the database environment

Position will focus on Oracle 19c+ and MS SQL Server databases, Informatica and/or other ETL tools, SSRS/PowerBI report development, and data warehouse design.

Essential Job Functions (EJFs):

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

EJF1: Database Administration, Security, and Performance (30%)
• Install, configure, upgrade, and maintain Oracle databases and infrastructure (including Oracle Exadata).
• Manage backup, restore, recovery, and disaster recovery strategies for high availability.
• Tune performance and manage storage capacity.
• Implement security solutions (Vault, Data Redaction, Masking) for PHI protection and compliance.
• Administer Oracle Identity Management and Goldengate for authentication and replication.
• Lead migrations, upgrades, and document operational processes.

EJF2: Data Modeling, Development, and Application Support (30%)
• Analyze user requests and integrate new data elements, ensuring integrity and eliminating redundancy.
• Design, maintain, and update data models and ERDs with tools like Erwin, Oracle SQL Data Modeler etc., generate and deploy database scripts.
• Support ETL development and integration with source-to-target mappings and Informatica and/or related tools.
• Develop and optimize stored procedures, triggers, views, and PL/SQL packages.
• Provide data mapping guidance and requirements analysis; support data warehouse/mart schema and performance.

EJF3: Monitoring, Reporting, and Business Intelligence (20%)
• Monitor and optimize databases using Oracle Enterprise Manager.
• Identify and resolve performance, outage, and storage issues.
• Develop, publish and maintain SSRS and Power BI reports and dashboards.
• Translate business requirements into actionable analytics.

EJF4: Collaboration, Documentation, and Leadership (15%)
• Collaborate with developers, analysts, and project managers on database design and integration.
• Serve as main contact for vendors and internal customers.
• Document architectures, security, and recovery processes.
• Mentor junior DBAs; support data governance and change management.

EJF5: Other duties as assigned include but are not limited to actively participating and/or serving in a supporting role to meet the agency's obligations for disaster response and/or recovery or Continuity of Operations (COOP) activation. Such participation may require an alternate shift pattern assignment and/or location. (5%)

Knowledge, Skills and Abilities (KSAs):
• Knowledge of HIPPA and CFR42 regulatory requirements
• Knowledge of data governance, change management, and best practices in database management.
• Knowledge of the principles, practices, and techniques of computer databases, and systems design; of computer operations, systems, and procedures; of computer database application systems; of data processing flowcharting techniques; of database structures and theories; of current database technologies; and of data analysis and evaluation techniques.
• Knowledge of Project Management tools such as MS Azure DevOps, MS Team Foundation Server, or similar.
• Proficiency in data modeling tools (Erwin, Oracle SQL Data Modeler) and ETL platforms (Informatica, etc.).
• Expert skills in SQL and PL/SQL programming, debugging, and performance tuning skills.
• Expert skills of Oracle database architecture, administration, and security
• Skills in Snowflake, OLTP, and OLAP design methods/patterns or equivalent
• Skills in the use of applicable software development life cycle concepts (SDLC).
• Skills in the development of Cloud database/data warehouses such as Oracle, AWS, and Azure Data Lakes
• Skills in database management systems such as Oracle and MS SQL Server
• Skills in testing principles and methodologies
• Skills in working collaboratively with multiple stakeholders to achieve consensus and common goals.
• Skills in working collaboratively with application and database developers
• Skills in planning, scheduling, and prioritizing work assignments
• Skills in written and verbal communications
• Ability to design and implement database security solutions, including PHI protection and regulatory compliance.
• Ability to analyze problems and develop solutions to correct the problems
• Ability to analyze functional/design requirements and to develop database solutions to implement the requirements
• Ability to mentor junior staff and lead technical initiatives.
• Ability to perform detailed work accurately and in accordance with standards
• Ability to work and communicate effectively with others
• Ability to meet deadlines and work on projects with changing priorities

Registrations, Licensure Requirements or Certifications:

N/A

Initial Screening Criteria:

Graduation from an accredited four-year college or university with major course work in Computer Science, Engineering or related field. May substitute Education with direct work experience on a year-for-year basis. Minimum of 10 years' experience developing, designing and maintaining application databases as an Oracle Database Administrator/Developer or a similar job function.

Additional Information:

Available for Hybrid for telework but required 3 days in the office per week.

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.