PMCS SERVICES
Austin, TX
Post Resume to
View Contact Details &
Apply for Job
Job Description :
We are looking for a full-time contractor or employee for a Senior Oracle Performance Engineer role.
  • 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.

Required SKills:
  • Experience in Analyzing and evaluating application performance across multiple tiers
  • Experience with identification and solution implementation for performance and scalability bottlenecks and issues
  • Experience with Oracle wait interface and event analysis
  • Experience with Performance tuning of large Oracle databases in AWS (50+ TB)
  • Experience with large Oracle Exadata databases and clusters
  • Experience with Single node non-Exadata Database tuning
  • Experience with Linux shell scripting, SQL tuning and session tracing.
  • Experience with AWR, ASH, ADDM generation and analysis
  • Experience with Oracle AWR Raw data analysis and interpretation.
  • Experience Extrapolating system behavior under representative load to predict system behavior under full load/stress.
  • Experience with Presenting complex results, analysis, and metrics to a diverse audience of technical and non-technical personnel.
  • Experience with Troubleshooting performance bottlenecks and issues.
  • Knowledge of Oracle internals pertaining to database performance
  • Experience with understanding of application behavior, performance, and interaction patterns with DBs in relation to performance and scalability.
  • Experience with extrapolating application and data tier metrics to explain system behavior.
  • 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.
  • Experience working with multiple teams concurrently, being able to prioritize and complete work on time with high quality

Preferred SKills:
  • Experience on an agile sprint team
  • Experience with JIRA software
  • Bachelor's degree in computer science, Information Systems, or Business or equivalent experience.
  • Prior experience with an HHS agency
  • Prior experience working with PII or PHI data
  • Prior experience working with HL7 data
  • Prior experience in the Healthcare Industry
             

Similar Jobs you may be interested in ..