15 Nov
|
Qloron Technology
|
Nagpur
15 Nov
Qloron Technology
Nagpur
## Job highlights
- Recommend and implement indexing,partitioning,statistics,SQL rewrites,optimizer and configuration improvements. . Work with developers and DBAs to resolve performance regressions and improve batch processing windows.
- Bachelors degree in Computer Science,Information Technology,Engineering,Finance,Business,or a related discipline
-
Experience:
6-10 Years
- Good to Have JOB ID: QT-SNB-11-462
Experience:
6-10 Years Role Summary: Improve database performance and scalability through SQL, instance, workload, and application-level tuning.
Key Responsibilities
- Analyze AWR, ASH, ADDM, SQL Monitor, execution plans, wait events, and workload patterns.
- Identify expensive SQL, bottlenecks, contention, memory pressure, I/O issues, and inefficient application access.
- Recommend and implement indexing, partitioning, statistics, SQL rewrites, optimizer and configuration improvements.
- Work with developers and DBAs to resolve performance regressions and improve batch processing windows.
- Establish baselines, capacity metrics,
tuning standards, and performance test recommendations.
- Document findings, tuning actions, measurable improvements, and preventive recommendations. Mandatory Skills Advanced Oracle SQL; execution plans; AWR/ASH/ADDM; SQL tuning; optimizer; indexing; partitioning; wait-event analysis; memory and I/O fundamentals. Valuable to Have Oracle 19c; SQL Tuning Advisor; SQL Plan Management; RAC performance; Exadata; OEM; application profiling; load testing. Education Bachelors degree in Computer Science, Information Technology, Engineering, Finance, Business, or a related discipline; equivalent experience may be considered. The job location mentioned in this description is based on publicly available information or company headquarters. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
📌 Oracle Database Performance Tuning Specialist (Nagpur)
🏢 Qloron Technology
📍 Nagpur