Fermé

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.

Compétences : Oracle, Administration de Bases de données, SQL, Développement de bases de données, Oracle Database

Concernant le client :
( 0 commentaires ) Calgary, Canada

Nº du projet : #36251440

35 freelances font une offre moyenne de 555 $ pour ce travail

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 en 1 jour
(73 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 2 jours
(14 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 4 jours
(30 Commentaires)
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. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(5 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(29 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(12 Commentaires)
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 en 2 jours
(1 Évaluation)
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 . Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 2 jours
(10 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(4 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(3 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 2 jours
(3 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 15 jours
(1 Évaluation)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 3 jours
(3 Commentaires)
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 en 1 jour
(5 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(3 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(0 Commentaires)
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. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 21 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 3 jours
(0 Commentaires)
0.0