Job Summary:
We are seeking an experienced Performance Tuning Engineer (Lead) to support our L3 Performance Tuning requirements. The ideal candidate will have a solid background in Oracle database systems with expertise in tuning, query optimization, and Oracle architecture.
Key Responsibilities:
Analyze and optimize Oracle Database performance to ensure productive operations.
Perform advanced query tuning and rewrite complex queries for improved execution.
Conduct instance-level tuning by adjusting configurations and resource allocations.
Collaborate with stakeholders to identify and resolve database performance bottlenecks.
Maintain and enhance database architecture to support high availability and scalability.
Create and implement performance-tuning strategies, tools, and processes.
Monitor and report performance metrics using tools like AWR, ASH, and ADDM.

Qualifications:




Experience of 6 to 7 years in Oracle database performance tuning and optimization.
In-depth understanding of Oracle Database Architecture (SGA, PGA, background processes).
Proven experience in Oracle Database Performance Tuning using tools like SQL Trace and TKPROF.
Proficiency in Query Tuning, including execution plan analysis and index optimization.
Expertise in Query Re-writing techniques for complex queries and large datasets.
Knowledge of Oracle Database Instance Tuning (parameters, redo logs, undo management).
PL/SQL knowledge is a must.
Experience in the BFSI sector is preferred.
Solid problem-solving skills, communication, and ability to work under tight deadlines.

📌 Performance Tuning Engineer Mumbai (India)
🏢 Clover Infotech
📍 India