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.

Habilidades: Oracle, Administração de Bancos de Dados, SQL, Desenvolvimento de Banco de Dados, Oracle Database

Sobre o Cliente:
( 0 comentários ) Calgary, Canada

ID do Projeto: #36251440

35 freelancers estão ofertando em média $555 nesse trabalho


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 em 1 dia
(73 Comentários)

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 Mais

$750 CAD in 2 dias
(14 Comentários)

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 Mais

$400 CAD in 4 dias
(30 Comentários)

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. Mais

$750 CAD in 7 dias
(5 Comentários)

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 Mais

$600 CAD in 7 dias
(29 Comentários)

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 Mais

$500 CAD in 7 dias
(12 Comentários)

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 in 2 dias
(1 Comentário)

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 . Mais

$250 CAD in 2 dias
(10 Comentários)

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 Mais

$500 CAD in 7 dias
(4 Comentários)

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 Mais

$500 CAD in 7 dias
(3 Comentários)

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 Mais

$500 CAD in 2 dias
(3 Comentários)

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 Mais

$700 CAD in 15 dias
(1 Comentário)

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 Mais

$500 CAD in 3 dias
(3 Comentários)

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

$759 CAD em 1 dia
(5 Comentários)

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 Mais

$500 CAD in 7 dias
(3 Comentários)

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 Mais

$500 CAD in 7 dias
(0 Comentários)

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. Mais

$500 CAD in 7 dias
(0 Comentários)

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 Mais

$500 CAD in 7 dias
(0 Comentários)

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 Mais

$750 CAD in 21 dias
(0 Comentários)

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 Mais

$500 CAD in 3 dias
(0 Comentários)