SQL DBA to monitor and address performance issues with production SQL 2 node cluster
We are looking for a SQL DBA with many years of experience in monitoring and identifying issues with performance on production SQL environment. Current DBA is leaving company in 1 week and we need to pair new DBA with current DBA in an effort minimalize risk. We have been having trouble with our managed hosting company and just recovered from a hardware failure they could not identify on a switch between our cluster on the fiber network.
We were seeing high latency and low disk read/write.
This position is for an individual in the US and available between 8-5 CST. We need an individual that is well qualified to handle a large corporate SAAS production transactional data base.
We are using SQL 2008 standard
2 node SQL cluster
Shared SAN at Verizon-Terremark facility.
Managed hosting with SQL DBA support.
Production transactional database that performance is crucial to our product.
The legacy application has a lot of stored procedures with heavy sql intense code. The code is not efficient and will need someone who can identify which queries are the most expensive, where locks are being caused and ideally help implement the changes to make more efficient or communicate to the SQL developers.