Helping Hand Organizing Ecommerce SQL Server DB

I'm Organizing 15 year worth of stuff added to the DB, by different .net programmers (me inc)

It's just much for me, to learn all the SQL, the more i learn the more i see that i know nothing.

and i do not want to do the mistake of rewritting SP, Designs, to find out a month ltr...

mmm maybe this wasn't the best solution.

I already got perfomance problem under control, was continuasly 40-60% CPU

down to 0-5% now.

but now i have ton of table,sp,views that are doubled.

to get an idea.

1gb of data 3gb of indexes

+950 DB objects

All is lucky pretty flat and simple, removed most sp, that queried, view on view on view

At the moment its near impossible to make any good stats, so much tables you have to add a query, that it takes a day, to then discover, it worthless.

its a easy job for any person with SQL knowledge.

I'm Looking for some one good knowledge:


SQL server 2014

SQL Admin

SQL Perfomance

ASP.NET (vb) would be Perfect but not crucial for this task.

Good english,dutch or Portugues

Work indempented

bringen own ideas

Organized, but not to an extreme.

And get the Job done ASAP.

develop new features

and give me a short explanation.

No Documentation needed at the end a diagram with the main structure.

I have total control of the server, upgrades, changes etc can be done fast.

since its impossible to estimate how many hours this is going to take.

I will make the milestones for amount of hours worked.

Let me know your knowledge (cv, links, articles)

Hour rate (discount for batch of hours)

How many hours you have available a day/week

You timezone and from and time you are available

a very global estimate, this job would take a min of 60 to 300 hours


there so many bids, very time consuming.
Candidates interested please send me a piece of code (SQL and ASP.NET if you have that knowledge) you are most:
proud off
you Re-use to speed up your development
a Bright efficient out of the box solution

Give short, i mean bullet style explanation why that is you pride.


uppss, forgot a word

Give short Description, i mean bullet style explanation why that is you pride.

Skills: Database Administration, Database Programming, Microsoft SQL Server, MySQL, SQL

See more: dynamics crm on premise backup, move the microsoft dynamics crm databases to another sql server, dynamics crm online backup policy, restore crm database from backup, microsoft dynamics crm backup, dynamics 365 backup and restore, crm backup and restore, db check sql server, i m looking for a graphic designer in the inland empire, i m looking for a grant writer in nj, i m looking for a good autocad student, i m looking for a gasmask designer, i m looking for a excel teacher, i m looking for a dress designers list, i m looking for a developer startup, i m looking for a content editor, i m looking for a computer coder, i m looking for a cloud software developer, i m looking for a bookkeeper for my small company, i m looking for a artist

About the Employer:
( 26 reviews ) cascais, Portugal

Project ID: #15883488

Awarded to:


I'm SENIOR SQL SERVER DBA and MCSA CERTIFIED with many years of experience in developing tunnig, and troubleshooting SQL Server environments, currenlty working for London based client. I don't speak portugal, but have More

$22 USD / hour
(4 Reviews)

27 freelancers are bidding on average $22/hour for this job


hello sir I am Microsoft certified developer and database administrator . I worked on several performance improvement and database tuning projects . I work alone , i am not a company or middle man . No one h More

$27 USD / hour
(130 Reviews)

Hi, I have 10 years experience in development and deployment that includes SQL Server, SSRS, SSIS and .NET. Involved in SQL Server activities like Installing, Migrations, Table Partitioning, Configuring maintenan More

$22 USD / hour
(43 Reviews)

Please explain which problem did you try to solve? As I understand you already succeed in optimize your DB. Did you want to refactor code to exclude duplicate code? btw, 1 gb of data - very tiny db. It could be fit More

$52 USD / hour
(17 Reviews)

@Hi, dear I am high skilled ASP.NET developer. I mastered in ASP.NET and MSSQL . If you hire me, I will do my best for you. I hope to discuss more detail Thanks @smile

$22 USD / hour
(9 Reviews)

Hi there, I am expert on ASP.NET, VB.NET, SQL Server(Admin), Code optimize. Thanks in advance, Noor All Safaet

$30 USD / hour
(66 Reviews)

Hi there? I am interested to work on this project. I will attach few links of my previous work to give my knowledge. [login to view URL] [login to view URL] these are my best work of this years. I am expert in databa More

$27 USD / hour
(16 Reviews)

A proposal has not yet been provided

$16 USD / hour
(65 Reviews)

Greeting, I have understood your Organizing Ecommerce SQL Server DB task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Database Administ More

$20 USD / hour
(13 Reviews)

I am a database developer with big experience in MS SQL ( 17 years) I am using - 2008, 2012, 2014 editions SQL Server DBA to install/setup/deliver and support MS SQL Server databases and applications. Configuring t More

$33 USD / hour
(16 Reviews)

Hi, An ASP.NET, c#, vb, [login to view URL], NopCommerce, JQuery, JavaScript, SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) expert here. Please More

$20 USD / hour
(2 Reviews)
$22 USD / hour
(4 Reviews)

SQL SERVER tasks.... SPs,views,all objects, performance optimization of SQL scripts support and maintenance of SQL SERVER tasks. I am based on India timings 9am IST to 5Pm IST. I have 10 years experience on SQL SERV More

$22 USD / hour
(9 Reviews)

Hello, I have read your project requirements and I can surely help you to increase performace of your system develop in with SQLServer as a backend. I have good design and development knowledge in .net & sql More

$15 USD / hour
(2 Reviews)

A proposal has not yet been provided

$27 USD / hour
(5 Reviews)

I have acted as database administrator and maintenance manager for performance of application. I have 10 years of experience in building .net applications with sql as database

$30 USD / hour
(9 Reviews)

Hello, My name is Michael Butar butar, I am from Indonesia. I found your vacancy for SQL Developer and I’m very interested in your vacancy. As a skilled Web / Database / Mobile Apps Programmer professional with experi More

$22 USD / hour
(3 Reviews)

hi there i have very long experience my cv CV Hesham Abdeen Mohamed Computer software engineer Brief: More than 10 years experience in programing administration support and quality assurance in software discipli More

$13 USD / hour
(0 Reviews)

Motivated and dedicated professional to understand and meet customer needs. Great communication skills and teamwork. 14 years experience in software development, working in the government, financial and Telecom. Extens More

$20 USD / hour
(0 Reviews)

HI, I have good experience MSSQL in last 6 years. I have handled 4 big and complex projects in my office. All the projects are in MSSQL database with a 200 GB data. Also I expert in writing search sp and analytics More

$16 USD / hour
(0 Reviews)

Hi - With 14 Years of experience in developing enterprise level applications using Microsoft Technologies. Technical experiences include developing web and mobile apps using ASP.NET MVC, ASP.NET, C#, Entity Framewo More

$13 USD / hour
(0 Reviews)