Database Administrator

Austin, TX

Database Administrator - Solicitation# 529501419

Texas Health and Human Services Commission (HHSC)

Works under the general supervision of the Regulatory LTC Application Manager or their designee. This position is responsible for leading complex technical database activities for the information systems supporting the HHSC Division of regulatory Services. Provides support in the development and maintenance of data warehouse and reporting systems. Develops, tests, debugs and documents highly complex program code to implement functional and design requirements for reporting systems in the agency. Participates in code walk-thrus. Assists in the development and maintenance of system documentation. Works with other members of the development team and end-users. Develops and maintains expertise in a variety of programming and database management tools. Develops technical and user documentation and supports training as required.

Hybrid role: Must be available to come into office 2 days/week – subject to change.

Program will only allow candidates who are LOCAL TO THE AUSTIN AREA ONLY (Within 50 mile radius).

Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

Actual

Years

Experience Years

Experience

Needed Required/

Preferred Skills/Experience

7 Required Evaluates users' requests for new data elements and systems and incorporates into the existing shared data

7 Required Install and use Data Modeling tools like Tableau, Azure Data Factory (ADF), Informatica and etc.

7 Required Develop logical and physical Data Models and Entity Relationship Diagrams.

7 Required Implement database objects in an Oracle cloud RDBMS, Salesforce CRM.

7 Required Advanced data modeler with experience in Design, creation, and maintenance data models representing production databases.

7 Required Generate scripts to be in the database using data modeler tools.

7 Required Incorporating changes to data model design.

7 Required Write source to target mapping instructions as needed to support ETL development.

7 Required Develop stored procedures, database triggers and complex PL/SQL packages where needed.

7 Required Perform requirement analysis and provide data mapping guidance to application and development teams.

5 Preferred Coordination and Collaboration: Work with various teams, including IT support, development, and operations, to gather information and expertise.

5 Preferred Relies on limited experience and judgment to plan and accomplish goals.

5 Preferred A certain degree of creativity, out of the box thinking, and latitude is required.

5 Preferred Works under limited supervision with considerable latitude for the use of initiative and independent judgment.

4 Preferred Communication: Keep stakeholders informed about the status of problems and solutions.

4 Preferred Familiar with standard concepts, practices, and procedures within a particular field.

2 Preferred Strong understanding of ETL (Extract, Transform, Load) to extract, transform, and load data, enabling businesses to use data for analysis and decision-making, extracting data from various sources, such as databases, files, and cloud services.

2 Preferred Certification in Azure Data Factory (ADF), Informatica preferred.

2 Preferred Experience understanding PERL scripts is a plus.

2 Preferred Experience creating Tableau dashboard.

I need Three References

Reference Name (Required):

Title (Optional)

Company Name (Required):

Phone Number (Required include area code):

E-mail address (Optional):

Professional Relationship (Optional):

Peer Co-Worker Supervisor

Customer End-User Subordinate

Reference Name (Required):

Title (Optional)

Company Name (Required):

Phone Number (Required include area code):

E-mail address (Optional):

Professional Relationship (Optional):

Peer Co-Worker Supervisor

Customer End- User Subordinate

Reference Name (Required):

Title (Optional)

Company Name (Required):

Phone Number (Required include area code):

E-mail address (Optional):

Professional Relationship (Optional):

Peer Co-Worker Supervisor

Customer End- User Subordinate