Closed

SQL tunning/configure for huge database.

We have a very huge database to track GPS users locations,

7 200 000 INSERTS/day, table grow to 150 400 000 registered locations,

7 200 000 DELETES/day (delete old historical locations),

and of course, lot of SELECTS,

I need and SQL SERVER expert to define the right way of define database architecture/options, for example, now, historical DELETE blocks database for some minutes,

please, only bid if you have experience with similar huge databases, I'm not posting on a forum!

Skills: Software Architecture, SQL

See more: architecture huge database, architecture define, tunning architecture, sql experience, sql software, server configure, gps track, track gps, database historical, grow 200, forum software database, huge forum, sql expert need, software expert experience, gps software sql, architecture database, gps server database, server gps, 200 000, course database, expert sql, database architecture, posting software bid, forum posting expert, inserts

About the Employer:
( 10 reviews ) Barcelona, Spain

Project ID: #1123309

30 freelancers are bidding on average $241 for this job

fedalal2

Hi, I have more 10 years experience with MS SQL Server, include data minning and cubes. I can help you with this project. Best Regards, Alex

$200 USD in 3 days
(11 Reviews)
5.1
sadeque

Hi, Please check the PMB.

$150 USD in 7 days
(12 Reviews)
4.4
AlexYes

Greetings! I'm a professional in Geographic Information Systems (GIS), and MS SQL Server DBA. It's a perfect - and rather rare - combination of qualifications to suit this project. I hope we could sort out all issues.

$200 USD in 10 days
(3 Reviews)
4.1
virusvi2

Please check PMB

$110 USD in 0 days
(5 Reviews)
3.5
patelrajan2000

Please check PMB

$500 USD in 3 days
(6 Reviews)
2.2
botzkobg

Hi, please check your PMB.

$200 USD in 10 days
(2 Reviews)
1.6
stalker2011

Name: Gritsenko Stanislav About Me: I am a 4+ years experienced linux server administrator. I am now looking forward to get a reputable full time technical support position, or a part-time server setup and security exp More

$160 USD in 2 days
(1 Review)
1.0
RationalMark

i dealt with the ETL , performance optimization database experience on the educational assessment records ranging to 10 million state level records pointing to 55 districts invidivuals from KG-K12. i had tuned the timm More

$400 USD in 10 days
(0 Reviews)
0.0
sunilk1303

I am data warehouse Architect and had worked on several high end data warehouse project involving trillions of records and managed data transaction from them with optimal SQLs.

$200 USD in 3 days
(0 Reviews)
0.0
sreejith4fun

I have experience in this type of projects.

$1000 USD in 15 days
(0 Reviews)
0.0
heyGuru

Hi, I am having extensive experience of large environments and resolved severe performance issues,I have worked on SQL server 2000, 2005,2008 versions of SQL server, please check my profile for detail. and let me know More

$350 USD in 4 days
(0 Reviews)
0.0
muthukumar0009

Please see PM

$250 USD in 2 days
(0 Reviews)
0.0
smbakhtiar

I am interested.Please check PM.

$160 USD in 7 days
(0 Reviews)
0.0
Sonika2011

I have 10 years experience in sql field. For more detail please chk my profile

$140 USD in 4 days
(0 Reviews)
0.0
Ausodev

There is very interesting project for us. We are specializing in this kind of work. Our team of DBA experts has done many similar projects and we can do this one above your expectations extremely quickly with high qual More

$250 USD in 5 days
(0 Reviews)
0.0
sqlfrndz

I'm good with Performance tuning. I'm sure I can do this.

$250 USD in 14 days
(0 Reviews)
0.0
jatinmadaan

i am new so i will complete your work on time for sure.

$30 USD in 3 days
(0 Reviews)
0.0
LakshmanT

Hi, I am microsoft certified DBA working from past years. i can do you task in time as you expected. Thanks, lakshman.

$200 USD in 3 days
(0 Reviews)
0.0
AhmedEj

i have superb expertise in SQL Sever and i know what kind of difficulty you are facing. there is some issue due to data gathering and you want to purge the data and optimize the some related queries. you can contact wi More

$250 USD in 5 days
(0 Reviews)
0.0
considerITsolved

I am ready to start. I have experience in Sybase SQL and Oracle PLSQL fine tuning and migration. 100% money back guarantee.

$250 USD in 2 days
(0 Reviews)
0.0