Job/Position DescriptionThe 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 FunctionsEJF#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 https://jobshrportal.hhsc.state.tx.us/ENG/CareerPortal/job_profile.cfm?szOrderID=598593 Copy the URL in the preceding sentence to an Internet Explorer browser to apply to the job directly through the Texas Health and Human Services Career Portal.