SQL Server Optimisation Consultancy

Closed Posted 4 years ago Paid on delivery
Closed Paid on delivery

We have an existing Microsoft SQL Server database (used in multiple locations, mainly on MSSQL 2012 and 2017) which for the most part performs well but there are a few bottlenecks we would like an expert to look into. These are mainly views built on top of other views, and somewhere we are (I think) being inefficient in how these views are built.

We would do this project by giving you RDP access to an isolated AWS instance running a copy of our database that you can review. Alternatively we could open up the SQL ports so you could use tools on your local hardward, but you would need a fixed IP address to do this.

You should be an expert SQL Developer and skilled in optimisation and view and query design. If this project works well there could well be a possibility of a retained position and / or regular work.

When replying, please indicate your level of experience with MSSQL. Oracle and MySQL are of course useful but you must have experience with Microsoft SQL Server and the associated tools.

Microsoft SQL Server Database Development Database Programming

Project ID: #20678836

About the project

48 proposals Remote project Active 4 years ago

48 freelancers are bidding on average £469 for this job

sumon355

Hello, I am basically expert in MSSQL, know MySQL also. I am interested to work on this project to optimize your views and queries. Let's discuss more in detail. Thanks

£500 GBP in 7 days
(177 Reviews)
7.7
fanninson45

INTRODUCTION I am an experienced Microsoft Certified Professional with Database Programming and Administration skills across both MS SQL and Business Intelligence Development. I have 4+ years’ experience with Databas More

£250 GBP in 10 days
(29 Reviews)
6.4
stefanolsencom

Hello I can definitely help you with your SQL queries. I write and profile/optimize those all the time, anyway. I can help you optimize the execution plans on MSSQL 2008 and newer versions. I am a senior ASP.Net and SQ More

£444 GBP in 3 days
(5 Reviews)
4.8
tutulsoft

17 years SQL server experience at practical field (Large Organisation MS SQL server based ERP development, implementation with performance tuning at Database level). I understood what you are actually looking... and I More

£500 GBP in 7 days
(21 Reviews)
5.0
jayantavkumar

Proposal - You can expect any kind of query on SQL Server, Oracle and MySQL. Let me know if you want to discuss further. I am a database / Business Intelligence / solution architect. I have more than 14 years of expe More

£500 GBP in 7 days
(27 Reviews)
4.9
kashivw

Hello, I am a veteran (25+ years) database developer with real industry experience using SQL Server (from Sybase days to v17), Oracle (v6 thru 12c), MySQL (4.x thru 8.x) and a few others. Serious SQL and procedural SQ More

£500 GBP in 7 days
(13 Reviews)
4.9
AliSafder

Hi, My name is Ali and I can work on it with immediate availability. Let's have quick discussion so I can work on it.

£250 GBP in 15 days
(20 Reviews)
4.5
IMExpertEngineer

Hi, I'm expert in sql server with over 10 years of experience and I can do this job very well. I've also experience in oracle and my sql but I'm best in sql server and I can fix all of your complex queries issues that More

£500 GBP in 7 days
(6 Reviews)
4.6
angnut

Hi, I am an italian backend developer with a lot of experiece on SQL and refactoring/optimitation tasks. I am a Computer Science Teacher. To improve your queries it will be necessary to study the db, understand the tab More

£350 GBP in 30 days
(18 Reviews)
4.2
sreenivas2903

Hi i am expertise in sql server and sql queries .currently we are maintain terabytes of data ping me if u are interested

£333 GBP in 7 days
(18 Reviews)
4.5
bluesea1990

Happy Bidding. How is your day? I have full experience in Database Development . I can start just now and can do it perfectly. I hope to discuss more via chatting.Thanks.

£500 GBP in 7 days
(4 Reviews)
4.1
saadtariq329

I have read your project details. I have to ask a few questions. Can you please message me via chat so we can discuss all the details to elicit all the requirements and hence start the development? I will showcase all More

£500 GBP in 7 days
(1 Review)
3.9
IntrinsecoTImx

Hello! Looks like you need also an experienced DBA so you can tune your Engine Parameters according to Microsofr Best Practices. Im an experienced Microsoft SQL DBA and Developer for more than 12 years, with more than More

£450 GBP in 7 days
(2 Reviews)
3.8
khaldalfalah

I have experience in MS SQL server and VB.net more than 12 years, please send more details to see how I can help you. CV: I am software engineer, Holder of a degree in Faculty of Information Technology - University of More

£300 GBP in 7 days
(8 Reviews)
3.9
Shakerfawzy

Hi I can help you but you first you need to collect the information from the original server to get the problem I'm Database Administrator with 10+ years of experience in maintenance, security, backup, recovery, design More

£250 GBP in 7 days
(5 Reviews)
3.5
l0ginp

Hi, I am keen to work for those who need an expert in SQL Language and Database System. More than 7 years experience in many project on SQL, non-SQL, and Database Management such as MS SQL, Oracle, mySQL, Postgresql, M More

£500 GBP in 10 days
(3 Reviews)
2.8
purnasasmal

Hello there, I know you are looking for mssql server specialist who can optimize SQL views performance in SQL 2012 or 2017. I have been working 13+ years in SQL server and server several complex project for MNC like More

£388 GBP in 7 days
(1 Review)
2.4
masterb325

- I work in a startup where I work with database creation from source, administration and then performing analysis. -I have done Certifications in Business Analytics and working as Analyst for 3 years. -Looking to brin More

£350 GBP in 4 days
(3 Reviews)
2.7
aap31374

I have more then 10 years of experience in SQL Server databse development and Administration.  I have worked with medium to large mission critical databases.  Worked for database design, and performance tuning. I am More

£277 GBP in 3 days
(2 Reviews)
1.7
avinpanwar300

Hello , Greetings !!! I just read your Project Description and i m willing to go ahead and start Development on this Project Microsoft SQl server optimization . I have done this kind of project recently i can give More

£500 GBP in 7 days
(1 Review)
1.0