DB Developer/Application Support Analyst

• This position can telework 100% from anywhere in Texas consistent with HHS telework policies. Candidates local to Austin preferred.*

The Systems Analyst reports to Application Manager within Health and Specialty Care Systems (HSCS) unit of Information Technology (IT) department for Health and Human Service Commissions (HHSC). This position applies their expertise and technical skills in creating, developing and maintaining database structures, database tuning, stored procedures, SQL Server packages and support for existing and new Electronic Health Record (EHR) application. This position is within the software development and support team and requires development of application business logic with stored procedures and support applications.

The analyst will also perform analytical, and database administrations work for information systems and technologies to support Electronic Health Record (EHR) systems and applications for the State Hospitals (SH's) and State Supported Living Centers (SSLCs). The analyst will support multiple third-party applications (Cerner's Millennium, Netsmart's myAvatar, in house developed MATS, and IRIS_DSS, among others). Work involves gathering and analyzing requirements, design and implementation, and on-going maintenance of existing systems and processes.

Analyst will work with other HSCS application support staff as well as other HHSC to develop and support information systems. The analyst may interact with staff from other agencies and outside entities as required to provide continued support, obtain required work products, or for consultation. Work is performed in an Agile environment and creativity is encouraged.

Essential Job Functions:

Participates in database design sessions for new initiatives and for enhancements to ensure requirements are met. Writes, Tests and Tunes complex database stored procedures. Create database tables, indexes, and other database objects. (25%)

Extracts data from Cerner Millennium or myAvatar application databases using existing tools. Builds data mappings, tasks and workflows using Informatica Tools to load data to the data warehouse databases. Documents, designs, validates, and implements reporting methodologies for multiple areas of specialization using selected HHSC methodology and tools. (25%)

Investigates and identifies corrective solutions to production problems / issues. Consults with IT teams on software/hardware justifications and purchases. Supports in troubleshooting and solving complex problems related to EHR system software and hardware incidents and problem calls, and in the processing of service requests and tasks. (20%)

May provide on-call application support as part of the support team based on team rosters. Provides technical expertise to aid in decision making and problem resolution for EHR applications (10%).

Performs quality assurance tasks to ensure accuracy of fixes provided to resolve issues. Documents processes and procedures for technical and non-technical users. (10%)

Performs other duties as assigned and required to maintain unit operations. Promotes and demonstrates appropriate respect for cultural diversity among coworkers and all work-related contacts (10%).

Knowledge Skills Abilities:

• Skills in developing complex high-quality database solutions.

• Skills in using server OS in Unix/Linux/AIX and Windows servers.

• Skills in using software such as SQL, SQL*Plus, PL/SQL, TOAD, Oracle, SQL Developer, Business Intelligence tools.

• Skills in analysis, problem solving, data comprehension, reporting methodologies, and designing statistical reports and charts/graphs.

• Skill in researching and troubleshooting application system issues and solving complex problems.

• Knowledge of relational databases, data systems and data warehouses.

• Experience in writing Stored Procedures, SQL quiries and query tuning on high transaction systems.

• Experience to maintain database indexes, columns and tables using DDL, DML and DCL constructs.

• Experience in using SQL Server Integration Services (SSIS).

• Experience in building data mappings, tasks and workflows using Informatica Tools to load into data warehouse databases.

• Analyze existing SQL queries for performance improvements.

• Develop procedures and scripts for data migration.

• Review and interpret ongoing business report requirements.

• Knowledge of cloud delivery models: PaaS, SaaS, IaaS.

• Knowledge of SDLC methodologies like Agile, Waterfall and DevOps.

• Knowledge of best practices governing architecture, infrastructure and security for information systems that collect PII, PHI and HIPAA data.

• Knowledge of EHR applications functionality.

• Ability to analyze, consolidate, and interpret complex data, procedures, and systems and write or revise program code as required.

• Ability to analyze systems, procedures, and problems and develop solutions.

• Ability to present information to a variety of audiences verbally and in writing and to communicate clearly, concisely, and effectively.

• Ability to work hours as needed to meet defined deadlines and support the agency's mission critical requirements.

• Ability to provide excellent customer service to end users of the applications.

Registration or Licensure Requirements:

Initial Selection Criteria:

Required:

• Minimum of 4 to 6 years of experience experience/knowledge in supporting Electronic Health Record (EHR) systems or similar applications.

• Experience using Microsoft office suites is required.

Preferred:

• Bachelor's degree or higher in a technology related field is preferred. May substitute direct work experience on a year-for-year basis in lieu of education.

• Minimum 4 years of experience in using EHR application (Cerner Millennium, Netsmart's myAvatar or similar) in a largescale private/public environment is preferred

• Minimum of 4 years of experience in using Unix/Linux/AIX OS pr MS Windows Servers are preferred.

• Minimum of 4 years of experience in report design, development and automation is preferred.

• Minimum of 4 years of experience in data extraction, transition, and load (ETL) tools such as Informatica PowerCenter, database design and implementation preferred.

• Minimum of 4 years of experience in using DDL (Data Definition Language), DML (Data Manipulation Language), and DCL (Data Control Language) in the creation/maintenance of SQL Server databases, Oracle or similar.

• Experience in using ITSM tools such as ServiceNow, Remedy on Demand or similar is a plus.

• Good command of written and spoken English.

Additional Information:

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. 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