Database Administrator 2

KAPITAL; Austin (TX); Hybrid; USD 80,000 - 100,000; Full time

Job summary

A leading company in Austin is seeking a Database Administrator 2 to oversee complex database activities for the Texas Health and Human Services Commission. The role involves developing data warehouses, ensuring data integrity, and collaborating with various teams. This hybrid position offers both remote and onsite work, providing opportunities for growth in a dynamic environment.

Qualifications

• 7 years of experience in database management and data modeling.
• Experience with ETL processes and tools.
• Advanced skills in PL/SQL and database triggers.

Responsibilities

• Lead complex technical database activities for HHSC.
• Develop and maintain data warehouses and reporting systems.
• Monitor database performance and recommend improvements.

Skills

Data Modeling

Database Management

ETL

Communication

Education

Certification in Azure Data Factory (ADF)

Certification in Informatica

Tools

Tableau

Oracle RDBMS

Salesforce CRM

Job description

Join to apply for the Database Administrator 2 role at KAPITAL

Join to apply for the Database Administrator 2 role at KAPITAL

Get AI-powered advice on this job and more exclusive features.

Submissions due by 5/20/2025

This is a Database Administrator 2 position that will work closely with the Texas Health and Human and Services Commission (HHSC). This position is responsible for leading complex technical database activities for the information systems supporting the HHSC Division of regulatory Services. They will provide support in the development and maintenance of data warehouses and reporting systems. They will develop, test, debug and document highly complex program code to implement functional and design requirements for reporting systems in the agency.

Location: Austin, Texas

3 Days Remote, 2 Days Onsite

Start Date - 7/1/2025

End Date - 8/31/2025

Submissions due by 5/20/2025

This is a Database Administrator 2 position that will work closely with the Texas Health and Human and Services Commission (HHSC). This position is responsible for leading complex technical database activities for the information systems supporting the HHSC Division of regulatory Services. They will provide support in the development and maintenance of data warehouses and reporting systems. They will develop, test, debug and document highly complex program code to implement functional and design requirements for reporting systems in the agency.

Key Responsibilities

• Enter codes to create a production database
• Direct programmers and analysts to make changes to database management system
• Confers with coworkers to determine impact of database changes on other systems and staff cost for making changes to database
• Modifies database programs to increase processing performance, referred to as performance tuning
• Providing assistance in the planning, development, maintenance, and monitoring of integrated database systems, and ensuring that the conceptual and design phases of new applications are consistent with the structural parameters within the database environment
• Evaluate user requests for new data elements and systems, incorporate them into the existing shared data environment, and provide technical assistance
• Coordinate the use of data to ensure data integrity and control redundancy, load databases, and reorganize as needed
• Performs logical and physical data modeling, designs relational database models, and creates physical data models from logical data models
• Perform security recovery procedures
• Determines and implements database search strategies and storage requirements
• Maintains data dictionaries ensuring uniformity of definitions and set standards for use of data dictionaries
• Monitor database performance and recommend efficiency improvements
• Create a test database environment for the application section, including the creation of necessary libraries and procedures
• Execute the procedures necessary to save, retrieve, and recover databases from hardware and software failures within established procedures
  
  

Minimum Requirements

Years

Required/Preferred

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, 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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology

• Industries

  Staffing and Recruiting

Referrals increase your chances of interviewing at KAPITAL by 2x

Get notified about new Database Administrator jobs in Austin, TX.

Database Administrator (Hybrid Position)

Austin, Texas Metropolitan Area 2 days ago

Austin, Texas Metropolitan Area 20 hours ago

Austin, Texas Metropolitan Area 2 days ago

Research Intern - High performance and Scalable Database Systems

Austin, Texas Metropolitan Area 2 days ago

Database Administrator 2 (Lead Data Architect)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.