Job Description

Skills:

Analyzing and evaluating application performance across multiple tiers, Experience with Oracle wait interface and event analysis.

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.

SALARY RANGE: 120K TO 130K Per Annum

CANDIDATE SKILLS AND QUALIFICATIONS

Required Skills/Experience:

• 8 years : Analyzing and evaluating application performance across multiple tiers.
• 8 years : Identifying and implementing solutions for performance and scalability bottlenecks.
• 8 years : Experience with Oracle wait interface and event analysis.
• 8 years : Performance tuning of large Oracle databases in AWS (50+ TB).
• 8 years : Experience managing large Oracle Exadata databases and clusters.
• 8 years : Single-node non-Exadata database tuning.
• 8 years : Proficiency in Linux shell scripting, SQL tuning, and session tracing.
• 8 years : AWR, ASH, ADDM generation and analysis.
• 8 years : Oracle AWR raw data analysis and interpretation.
• 8 years : Extrapolating system behavior under representative load to predict behavior under full load/stress.
• 8 years : Presenting complex results, analysis, and metrics to diverse audiences of technical and non-technical personnel.
• 8 years : Troubleshooting performance bottlenecks and issues.
• 8 years : Knowledge of Oracle internals pertaining to database performance.
• 8 years : Understanding application behavior, performance, and interaction patterns with databases in relation to performance and scalability.
• 8 years : Extrapolating application and data-tier metrics to explain system behavior.
• 8 years : Proficiency in technical writing and diagramming, including modeling/mapping tools (e.g., Visio, Erwin) and Microsoft Office Suite (Word, Excel, PowerPoint) and MS Project.
• 8 years : Experience working with multiple teams concurrently, prioritizing, and completing work on time with high quality.

Preferred Skills/Experience:

• 5 years : Experience on an agile sprint team.
• 5 years : Experience with JIRA software.
• 4 years : Bachelor’s degree in computer science, information systems, business, or equivalent experience.
• 2 years : Prior experience with an HHS agency.
• 2 years : Prior experience working with PII or PHI data.
• 2 years : Prior experience working with HL7 data.
• 2 years : Prior experience in the healthcare industry.

Job Tags

Similar Jobs