Helping Hand Organizing Ecommerce SQL Server DB

Annullerat Publicerat 6 år sedan Betalades vid leverans
Annullerat

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:

T-SQL

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

Thanks

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.

Thanks

uppss, forgot a word

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

Databasadministration Databasprogrammering Microsoft SQL Server MySQL SQL

Projekt-id: #15883488

About the project

25 offerter Distansprojekt Aktivt 6 år sedan

Tilldelades:

Splaszczyk

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 Mer

$22 USD / timme
(3 omdömen)
4.3

25 frilansare har lagt bud på i genomsnitt $23/timme för det här jobbet

dotnetsqlCoder

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 Mer

$27 USD / timme
(146 omdömen)
7.3
feninsoftech

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 Mer

$22 USD / timme
(54 omdömen)
6.8
sunnysmile911

@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 / timme
(11 omdömen)
6.1
papon13

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

$30 USD / timme
(118 omdömen)
6.5
schoudhary1553

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 Mer

$20 USD / timme
(46 omdömen)
6.5
sopholos

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 Mer

$52 USD / timme
(18 omdömen)
5.8
vinaysinghh

A proposal has not yet been provided

$16 USD / timme
(69 omdömen)
5.5
DeoTech

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 Mer

$33 USD / timme
(16 omdömen)
4.6
bnrajumnc

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 Mer

$22 USD / timme
(9 omdömen)
3.7
qualityhelp

A proposal has not yet been provided

$27 USD / timme
(5 omdömen)
2.8
nithyarajeshg

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 / timme
(10 omdömen)
2.2
samsonnite39

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 Mer

$22 USD / timme
(3 omdömen)
2.1
Alpine12812

Hi there, I'm interesting for your offer here. I have experience 9 years on data analysis using MS SQL Server tools. I'm a quick learner and also can working together as a team member. My last project are doing d Mer

$20 USD / timme
(0 omdömen)
0.0
naveekarthik

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 Mer

$16 USD / timme
(0 omdömen)
0.0
mrhsham2

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 Mer

$13 USD / timme
(0 omdömen)
0.0
tiagojaques

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 Mer

$20 USD / timme
(0 omdömen)
0.0