Apply on Employer Site

Texas Health and Human Services · 12 hours ago

2-1-1 TIRN Database Administrator II

Austin, TX

Full-time

Onsite

Mid Level

$5,098.66/mo - $6,701.75/mo

Texas Health and Human Services Commission (HHSC) is seeking qualified candidates for the Database Administrator II position within the 2-1-1 Texas Information and Referral Network (TIRN). The role involves planning, developing, maintaining, and monitoring the integrated 2-1-1 TIRN database and technology-related applications while managing technical projects to achieve program goals.

Health Care

Responsibilities

In coordination with HHSC IT and technology contractors designs, develops, maintains, and tests the 2-1-1 Texas Information and Referral Network (TIRN) database, websites, and applications; performs database performance monitoring, develops performance monitoring tools, identifies database performance problems, and implements efficiency and capacity improvements and updates for the 2-1-1 TIRN database; determines, implements, and enhances database architecture standards to meet 2-1-1 TIRN Program needs, application performance needs, and security requirements; designs or coordinates with HHSC IT and technology contractors the designing of policies and procedures necessary to save and recover databases from hardware and software failures on test, training, and production platforms and environments; plans and coordinates storage, retrieval, migration, and archiving of existing and new data to data management software systems; determines database storage requirements; establishes and controls database, website, and application security; determines and implements database search strategies; performs and/or coordinates the loading of databases and reorganizes as needed, performing data modeling and prototyping, and analyzing, designing, and implementing databases; performs related work as assigned. (35%)

Formulates project plans outlining steps to design, develop, implement, enhance, and maintain the 2-1-1 TIRN database and technology applications; Participates in TIRN team cross-program and multi-agency workgroups, and meetings as required by departmental goals and initiatives; develops project budgets, schedules, work plans, resources requirements, cost estimates and projections; provides guidance, direction, and support to the HHSC-IT, technology contractors, and other development teams to support database and application design, development, maintenance, and enhancements; monitors and manages project quality to ensure project deliverables are acceptable and fulfill the terms of project-related contracts or other specifications; monitors and coordinates with 2-1-1 contract managers to manage project cost and timelines to ensure projects are completed on time and within budget constraints; identifies potential project risks and difficulties and designs strategies to mitigate or avoid them. (35%)

Coordinates communication and reoccurring meetings between 2-1-1 TIRN program staff and HHSC-IT, technology contractors, Area Information Center (AIC) contractors, and other business partners regarding technical database information for the 2-1-1 TIRN database and other technology-related projects; evaluates and prioritizes requests from AIC contractors for new features, tools, and data elements; plans and coordinates with AIC contractors on the use of the 2-1-1 TIRN database and technology applications to ensure data integrity and minimize errors and redundancy; develops policies and procedures to ensure consistent use of the 2-1-1 TIRN database and technology applications by AIC contractors; provides training and technical assistance to AIC contractors, 2-1-1 TIRN program staff, and other and business partners as necessary on the 2-1-1 TIRN database and applications; educates HHSC-IT, AIC contractors, 2-1-1 TIRN program staff, and other business partners on database concepts and techniques; Supports in TIRN related contract management, performance monitoring, and reviews, as needed; the collection, organization, analysis, and preparation of 2-1-1 data and materials in response to requests for information, open records, and other related call data reporting inquiries.(15%)

Analyzes and evaluates enhancements and upgrades to the 2-1-1 TIRN database and technology applications to determine feasibility, cost, time required, compatibility with current system, and computer capabilities; obtains authorization and commitment from 2-1-1 TIRN management for database projects, and demonstrates business need and project feasibility for them; develops and advises 2-1-1 TIRN management on the adoption of operating procedures for the management, performance, and monitoring of the 2-1-1 TIRN database and technology applications; advises on budgets and recommendations for future upgrades to the 2-1-1 database and applications; evaluates and recommends data software packages and upgrades to improve performance of the 2-1-1 TIRN database; reviews and recommends proposals and bids to management; develops and maintains expertise in database management software and performance management tools necessary to meet the needs of 2-1-1 TIRN; stays current on the latest technology updates and development techniques related to the 2-1-1 TIRN database and related applications. (10%)

Other duties as 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. (5%)

Qualification

Database developmentData analysisProject managementDatabase architecturePerformance monitoringTraining othersMicrosoft OfficeCommunication skillsTeam collaborationTechnical writingPresentation skills

Required

Demonstrated experience in project coordination role which includes experience planning and implementing highly complex technology projects

Experience in Texas Health and Human Services funded programs or relevant 2-1-1 Texas experience preferred

Graduation from an accredited four-year college or university

Master's degree preferred

Additional related work experience in a relevant social service field may substitute for the required education on a year-for-year basis with a maximum substitution of four (4) years

Knowledge of the principles, practices, and techniques of database development, design, testing, and monitoring

Knowledge of database structures and theories

Knowledge of various data file formats and file transfer applications

Knowledge of computer operations, systems, and procedures

Knowledge of HHS information security requirements

Knowledge of computer systems, data analysis, or database development and maintenance work

Knowledge of data analysis techniques

Knowledge of supporting projects and participating in workgroups, contract monitoring support, and other related diligence

Knowledge of project management and cost estimating techniques

Knowledge of HHS contracting policies and procedures

Skill in establishing and managing program performance requirements

Ability to assess future database information needs and data elements

Ability to develop reports

Ability to conduct short-range and long-range project planning

Ability to plan, organize, and coordinate work assignments among contracted and non-contracted staff

Ability to analyze systems and procedure, write and revise standards and procedures, and evaluate and make recommendations for program improvements

Ability to train others, prepare concise reports, communicate effectively, and to lead, oversee, and prioritize staff work

Skill creating and conducting presentations both verbally and in writing in meetings

Ability to translate technical information into plain-language for a variety of audiences

Knowledge of Inform USA, formerly known as Alliance of Information & Referral Systems (AIRS) Taxonomy and Professional Standards for Information and Referral

Knowledge of the 2-1-1 TIRN program, local, statewide, and/or nationwide resources, and relevant local, state and federal laws related to 2-1-1 TIRN

Proficiency with in Microsoft Office: Word, Excel, PowerPoint, Access, Project, Teams, SharePoint, and other software