I will troubleshoot and optimize your oracle database performance
Lead Site Reliability Engineer
About this Gig
Is your Oracle database running slowly, causing high CPU usage, long-running SQL, excessive I/O, or poor application response time?
I will analyze your Oracle database performance issue and help identify the likely root cause with practical recommendations for improvement.
My analysis can include:
AWR and ASH report review
SQL and execution plan analysis
Wait event and resource analysis
CPU, memory and I/O bottleneck identification
SQL tuning recommendations
Database configuration and performance recommendations
Identification of potential performance bottlenecks and next steps
I have 14+ years of enterprise database engineering experience and extensive hands-on experience with Oracle databases, performance tuning, RAC, ASM, Data Guard, RMAN, and large production environments.
You can provide relevant AWR/ASH reports, SQL statements, execution plans, logs, or a description of the issue. I will review the available information and provide clear, practical findings and recommendations.
This Gig focuses on performance analysis and recommendations. Complex production changes, implementation, emergency troubleshooting, or large-scale remediation can be discussed separately.
Database type:
Relational database
FAQ
What information do you need from me?
Please provide a description of the performance issue and, where available, AWR/ASH reports, SQL IDs, execution plans, database version, error details, or relevant logs.
Can you troubleshoot any Oracle database version?
I can work with modern Oracle Database environments, including Oracle 12c, 18c, and 19c. Share your database version and issue details when placing the order.
Will you directly make changes to my production database?
The standard Gig focuses on analysis and recommendations. Production changes or implementation can be discussed separately based on your environment, access requirements, and project scope.
Can you analyze a specific slow SQL query?
Yes. I can review SQL statements, execution plans, SQL statistics, and relevant performance data to identify potential bottlenecks and recommend optimization approaches.
Can you handle complex Oracle performance issues?
Yes. For RAC, ASM, Data Guard, severe production incidents, large-scale performance remediation, or ongoing DBA support, please contact me first so I can understand the environment and provide an appropriate custom scope.
