Job ID: TX-529501275R (913090220)
Hybrid/Local Oracle Performance Engineer (Austin ONLY/15+) with Exadata, AWS, Linux shell scripting, SQL tuning, AWR Raw data analysis, ASH, ADDM, Erwin/Visio, MS Project, agile, JIRA, PII/PHI/HL7/healthcare experience
Location: Austin, TX (HHSC)
Duration: 6 Months
Position: 1
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.
Skills:
Years Required/Preferred Experience
8 Required Experience in Analyzing and evaluating application performance across multiple tiers
8 Required Experience with identification and solution implementation for performance and scalability bottlenecks and issues
8 Required Experience with Oracle wait interface and event analysis
8 Required Experience with Performance tuning of large Oracle databases in AWS (50+ TB)
8 Required Experience with large Oracle Exadata databases and clusters
8 Required Experience with Single node non-Exadata Database tuning
8 Required Experience with Linux shell scripting, SQL tuning and session tracing.
8 Required Experience with AWR, ASH, ADDM generation and analysis
8 Required Experience with Oracle AWR Raw data analysis and interpretation.
8 Required Experience Extrapolating system behavior under representative load to predict system behavior under full load/stress.
8 Required Experience with Presenting complex results, analysis, and metrics to a diverse audience of technical and non-technical personnel.
8 Required Experience with Troubleshooting performance bottlenecks and issues.
8 Required Knowledge of Oracle internals pertaining to database performance
8 Required Experience with understanding of application behavior, performance, and interaction patterns with DBs in relation to performance and scalability.
8 Required Experience with extrapolating application and data tier metrics to explain system behavior.
8 Required Experience 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.
8 Required Experience working with multiple teams concurrently, being able to prioritize and complete work on time with high quality
5 Preferred Experience on an agile sprint team
5 Preferred Experience with JIRA software
4 Preferred Bachelor’s degree in computer science, Information Systems, or Business or equivalent experience.
2 Preferred Prior experience with an HHS agency
2 Preferred Prior experience working with PII or PHI data
2 Preferred Prior experience working with HL7 data
2 Preferred Prior experience in the Healthcare Industry
Job Description:
· 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 audiences.
· 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.