Database Administrator V

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.

Brief Job Description:

Physical Database Administrator (PDBA) supporting TIERS Databases on a 24x7 environment. Reports to the Manager of TIERS Data Center Services. PDBAs perform physical database administration, developing and maintaining the TIERS Oracle database so that they are highly available, fault tolerant, recoverable and performing at 100% expectancy. Additional PDBA support is provided for the Oracle databases associated with custom in-house applications, performing both physical and logical DBA support for the Oracle databases associated with third party tools (PPM, Cognos, Informatica, etc.); administering database security for TIERS Operations; performing logical tasks including schema build-outs for tools metadata repositories; providing Production Service Request (PSR) administration, script customization, and responding to audits. This position requires on-call support on a rotating basis.

Essential Job Functions (EJFs):

Perform DB refreshes/clones and provide support for building development and testing DBs. (20%)

Install, Patch and Upgrade database software. (15%)

Execute, schedule, restore, and maintain DB backups. (15%)

Configure and maintain a highly available database architecture including Real Application Clusters (RAC), DataGuard, an Automatic Storage Management (ASM). (15%)

Troubleshoot the database software and its infrastructure and where necessary engage and support the software vendor with problem analysis and resolution (10%)

Participate in performance monitoring and root cause analysis in DB layer and other layers as applicable. (5%)

Provide tight security for all data and support for third party vendor tools such as Privileged Identify Manager (PIM), Imperva Data Security Fabric, etc. (5%)

Support Agile sprints when required. (5%)

Provide support for PSR Team including analyzing, troubleshooting, and executing data corrections production databases (5%)

Manage accounts for users that access to production data. Develop procedures for documenting accounts and monitor user compliance. (5%)

Knowledge, Skills and Abilities (KSAs):

Experience supporting custom development

environments.

ITIL and Governance experience preferred.

In-depth knowledge of Oracle internal views, shell & SQL scripting.

Experience managing Oracle databases version 19C on Linux.

Solid experience in managing Oracle version 19C databases with Automated Storage Management (ASM), Real Application Clusters (RAC), and Data Guard.

Experience developing tools to administer large numbers of test & development database environments.

Experience with on call and carrying 24x7 pager for supporting Production & Development database systems.

Experience designing, installing & maintaining large size databases.

Performance Tuning large size databases & applications.

Thorough knowledge & working experience in setting up infrastructure for databases in datacenters at multiple sites including cloud infrastructure.

Working experience in moving live production, development and testing database and applications hosted in different physical sites including cloud environments.

Experience with administration of Oracle database on Oracle ExaData.

Experience using Remedy and/or Service Now.

Registrations, Licensure Requirements or Certifications:

ITIL Foundation Certification preferred.

Oracle Certified Professional is preferred.

AWS cloud certification is preferred.

Initial Screening Criteria:

Experience supporting Oracle Linux Databases on Exadata.

Experience with Oracle 19c or higher.

Experienced in Oracle Grid, RAC, and Data Guard.

Experience with Oracle Automatic Storage Management (ASM).

Strong performance tuning skills.

Additional Information:

N/A

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.