Database Administrator IV - Austin, United States - Texas Department of Aging & Disability Services

Texas Department of Aging & Disability Services Austin, United States

1 week ago

Description

Job Description:

The Database Administrator IV performs advanced (senior level) database administration and application development functions for the Data Management team within Information and Data Management, Office of Data, Analytics and Performance (DAP).

The DBA IV will be responsible for overseeing and coordinating support of various DAP controlled data assets including SQL Server and Oracle systems.

They will work to ensure reliable performance and functionality and will work with other members of the DM team to perform development and testing within these assets.

DBA IV will also review and provide feedback on larger DAP data asset architecture and data modeling.

They will also be responsible for developing and updating standard operating procedures and guidelines for the work done within these data assets.

The DBA IV will conduct analysis of data sets, perform data needs assessment, data acquisition, cleaning, standardization, extraction, transformation, and loading into database systems.

The DBA IV will design, code, evaluate and implement changes to the data sets as driven by the needs of DAP and HHSC.

They will be responsible for managing these data assets and working to increase efficiency by automating routine tasks. Mentors ADDM team members and DAP staff in the use of compiled datasets. Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment.

Essential Job Functions:

EJF#1:

Consults and coordinates with HHSC IT, Texas Shared Technology Services, and data trading partner technical staff in order to maintain and troubleshoot computer applications and data management processes.

Collaborates with business analysts to understand data requirements and translate them into technical specifications to integrate into current data warehouse models.

Develops and maintains data quality and data governance processes to ensure accuracy, consistency, and integrity of data in the warehouse.

EJF #2:
Initiates and coordinates projects to refresh and upgrade database software and server operating systems. Maintains and updates server and database configuration to maintain connectivity between HHSC systems and data trading partners.

Resolves functional and performance issues by conducting performance tuning and optimization of data warehouse processes and queries to improve overall system efficiency.

Collaborates with ATOS and other database system management vendors to ensure proper configuration, backup, and recovery of the data warehouse.

EJF#3:
Consults and coordinates with DAP and other HHSC staff to identify business needs related to database systems. References data in various HHS and other systems and transform research and reporting requirements into ADDM/DAP data systems.

Acquires, extracts, cleans, transforms, and loads needed datasets into ADDM/DAP database systems and writes complex SQL queries and stored procedures to extract and manipulate data for reporting and analysis purposes.

Mentors DAP staff in the use of data systems.

EJF#4:

Consults and coordinates with ADDM, DAP and other HHSC staff to identify potential areas for increased efficiencies using automation.

Designs, develops, codes, evaluates, implements, and documents computer applications and procedures to implement those efficiencies. Conducts data profiling and data analysis to identify data quality issues and recommend improvements.

EJF#5:

Prepares and reviews a variety of written, oral, and graphical deliverables containing analyses of Health and Human Services data to detect data trends and anomalies, optimize health outcomes.

Provides DAP and data management leadership information necessary to make informed decisions on streamlining workflows and processes, modification of existing data models, and recommendations on the enhancement of database system architecture.

Develops and maintains data quality and data governance processes to ensure accuracy, consistency, and integrity of data in the warehouse.

EJF#6:
Trains DAP staff on QAI Datamart applications and systems. Identifies areas for learning and development and participates in training programs available to HHSC and DAP staff members. Identifies and incorporates innovative solutions to streamline workflows and processes.

Knowledge Skills Abilities:
Knowledge of the process of computer application development.
Knowledge of Oracle 19c on the Linux platform
Knowledge of data warehouse architecture of Star and Snowflake schemas used in relational, dimensional, and multi-dimensional data modeling.
Knowledge of scripting language to import and extract database information in a Linux batch environment – preferably PERL.
Knowledge of scientific research methods, statistical techniques, mathematics, geographical concepts, and their application to data analytics.
Knowledge of the various Texas Health and Human Service (HHS) programs.

Knowledge of patient level health and demographic data (e.g., Census, Vital, Medicaid, and CHIP data including eligibility, enrollment, medical claims, and encounters).

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

Knowledge of medical records systems or clinical coding practices.
Knowledge of Internet and World Wide Web.
Knowledge of computer programming principles, spreadsheet macros, and database design.
Skill in developing computer applications using high level interpreted languages such as Perl.
Skill in using SAS, SPSS, SQL, R, ACCESS, Business Objects, or other statistical and database management software.
Skill in using EXCEL or other spreadsheet software.
Skill in graphical, tabular, and geographical presentation of data.
Skill in verbal and written communications.
Skill in database management with Oracle, SQL Server, or similar large database systems.

Ability to analyze and solve problems.
Ability to design, develop, code, test, implement, maintain, and document computer applications.
Ability to manage, manipulate, and analyze complex databases.

Ability to Extract, transform, and load (ETL) data from various sources into the data warehouse using tools like Informatica, PERL, and Linux shell scripts.

Ability to oversee and/or supervise the work of others.
Ability to plan, organize, and conduct data analytic projects.
Ability to work in a team and to communicate effectively.
Ability to develop and interpret statistical data charts, maps, and tables.
Ability to interpret and publish data analytic findings.
Ability to exercise independent judgment and show initiative.
Ability to maintain detailed and organized documentation of data analytic projects.
Ability to train staff in the use of data systems.

Database Administrator

2 weeks ago

Health & Human Services Comm Austin, United States

The DBA works on activities including but not limited to database tuning, indexing, customization, data migrations/conversions, installations, troubleshooting, upgrades, patching, user management, security of data at rest and in motion, disaster recovery, clustering for high avai ...
Vertica Database Administrator

2 days ago

Q1 Technologies Austin, United States

