Database Administrator III

Designs, develops, enhances, maintains, and supports the databases underlying IT systems utilized by HHSC program areas. Maintains and monitors integrated database systems.

Develops and maintains complex models and logical database designs. Provides expertise in and participates in the development and implementation of database architectures to meet application performance and security requirements. Works with the application development teams, business stakeholders and other partners to enhance existing systems and implement new solutions. Develops goals and objectives for the use and improvement of efficient and cost-effective database systems.

This position is classified as a fulltime position (40 hours a week). Work outside of regular hours may be required. Travel to other work locations may be required. Performs other duties as assigned Essential Job Functions:

Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned. Work outside of regular hours may be required. Travel to other work locations may be required.

(30%) Perform and support the design, development, tuning and maintenance of databases including structures, performance, security, and recovery. Provide expertise in and participate in the development and implementation of database architectures to meet application performance and security requirements.

Develop and maintain complex models and logical database designs. Coordinate with application development and support teams to ensure their needs are met from a database perspective. Participate in the planning, design, administration, operation, monitoring, maintenance, user security, archiving, and system parameters setting for associated database environments.

(25%) Implement, administer, manage, and monitor assigned application databases in production and non-production environments. Analyze, design, plan and perform database upgrades and maintenance.

Monitor database performance and implement improvements. Ensure that data integrity and data security is maintained. Setup views, roles, stored procedures, and database links to allow use of databases while preserving data integrity and maintaining security within established policies, regulations, and guidelines.

Assist in the development and maintenance of the database disaster recovery and backup plan. Establish and implement database security controls and user access levels.

(25%) Identify and resolve issues related to database systems to ensure that systems are online and without service interruption. Perform analysis, troubleshooting, diagnosis, and problem resolution.

Analyze software for defects and performance tuning opportunities. Develop and test database code/scripts to restore defects and improve application reliability and performance. Write and debug complex stored procedures and triggers. Develop, maintain, monitor, and troubleshoot batch processes.

(15%) Provide technical guidance for database related design, development, integration, conversion, and testing work. Educate development teams on database concepts and techniques.

Assist with analysis and design of new development, updates, changes, and fixes. Evaluate and recommend database software packages for potential acquisitions. Perform routine and ad hoc report design and development.

(5%) Other duties as assigned. May 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 Knowledge Skills Abilities:

Knowledge of the principals, practices and techniques of database design and development, database structures and theories and current database technologies.

Knowledge of data analysis techniques.

Knowledge of relational databases (e.g., Oracle, SQL Server)

Knowledge of the principles, practices, and techniques of software development and the full software development life cycle (SDLC).

Knowledge of computer operations, systems, and procedures.

Skill in administering Oracle and/or MS SQL databases.

Skill in performing Extract, transform, and load (ETL).

Skill in SQL and scripting.

Skill in technical analysis and design, including database design and planning.

Skill in complex problem solving and critical thinking.

Ability to design and develop database systems based on customer requirements

Ability to coordinate the development and dissemination of technical content for a variety of users.

Ability to identify and analyze complex business problems and define user needs.

Ability to process information logically and perform detailed work accurately.

Ability to work independently and to meet deadlines.

Ability to manage and coordinate multiple activities in different projects. Registration or Licensure Requirements:

Oracle/SQL Certification is preferred but not required

Initial Selection Criteria:

Graduation from an accredited four-year college or university. Major coursework in computer science, computer information systems, management information systems, or a related field is preferred.

Related work experience may be substituted on a year-for-year basis.

Must have at least 4 years of experience supporting relational databases as a DBA, with a focus in Oracle.

Experience with Pl/SQl

Experience with MS SQL preferred.

Experience with Tableau and/or Informatica preferred Additional Information:

MOS Code:

Note: There may be no military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position.

All active duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified to fill this position. For more information see the Texas State Auditor's Military Crosswalk at http://www.hr.sao.state.tx.us/Compensation/JobDescriptions.aspx.

HHS agencies use E-Verify. You must bring your I-9 documentation with you on your first day of work.

I-9 Form - Click here to download the I-9 form.

In compliance with the Americans with Disabilities Act (ADA), HHS 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.

Top 10 Tips for Success when Applying to Jobs at HHSC and DSHS