Texas Health & Human Services Commission-posted about 2 months ago
Full-time • Mid Level
Onsite • Austin, TX
1,001-5,000 employees
Administration of Human Resource Programs

Under the general supervision of the Branch Manager in the Public Health Applications Division of Texas Health & Human Services (HHS) IT, serves as a Senior Database Administrator performing highly advanced (Senior-level) database administration work. Work involves providing for efficient and effective storage, retrieval, customization, and archiving of data to ensure integrated database systems. The Database Administrator will ensure that data is available to users; data remains consistent across the database; is clearly defined and there is provision for data security and recovery control (ensuring all data is retrievable in an emergency), maintain the integrity, performance and security of the databases of many SQL application databases, Mongo DB and PostgreSQL Database. This Database Administrator is responsible for the maintenance, administration, and performance of databases including SQL server. The DBA is a key player in maximizing database performance. Main responsibilities are keeping the databases up and running all the time. Ability to do DML and DLL script deployments to various environments. Daily monitoring of the applications for their uptime, and error resolutions. This position provides product and/or process expertise necessary to support design, development, testing and execution of solutions, utilizes business and technical knowledge of server platforms/operating systems to develop and support data, databases or vendor products, implements data monitoring solutions to monitor the database performance and evaluate complex information coming from a variety of sources, develops and implements data validation processes, works under minimal supervision, with extensive latitude for initiative and independent judgement, performs advanced analysis and design duties, maintains an understanding of how technology can enhance and offer a range of solutions for continual improvement of processes in order to increase business value and/or improve efficiencies. Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned. Work outside of regular hours may be required. Must be willing to work onsite at an Austin, TX HHS office three (3), or more, days per week. Selected candidates must be legally authorized to work in the U.S. without sponsorship.

  • Coordinates the installation of database software and migrations to new data management system software levels and ensures that migrations are appropriately tested and validated. Coordinates and provides application and database operations triage support to troubleshoot and resolve functional and performance issues encountered in production, development and test environments. Provides advanced database development and oversee modifies and/or maintains database structures. Performs logical and physical data modeling, evaluates relational database models, and reviews physical data models created from logical data models.
  • Plans and databases, as well as in troubleshooting any issues on behalf of the users. Knowledge and experience in development and maintenance of PostgreSQL databases. Installing and configuring PostgreSQL databases, ensuring security through access control and auditing, maintaining performance through tuning and monitoring, and managing data integrity with regular backups, disaster recovery plans. Collaborate with developers on database design and feature implementation, maintain documentation, and provide technical support for database-related issues. Communicate regularly with technical, applications and operational staff to ensure database integrity and security. Control access permissions and privileges.
  • Make requested changes, updates and modifications to the database structure and data to ensure security, integrity, stability and system availability. Prepare regular reports to summarize all database operating issues and appropriate resolutions.
  • Maintain database backup and recovery infrastructure.
  • Assists in developing strategic plans. Assists in developing agency data processing plans, budgets and justification. May prepare management level reports, such as priority lists, quarterly reports, and operating plan. Advise management of the status and progress of projects and other tasks being conducted.
  • Other duties assigned include but are not limited to actively participating and/or serving in a supporting role to meet the agency's obligations for disaster response and/or recovery or Continuity of Operations (COOP) activation. Such participation may require an alternate shift pattern assignment and/or location.
  • Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.
  • Knowledge of cloud database management, SSIS, SSRS, SSAS - SQL server integration.
  • Advanced skill with SQL server administration functions
  • Skill with SQL performance tuning and optimization
  • Skill with SQL high availability and disaster recovery
  • Skill with SQL database security, SQL scripting and automation, monitoring and alerting
  • Skilled with PostgreSQL
  • Skilled in MongoDB administration, replication and sharding, Experience in complex enterprise level deployments, and providing top-tier support.
  • Ability to complete performance tuning, high availability, large scale production environment monitoring and maintenance.
  • A bachelor's degree in a computer-related field, computer science or information technology, is required.
  • 3 to 5 years of experience in specific database software including one, or more, of the following is required: SQL, Microsoft Azure, MongoDB, PostgreSQL.
  • 3 to 5 years of hands on work experience experience as a Database Administrator is required.
  • A master's degree in a computer-related field is preferred.
  • Certification in Mongo DB or PostgreSQL preferred.
  • comprehensive benefits package includes 100% paid employee health insurance for full-time eligible employees, a defined benefit pension plan, generous time off benefits, numerous opportunities for career advancement and more
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service