DB Developer/Application Support Analyst - Austin, United States - Texas Department of Aging & Disability Services

Texas Department of Aging & Disability Services Austin, United States

3 weeks ago

Description

Job Description:

This position can telework % 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.

Customer Support Analyst

2 weeks ago

Iodine Software Austin, United States

**Customer Support Analyst** · Iodine Software equips medical care teams with the most innovative tools to solve some of their toughest problems in clinical documentation. By leveraging new technologies like Natural Language Processing, Machine Learning, and Artificial Intelligen ...
Appeals Support Analyst

2 weeks ago

Experian Austin, United States

Full-time · Employee Status: Regular · Role Type: Hub · Job Posting - Salary Range: $42,098 - $72,969 · Department: Customer Service · Flexible Time Off: 15 Days · Schedule: Full Time · Shift: Day Shift · **Company Description**: · - Our mission is to use data driven insights to ...
Desktop Support Analyst

2 weeks ago

Brown Advisory Austin, United States

Company Overview · Every firm has a culture - the values, beliefs, methodology, attitudes and standards that reflect an organization's DNA. But the truly inspiring firms - the game-changers, the industry leaders and the disruptors - have cultures that propel them to innovate and ...
Investment Banking Support Analyst

3 weeks ago

Benchmark International CSS, L Austin, United States

Benchmark International is looking for an experienced and driven Analyst to add to our team. As an Analyst, you will be a part of our busy office. The Analyst will collect, analyze, summarize, and discuss Benchmark International's clients' most sensitive data; preparing our clien ...
Tier 1 Support Analyst

1 week ago

Acumera Inc Austin, United States

**Who We Are** · Based in Austin, Texas, Acumera is a leader in managed network security and automation services for multi-site businesses' payment systems and operations. Acumen provides software-as-a-service (SaaS) solutions for edge computing, secure edge networking, network o ...
Irb Analyst, Office of Research Support and

1 week ago

University of Texas at Austin Austin, United States

Job Posting Title: · IRB Analyst, Office of Research Support and Compliance · - Hiring Department: · Office of Research Support and Compliance · - Position Open To: · All Applicants · - Weekly Scheduled Hours: · 40 · - FLSA Status: · Exempt · - Earliest Start Date: · Immediately ...
Technical Support Analyst

1 week ago

GCS Technologies Austin, Texas, United States Permanent

· Job Summary · Technical Support Analysts at GCS are expected to have and maintain a high level of technical competence over a very large range of products. They will be expected to learn new products and technologies quickly and constantly. In addition, they are expected to ha ...
IT Support Analyst II

4 weeks ago

Texas Association of School Boards Austin, United States

Why Texas Association of School Boards (TASB) · We come from humble beginnings — picture a one-person organization created in 1949 to advocate for excellence in public education on behalf of Texas school board members. Flash forward to today, and we have over 500 employees worki ...
Drupal Support Analyst

3 weeks ago

Esolvit Austin, United States

Title: Drupal Support Analyst · Location: Austin, TX · Duration: Long Term · You may either create a user id and sign up under the arytic link or go in without signing up to access the job/open roles on our Arytic platform. · Job Description: · Implement the configuration man ...
Senior Technical Support Analyst

1 week ago

GCS Technologies Austin, Texas, United States Permanent

· Job Summary · Senior Technical Support Analysts at GCS are expected to have and maintain a high level of technical competence over a very large range of products. They will be expected to learn new products and technologies quickly and constantly. In addition, they are expecte ...
ERS - Financial System Support Analyst

1 day ago

EMPLOYEES RETIREMENT SYSTEM Austin, United States

ERS - Financial System Support Analyst Organization · :EMPLOYEES RETIREMENT SYSTEM Primary Location · :Texas-Austin Work Locations · :Main Office E 18th StreetAustin78701 Job · :Computer and Mathematical Employee Status · :Regular Schedule · :Full-timeStandard H ...
Atlassian Product Support Analyst

3 weeks ago

Esolvit Austin, United States

Title: · Atlassian Product Support Analyst · Location: · Austin, TX · Duration: · Long Term · You may either create a user id and sign up under the arytic link or go in without signing up to access the job/open roles on our Arytic platform. · Job Description : · The Depar ...
IT Business Analyst, Client Support

3 weeks ago

Sonic Healthcare USA Inc Austin, United States

Position Summary · Job Functions, Duties, Responsibilities and Position Qualifications: · The Client IT Support Analyst I (CITSA-I) position will acquire a proficiency level to independently provide support for low issues for all client connectivity solutions provided by SHUSA. ...
Senior Technical Support Analyst

2 weeks ago

GCS Technologies Austin, United States

Job Description · Job DescriptionJob SummarySenior Technical Support Analysts at GCS are expected to have and maintain a high level of technical competence over a very large range of products. They will be expected to learn new products and technologies quickly and constantly. In ...
Software Technical Support Analyst

3 weeks ago

Xerox Austin, United States Paid Work

Software Technical Support Analyst · General Information · Press space or enter keys to toggle section visibility · Country · United States · Department · Technical Customer Services · Date · Wednesday, May 1, 2024 · Working time · Full-time · Ref# · Job Level · Individual Contri ...
Business Application Support Analyst I

11 hours ago

The University of Texas at Austin Austin, United States

Job Posting Title: · Business Application Support Analyst I · ---- · Hiring Department: · Enterprise Business Information Technology Solutions · ---- · Position Open To: · All Applicants · ---- · Weekly Scheduled Hours: · 40 · ---- · FLSA Status: · To Be Determined a ...
Systems Support Analyst

1 week ago

Esolvit Austin, United States

Title: · Systems Support Analyst · Location: · Austin, TX · Duration: · Long Term · You may either create a user id and sign up under the arytic link or go in without signing up to access the job/open roles on our Arytic platform. · Job Description : · Seeking a highly sk ...
OIM Support Analyst

2 weeks ago

ApTask Austin, United States

Position Title: OIM Support Analyst · Job Location: Austin, TX or Phoenix, AZ (Onsite) · Job Type: FTE · JOB DESCRIPTION: · We are looking for an OIM Support engineer, who would be helping our production support team with Client interaction, Providing Technical Solutions, Task ma ...
Contract Support Analyst

4 days ago

CBRE Austin, United States

Contract Support Analyst - Contract WriterJob ID169898Posted30-May-2024Service lineGWS SegmentRole typeFull-timeAreas of InterestPurchasing/ProcurementLocation(s)Austin - Texas - United States of America, Charlotte - North Carolina - United States of America, Chicago - Illinois - ...
Drupal Support Analyst

3 weeks ago

Esolvit Austin, United States

Title: · Drupal Support Analyst · Location: · Austin, TX · Duration: · Long Term · You may either create a user id and sign up under the arytic link or go in without signing up to access the job/open roles on our Arytic platform. · Job Description : · Implement the config ...