Find Jobs
Hire Freelancers

SQL Stored Procedure Database Optimization

£20-250 GBP

Completed
Posted almost 9 years ago

£20-250 GBP

Paid on delivery
We have a database and a number of stored procedures that require optimising to improve performance. The database is SQL Azure. There are currently 20 SPs that require optimising, but there will be ongoing work for the right person.
Project ID: 7621894

About the project

25 proposals
Remote project
Active 9 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
Hello, I am a Microsoft Certified Solutions Master: SQL Server (on-premise and Azure). I am a SQL Server Consultant working as a Developer and DBA, I have had 14 years experience with on-premise (2005 - 2014) and 3 years experience with Azure (SQL Database and SQL in an Azure VM). I run my own website [login to view URL] on Azure. I have experience with many companies small and large. I have also worked with many businesses migrating SQL to Azure. If you have any questions let me know.
£145 GBP in 4 days
5.0 (25 reviews)
5.7
5.7
25 freelancers are bidding on average £184 GBP for this job
User Avatar
Dear customer, I am an expert db admin with 10 years experience on SQL Server, Oracle, Mysql and Postegres. Right now we are migrating a Sql Server database with 300 tables, 100 functions, 1500 stored procedure to PostGreSQL. Regards Armando
£368 GBP in 15 days
4.7 (6 reviews)
6.1
6.1
User Avatar
Hello Sir, Greeting for the day, Hope you are doing well We are Group of professional Having more than  8 years’ experience in Windows/Linux Server administration , Website Hosting (Cpanel/Plesk) migration, Mail server configuration management ,CISCO Router Switches, Firewall(ASA,PIX,Sonicwall, cyberoam) ,Cloud Computing(AWS/Azure,office 365) ,Software development on all technologies .I read your Requirement and able to perform task successfully. Please add me in Skype (karunakartiwari) for details discussion about your requirement. Thanks karun
£222 GBP in 5 days
4.7 (32 reviews)
6.1
6.1
User Avatar
Hello For the optimization we may need to change the indices of the tables or make summarized tables and not only changes to the sp. The price a gave is for one hour per sp 9GBP per hour we may need more according to the code and size of the sp. I have been working with MSSQL for over 14 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits the reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo
£200 GBP in 12 days
4.9 (64 reviews)
6.0
6.0
User Avatar
I am having 5.5+ years of experience in Web Developement.I have worked on different projects with different technologies like Asp.net,C#.net,SQL server,Javascript,Jquery,Asp.net MVC,Linq to SQL,KnockoutJS etc . I am working in IT company from last 5.5+ years. I love working on SQL. I can help you with query optimization too , if required. We can discuss the time and price.
£150 GBP in 3 days
4.9 (31 reviews)
5.5
5.5
User Avatar
Hello, I am a database programmer with 14 years experience in MSSQL. What version of MS SQL are you using?
£188 GBP in 3 days
5.0 (7 reviews)
3.9
3.9
User Avatar
SQL Server DBA/MSBI Developer with 4+ years of experience. I have expertise in creating ssis packages, ssrs reports and writing sql queries. Please check my feedback (5 star rated) --------SQL Server DBA------ Adding users in SQL Server Moving the database Import and Export in SQL Server SQL Server indexes SQL Server jobs SQL Server Maintenance Plan SQL Server backup and Restore SQL Server Profiler for performance bottlenecks Working with SQL Server Transaction Log ---------------------------------------------------------------
£222 GBP in 1 day
5.0 (5 reviews)
3.9
3.9
User Avatar
I'm a database developer with more than 25 years of experience, most of them in MS SQL Server, and more recently with Azure SQL Database. The past 20 years I worked (in-situ) developing/implementing database for for two international organizations, including the United Nations. I'm sure I can help with your project and complete it to your satisfaction. If you think you may be interested in my services, please open a private chat, then I can provide my CV (for you to check references/experience) and we can further discuss your requirement regarding the optimization of these stored procedures. kind regards, Marco Garcia
£244 GBP in 10 days
5.0 (2 reviews)
3.5
3.5
User Avatar
Hello I'w working in top 10 retail of Russia. so I do know what does mean big tables and know how to write code (SP espesically) effectively Regards, Yuriy
£150 GBP in 7 days
5.0 (5 reviews)
3.5
3.5
User Avatar
A proposal has not yet been provided
£100 GBP in 3 days
4.6 (4 reviews)
3.1
3.1
User Avatar
Hello Sir/Madam I have solid experience as Oracle, SQL Server, Sybase, PostgreSQL DBA. I am SQL server certified DBA in both as DBA and Designer. I worked as DBA in USA for 13 years. I came back recently to start my own work. I have a number of excellent reference as DBA, Architect and Modeler. Please take a look at my resume and you will find that I am the best fit for this job. I have just completed couple of projects on database and the clients were from Australia, Canada, GB, USA and Russia. Currently I am working on a USA project Please see the review. I have excellent experience in performance and tuninig at server, stored procedure and query level. Appreciate your kind attention in this regard, Warm regards,
£151 GBP in 5 days
4.7 (3 reviews)
2.7
2.7
User Avatar
====Payment After Successfully Deliverable==== Estimated Time: 32 hrs. I am very much intersected in a long term project. My prime focus is provide quality work with affordable budget and make a healthy long-term clients like you. Please have a look on few things below that make me different than other software developers : 1. Specialist in .NET and SQL Server as well as handling large database (upto 32 GB Size) for our ERP application. 2. 12 Years of sound experience. 3. I am punctual, honest and excellent in English communication. 4. I available on Skype on daily basis as per your convenient. 5. I will provide you free maintenance services (60 days after the deployment of project). 6. I will provide you the project updates on daily basis through Skype meeting or mail, if required. 9. I will not charge you in case of any delay and disaffection. 10. And lastly, I also offer a No Risk - Money Back Guarantee. Please connect me once I assure you that I will try to finalize everything as per your expectation. I really appreciate your unavoidable attention on my proposal, I look forward to hear from you soon.
£150 GBP in 3 days
5.0 (2 reviews)
2.2
2.2
User Avatar
Dear Sir, I'm a certified C#, SQL & Azure Developer from Microsoft. I'm ready to start working right now. Note: I'm always available on Freelancer mobile chat.
£100 GBP in 2 days
5.0 (1 review)
0.3
0.3
User Avatar
15+ years of experience in developing VB, VBA Excel, .Net, Access, SQL SERVER CERTIFIED, and others. See my resume and verify my qualifications. I'm the right professional to complete your project successfully. Contact me, I'm interested in helping you in your project.
£300 GBP in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am Master of Computer science Andhra University(INDIA) topper, database certified with ten years of database experience and lead the team of five members. we can work 24*7 for generating best outputs and team lead of this. We are working under my own company RAMTECHNOLOGIES reg. no. 1504. THANK-YOU. Bhaskar +91 8886987382
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Over the last years my activity has been: - Design, development and production of worksheets to support the management of operational teams; - Production: Tableaus of Board, Dashboards, Scorecards, and Executive Summaries for Administration, Financial & Operational Management and External Customers; - Management of a Business Intelligence tool supported in Microstrategy; - Responsible for the design values to be billed to customers and ordering Service Providers resulting from operating activities; - Database Design (T-SQL) for processing and key performance indicators repository.
£277 GBP in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm working full time in MSSQL doing exactly what you need. I work for a Portuguese Telecom Company, and I'm also responsable for our stagging area of BI ( Microstrategy ). Hope to ear from You soon,
£277 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Small company doing only SQL implementation and high level administration. Looking for smaller projects which must be completed perfectly.
£222 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£55 GBP in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£111 GBP in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£150 GBP in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
CARDIFF, United Kingdom
4.9
4
Payment method verified
Member since Dec 8, 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.