Performance Tuning Engineer (Lead)
Mumbai, Maharashtra
Clover Infotech Private Limited
Tap Again To Close
Job Description
Job Openings
Performance Tuning Engineer (Lead)
Experience
6-7 Years
Location
Mumbai
Job Summary:
We are seeking an experienced Performance Tuning Engineer (Lead) to support our L3 Performance Tuning requirements. The ideal candidate will have a strong background in Oracle database systems with expertise in tuning, query optimization, and Oracle architecture.
Key Responsibilities:
Analyze and optimize Oracle Database performance to ensure efficient 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. Strong problem-solving skills, communication, and ability to work under tight deadlines.
This advertiser has chosen not to accept applicants from your region.