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!
30 freelancers are bidding on average $241 for this job
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.
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.