
Closed
Posted
Our Oracle E-Business Suite instance and its core databases are straining under heavy loads, and I need an experienced hand to restore peak performance. The assignment centers on performance tuning, specifically: • Query optimisation – analysing execution plans, AWR/ASH reports and SQL traces to cut response times and CPU usage. • Index management – auditing existing structures, redesigning or rebuilding where needed, and advising on partitioning or compression if it brings measurable gain. I will grant full access to the non-production environments first, then schedule controlled moves into production once we agree on the changes. Clear before-and-after metrics are essential; please include a concise report that shows what you changed, why, and the improvement achieved. A solid background with both Oracle Database and Oracle E-Business Suite is mandatory, and comfort with tools such as SQL*Plus, OEM/Cloud Control, SQL Tuning Advisor and Data Dictionary views will help you work quickly inside our stack. If you have over a decade of Core and Apps DBA experience and can deliver tangible performance gains without disrupting business operations, I’m ready to get started.
Project ID: 40645372
12 proposals
Remote project
Active 7 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
12 freelancers are bidding on average ₹983 INR/hour for this job

Hi, We went through your project description and it seems like our team is a great fit for this job. We are team of experts which have many years of experience on Oracle, Database Administration, Oracle Database, Database Design, Database Management, Performance Tuning Please come over chat and discuss your requirement in a detailed way. Regards
₹1,250 INR in 40 days
3.9
3.9

I am Oracle certified DBA having 15 years of experience in installing and administrator oracle database
₹1,250 INR in 40 days
2.6
2.6

Hi, I can support your Oracle E-Business Suite and Oracle Database performance tuning work, focusing on query optimization, AWR/ASH review, SQL trace analysis, index management, and measurable before/after improvements. The best solution is to first review non-production performance data, top SQL, execution plans, wait events, AWR/ASH reports, indexes, table statistics, and EBS workload patterns. Then I’ll identify slow queries, tune SQL where possible, recommend index rebuild/redesign, review partitioning or compression options, and prepare safe changes for controlled production deployment. I’m comfortable with Oracle Database, Oracle E-Business Suite, Core/Apps DBA workflows, SQL*Plus, OEM/Cloud Control, SQL Tuning Advisor, Data Dictionary views, execution plans, SQL traces, AWR/ASH analysis, index tuning, statistics review, and production-safe performance optimization. Deliverables will include: * AWR/ASH performance review * Slow SQL identification * Execution plan analysis * Query tuning recommendations * Index audit and tuning * Statistics/partitioning review * Non-production validation * Production change plan * Before/after metrics * Concise tuning report I’ll focus on practical performance gains, low-risk changes, and clear documentation so response time, CPU usage, and database efficiency improve without disrupting business operations. Best regards Ankit
₹750 INR in 40 days
2.8
2.8

Oracle DBA with 15 Years of experience in database administration, Performance Tuning, Dataguard and other related technologies in Oracle. I can resolve the performance issue after verifying the database and can provide recommendations for improvement.
₹900 INR in 10 days
2.3
2.3

As a seasoned IT Specialist with over 17 years of diverse experience, I am confident in my capability to tackle even the most intricate performance issues your Oracle DB and E-Business Suite face. My primary area of expertise has been as a Database Engineer, which includes managing advanced database systems, optimizing query performance, index management, and data analysis - all significant aspects you're seeking for this project. I have invested heavily over the years in accruing thorough knowledge of Oracle databases, E-Business Suite, and other essential tools like SQL*Plus, OEM/Cloud Control, SQL Tuning Advisor and Data Dictionary views mentioned in your requirements. I also assure you that changes made will be meticulously documented, providing an appreciable 'before-and-after' analysis along with concise reports for transparency. I understand that 'performance tuning' here isn’t just about superficially enhancing performance but maintaining seamless operational workflow too. That's why my approach guarantees minimal disruption to your business operations even as I strive until we see measurable performance gains on your Oracle DBs. So let's collaborate and restore peak performance while ensuring uninterrupted business activities for you!
₹1,000 INR in 40 days
2.2
2.2

Hello, I’m interested in your Oracle Database performance tuning project. I have 4.2+ years of experience in enterprise Banking and FinTech applications, with hands-on experience in Oracle, SQL, Java backend systems, production support, application troubleshooting, performance optimization, and Root Cause Analysis. I can assist with: • SQL query analysis and optimization • Execution plan analysis and identifying bottlenecks • Index analysis and optimization recommendations • Oracle SQL troubleshooting • Application/database performance investigation • Production issue analysis and RCA • Before-and-after performance measurement and documentation I’m comfortable working in non-production environments first, establishing baseline metrics, implementing controlled changes, and validating measurable improvements before production deployment. I want to be transparent that my primary background is Java backend/application support rather than 10+ years of dedicated Oracle EBS/Core DBA administration. However, my Banking/FinTech production experience gives me strong exposure to enterprise Oracle environments and application-level performance troubleshooting. If you are open to an engineer with strong Oracle/application performance experience, I’d be happy to discuss your environment, current bottlenecks, and expected outcomes. Regards, Sumit Karanwal
₹750 INR in 40 days
0.0
0.0