Minimum 10+ years experience in Vertica and managing several multi-terabyte Vertica databases both on-prem and cloud. · Expert Knowledge of Vertica Architecture - Vertica Enterprise and Vertica Eon.Expertise in installing/upgrade and maintaining 50+ Vertica environments. · 5+ yea ...
Vertica Database Administrator

2 days ago

Formac Austin, United States

Vertica DBA · Austin, TX / Sunnyvale, CA · Long TERM · Minimum 10+ years experience in Vertica and managing several multi-terabyte Vertica databases both on-prem and cloud. · Expert Knowledge of Vertica Architecture - Vertica Enterprise and Vertica Eon. · Expertise in installing/ ...
Database Administrator

1 week ago

Alliance IT Austin, United States

Position: Database Administrator · Location: Austin, TX · The role is for a Senior Database Administrator and will perform advanced database administration tasks for databases used by applications with complex data models, workflows, and reports. · Assists the team in creating a ...
Database Administrator

1 week ago

Infojini Austin, United States

Enters codes to create production data base. Selects and enters codes of utility program to monitor database performance, such as distribution of records and amount of available memory. Directs programmers and analysts to make changes to data base management system. Reviews and c ...
Database Administrator

1 week ago

Rose International Austin, United States

Date Posted: 05/01/2024 · Hiring Organization: Rose International · Position Number: 463334 · Job Title: Database Administrator · Job Location: Austin, TX, USA, 78751 · Work Model: Hybrid · Shift: 8:00 AM to 5:00 PM · Employment Type: Temporary · Estimated Duration (In months): 2 ...
Database Administrator

2 weeks ago

Oscar Austin, United States

We are seeking a skilled and experienced Database Administrator to join our team. The ideal candidate will have a strong background in database management systems, along with expertise in software development life cycle principles and practices. As a Database Administrator, you w ...
Database Administrator

5 days ago

L.K. Jordan & Associates Austin, United States

Database Administrator wanted in the Austin area Are you a tech-savvy problem-solver with a keen eye for detail? We're seeking a dynamic individual to join our team and revolutionize our lead intake, tracking, and communication processes100% Remote Database Administrator, Databas ...
Database Administrator

2 weeks ago

My3Tech Austin, TX, United States

Title : Sr. Database Administrator · Location : Austin, TX (Hybrid - 2 days Onsite, 3 days Remote) · Duration : 12+ months · Note: Consultants who are in AUSTIN TX are preferred. · Job Details : · JOB DESCRIPTION · This candidate must have at least 8 years of experience in this f ...
Database Administrator

2 weeks ago

SilverLinx Hollow Rock, United States

Reference number: · Your tasks · As a motivated database administrator, you are responsible for the operation and monitoring of our customers' Oracle databases and support technical and functional database issues · You install and manage single instance, standby, and RAC environ ...
Database Administrator

1 week ago

Keylent Inc Austin, United States

Position: Database Administrator (ORACLE, SQL, POSTGRE-SQL) · Location: Austin, TX (Hybrid) · Duration: 12 months · Job Description: Enters codes to create production data base. · Selects and enters codes of utility program to monitor database performance, such as distribution o ...
Database Administrator

3 days ago

IDR Healthcare Austin, United States

IDR is seeking a Database Administrator to join one of our top clients in the public sector industry. If you are looking for an opportunity to join a large organization and work within an ever-growing team-oriented culture, please apply today · Position Overview/Responsibilities ...
Database Administrator

1 week ago

Texas Department of Aging & Disability Services Austin, United States

Job Description: · The Database Administrator (Database Administrator IV) position performs advanced database administration tasks for databases used by applications with complex data models, workflows, and reports. Assists the team in creating and maintaining logical and physica ...
Database Administrator

4 days ago

Zilliant Austin, United States

Job Description · Job DescriptionZilliant powers intelligent B2B commerce with our industry-leading price optimization and sales guidance software. Our data science, cloud-native software, and passion for customer success deliver the highest ROI, fastest time to value, and highes ...
Database Administrator

1 week ago

LanceSoft Austin, United States

Job Description... · Designs and builds relational databases. Develops strategies for data acquisitions, archive recovery, and implementation of a database. Cleans and maintains the database by removing and deleting old data. Years Required/Preferred Experience 8 Required Design ...
Database Administrator 3

1 week ago

Smart IMS Austin, United States

Texas Health and Human Services Commission requires the services of 1 Database Administrator 3, hereafter referred to as Candidate(s), who meets the general qualifications of Database Administrator 3, Data/Database Administration and the specifications outlined in this document f ...
Database Administrator 3

2 weeks ago

Indotronix International Corporation Austin, United States

OTHER SPECIAL REQUIREMENTS · remote work Mon -Fri · Location: any location in the Client · Interviews will be conducted through Microsoft Teams · Enters codes to create production data base. Selects and enters codes of utility program to monitor database performance, such as ...
Database Administrator 1

56 minutes ago

Abacus Austin, United States

Solicitation Reference Number · Customer Name · Texas Health and Human Services Commission · Category · Data/Database Administration · Customer Entity Name · Health and Human Services Commission · Title · Database Administrator · Level · Database Administrator 1 · Estimated Hours ...
Senior Database Administrator

1 week ago

Allied Consultants (Texas) Austin, United States

Overview: · Allied Consultants, Inc. is an Austin-based firm which has for 32 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced Senior Database Administrator to be a key resource on a technical serv ...
Database Administrator 3

1 week ago

Five Cubes, Inc. Austin, United States

Job Title: Database Administrator · Location: Austin, TX (Remote) · Duration: 6+ months · Direct Client · Out of State candidates will not be considered. · Job Description: · This Database Administrator (DBA) 3 contractor position is part of the Administrative Applications Data ...