What are the responsibilities and job description for the Oracle Performance Engineer (AWR, OWI)-Software Engineer (Prefer Local Cand with Healthcare/Public S position at Texcelvision?
Job Description
Job Description
Respond by : 02 / 19 / 24
Rate : DOE
Type : Contract
Work Mode : 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.
Please respond with resume and 3 references preferably supervisor (name, title, company, email, phone number)
Preference will be given to candidates who meet all preferred skills and have public sector experience
Background Check will be performed if a candidate is selected for placement and will have to be passed'
Job Description
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.
Years
Required / Preferred
Experience
Required
Experience in Analyzing and evaluating application performance across multiple tiers
Required
Experience with identification and solution implementation for performance and scalability bottlenecks and issues
Required
Experience with Oracle wait interface and event analysis
Required
Experience with Performance tuning of large Oracle databases in AWS (50 TB)
Required
Experience with large Oracle Exadata databases and clusters
Required
Experience with Single node non-Exadata Database tuning
Required
Experience with Linux shell scripting, SQL tuning and session tracing.
Required
Experience with AWR, ASH, ADDM generation and analysis
Required
Experience with Oracle AWR Raw data analysis and interpretation.
Required
Experience Extrapolating system behavior under representative load to predict system behavior under full load / stress.
Required
Experience with Presenting complex results, analysis, and metrics to a diverse audience of technical and non-technical personnel.
Required
Experience with Troubleshooting performance bottlenecks and issues.
Required
Knowledge of Oracle internals pertaining to database performance
Required
Experience with understanding of application behavior, performance, and interaction patterns with DBs in relation to performance and scalability.
Required
Experience with extrapolating application and data tier metrics to explain system behavior.
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.
Required
Experience working with multiple teams concurrently, being able to prioritize and complete work on time with high quality
Preferred
Experience on an agile sprint team
Preferred
Experience with JIRA software
Preferred
Bachelor's degree in computer science, Information Systems, or Business or equivalent experience.
Preferred
Prior experience with an HHS agency
Preferred
Prior experience working with PII or PHI data
Preferred
Prior experience working with HL7 data
Preferred
Prior experience in the Healthcare Industry
III. TERMS OF SERVICE
Services are expected to start 03 / 24 / 2025 and are expected to complete by 08 / 31 / 2025 . Total estimated hours per Candidate shall not exceed 1550 hours. This service may be amended, renewed, and / or extended providing both parties agree to do so in writing.
