Probíhá

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:

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.

Dovednosti: Správa databází, Programování databází, Microsoft SQL Server, MySQL, SQL

Zobrazit více: 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

O zaměstnavateli:
( 25 recenzí ) cascais, Portugal

IČ projektu: #15883488

Uděleno uživateli:

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 Více

$22 USD / hod.
(3 recenzí)
4.2

31 freelanceů na tento projekt zveřejnilo nabídku v průměrné hodnotě $22/hod.

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 Více

$27 USD / hod.
(123 recenzí)
7.0
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 Více

$22 USD / hod.
(32 recenzí)
6.0
papon13

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

$30 USD / hod.
(64 recenzí)
6.1
vinaysinghh

A proposal has not yet been provided

$16 USD / hod.
(62 recenzí)
5.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 Více

$52 USD / hod.
(15 recenzí)
5.4
Raitechintro

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

$27 USD / hod.
(15 recenzí)
5.2
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 / hod.
(7 recenzí)
4.7
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 Více

$20 USD / hod.
(13 recenzí)
4.6
murtaza1981

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

$20 USD / hod.
(2 recenzí)
4.0
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 Více

$33 USD / hod.
(16 recenzí)
4.6
$22 USD / hod.
(3 recenzí)
3.6
quadermamun1

Expert 10+ years of experience Microsoft Certified .NET Developer. Relevant and Experience: .NET - 10+ years ASP.NET - 10+ years C#/VB.NET - 10+ years CSS/HTML/JavaScript - 10+ years MS SQL Server - 10+ years Více

$17 USD / hod.
(4 recenzí)
3.3
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 Více

$22 USD / hod.
(6 recenzí)
3.0
Shubhangee123

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

$15 USD / hod.
(2 recenzí)
2.8
qualityhelp

A proposal has not yet been provided

$27 USD / hod.
(5 recenzí)
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 / hod.
(9 recenzí)
2.1
devesh0012

Dear Sir/Mam, I am Devesh from Pune, India. I have 4 years of experience in web and Windows application development using .NET framework (C#, Windows Forms, ASP .NET MVC, WEB API 2.0, LINQ, Entity framework, SQL Více

$16 USD / hod.
(0 recenzí)
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 Více

$20 USD / hod.
(0 recenzí)
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 Více

$13 USD / hod.
(0 recenzí)
0.0
rohitimentus62

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 Více

$13 USD / hod.
(0 recenzí)
0.0