Job description

Sr. Oracle Performance Engineer

Oaks, PA

Full Time

Note: Candidate should work onsite from Day 1 on hybrid basis

Job Description

· We need candidate who worked on Application side in oracle database not from Infrastructure side in oracle database.

· Proficient in performance tuning using SQL Trace / TKPROF / Explain Plan/Stat pack, AWR reports, ADDM advisors, Active Session History, Database replay report, SQL Performance Analyzer.

Skills Required:

Minimum 8 Year experience as Oracle database performance engineer– Very thorough and clear understanding of Oracle Database Architecture – including the latest version of Oracle and Databases on cloud.

Extensive knowledge of key factors impacting performance of Oracle database.

Must have worked with customers in an advisory role helping them implement best practices during migrations or upgrades.

Should have experience on utilities like OEM, AWR, ADDM, SQL Tuning Advisor, SQL Profiles

Extensive knowledge and solid troubleshooting experience in the following areas RAC, ASM,

Performance tuning (AWR, SQL Monitor, OEM), Data Guard (Physical and Logical) including active dataguard and DG broker, RMAN – Experience in handling complex installation/patching, database recovery scenarios is desired

Added skills with Oracle Golden Gate and tuning would be excellent.

Excellent written and verbal communication skills.

Ability to work with customer during pre-go live or post go-live scenarios involving.

Quick thinking willingness to work based on customer situation and take ownership for resolve performance issue.

Reach out to other supporting teams as needed.

Ability to quickly grasp complex technical issues. – Appetite to learn new technologies and constantly improve technical skills.

Provide guidance to customers for designing, implementing, and supporting performance testing systems and strategies

Job Type: Full-time

Pay: $110,000.00 - $140,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Vision insurance

Schedule:

• 8 hour shift

Experience:

• Oracle Database: 10 years (Required)
• Performance tuning: 5 years (Required)
• performance issue: 5 years (Required)
• OEM or AWR Report: 5 years (Required)

Work Location: One location

colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, colinoncars.com is the ideal place to find your next job.