DB Developer/Application Support Analyst

Found in: Talent US 2 C2 - 2 weeks ago

Austin, United States Texas Department of Aging & Disability Services Full time
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.

  • Developer/Programmer Analyst 3

    1 week ago

    Austin, United States CareerBuilder Full time

    Texas Education Agency requires the services of 1 Developer/Programmer Analyst 3 , hereafter referred to as Candidate(s), who meets the general qualifications of Developer/Programmer Analyst 3, Applications/Software Development and the specifications outlined in this document for the Texas Education Agency . All work products resulting from the project shall...

  • Application Systems Analyst II

    1 week ago

    Austin, United States Cap Metro Full time

    Application Systems Analyst II will analyze science, engineering, business, and other data processing problems to develop and implement solutions to complex applications problems, system administration issues, or network concerns. Perform systems management and integration functions, improve existing computer systems, and review computer system capabilities,...

  • IT Support Analyst

    4 days ago

    Austin, United States CareerBuilder Full time

    Role: IT Support Analyst 6+ months with extension This is a 100% onsite role. Location - Austin TX Rate : $55-60/hr.c2c NOTE : Austin and willing/able to drive to various site locations within Austin throughout the day. There is no mileage reimbursement. Key Activities/Responsibilities: Assist in installs, maintains and provides technical support for users....

  • Application Developer

    4 days ago

    Austin, United States NR Consulting Full time

    Job Title: Application Developer - Java Work Location: Austin, TX or San Jose, CA Position Type: Contract with possible extension Duration: 12 + Months Job Description: •Developer || Business Analyst •Responsible for maintenance activities •Responsible for monitoring the production applications •Responsible for analyzing the production issues and...

  • Application Development Management Analyst

    7 hours ago

    Austin, United States Dept of Family & Protectve Svc Full time

    Management Analyst IV - Performs highly advanced (senior-level) professional organizational, program and policy analysis and oversight work, conducting organizational studies and evaluations, analyzing systems and procedures, conducting work simplification studies, developing and conducting program activities, and preparing operations and procedures manuals...

  • IT Systems/Business Analyst

    1 week ago

    Austin, United States CareerBuilder Full time

    Systems/Business Analyst Enterprise Applications Position Overview: The Systems/Business Analyst - Enterprise Applications is part of Kendra Scotts Information Technology team that supports a portfolio of enterprise-wide applications and integrations. This role will provide application analysis and support of Kendra Scotts ERP (QAD) systems, Oracle...

  • SAP Senior ABAP Development Lead

    2 weeks ago

    Austin, United States Diverse Lynx Full time

    Senior SAP ABAP Developer with demonstrated hands-on application programming experience Demonstrated ability to debug and troubleshoot complex performance issues Should be able to design and implement scalable and performant solutions (App + DB) Should be able to propose forward looking architecture / designs for ECC solutions to minimize remediation...

  • SAP BTP Developer

    4 days ago

    Austin, United States Natsoft Full time

    Job Title: SAP BTP Developer Location: Austin, TX (Hybrid 3 days onsite per week) Hire Type: Full time/Contract Description: Design, develop and support application solutions with focus on SAP BTP Development. 5 years of Strong Java/J2EE and Spring experience is required. One year of hands-on implementation experience with SAP BTP development. HANA Cloud...

  • SAP BTP Developer

    Found in: Appcast Linkedin GBL C2 - 5 days ago

    Austin, United States Natsoft Full time

    Job Title: SAP BTP Developer Location: Austin, TX (Hybrid – 3 days onsite per week)Hire Type: Full time/Contract Description: Design, develop and support application solutions with focus on SAP BTP Development.5 years of Strong Java/J2EE and Spring experience is required.One year of hands-on implementation experience with SAP BTP development.HANA Cloud...

  • SAP BTP Developer

    Found in: Appcast US C2 - 6 days ago

    Austin, United States Natsoft Full time

    Job Title: SAP BTP Developer Location: Austin, TX (Hybrid – 3 days onsite per week)Hire Type: Full time/Contract Description: Design, develop and support application solutions with focus on SAP BTP Development.5 years of Strong Java/J2EE and Spring experience is required.One year of hands-on implementation experience with SAP BTP development.HANA Cloud...

  • SAP BTP Developer

    5 days ago

    Austin, United States Natsoft Full time

    Job Title: SAP BTP Developer Location: Austin, TX (Hybrid – 3 days onsite per week)Hire Type: Full time/Contract Description: Design, develop and support application solutions with focus on SAP BTP Development.5 years of Strong Java/J2EE and Spring experience is required.One year of hands-on implementation experience with SAP BTP development.HANA Cloud...

  • Mid Appian Developer

    2 weeks ago

    Austin, United States Saxon Global Full time

    Role - Appian Developer Duration - 6 month contract to hire Visa - GC or Citizen Hybrid 2 days a week Austin TX Job Description looking for a qualified Senior Appian Developer to design and code functional programs and applications. You will work as part of a team and individually with little supervision. What you'll do: •Build applications:...

  • Java Developer

    Found in: beBee S US - 3 weeks ago

    Austin, United States QData Full time

    Required Skills Strong hands-on experience on Java J2EE REST API with Spring Framework Strong in Java J2EE Spring SpringBoot Hibernate etc. Experience with JSP NodeJS AngularJS Bootstrap etc. DB SQL Queries on SQL Server or Oracle Knowledge of HTML5 and CSS3 Solid understanding of cross-browser/platform issues and solution(s) for...

  • Java Developer

    Found in: beBee S US - 3 weeks ago

    Austin, United States QData Full time

    Job Title Java DeveloperJob Location Austin TXLinkedIn is mandatoryJob DescriptionMust have skills Strong hands-on experience on Java J2EE REST API with Spring Framework Strong in Java J2EE Spring SpringBoot Hibernate etc. Experience with JSP NodeJS AngularJS Bootstrap etc. DB SQL Queries on SQL Server or Oracle Knowledge of HTML5 and CSS3...

  • Java Lead/ Java Developer

    2 weeks ago

    Austin, United States CareerBuilder Full time

    Role Description " Strong experience in Java Spring, J2EE technologies (Spring microServices, Spring mvc), Hibernate, Rest/Soap Services, Docker " experience in using the following aspects of o Experience in Javascript, Servlet and JSP development o Experience with CICD using tools like Jenkins, Maven and Github o Hands on experience and basics of Openshift,...

  • Java Developer

    Found in: beBee jobs US - 3 weeks ago

    Austin, Texas, United States QData Full time

    Job Title Java DeveloperJob Location Austin TXLinkedIn is mandatoryJob DescriptionMust have skills Strong hands-on experience on Java J2EE REST API with Spring Framework Strong in Java J2EE Spring SpringBoot Hibernate etc. Experience with JSP NodeJS AngularJS Bootstrap etc. DB SQL Queries on SQL Server or Oracle Knowledge of HTML5 and CSS3 Solid...

  • Developer/Programmer Analyst III

    1 week ago

    Austin, United States Optimized Technical Solutions Full time

    Job DescriptionJob DescriptionI. DESCRIPTION OF SERVICESThe Developer/Programmer Analyst performs advanced analysis and programming work involving all technical aspects of designing, creating and maintain software applications.This position will work with the Texas Student Data System (TSDS) development team to provide the following Software Development...

  • Linux Administrator with Oracle fusion Middleware.

    6 days ago

    Austin, United States Diverse Lynx Full time

    Job Description:RedHat Linux administration ( RHEL certified preferred )OS performance/tuning knowledge, maintaining large fleet of virtualized environments.Oracle Applications Fusion middleware, SOA architecture, BPM multi-node administration,Python environment knowledgeSecurity vulnerability management, understanding and remediation experience is...

  • Senior Support Analyst

    9 hours ago

    Austin, United States GCS Technologies Full time

    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 expected to have top notch communication skills. This is not your typical corporate help...

  • Linux Administrator with Oracle fusion Middleware.

    4 days ago

    Austin, United States Diverse Lynx Full time

    Job Description: RedHat Linux administration ( RHEL certified preferred ) OS performance/tuning knowledge, maintaining large fleet of virtualized environments. Oracle Applications Fusion middleware, SOA architecture, BPM multi-node administration, Python environment knowledge Security vulnerability management, understanding and remediation experience...