Find Jobs
Hire Freelancers

Oracle SQL Query Tuning - Oracle Performance

$250-750 CAD

Închis
Data postării: 12 luni în urmă

$250-750 CAD

Plata la predare
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.
ID-ul proiectului: 36251440

Despre proiect

35 propuneri
Proiect la distanță
Activ: 11 luni în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
35 freelanceri plasează o ofertă medie de $555 CAD pentru proiect
Avatarul utilizatorului
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
$500 CAD în 1 zi
4,7 (73 recenzii)
6,6
6,6
Avatarul utilizatorului
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 area, I will work on rewriting the queries, adding relevant DB configurations, and optimizing indexes to help reduce the runtime of these queries to less than 30 seconds. In addition to my expertise, I have worked on similar projects in the past, where I have successfully tuned queries with a similar or larger amount of data. I am confident that I can apply my past experiences to your project and deliver the desired results. Here is a brief outline of the services I will offer: Analysis of current queries and system configurations to identify the root cause of performance issues Rewriting SQL queries to improve performance Adding or modifying indexes as needed to optimize query execution Optimizing DB configurations to reduce query execution time Testing and validating the performance of the optimized queries. To begin, I will require access to your system and database environment to perform a thorough analysis of the current system configurations and query performance. I will then work on implementing the necessary changes and optimizations to improve the performance of the queries. Sincerely, Muzzamil
$750 CAD în 2 zile
5,0 (14 recenzii)
5,5
5,5
Avatarul utilizatorului
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 knowledge and experience in both SQL Server Prod & Dev environments. Please feel free to ask for adjustment if my Bid Amount or Hourly Rate does not suit your budget. Warm regards, Kundan Bihari (Freelance, SQL Server Consultant.)
$400 CAD în 4 zile
5,0 (30 recenzii)
5,0
5,0
Avatarul utilizatorului
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. Thanks, Devendra Shirbad DBA & Data Architect ? 09.00 am – 06.00 pm (Mon – Fri) ?? India
$750 CAD în 7 zile
4,9 (5 recenzii)
5,1
5,1
Avatarul utilizatorului
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 happens in those queries? - is temporary tablespace having adequate size? Can you share execution plan of your queries first. Thanks
$600 CAD în 7 zile
4,9 (29 recenzii)
5,2
5,2
Avatarul utilizatorului
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 using python and c# and reporting with powe bi experience. I will be able to complete the project. Please ping me offline to discuss further.
$500 CAD în 7 zile
4,9 (12 recenzii)
4,5
4,5
Avatarul utilizatorului
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
$500 CAD în 2 zile
5,0 (1 recenzie)
3,4
3,4
Avatarul utilizatorului
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 . I have a perfect grip on “Database Administration” , and work in “Oracle” Mysql”. I want to assure you that these are my areas of expertise and I can do any work related. Here I am also assuring you that the quality of work will not be compromised . I am able for work full time on your time zone and start work right now . Please send me a message for further Details . Thanks and Best Regards
$250 CAD în 2 zile
5,0 (10 recenzii)
3,2
3,2
Avatarul utilizatorului
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 suggest analyzing the execution plans of the queries to identify the bottlenecks and tune the query accordingly. Additionally, optimizing memory allocation for the Oracle database and ensuring that statistics are up-to-date can further enhance performance. I am available to discuss these options in more detail and work with you to find the most effective solution for your specific needs. Best regards. Courser Xu
$500 CAD în 7 zile
5,0 (4 recenzii)
3,0
3,0
Avatarul utilizatorului
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, and SQL and PLSQL programming. I've upgraded many databases from Oracle 12c to 18c and 19c from on-premise to on-premise and on-premise to Oracle cloud AWS RDS and EC2 utilising DMS and S3 bucket. Please let me know if you require any database assistance.
$500 CAD în 7 zile
5,0 (3 recenzii)
3,1
3,1
Avatarul utilizatorului
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 freelancer. I have 6+ years of experience in Oracle SQ/PLSQL development. I can also provide you a free mock sample to you to see my working abilities
$500 CAD în 2 zile
5,0 (3 recenzii)
3,0
3,0
Avatarul utilizatorului
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 experience in SQL, Oracle, Oracle Database, Database Administration and Database Development. I am a Full stack developer with a team of experienced developers, So it would be my pleasure to build long term relationship with you. All my skills are related to this particular project. Please let me know what is needed to secure the bid! Thanks for your consideration. Rashid Amjad.
$700 CAD în 15 zile
5,0 (1 recenzie)
2,4
2,4
Avatarul utilizatorului
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 experience using manual analysis and tools such as sql_profiles, partitioning, creation or modification of indexes, materialized views (including query rewrite), etc.
$500 CAD în 3 zile
5,0 (3 recenzii)
2,5
2,5
Avatarul utilizatorului
I am Oracle certified DBA having 12 years of experience in installing and administrating oracle database
$759 CAD în 1 zi
5,0 (5 recenzii)
2,6
2,6
Avatarul utilizatorului
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. Sql server, mysql, access, excel, oracle, mongodb, postgrey Sql, sybase etc. 3. Installer nsis, msi etc 4. Unit testing 5. Tdd approach 6. Single responsibility principal 7. Design pattern 8. Mvc .net core 9. NodeRed 10. Selenium for web automation 11. White framework for wpf automation 12. macro Voice bot with c# to automate things Thanks Dayanand
$500 CAD în 7 zile
5,0 (3 recenzii)
2,4
2,4
Avatarul utilizatorului
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 requirement in a detailed way. Thank You
$500 CAD în 7 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
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.⭐ ⭐ I would like to ask question before start your work then we will decide budget and deadline.⭐ Let's have a quick conversation on the details to proceed further with this project. We look forward to work with you:)
$500 CAD în 7 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
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 Development, Oracle Database Let's connect by chat so that we can discuss further. Best Regards, Nikoloz Nadashvili
$500 CAD în 7 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
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 free to ping me anytime so we can have a detailed discussion. If I can deliver I will deliver in best possible way. Thanks My portfolio: https://www.freelancer.com/u/AITSoft
$750 CAD în 21 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
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 sQL Language also. I have completely understand your problem. You want to optimize your query that gives you result less than a minute. I am available for your work. Kindly hire me.
$500 CAD în 3 zile
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul CANADA
Calgary, Canada
0,0
0
Metoda de plată a fost confirmată
Membru din sept. 2, 2020

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.