Health & Human Services Comm
Database Administrator
Health & Human Services Comm, Austin, Texas, us, 78716
Job Description:
The Database Administrator (DBA) administers databases that are part of the State Health Analytics and Reporting Platform (SHARP) for IDDI Expansion in the AWS GovCloud environment. The DBA works closely with the IDDI agile data engineering team and supports them in the timely delivery of curated data for consumption by downstream reporting and analytics consumers. The DBA is responsible for ensuring the reliability of the databases at the scheduled operational times, enforcing organizational policies and standards related to data classification, data management, and data security. This employee will be provided with training to allow them to function as a backup systems administrator for other tools that are part of the SHARP platform. Additionally, the DBA will collaborate with other stakeholders to formulate policies, procedures, and standards related to data.
Essential Job Functions: Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.
(25%) Perform database installation, configuration, upgrades, apply security patches, and support integration with other ETL/Analytics tools.
(20%) Perform user provisioning and access management using the Principle of Least Privilege principle, monitoring the health of the databases, logging, and auditing to ensure compliance with organizational policies and standards.
(15%) Participate in agile data engineering development and support the team with the database design and implementation based on data pipeline requirements.
(10%) Perform as a backup administrator for other applications (non-database) that are part of the platform.
(10%) Collaborate with various internal and external stakeholders to formulate policies, procedures, and standards related to data management.
(10%) Perform timely resolution of incidents reported in production and ensure minimal disruption to operations.
(10%) Participate in meetings, report performance metrics, and support project management activities, including but not limited to timekeeping, status reporting, and presentations.
Knowledge Skills Abilities: Working knowledge of cloud networking, infrastructure, storage, and database services. Experience in administration of databases such as SQL Server, Snowflake, and Oracle. Experience in database modeling specifically for the analytical workload. Experience automating routine work in a CI/CD environment. Experience in integrating databases with tools such as Informatica PowerCenter, Informatica Data Quality, Tableau, and SAS Viya. Experience with Kubernetes would be helpful. Excellent oral and written communication skills. Effectively manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between tasks, as required.
Registration or Licensure Requirements:
Initial Selection Criteria: 8 years of Database Administrator (DBA) experience. Experience with AWS or Azure or similar. Experience automating work in a CI/CD environment preferred. 1 year experience with Kubernetes preferred. Experience on Oracle and SQL Server preferred 1 year DBA experience with Snowflake is preferred.
Additional Information:
MOS Code: There are no direct military occupation(s) that relate to the responsibilities, and registration or licensure requirements for this position. All active duty, reservists, guardsmen, and veterans are encouraged to apply if they meet the qualifications for this position.
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
Essential Job Functions: Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.
(25%) Perform database installation, configuration, upgrades, apply security patches, and support integration with other ETL/Analytics tools.
(20%) Perform user provisioning and access management using the Principle of Least Privilege principle, monitoring the health of the databases, logging, and auditing to ensure compliance with organizational policies and standards.
(15%) Participate in agile data engineering development and support the team with the database design and implementation based on data pipeline requirements.
(10%) Perform as a backup administrator for other applications (non-database) that are part of the platform.
(10%) Collaborate with various internal and external stakeholders to formulate policies, procedures, and standards related to data management.
(10%) Perform timely resolution of incidents reported in production and ensure minimal disruption to operations.
(10%) Participate in meetings, report performance metrics, and support project management activities, including but not limited to timekeeping, status reporting, and presentations.
Knowledge Skills Abilities: Working knowledge of cloud networking, infrastructure, storage, and database services. Experience in administration of databases such as SQL Server, Snowflake, and Oracle. Experience in database modeling specifically for the analytical workload. Experience automating routine work in a CI/CD environment. Experience in integrating databases with tools such as Informatica PowerCenter, Informatica Data Quality, Tableau, and SAS Viya. Experience with Kubernetes would be helpful. Excellent oral and written communication skills. Effectively manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between tasks, as required.
Registration or Licensure Requirements:
Initial Selection Criteria: 8 years of Database Administrator (DBA) experience. Experience with AWS or Azure or similar. Experience automating work in a CI/CD environment preferred. 1 year experience with Kubernetes preferred. Experience on Oracle and SQL Server preferred 1 year DBA experience with Snowflake is preferred.
Additional Information:
MOS Code: There are no direct military occupation(s) that relate to the responsibilities, and registration or licensure requirements for this position. All active duty, reservists, guardsmen, and veterans are encouraged to apply if they meet the qualifications for this position.
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