Find Jobs
Hire Freelancers

Ms-SQL optimising

£250-750 GBP

Completed
Posted over 2 years ago

£250-750 GBP

Paid on delivery
Hi I have an MS SQL database, not massively big, but with some core functions that need tuning/optimising to increase performance. it was originally designed on SQL2005, migrated to 2014 last year and now to 2019. However we have had to turn on cardinality optimisation as the performance was awful with it off. I'd like guidance / work on indexing, partitioning, and maybe some stored procedure / query re-engineering to make use of better features in 2019
Project ID: 31452514

About the project

30 proposals
Remote project
Active 3 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
£0 GBP in 2 days
5.0 (59 reviews)
6.0
6.0
30 freelancers are bidding on average £561 GBP for this job
User Avatar
Database Server Health Check ============================ Management ---------- # Type: Contract # Location: Remote, work from home # Commitment: Fixed scope # Time Zone: Any, India Standard Time (preferred) # Language: English, Hindi # Database Engine: Microsoft SQL Server # Unit: 1 server # Turnaround Time (TAT): 5 working days # Rate: $500 / unit Work Breakdown -------------- # Day 1: Data collection (online) # Day 2 and 3: Analysis and report compilation (offline) # Day 4 or 5: Clarification call Deliverables ------------ # Performance monitor snapshots (I/O, memory, CPU etc) # Summary reports ## SQL Server bottleneck analysis ## Resource wait statistics ## Blocking chain ## Top expensive queries ## Missing indexes # Raw observations # Recommendations ## Query Level ## Database Level ## Server Level # Clarification call (up to 1 hour) Prerequisites ------------- # Database server privileged access Available Add-on ---------------- # Additional clarification call (up to 1 hour) ++ $50 # Priority delivery (3 working days) ++ $100
£500 GBP in 7 days
4.9 (7 reviews)
5.4
5.4
User Avatar
Greetings, I'm a professional database and BI expert with 15+ years of experience. Currently, I'm working as a Senior DW, BI & DB developer in one of the leading financial corporation. As you can see in my profile page, I have deep experience in database-related projects. I'm a top expert. -- Best regards, David Dartsimelia Senior BI & SQL Developer
£560 GBP in 2 days
5.0 (4 reviews)
4.4
4.4
User Avatar
Greetings. I am MSSQL DBA. Total 19 years of IT experience. Since 8+ years working as dedicated MSSQL DBA. Past 11 years worked as SQL,.NET developer. Have worked on 250+ servers for administrative part and performance improvement. Being developer and DBA, I can do performance improvement by tuning server level, database level and query level. Looking forward to work with you to complete your project. Thanks & Regards, Milind
£250 GBP in 7 days
5.0 (24 reviews)
4.3
4.3
User Avatar
Hi, i hope you are doing well I am a professional on SQL server, Microsoft access, excel, PHP and also in power BI. I am doing this job since 2010. Give me the chance so that I can show you my skills through this project. And also give me the full information about your project so that I can start. Thank you
£500 GBP in 7 days
4.8 (13 reviews)
4.3
4.3
User Avatar
hi,I can help you I'm Database Administrator with 10+ years of experience in maintenance, security, backup, recovery, designing, coding, testing and supporting solutions in SQL Server environments. Proficient in an assortment of technologies MS SQL Server 2000/2005/2008/2012/2014/2016/2017, SAN Storage and Backup Solutions Thank you for your time and consideration. Best Regards, Shaker
£300 GBP in 7 days
5.0 (10 reviews)
3.8
3.8
User Avatar
Hi, I'm a Senior Engineer who have experience over 15 years in DB Design, Maintanace and Administration. Unexpected challenges in every new project is my key interest to go on and keep working. I'm expert in Writing Functions, Partitioning, Indexing, Complex Stored Procedures to Handle Time-Consuming task in Data Tier. I have also experience in Always on in MS SQL. I have good Knowledge in detecting problems or weak points in Enterprise Systems and offer High Performance and Low Budget Solutions. I'm confident that I can do your job.
£340 GBP in 7 days
5.0 (3 reviews)
2.9
2.9
User Avatar
Hello. I'm very happy to bid on your project. I've just read your description and I'm interested in your job. I am a senior PHP developer with 8 years of experience in Web development. I have the strong experiences in Wordpress, Shopify, Laravel, CodeIgnitor and web design. Building user-friendly websites and applications is truly a passion of mine and I am confident I would be an excellent addition to you. My Skills: - Laravel, Yii, CodeIgniter, Wordpress, Shopify - HTML5, CSS, Javascript, JQuery - MySQL, Sqlite, MSSQL, MongoDB - SEO and API Integration I'll do my best for you and provide you satisfied results in a short time. I hope we will discuss more details about your project. Looking forward to your reply. Best Regards...
£500 GBP in 4 days
4.6 (1 review)
3.2
3.2
User Avatar
Hello Tim , I have read your requirements. I have 6+ Years of experience in this field. I have the right skills to work on this assignment. Let's have a Quick Chat or Call to discuss your Project. I can start work immediately . Awaiting for your earliest response. Thanks and Regards, Virang Patel Please note that this is a placeholder proposal, we can be more specific once we get all the requirements and information required to execute the project.
£500 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am working in MNC Bank as Senior Data Engineer and currently working on Big Data project using Spark, SQL, Hadoop Frameworks and Scala library . Having more than 3 years of experience in Big Data Field and 13 years overall experience in BI/data analytics space and worked with various databases like Netezza, SQL Server etc.. Requesting you to please share the details about the project.
£500 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi , I am an enterprise MSSQL certified DBA with 8 years of experience and will help you to complete your work asap
£300 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Prolific SQL Developer ♦ Knowledge of writing complex T-SQL Queries having 5.9 yrs of experience. ♦ Experience in developing T-SQL queries, views, functions, stored procedures and triggers, indexes, Query tuning using SQL Server 2000/2005/2008/2014/2019 ♦ Working knowledge of SSIS. ♦ PoSH ♦ Deadlocks ♦ Code review and Optimization ♦ Data Migration
£500 GBP in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Winkleigh, United Kingdom
5.0
1
Payment method verified
Member since Jan 3, 2020

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.