Închis

Oracle SQL Query Tuning - Oracle Performance

Job Description:

I'm looking to hire a freelancer who can help me with Oracle SQL Query Tuning and improve Oracle Performance. I will be using Oracle Exadata Database and therefore the successful freelancer should have prior experience working with these versions. The specific work required is Ad-hoc Query Tuning so the applicant should include relevant past work and experiences as part of their application. Detailed project proposals are also appreciated.

Scenario: 4 Oracle SQL Queries that we have taking time anywhere from 3-7 minutes and wanted these to be running in less than 30 seconds. So require some one with Oracle SQL Performance Tuning Expertise to rewrite the query or Add any DB Configuration or Indexes or other Performance enhancement tips to cut that runtime down to 30 seconds or less.

Amount of data that's coming out of the query results are around 400K - 1 Million Rows

We need some one immediately as it has to be done in a day.

Aptitudini: Oracle, Administrare baze de date, SQL, Dezvoltare Baze de Date, Oracle Database

Despre client:
( 0 recenzii ) Calgary, Canada

ID Proiect: #36251440

35 freelanceri licitează în medie 555$ pentru acest proiect

adeeladeel1234

Hi I have extensive experience with Oracle database development specifically sql and plsql i can make your query tunned please do review my profile and send me message to discuss your requirements in details Thanks

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD în 1 zi
(73 recenzii)
6.6
muzzamilnoor

Dear Client, As a seasoned freelancer with extensive experience in Oracle SQL Performance Tuning, I understand the importance of Ad-hoc Query Tuning in improving overall system performance. With my expertise in this ar Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 2 zile
(14 recenzii)
5.5
kundansql

Hi there! Let me help you out... I usually work on SQL Server - but it can help you to optimize the 4 ad-hoc SQL Queries for Oracle. I know 500-level things about Microsoft SQL Server. I have 7+ years of exceptional Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 4 zile
(30 recenzii)
5.0
dhanuitdevendra

Hello, I can help you. * Fixed-time: 5 working day(s) * Fixed-scope: 1-10 SQL queries * Fixed-price: $500 Please schedule a [30 min] One-on-One with me here, for a detailed discussion. It's FREE. Let's get started. Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 7 zile
(5 recenzii)
5.1
smshafiqulislam

I am oracle certified developer and dba with more than 15 years of experience. Master In performance tuning as I know oracle architecture very well. I can try to solve your problem. Few questions: - any sorting happen Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 7 zile
(29 recenzii)
5.2
bizmanas

Hi I have 16 years of experience in sql server database development, mysql database development and postgresqldb development. Expert in sql performance tuning. Extensive etl on json and xml data structure. Programming Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 7 zile
(12 recenzii)
4.5
HamAbbasi00

Hello Dear sir i have Great experience in Oracle so this project is quited suited for i have hand on experience in PL/SQL So hit me up for Detail thanks

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 2 zile
(1 părere)
3.4
Muhammadzeesha59

Hello Client ! I am a skilled full stack developer. Having rich experience in Java , Python , C , C++ , C# , Mysql , Sql , Oracle , Object Oriented Programming , Data Structure , Algorithms . Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 2 zile
(10 recenzii)
3.2
CourserXu

Hello there, I would recommend breaking down the SQL queries into smaller parts and using sub-queries to retrieve data more efficiently. Adding appropriate indexes can also significantly improve performance. I would s Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 7 zile
(4 recenzii)
3.0
svenkadesh20

Hi, I have 9+ years of expertise in Oracle core and APPS database administration, single instance and cluster configuration (ORACLE RAC), Dataguard,Golden Gate,OCI cloud,AWS RDS, AWS EC2,S3, Oracle Docker container, an Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 7 zile
(3 recenzii)
3.1
hayatkhan511

Hi, I see you are looking for an Oracle SQ/PLSQL developer. I also understand that you have an idea of related Oracle SQ/PLSQL Development, but you expect the best Oracle SQ/PLSQL development from the selected freelanc Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 2 zile
(3 recenzii)
3.0
rashidamjad

Hi there, I am Rashid. Hope you are doing great. Firstly about the Oracle SQL Query Tuning - Oracle Performance that I have a great experience in it. I am very confident to pull it off once awarded. I have good experie Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 15 zile
(1 părere)
2.4
anuarcastillo

We have a experience in the tuning process of SQL sentences and DB performance, since 9i version, in DB whose size goes until 500 TB, having tables with +7000 million of rows. Among tuning way, our team uses their exp Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 3 zile
(3 recenzii)
2.5
Appsdbatalha

I am Oracle certified DBA having 12 years of experience in installing and administrating oracle database

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD în 1 zi
(5 recenzii)
2.6
dayanandyadav

Hi, I can improve the performance of oracle queries. Lets discuss. I have 22 years of development experience with 1. WCF service, C#, Vb .net, vb, IoT (thing worx, axeda), python, wpf, Windows desktop application 2 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 7 zile
(3 recenzii)
2.4
filipniktreci

Hi, Dear I went through your project description and it seems like me is a great fit for this job. I am an expert which have many years of experience on Database Administration Please come over chat and discuss your Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 7 zile
(0 recenzii)
0.0
vanshika2022

Hi There, Good day! Hope you are doing fine. ⭐ I will work with milestone only and release money as per good work progress. ⭐ I have gone through your initial project requirement and understand your project details. Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 7 zile
(0 recenzii)
0.0
Nikoloz13

Hi, I would like to grab this opportunity and will work till you get 100% satisfied with my work. I'm a professional software engineer with many years of experience in SQL, Oracle, Database Administration, Database Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 7 zile
(0 recenzii)
0.0
AITSoft

Hi there! I have read what you exactly need, however I would like to ask you a few questions. I do have good experience with Database Administration, Database Development, SQL, Oracle and Oracle Database. Please feel f Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 21 zile
(0 recenzii)
0.0
hassanraza678900

Hello Dear, I hope you are doing well. I am working as an Oracle Developer in my country. I have great experience in developing Oracle Forms and Oracle reports using Oracle sql queries. I have great command in PL s Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 3 zile
(0 recenzii)
0.0