Evaluates and recommends goals and objectives for the use and improvement of an efficient and cost-effective database system and software packages. Evaluates and implements database policies and procedures; Develops goals and objectives for the use and improvement of an efficient and cost-effective database system. May train others. Works under limited supervision, with considerable latitude for the use of initiative and independent judgment.
Oversees and performs the design, development, and maintenance of databases including structures, behaviors, performance, security, and recovery. Monitors database performance and implements efficiency improvements. Ensures that data integrity and data security is maintained. Identifies and resolves problems. Prepares status updates for supervisor. Analyzes, designs, plans, and performs database upgrades and maintenance. Coordinates with service provider and application groups to install new versions, new enhancements, and newly released databases. Monitors database performance and implements efficiency improvements. Coordinates backup monitoring and fixes issues related to backups. Modifies existing databases and database management systems. Analyzes objects and databases. Performs database migration. Analyzes and reports the performance of database operations. (50%)
Coordinates with application development, customers, and support teams to ensure their needs are met from a database perspective. Participates in the planning, design, administration, operation, monitoring, maintenance, user security, and system parameter settings for databases. Coordinates backup, restore, and recover tasks that apply to production, development, and test databases. (20%)
Evaluates users' requests for new data elements, data systems, data migration, and data integration. Provides input and analysis to other teams regarding database related topics and decisions. Sets-up views, roles, stored procedures, and database links to allow use of databases. Creates tables and provides the data required to fulfill requests. Assists customers and other groups in troubleshooting, testing, and resolving database issues. Evaluates and recommends database software packages for potential acquisitions. May train others. (15%)
Develops standards, guidelines, policies, and procedures designed to ensure the integrity of the database environment. Ensures audit and security standards are adhered to and documented appropriately. Maintains data integrity and security. Creates and maintains data dictionaries. Participates in security and risk evaluations for applications. Maintains practices within established policies, regulations, and guidelines. (10%)
Other duties as assigned. May 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. (5%)
Knowledge:
Skills:
Abilities:
Three years of database administration experience in SQL database.
Bachelor’s degree or higher in a technology related field is preferred.
Experience in cloud migration and Power BI is preferred.
This position can telework full time from any location in Texas consistent with HHS telework policies. Applicants from outside Texas must be willing to relocate within 60 days of hire.
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.
Top 10 Tips for Success when Applying to Jobs at HHSC and DSHS
HHS agencies use E-Verify. You must bring your I-9 documentation with you on your first day of work.
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.