What are the responsibilities and job description for the Software Engineer 3 - Oracle position at Hill Country Project Management LLC?
Job Description
Job Description
Ciurrent Texas Residents Only |R | Closes 02 / 20
Position will be 4 days remote with 1 day (Wednesdays) required to be onsite at the location listed above. Program will only accept LOCAL ONLY candidates for this position.
I. DESCRIPTION OF SERVICES
Texas Health and Human Services Commission requires the services of 1 Software Engineer 3 , hereafter referred to as Candidate(s), who meets the general qualifications of Software Engineer 3, Applications / Software Development and the specifications outlined in this document for the Texas Health and Human Services Commission .
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.
- 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.
- Identifies performance and scalability bottlenecks and issues and propose solutions to resolve the same.
- Simulates user / system traffic / load using scripts or other mechanisms, measure, evaluate and analyze component behavior.
- Optimizes code, queries, and system configurations to improve response time, scalability, and resource efficiency (CPU, memory, I / O).
- Analyzes and interprets Oracle wait events, AWR Raw data and trace and correlate observations and analysis to system behavior.
- Generates and analyzes AWR, ASH and ADDM reports.
- Extrapolates system behavior under representative load to predict system behavior under full load / stress.
- Extrapolates system behavior from application and data tier metrics.
- Communicates complex results, analysis, and metrics to diverse technical and non-technical audience.
- Evaluates and predicts future performance needs based on application usage trends, traffic patterns, and growth projections.
- Conducts detailed root cause analysis (RCA) on performance issues to pinpoint the underlying cause of slowdowns or failures.
II. CANDIDATE SKILLS AND QUALIFICATIONS
Minimum Requirements :
Candidates that do not meet or exceed the minimum stated requirements (skills / experience) will be displayed to customers but may not be chosen for this opportunity. YearsRequired / PreferredExperience8RequiredExperience in Analyzing and evaluating application performance across multiple tiers8RequiredExperience with identification and solution implementation for performance and scalability bottlenecks and issues8RequiredExperience with Oracle wait interface and event analysis8RequiredExperience with Performance tuning of large Oracle databases in AWS (50 TB)8RequiredExperience with large Oracle E
