Job Description
Company: Texas Health and Human Services Commission
Location: Austin, TX
Workplace Type: On-site
Employment Type: Full-time
Pay / Compensation: $7,015.16 – $9,439.83 / Month
About the Role
The Texas Health and Human Services Commission (HHSC) Social Services Applications division is seeking a Senior Logical Database Administrator / Database Developer. This role is central to ensuring that critical applications, such as the Texas Integrated Eligibility Redesign System (TIERS), remain available and performant for staff and the citizens of Texas. You will work in a fast-paced, customer-service-based environment utilizing Agile methodologies and cutting-edge web platform technologies.
What You’ll Do / Key Responsibilities
- Database Design & Architecture: Design, develop, maintain, and improve database solutions and underlying architectures for the TIERS applications portfolio, ensuring optimal structures, behaviors, performance, security, and recovery.
- Performance Tuning & Monitoring: Perform advanced logical database administration, performance monitoring, and tuning, including writing and debugging complex stored procedures and triggers.
- Application Support & Triage: Provide application and database operations triage support to troubleshoot and resolve functional and performance issues across production, development, and test environments, including participating in on-call support rotations.
- Collaboration & Guidance: Work closely with application development teams, business stakeholders, and scrum masters to enhance applications, build out database code/scripts, and provide technical guidance on integration, conversion, and testing work.
- Upgrades & Migrations: Plan, coordinate, and implement database management software installations, upgrades (including Oracle 19 upgrades), and database migrations to PostgreSQL.
Requirements & Qualifications
- Graduation from an accredited college or university with a bachelor’s degree in computer science, computer information systems, management information systems, or a related field (or equivalent high school diploma/GED plus 4 years of relevant full-time experience).
- 8+ years of full-time logical database administration or closely related experience in an enterprise-class production environment.
- 5+ years of logical database administration experience with Oracle 11 and/or Oracle 19 databases in a production environment, including data modeling, stored procedures, and SQL optimization/tuning.
- 4+ years of experience supporting Oracle 19 and/or PostgreSQL in an enterprise-scale production environment.
- 4+ years of experience performing logical database administration in support of Java (J2EE) / WebSphere based enterprise applications.
- 4+ years of database programming and/or script writing experience.
- Ability to work effectively with Oracle 11g/19c, PostgreSQL, Windows Server, Unix (Solaris), and Linux.
Preferred / Bonus Qualifications (if applicable)
- 2+ years of experience supporting application databases through an Oracle 19 upgrade.
- 2+ years of experience with RAC, RAT, Big Data, Goldengate, ASM, Dataguard, and RMAN.
- 2+ years of experience supporting migration of Oracle databases to PostgreSQL.
- 2+ years of experience supporting enterprise-scale databases in Azure, Amazon, and/or Google Cloud platforms.
Benefits & Perks (if applicable)
- 100% paid employee health insurance for full-time eligible employees
- Defined benefit pension plan
- Generous time off benefits
- Numerous opportunities for career advancement
Any employment offer is contingent upon available budgeted funds. Selected candidates must be legally authorized to work in the U.S. without sponsorship and be willing to commute to the office on the required days. HHSC uses E-Verify.