I can help restore peak performance for your Oracle E-Business Suite instance. Optimizing query execution plans and managing indexes will significantly enhance response times and reduce CPU usage. I noticed you require clear before-and-after metrics, which is crucial for tracking improvements. My approach includes in-depth analysis of AWR/ASH reports and SQL traces, ensuring we target the right areas for tuning. With over a decade of experience in Core and Apps DBA roles, I'm comfortable with SQL*Plus and SQL Tuning Advisor. I've done similar work: [Community Events Web Application](#) where performance optimization was key to delivering a seamless user experience. Let’s chat about your specific challenges, and I can provide a free consultation to discuss the best approach. Regards, Dean I have done similar work: Modern Real Estate Investment Website
₹750 INR in 7 days
0.0
0.0

I have total 19 years of experience mainly in migration project in telecom billing domain dealing with oracle database. Also I have successfully handled data volumes of approximately 150 million records during migration activities, giving me strong practical experience in dealing with large datasets, SQL performance, database resource utilization, indexing, and migration-related performance challenges. For this engagement, my objective is straightforward: Identify the real performance bottlenecks, implement measurable improvements, and ensure that changes are introduced into production safely with minimal business disruption. My approach will focus on measurable results rather than assumptions—establishing a performance baseline first, tuning the highest-impact SQL and database structures, validating the results in non-production, and then carefully moving approved changes into production.
₹1,000 INR in 40 days
0.0
0.0

Hi, I have strong expertise in PL/SQL and MSSQL object tuning and performance optimization. I can analyze AWR/ASH reports, execution plans, SQL traces and SQL Tuning Advisor recommendations to identify CPU, I/O, and response-time bottlenecks. I’ll also audit indexes, optimize SQL and PL/SQL procedures, functions, packages, and queries, and evaluate partitioning or compression where measurable benefits exist. All changes will be tested in non-production first, with controlled production deployment. I’ll provide before/after metrics and a concise report documenting changes, rationale, and measurable improvements.
₹1,000 INR in 40 days
0.0
0.0

Hello, I am a **Senior Oracle Database Engineer / DBA with 10+ years of experience** in enterprise Oracle environments, performance engineering, production support, High Availability and complex database troubleshooting. Your requirement for Oracle E-Business Suite database performance tuning closely matches my experience in identifying database bottlenecks and implementing measurable improvements with minimal production impact. **My approach:** • Analyze AWR/ASH reports, execution plans, wait events and SQL performance to identify bottlenecks. • Review CPU, I/O, memory, locking and database workload patterns. • Assess indexes and database structures and recommend changes based on measurable impact. • Optimize SQL execution and validate changes in non-production before production rollout. • Establish before-and-after performance metrics and provide a concise tuning report. My experience includes **Oracle 11g/12c/19c, RAC, ASM, Data Guard, Exadata, RMAN, OEM and enterprise production database administration**. I focus on **root-cause analysis and measurable performance improvement** while minimizing production risk. **Rate: ₹1,250/hour** **Availability: 30 hours/week** I am available to start immediately. Regards, **Swethalana**
₹1,250 INR in 30 days
0.0
0.0

I am a Certified DBA with 25+ years of hands-on experience with Oracle Database and SQL Server, including extensive Core DBA and production database administration. I have worked extensively with performance troubleshooting, SQL tuning, execution plans, indexing, database health, and high-load production environments. I can help optimize your Oracle E-Business Suite environment with a structured, measurement-driven approach: • Analyze AWR/ASH reports, SQL traces and execution plans to identify CPU-intensive and slow SQL • Tune problematic SQL using appropriate optimizer strategies and SQL Tuning Advisor • Audit indexes, identify redundant/missing/inefficient indexes, and recommend rebuild/reorganization where justified • Evaluate partitioning, compression, statistics, and execution-plan improvements • Review database configuration and workload-related bottlenecks • Use SQL*Plus, OEM/Cloud Control and Oracle Data Dictionary views for detailed analysis • Test all changes in non-production before controlled production deployment • Establish clear before/after metrics for response time, CPU, I/O and throughput I will provide a concise tuning report documenting each change, the reason behind it, and measurable performance improvement. My priority is achieving tangible gains while maintaining Oracle EBS stability and minimizing production risk. I can start with a detailed health/performance assessment and quickly identify the highest-impact optimization opportunities.
₹1,000 INR in 40 days
0.0
0.0

I have 5.5 years of hands-on Oracle DBA experience, with strong practical expertise in Oracle performance tuning, SQL optimization, execution plans, AWR/ASH analysis, RMAN, Data Guard, indexing, statistics, and database troubleshooting. I can analyze your performance issues, identify high-resource SQL and bottlenecks, optimize queries and indexes, and provide before/after performance metrics. I am comfortable working first in non-production and implementing validated changes safely in production. While I have 5.5 years of experience rather than 10+, my experience is strongly aligned with the technical requirements of this project. I am confident I can deliver measurable performance improvements and would appreciate the opportunity to prove my capabilities.
₹900 INR in 10 days
0.0
0.0

Pune, India
Member since Jul 17, 2026
₹37500-75000 INR
$30-250 USD
₹75000-150000 INR
$15-25 USD / hour
₹50000-100000 INR
₹750-1250 INR / hour
₹600-1500 INR
$750-1500 AUD
₹100-400 INR / hour
₹750-1250 INR / hour
$750-1500 CAD
$30-250 USD
₹75000-150000 INR
₹60000-65000 INR
₹750-1250 INR / hour
₹400-750 INR / hour
₹750-1250 INR / hour
$250-750 USD
$30-250 CAD
$10-30 USD