Health & Human Services Comm
Database Administrator III
Health & Human Services Comm, Austin, Texas, us, 78716
Job Description:
Performs highly complex (senior-level) database administration work. Work involves planning, designing, developing, maintaining, and monitoring integrated database systems; evaluating and reviewing database policies and procedures; and maintaining data integrity, security, and accessibility of the agency's data. Coordinates with service providers and application groups to install new versions, new enhancements and newly released databases to HHSC database system. Monitors applications for space utilization on test, development, and production environments. Works with service provider Systems Group, Production Control Group, and Mainframe Database Group to set up production jobs, schedule jobs, monitor jobs, and performance tune the jobs that run with specific job schedulers in the Health and Human Services (HHSC) database environments. Monitors database performance and adjusts as required to maximize efficiency. Archives, restores, and recovers databases as required.
The position will have primary responsibility for analyzing the business needs of the Office of Data Analytics and Performance (ODAP) related to data in the Texas Integrated Eligibility Redesign System (TIERS), Quality Assurance and Improvement (QAI) Data Mart, and Office of Data Analytics and Performance Data Repository (ODAP DR) and perform data extractions. Work involves the transformation of research and reporting requirements into data system designs to provide for effective and efficient data file processing, data uploads, and retrieval in both Oracle and SQL Servers to meet the data needs of the ODAP. Prepares accurate and concise reports in a timely manner. Performs quality assurance tasks to ensure the accuracy of distributed reports. Works under limited supervision, with considerable latitude for the use of initiative and independent judgment.
Essential Job Functions: EJF. 1 Analyzes, designs, plans and performs database upgrades and maintenance. Coordinates with service providers and application groups to install new versions, new enhancements, and newly released databases to HHSC data systems. Maintains system vulnerability, risk assessment, and security logs and works with IT vendors to resolve security and compliance issues.
EJF 2. Coordinates with application development and support teams to ensure their needs are met from a database perspective. Participates in the planning, design, administration, operation, monitoring, maintenance, and user management related ODAP data assets. Develops and maintains system security plans to ensure data integrity.
EJF 3. Consults and coordinates with the Office of Data Analytics and Performance (ODAP) program areas to identify business needs related to data housed within the HHSC data assets. Acquires, extracts, transforms and loads data into HHSC applications and database systems. Retrieves data from HHSC applications and data assets to fulfill reporting needs of program areas within HHSC and ODAP.
EHF 4: Participates in DM unit's cross-training activities and inter-agency work group activities including data quality control analyses, periodic data quality assessments, and data-related continuous quality improvement tasks. Identifies areas for learning and participates in training programs available to HHSC and DAP staff members. Identifies and incorporates innovative solutions to streamline workflows and automation of ETL processes. Creates and maintains training materials on team processes and provides training to internal and external staff. Creates and maintains process documentation, including workflows, work plans, tasks, and project timelines.
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 the various Texas Health and Human Services (HHS) programs. Knowledge of the data systems used to store and track program eligibility related to the various Texas HHS programs. Knowledge of data analytics tools. Skills in administering Oracle and MS SQL databases. Skills in using data querying and analytics tools. Skills in extracting data from OLTP systems for use in OLAP systems. Skills in performing and automating ETL processes. Ability to clearly communicate complex concepts, both verbally and in writing, to audiences with a wide range of backgrounds, experiences and expertise. Ability to find root causes of problems and devise efficient and effective solutions. Ability to train staff in the use of database client tools. Ability to work independently and to meet deadlines. Ability to manage and coordinate multiple activities in different projects. Ability to design and develop database systems based on customer requirements. Ability to work independently and to meet deadlines. Ability to oversee and/or supervise the work of others.
Registration or Licensure Requirements:
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. Experience may be substituted for education on a year for year basis. 1. At least 2 years of full-time job experience doing Data Extraction, Transformation, and Loading (ETL)? 2. At least 2 years of full-time job experience managing data in the databases? 3. At least 2 years of full-time job experience writing MS SQL and/or Oracle SQL queries to retrieve data from databases?
Additional Information: This position is eligible for a hybrid telework schedule but must attend the office at least one day per week to facilitate specific job functions and support team collaboration.
The offered salary will be based on available budgeted funds. This position also includes a comprehensive benefit package, including health coverage, wellness programs, and retirement benefits.
MOS Code: 25B, IT, 275, 0651, 3D0X2
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
The position will have primary responsibility for analyzing the business needs of the Office of Data Analytics and Performance (ODAP) related to data in the Texas Integrated Eligibility Redesign System (TIERS), Quality Assurance and Improvement (QAI) Data Mart, and Office of Data Analytics and Performance Data Repository (ODAP DR) and perform data extractions. Work involves the transformation of research and reporting requirements into data system designs to provide for effective and efficient data file processing, data uploads, and retrieval in both Oracle and SQL Servers to meet the data needs of the ODAP. Prepares accurate and concise reports in a timely manner. Performs quality assurance tasks to ensure the accuracy of distributed reports. Works under limited supervision, with considerable latitude for the use of initiative and independent judgment.
Essential Job Functions: EJF. 1 Analyzes, designs, plans and performs database upgrades and maintenance. Coordinates with service providers and application groups to install new versions, new enhancements, and newly released databases to HHSC data systems. Maintains system vulnerability, risk assessment, and security logs and works with IT vendors to resolve security and compliance issues.
EJF 2. Coordinates with application development and support teams to ensure their needs are met from a database perspective. Participates in the planning, design, administration, operation, monitoring, maintenance, and user management related ODAP data assets. Develops and maintains system security plans to ensure data integrity.
EJF 3. Consults and coordinates with the Office of Data Analytics and Performance (ODAP) program areas to identify business needs related to data housed within the HHSC data assets. Acquires, extracts, transforms and loads data into HHSC applications and database systems. Retrieves data from HHSC applications and data assets to fulfill reporting needs of program areas within HHSC and ODAP.
EHF 4: Participates in DM unit's cross-training activities and inter-agency work group activities including data quality control analyses, periodic data quality assessments, and data-related continuous quality improvement tasks. Identifies areas for learning and participates in training programs available to HHSC and DAP staff members. Identifies and incorporates innovative solutions to streamline workflows and automation of ETL processes. Creates and maintains training materials on team processes and provides training to internal and external staff. Creates and maintains process documentation, including workflows, work plans, tasks, and project timelines.
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 the various Texas Health and Human Services (HHS) programs. Knowledge of the data systems used to store and track program eligibility related to the various Texas HHS programs. Knowledge of data analytics tools. Skills in administering Oracle and MS SQL databases. Skills in using data querying and analytics tools. Skills in extracting data from OLTP systems for use in OLAP systems. Skills in performing and automating ETL processes. Ability to clearly communicate complex concepts, both verbally and in writing, to audiences with a wide range of backgrounds, experiences and expertise. Ability to find root causes of problems and devise efficient and effective solutions. Ability to train staff in the use of database client tools. Ability to work independently and to meet deadlines. Ability to manage and coordinate multiple activities in different projects. Ability to design and develop database systems based on customer requirements. Ability to work independently and to meet deadlines. Ability to oversee and/or supervise the work of others.
Registration or Licensure Requirements:
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. Experience may be substituted for education on a year for year basis. 1. At least 2 years of full-time job experience doing Data Extraction, Transformation, and Loading (ETL)? 2. At least 2 years of full-time job experience managing data in the databases? 3. At least 2 years of full-time job experience writing MS SQL and/or Oracle SQL queries to retrieve data from databases?
Additional Information: This position is eligible for a hybrid telework schedule but must attend the office at least one day per week to facilitate specific job functions and support team collaboration.
The offered salary will be based on available budgeted funds. This position also includes a comprehensive benefit package, including health coverage, wellness programs, and retirement benefits.
MOS Code: 25B, IT, 275, 0651, 3D0X2
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