Database Administrator

The Database Administrator (Systems Analyst VI) focuses on Oracle database administration and development functions in support of web-based applications used statewide in various stages of design, implementation, enhancement, and maintenance. Work involves automating processing, troubleshooting, customer support, SQL performance tuning, planning, analyzing user requirements, procedures, and problems to maintain existing functionality as well as programming to implement new functionality on existing systems. The position will provide solutions for critical cross-agency business process analysis projects for Health and Human Services Commission (HHSC) agencies, as well as perform analysis and development of complex business processes through proven or creative system solutions. Work is performed in an Agile environment and creativity is encouraged. Mentorship of junior team members will also be a key requirement of this role.

The Database Administrator reports to the HHSC IT Admin Applications Director of Application Development.

Selected candidate must work onsite from an HHS office located in Austin, Texas designated by the hiring manager.

Essential Job Functions (EJFs):

• Architects, implements, and supports highly available, secure, and scalable database platforms across HHSC Cloud and hybrid environments. (20%)
• Leads and executes database migrations, including on premises to cloud transformations, Oracle to Oracle/SQL Server conversions, workload modernization, and Query optimization. (20%)
• Installs, configures, upgrades, patches, and maintains relational and non relational database technologies while ensuring compliance with strict security and governance requirements. (20%)
• Designs and manages HA/DR solutions-including Golden Gate replication, clustering, failover, and backup/recovery-to protect mission critical workloads. (15%)
• Drives automation-first practices by building database automation and CI/CD workflows. (15%)
• Performs Crystal Reports Development and/or Business Objects Universe maintenance by consulting with the users to gather information about program needs, objectives, functions, features, and input-output. (5%)
• Participates in Agile ceremonies and completes other job duties as required. (5%)

Do you have experience in Performance tuning?, * Knowledge of Software Development Lifecycle (SDLC) process for report development.

• Knowledge of Oracle architecture (SGA, PGA, redo/undo, etc.).
• Knowledge of industry standards for databases such as Oracle and/or SQLServer.
• Knowledge of Agile Methodologies.
• Knowledge of Query Optimization.
• Skill in information technology equipment and computer systems.
• Skill in oral and written communications that convey technical analysis and data results in common business terms that management, executive, and non-technical customers can understand.
• Skilled in migrating mission critical Oracle databases
• Skilled with general-purpose systems language such as: Python, Perl, Unix Shell and/or database language SQL, PL/SQL,Rust
• Skilled with performance tuning (AWR, ASH, execution plans, indexing) and Query Optimization
• Skilled with scripting (Bash).
• Skilled with Linux/Unix administration skills (RHEL, Oracle Linux).
• Skilled with production experience managing systems or database environment.
• Skills migrating Oracle databases from on-premises to cloud platforms.
• Skilled in Oracle replication tools like Goldengate , Data Guard.
• Skilled in RMAN backup and recovery, Data Pump including restore and disaster recovery scenarios
• Skilled with with Oracle Database (11g/12c/19c or later).
• Skilled with with Oracle RAC and/or Exadata.
• Skill in troubleshooting, performance tuning, and problem solving.
• Skill in consulting with users to gather information about program needs, objectives, functions, features, and input-output requirements.
• Ability to provide technical assistance by responding to inquiries from others regarding errors, problems, or questions about programs.
• Ability to independently facilitate meetings and build consensus across multiple teams and working with teams located in different geographic locations.
• Ability to effectively train and mentor other team members.
• Ability to provide excellent customer service.
• Ability to learn and quickly comprehend new concepts.
• Ability to perform Root Cause Analysis.
• Ability to break down tasks into sub-tasks and estimating required effort.
• Ability in releasing and maintaining cloud services.
• Ability to exhibit strong troubleshooting and problem-solving skills.
• Ability to perform database patching and upgrades., * Minimum of 8 (eight) years of experience working with large data sets in an Oracle environment.
• Minimum of 8 (eight) years of experience programming - writing complex stored procedures using SQL.
• Minimum of 8 (eight) years of experience in database design such as Queries, Cursors and Triggers.
• Minimum of 5 (five) years of experience in enterprise database migrations on-prem-Cloud transformations.
• Minimum of 5 (five) years of experience supporting, maintaining and monitoring of multi-tier, mission-critical Enterprise systems
• Minimum of 5 (five) years of experience SQL performance tuning in Enterprise Oracle databases
• Minimum of 5 (five) years of experience with Software Development Lifecycle (SDLC) process, coding standards, change control, and version management
• Minimum of 2 (two) years of experience with Agile methodologies - (Scrum, for example).

Preferred Skills and Experience:

• Preferred 8 (eight) years of experience as a senior Oracle database administrator.
• Preferred 2 (two) years of experience with GoldenGate 11.x or above.
• Preferred experience with OEM and RAC.

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 work from an HHS office located in Austin, designated by the hiring manager. #LI-GN1

Pulled from the full job description

• Health insurance
• Pension plan
• Opportunities for advancement

Full job description

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.