Find Jobs
Hire Freelancers

SQL Query Optimisation

$250-750 USD

Completed
Posted about 8 years ago

$250-750 USD

Paid on delivery
I need someone that is very proficient in writing SQL Queries and DB management. You will have to analyze the bottlenecks in the current setup and optimize the queries so that searches will load faster. The DB runs on an AWS RDS instance and is multiple GB in size and with a few million rows.
Project ID: 9962459

About the project

39 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Have experience when working with amazon scrapper database with 70 million of record. Sure that I can help you to fix the problem. Please contact me for details. Hope we can work together. Have a nice day :D
$350 USD in 3 days
5.0 (46 reviews)
5.7
5.7
39 freelancers are bidding on average $553 USD for this job
User Avatar
Hi, I'm Dario, a Software Developer and DB Administrator experienced in DB tuning in Naples, Italy. I reviewed your bid request and I'm interested in it as I have several years working experience in tuning code and DBs to provide fast responses. I will be glad to inspect your db schema for errors/misconfiguration in schema definition as well as you application code to detect wrong queries and provide a solution to have a fast and responsive db. Looking forward to work with you, feel free to contact me with to further discuss your project and respond to any question you could have. Kind regards, Dario
$515 USD in 10 days
5.0 (172 reviews)
10.0
10.0
User Avatar
Hello, sir. I am very interested from your project. I'm TOP 6TH freelancer as you can see my profile (https://www.freelancer.com/u/kchg.html). I have enough skills for your project. Kind Regards
$721 USD in 10 days
4.9 (446 reviews)
9.8
9.8
User Avatar
Hi, I can do your job but need to make a short chat discussion with you. let me know if possible for you. please let me know. You can check my profile and feedbacks of clients which itself I got from them. Hope they make some small help trust on me for your job. Regards Rina
$2,631 USD in 28 days
5.0 (156 reviews)
7.6
7.6
User Avatar
Hi there can you tell me what's your website URL ? is server managed or un-managed ? I have experience of writing queries and gave worked with millions of data. I have over 6+ years of experience in php, MySQL, css, Facebook apps etc. Waiting for your response
$277 USD in 4 days
4.7 (90 reviews)
6.4
6.4
User Avatar
I've worked with DBs for 14 years (all sorts, Oracle, mysql, cassandra, mongo)... And I'm a performance engineer and have done analysis, written queries better, built indices, and written stored queries. A big DB doesn't have to be slow and debugging isn't any harder. But sometimes you need more primary and foreign keys, indices, and more attention to your queries. So good DB practices are the same whether youare big or slow.
$555 USD in 10 days
5.0 (50 reviews)
5.8
5.8
User Avatar
if you are using the mysql engine I can check and optimize your query. I'm also available to replicate your mysql in a virtual machine if you can give me your data to perform an accurate tuning. I've already worked with a mysql db of more than 15gb 20% milestone requested in advance
$569 USD in 5 days
5.0 (20 reviews)
5.6
5.6
User Avatar
Yes, I can help you out surely with your project I have read your requirements and understand what exactly you want to do. I'm ready to start the work. Please inbox me for discussion. Looking forward for your response. Thanks, Preeti
$667 USD in 15 days
4.9 (22 reviews)
5.2
5.2
User Avatar
Hello Sir, I have more than 8 year experience in web development ,made many website with delivered quality work I am expert in web development . few things that i have , i am very quick learner ,good listener ,and make understanding with whom i am working. I am sure ,i can help you in web development . Looking forward for long term relationship. Please give me chance to working with you. Hope we will work together. Thanks Ricky
$444 USD in 10 days
4.7 (29 reviews)
5.2
5.2
User Avatar
Hello, I'm ready to help and diagnose the issue for sql server db. please give me access to db so that I could start work asap. Thanks, Hafiz
$555 USD in 10 days
5.0 (8 reviews)
4.8
4.8
User Avatar
I have 4 + years of experience in MSBI Technology (SQl Server 2008/2012, SSIS, SSRS, and SSAS) Worked with the reputed clients like Microsoft, HCL, and Dicks Sporting Goods etc. Expert in creating Sql queries ,Dynamic T-sql,functions,triggers,indexes,Procedures,cte,temp tables and sub queries . Expert in creating SSIS package, configuration, Deployment and Scheduling and extracting the data from different sources like SharePoint lists, excel files, csv files, Data feed store, MySQL database, sql databases etc. Expert in creating different ssrs reports like drill through, drill down, parameterized, table, matrix,Chart,Line,Stacked columns, Map ,Document type etc. SSRS reports integration with SharePoint and windows applications. Fetching the data from multidimensional cube, tabular cubes with the help of MDX queries and creating SSRS reports. Expert in handling the huge databases (in TB) and performance optimization of the legacy codes.
$300 USD in 10 days
4.6 (24 reviews)
4.8
4.8
User Avatar
Hi this is bhargava expert in mysql . i am ready to provide quick and efficient solution . Thanks bhargava
$300 USD in 3 days
4.9 (32 reviews)
4.4
4.4
User Avatar
Hello, We have managed about 15Gb large database and able to work on this project. We have basic idea how to do this, we need to understand query path and may use sql profiler to see this.
$555 USD in 10 days
5.0 (10 reviews)
3.9
3.9
User Avatar
I am sure I can help you with this. Please let me know if you'r interested so we can discuss the details and the help you need.
$526 USD in 0 day
5.0 (12 reviews)
3.9
3.9
User Avatar
Small Price for for first use freelancer.com. I am a full time programmer with 20 year exp in Russia. I have exp on development, use, and optimize database of _many_ over 100GB size. Over 1000 tables. MSSQL, MySQL, InterBase SQL, FireBird SQL. I Need Preview SQL code before accept - for estimate size of project
$250 USD in 10 days
4.9 (31 reviews)
4.2
4.2
User Avatar
Hello! I have 6+ years of experience in Mysql administration. I resolved the issues with performance caused by server misconfiguration, not optimized queries, HW issues. I have experience of huge queries optimizations (more than 10 tables were involved in some queries). Execution of some queries took more than few hours and after optimization (I modified the queries, so they started to use existed indexes) the execution time reduced to a few seconds. In one of other cases, I modified one of the existed indexes, so the query execution time was significantly reduced (from ~0.1 seconds to a few milliseconds). Let me know if you have any additional questions regarding my qualification.
$333 USD in 4 days
4.9 (7 reviews)
3.8
3.8
User Avatar
I have more than 16 years of experience as Database Administrator dealing with query tuning among other things. Regards, LFR
$294 USD in 10 days
5.0 (9 reviews)
3.3
3.3
User Avatar
I am good in SQL and can do the task as per your requirements. .
$250 USD in 10 days
4.6 (13 reviews)
3.5
3.5
User Avatar
Good Afternoon. I'm Enmanuel Soria from venezuela, i am a System Analist with over 7 years of experience in software development and configuration and maintenance of Databases, i work mostly using Mysql, and would be glad to help you to optimize your database
$555 USD in 10 days
5.0 (2 reviews)
2.9
2.9
User Avatar
Hi I am Hema, having 10 years experience in software development. Worked on various database projects on Oracle , MS SQL Server, MYSQL and POSTGRESQL.I am passionate working on database programming and got very good feedback from clients. I am a very quick learner and easily adapts to client's requirements. Very dedicated and sticks to deadlines. Please reach out for any questions. Looking forward to hear from you.
$555 USD in 10 days
3.7 (4 reviews)
3.4
3.4
User Avatar
I have almost 5 years of experience in Database Development, Database Optimizations, Database Design Currently at work responsible for implementing complex business of this client at database side from data Design till development of modules. My Area of Specialties are - Database Designing - Database Development - Query Optimization. - Stored Procedures development For complex business - Views, Triggers and Functions development - SQL Scripting - Client Issues Fixations - Creating reports - Index maintenance - SSRS - SSIS
$283 USD in 10 days
4.8 (4 reviews)
2.2
2.2

About the client

Flag of DENMARK
Seattle, Denmark
5.0
9
Member since Oct 7, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.