Find Jobs
Hire Freelancers

2 SQL Querry optimization and improvements

$30-250 USD

Cancelled
Posted about 5 years ago

$30-250 USD

Paid on delivery
Our primary service is to rent mobile phone lines and we need to audit the phone bills that we get to see that the mobile operator is charging us correctly and also need to bill the end users. We have stored procedures that create both the audit and the re-bill reports on excel but we need to add a few feilds to the reports and make some other improvements like try to shorten the time that the current sp takes to finish and generate a report. Our objective is to start with VERY simple task so that the developer can gradually become familiar with the DB to then continuously make new reports, improvements etc. Our current SQL sepcialist is no longer able to do freelance for lack of time. Please bid for this simple task only if your looking to do ongoing work because it will take some time to become familiar with the entire DB structure. There are 2 basic tasks 1) create 3 new columns in our current report - We will tell you the name of the field and we will tell you the name of the fields that need to be added to generate the values that go in these new fields. This is something that our current SQL specialist could do in CONSIDERABLY LESS THAN 1 HOUR. Its VERY BASIC CHANGES with detailed explanation to complete the task. 2) get our current sp that takes about 20-30 min to finish and optimize it so that it runs in 1/2 the time or less. I have no idea how long this would take and its not a critical task that we need, its more to test the developers ability to improve what we already have. Its ok to just bid on item 1 if your not comfrotable estimating a value for the service without knowing more about the stored procedure to be optimized.
Project ID: 18737597

About the project

