At what point should you employ a specialist DBA

At what point should a company think about employing a specialist DBA? How big would they tend to be, how critical do those servers need to be?

more ▼

asked Oct 15 '09 at 07:39 AM in Default

Melvyn Harbour 1 gravatar image

Melvyn Harbour 1 ♦♦
1.4k 18 20 22

(comments are locked)
10|1200 characters needed characters left

5 answers: sort voted first

I think that you ought to hire one on a consulting basis as you are building software, or setting up servers. They can help ensure that you build a strong design or don't make mistakes as you get started.

If you find yourself hiring a consultant more than a week a month, it might be time to consider hiring someone full time, and perhaps letting them handle other tasks on the side.

more ▼

answered Oct 15 '09 at 05:01 PM

Steve Jones - Editor gravatar image

Steve Jones - Editor ♦♦
5.1k 76 79 82

(comments are locked)
10|1200 characters needed characters left

I think that's largely a business decision. How important is your data to the company? The more important it is, the more it might behoove you to have someone who knows how best to protect it. You don't have to hire a DBA full time right out of the gate. You can take advantage of services or consultants that can bring a full set of knowledge to bear on your system for shorter periods of time. I'm not sure that the size of the database has any bearing on whether or not you should have someone on full time. I've seen quite small databases that were poorly designed or had poorly built code running against them that needed a lot of hands on support. I've seen well designed databases in the 200-500gb range that needed the barest of maintenance routines to stay running 24/7 without the need for any DBA attention at all.

In short, the amount of pain you'll experience if your database slows down or goes offline should be the measure of how much you'll be willing to spend to get a DBA into the office, full time or part time.

more ▼

answered Oct 15 '09 at 09:09 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
90.9k 19 21 74

(comments are locked)
10|1200 characters needed characters left

At the point where the return-on-investment from hiring one is positive.

Honestly, that's the only answer that really covers it.

Steve's answer is one way that it would come up positive on that test.

more ▼

answered Oct 15 '09 at 06:01 PM

GSquared gravatar image


(comments are locked)
10|1200 characters needed characters left

I think it also depends on what type of DBA you need, or to put it a better way, what kind of work they will be doing. Any business doing development work against SQL, will use a 'development' DBA different than how a business with off-the-shelf software that runs against SQL, will use a DBA. In those cases, gut-feel tells me that dev shops need DBA experience a lot sooner than non-dev shops.

more ▼

answered Oct 15 '09 at 10:00 AM

Kev Riley gravatar image

Kev Riley ♦♦
50.7k 43 49 76

(comments are locked)
10|1200 characters needed characters left

I hope soon that there will be a commonly use acronym DBD as well as DBA. DBA stands for DataBase Administrator, which for me means administering the databases and servers. DBD stand for DataBase Developer, which for me means developing withing the databases and servers.

more ▼

answered Oct 15 '09 at 04:52 PM

Peso gravatar image

1.6k 5 6 8

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 15 '09 at 07:39 AM

Seen: 911 times

Last Updated: Oct 15 '09 at 07:39 AM