Database: 12 Tips for Making Remote Database Administration Easier

 
 
By Don E. Sears  |  Posted 2009-04-08
 
 
 

12 Tips for Making Remote Database Administration Easier

by Don Sears

12 Tips for Making Remote Database Administration Easier

12 Tips for Making Remote Database Administration Easier - Page 2

Make sure to review service levels as well as price. Service levels can vary widely by provider.

12 Tips for Making Remote Database Administration Easier - Page 2

12 Tips for Making Remote Database Administration Easier - Page 3

Assess your environment. Determine segments best suited for 24/7 support. Lower traffic, more stable segments may not require 24/7 support.

12 Tips for Making Remote Database Administration Easier - Page 3

12 Tips for Making Remote Database Administration Easier - Page 4

Make sure it's scalable. Your support contract needs to remain cost-effective while you grow. Sometimes, it may be more cost-efficient to add an additional FTE.

12 Tips for Making Remote Database Administration Easier - Page 4

12 Tips for Making Remote Database Administration Easier - Page 5

Create a list of expectations up front. If the vendor's initial service offering doesn't include what you'd like to see, ask. Not every offering will match requirements.

12 Tips for Making Remote Database Administration Easier - Page 5

12 Tips for Making Remote Database Administration Easier - Page 6

Start small. Ask for a "trial" segment of your environment on a month-to-month contract. This will allow you to expand scope as needed.

12 Tips for Making Remote Database Administration Easier - Page 6

12 Tips for Making Remote Database Administration Easier - Page 7

Evaluate the vendor's team and make sure they have seasoned, full-time remote DBAs.

12 Tips for Making Remote Database Administration Easier - Page 7

12 Tips for Making Remote Database Administration Easier - Page 8

Does the vendor conduct regular on-site customer visits? Regular on-site visits allow the remote provider to be an extension of your team and understand how to handle emergencies.

12 Tips for Making Remote Database Administration Easier - Page 8

12 Tips for Making Remote Database Administration Easier - Page 9

Make sure you have network/security team that can open firewall ports securely for remote DBA. Always require a VPN.

12 Tips for Making Remote Database Administration Easier - Page 9

12 Tips for Making Remote Database Administration Easier - Page 10

Make sure that you have single point of contact within your company who can manage the relationship between you and the remote DBA team.

12 Tips for Making Remote Database Administration Easier - Page 10

12 Tips for Making Remote Database Administration Easier - Page 11

Make sure that you have a ticketing system that can track the requests for your remote DBA tasks.

12 Tips for Making Remote Database Administration Easier - Page 11

12 Tips for Making Remote Database Administration Easier - Page 12

Consider and analyze your change management procedures - have clear procedures in place.

12 Tips for Making Remote Database Administration Easier - Page 12

12 Tips for Making Remote Database Administration Easier - Page 13

Does the provider offer on-shore, on-site and on-demand remote DBA resources, so they are available when you need them?

12 Tips for Making Remote Database Administration Easier - Page 13

Rocket Fuel