Find Jobs
Hire Freelancers

2 SQL Querry optimization and improvements

$30-250 USD

Ακυρώθηκε
Αναρτήθηκε περίπου 5 χρόνια πριν

$30-250 USD

Πληρωμή κατά την παράδοση
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.
Ταυτότητα εργασίας: 18737597

Σχετικά με την εργασία

27 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 5 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
27 freelancers δίνουν μια μέση προσφορά $109 USD για αυτή τη δουλειά
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 σε 2 ημέρες
4,9 (52 αξιολογήσεις)
6,0
6,0
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 σε 3 ημέρες
4,9 (24 αξιολογήσεις)
6,0
6,0
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 σε 4 ημέρες
4,9 (28 αξιολογήσεις)
5,5
5,5
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 σε 0 ημέρα
4,8 (20 αξιολογήσεις)
5,2
5,2
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 σε 1 ημέρα
5,0 (25 αξιολογήσεις)
4,9
4,9
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 σε 3 ημέρες
4,8 (22 αξιολογήσεις)
4,6
4,6
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 σε 3 ημέρες
5,0 (3 αξιολογήσεις)
3,4
3,4
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 σε 2 ημέρες
5,0 (5 αξιολογήσεις)
3,5
3,5
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 σε 2 ημέρες
4,5 (12 αξιολογήσεις)
3,6
3,6
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 σε 2 ημέρες
5,0 (7 αξιολογήσεις)
3,3
3,3
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 σε 3 ημέρες
5,0 (1 αξιολόγηση)
2,6
2,6
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 σε 3 ημέρες
5,0 (5 αξιολογήσεις)
1,7
1,7
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 σε 3 ημέρες
5,0 (2 αξιολογήσεις)
1,2
1,2
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 σε 3 ημέρες
2,7 (3 αξιολογήσεις)
1,5
1,5
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 σε 4 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
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 σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
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 σε 2 ημέρες
0,0 (0 αξιολογήσεις)
3,2
3,2
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 σε 2 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
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 σε 10 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
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 σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της BRAZIL
RIO DE JANEIRO, Brazil
5,0
49
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Αυγ 17, 2010

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.