Oracle Performance Tuning Specialist

ti Steps

3 - 6 years

3 - 5 Lacs

hyderabad chennai bengaluru

Posted:3 weeks ago| Platform:

Apply

Skills Required

explain plan awr oltp tkprof sql ash

Work Mode

Work from Office

Job Type

Full Time

Job Description

Job Summary:

Oracle Performance Tuning Specialist

Key Responsibilities:

Identify and resolve
performance bottlenecks
at the SQL, PL/SQL, and instance levels.
Conduct in-depth analysis using
AWR, ASH, SQL Trace, tkprof
, and other diagnostic tools.
Work with developers and DBAs to tune
SQL queries, indexes, and PL/SQL code
.
Optimize
Oracle database configurations
, including memory (SGA/PGA), I/O, and parallel execution settings.
Analyze execution plans using tools like
EXPLAIN PLAN, DBMS_XPLAN
.
Recommend and implement
indexing strategies
,
partitioning
, and
materialized views
to enhance performance.
Collaborate with application and infrastructure teams to troubleshoot and improve end-to-end performance.
Proactively monitor system performance and capacity trends to avoid performance degradation.
Document tuning recommendations, performance baselines, and best practices.
Stay up to date on new Oracle features and enhancements (especially in versions 12c, 19c, and 21c).
Support production issues with rapid diagnosis and resolution, including after-hours support when needed.

Preferred Qualifications:

Oracle Certified Performance Tuning Expert
or
Oracle Certified Professional (OCP)
.
Knowledge of
APEX
,
Oracle Forms
, or
Java-based Oracle applications
is a plus.

More Jobs at ti Steps

Business Development Manager- Staffing

Chennai

5 - 10 yrs

INR 8 - 18 Lacs

Executive Secretary

Chennai

5 - 10 yrs

INR 10 - 12 Lacs

Business Development Manager / Executive - ( SAAS)

Madurai, Salem, Thanjavur

Experience: Not specified

INR 2 - 6 Lacs

Business Intelligence Analyst

Hyderabad, Chennai, Bengaluru

2.0 - 5.0 yrs

INR 6 - 12 Lacs

Business Analyst

Hyderabad, Chennai, Bengaluru

2.0 - 5.0 yrs

INR 8 - 12 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.