27 proposals
Remote project
Active 5 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
27 freelancers are bidding on average $109 USD for this job
User Avatar
Hi! I offer you my skills for your task. I'm expert for MS SQL SERVER (full stack) and i ready to work with you. I have lot of experiences with MS SQL SERVER (10+ years).
$55 USD in 2 days
4.9 (52 reviews)
6.0
6.0
User Avatar
Hello! I am a Computer Engineer, with a Master of Business Administration and a MCSA SQL Server 2014, with 12 years of experience using SQL, queries, reports and dashboards design and construction, database management, data warehousing, and related projects and tasks. I am a near-native English speaker, currently available, and results oriented. I can provide you ongoing support for your needs, with database analysis, optimization and writing robust, efficient, and easy-to-understand SQL queries. About these 2 tasks, I am positively sure that I can finish them. We can discuss details over chat, if you like. Thanks!
$150 USD in 3 days
4.9 (24 reviews)
6.0
6.0
User Avatar
Hello, your project caught my attention and I'd like to work with you. Although the second part may take some time because I will need to get familiar to the database for the optimization but be rest assured that I can surely provide you with what you require.
$200 USD in 4 days
4.9 (28 reviews)
5.5
5.5
User Avatar
Hello I am a full stack developer for over 5 years on the freelancer.com. I have read your description in more detail and have many interest to your project. I have many experience what I have ever done before similar to your project. I think that I can finish your work perfectly as you need. If you need to discuss with me for any kind of suggestions or information, please knock me anytime. I am looking forward to hearing from you very soon. Thank you.
$60 USD in 0 day
4.8 (20 reviews)
5.2
5.2
User Avatar
Hello, I am Oracle certified professional java programmer and work as Oracle EBS techno functional consultant in finance area. My duties are very similar to what you specified in the description, ie: report development, debug and interface, worflow development. I would like to complete the given task so you can get idea about my skills. If everything worked well I like to continue work. Thank you.
$80 USD in 1 day
5.0 (25 reviews)
4.9
4.9
User Avatar
Hello i am expertise in sql server and querying please let me know ur requirment and ping me if u serious about ur requirment and need an expert
$166 USD in 3 days
4.8 (22 reviews)
4.6
4.6
User Avatar
Hello, Dear Sir. I read your requirement carefully. So I can tell you that I can do it. I have the ability to help you perfectly. We will work hard until you are fully satisfy. Thank you.
$150 USD in 3 days
5.0 (3 reviews)
3.4
3.4
User Avatar
I have big experience as Senior Database Developer/DBA. Expert in MS SQL. I Know well T-SQL, make queries of any complexity. Also know well query optimization, performance tunning and troubleshooting. I can help with both tasks.
$100 USD in 2 days
5.0 (5 reviews)
3.5
3.5
User Avatar
Dear client. I've read your project description carefully and very interested. Let's discuss over chat and get started. Waiting for your reply. Regards.
$250 USD in 2 days
4.5 (12 reviews)
3.6
3.6
User Avatar
Hi. I have 6+ years of experience in IT Sector working with Database especially writing and optimizing complex sql queries. I have gone through your project requirements and I believe I would be able to complete this project as required in the given time frame.
$80 USD in 2 days
5.0 (7 reviews)
3.3
3.3
User Avatar
I am a database expert in an mnc. I have experience with huge databases that involves 100's of sp and query optimizations. Have worked on large scale database projects.
$35 USD in 3 days
5.0 (1 review)
2.6
2.6
User Avatar
I have many years of experience with optimizing SQL queries. Actually, the first year of my current full-time work was like 90% optimizing legacy SQL code and 10% of new developing :) Now the ratio is different, but I'm still doing it a lot. Would you like to include exact version of your database software in your project (is it MySQL or Microsoft SQL Server and which version). Also, would you like to attach your SP or some part of it to your project?
$45 USD in 3 days
5.0 (5 reviews)
1.7
1.7
User Avatar
Greetings !!! I just read your Project Description and i m willing to go ahead and start Development on this Project Query Optimization . I have done this kind of project recently i can give you this Project in real quick time. I have 10 year working experience on multiple Database Project based on SSIS, ASP.NET,MS SQL server, mysql and Oracle. i will work in Strategic milestones and transparency so that you will be frequently uploaded on where we stand in the project i can achieve the result that you are looking . Looking forward to hearing at your earliest convenience. Regards Avin Panwar
$55 USD in 3 days
5.0 (2 reviews)
1.2
1.2
User Avatar
Hi,I developer and Analist professional with experiency in PHP Framework Yii and Laravel Experiency in implementation and maintenance of plataform Moodle Manager Database Mysql Please me contact and I can help you best regards
$155 USD in 3 days
2.7 (3 reviews)
1.5
1.5
User Avatar
hey, i'm interested in your project work.i have got 17 yrs experience in database design and programming using DDL,DML,CURSOR,STORED PROCEDURE,FUNCTIONS,TRIGGERS etc. Give us a chance and You will not be disappointed for sure.
$177 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm a software developer with over 5 years of industry experience working on many tools and technologies. I have expertise and experience to carry out projects smoothly and I'm interested in this work. Please remember the price and timeline specified is just a placeholder and it will be appropriately updated after the discussion of the requirements.
$35 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Gone through your requirements. Will optimize your stored procedure so that will work in 1min instead of 20mins. In which technology your reports are designed. What is your database version. How do you want to share the Db backup. Kindly reply these questions. Interested to start your work. Regards Kaushik
$166 USD in 2 days
0.0 (0 reviews)
3.2
3.2
User Avatar
Hi , Interested to work on this project. Here is the bid for first work . Second part - also i am interested to take up as i have experienced in SQL tuning. But it may take some time to understand the DB structure and the stored proc, hence not estimating for the same. Thanks.
$70 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, please share the details of database and code that need correction. I have experience in the optimization of sp related things. Thanks
$200 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Thank you so much for positing for your requirements. Surely, We are ready to help you with connect wordpress page website to oracle database We have understood your requirements. Let discuss little more? We are ready to start the work now! Rest be assured you we will offer you the best.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BRAZIL
RIO DE JANEIRO, Brazil
5.0
49
Payment method verified
Member since Aug 17, 2010

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.