Software Engineer 3 job in Cedar Park

Develops software solutions by studying information needs, conferring with users, and studying systems flow, data usage, and work processes. Investigates problem areas. Prepares and installs solutions by determining and designing system specifications, standards, and programming.

The Department of Information Resources (DIR) requires the services of One Performance engineer hereafter referred to as Worker, who meets the general qualification of Developer 3 Emerging and the specifications outlined in this document for Health & Human Services Commission - Social Services Applications team.

All work products resulting from the project shall be considered "works made for hire" and are the property of the HHSC. HHSC may include pre-selection requirements that potential Vendors (and their Workers) submit to and satisfy criminal background checks as authorized by the Texas law. HHSC will pay no fees for interviews or discussions, which occur during the process of selecting a Worker(s). &bull Analyzes and evaluates application, system and ecosystem performance and scalability across multiple tiers with particular emphasis on the data tier in both cloud and on-prem environments. &bull Identifies performance and scalability bottlenecks and issues and propose solutions to resolve the same. &bull Simulates user/system traffic/load using scripts or other mechanisms, measure, evaluate and analyze component behavior. &bull Optimizes code, queries, and system configurations to improve response time, scalability, and resource efficiency (CPU, memory, I/O). &bull Analyzes and interprets Oracle wait events, AWR Raw data and trace and correlate observations and analysis to system behavior. &bull Generates and analyzes AWR, ASH and ADDM reports. &bull Extrapolates system behavior under representative load to predict system behavior under full load/stress. &bull Extrapolates system behavior from application and data tier metrics. &bull Communicates complex results, analysis, and metrics to diverse technical and non-technical audience. &bull Evaluates and predicts future performance needs based on application usage trends, traffic patterns, and growth projections. &bull Conducts detailed root cause analysis (RCA) on performance issues to pinpoint the underlying cause of slowdowns or failures., 8RequiredExperience with identification and solution implementation for performance and scalability bottlenecks and issues

8RequiredExperience with Oracle wait interface and event analysis

8RequiredExperience with Performance tuning of large Oracle databases in AWS (50+ TB)

8RequiredExperience with large Oracle Exadata databases and clusters

8RequiredExperience with Single node non-Exadata Database tuning

8RequiredExperience with Linux shell scripting, SQL tuning and session tracing.

8RequiredExperience with AWR, ASH, ADDM generation and analysis

8RequiredExperience with Oracle AWR Raw data analysis and interpretation.

8RequiredExperience Extrapolating system behavior under representative load to predict system behavior under full load/stress.

8RequiredExperience with Presenting complex results, analysis, and metrics to a diverse audience of technical and non-technical personnel.

8RequiredExperience with Troubleshooting performance bottlenecks and issues.

8RequiredKnowledge of Oracle internals pertaining to database performance

8RequiredExperience with understanding of application behavior, performance, and interaction patterns with DBs in relation to performance and scalability.

8RequiredExperience with extrapolating application and data tier metrics to explain system behavior.

8RequiredExperience with Technical writing and diagramming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, and PowerPoint) and MS Project.

8RequiredExperience working with multiple teams concurrently, being able to prioritize and complete work on time with high quality

5PreferredExperience on an agile sprint team

5PreferredExperience with JIRA software

4PreferredBachelor's degree in computer science, Information Systems, or Business or equivalent experience.

2PreferredPrior experience with an HHS agency

2PreferredPrior experience working with PII or PHI data

2PreferredPrior experience working with HL7 data

2PreferredPrior experience in the Healthcare Industry

Required Skills : Software Architecture,Oracle

Basic Qualification :

Additional Skills : Software Engineer,Database Administrator