Re: How many databases do you support?

At my old job I was one of two DBAs that supported about 30 E-Com databases, versions 7.3.4 to 8.1.6. Primarily dev and test, some prod. Small databases (<50 GB). Never a dull moment, and sometimes adminstration was more reactive than proactive. We supported three development teams, one test team, and one prod team.

At my new job (very new, into my 2nd week), there are 5 databases (dev, test, prod24x7) all Oracle 8i, plus about 6 prod MSSQL databases. Right now, I'm the only DBA. Am I bored having fewer databases? Nope, just have more time for proactive administration, strategy and planning, tools development, learning new stuff, reading oracle-l.

Besides the number of databases, you might also consider what skill levels are needed vs. what the budget can afford. This will help you choose the mix of junior, mid and senior DBAs. Or maybe even DBOs to handle daily routine tasks like user management, monitoring backups, database status, installing software and patches, end-user support.

Suzy

Cherie_Machler_at_gelco.com wrote:
>
> Is there any sort of rule-of-thumb for how many database
> that a DBA should be expected to support? I realize
> that the answer would vary based on size of databases,
> stability, production vs. development, mission critical,
> 24/7, etc.
>
> But in general, how many databases would you think
> a DBA should be supporting if you divide the total
> number of databases in an organization by the number
> of DBAs supporting them?
>
> How many databases do you support on average?
> What is the size of your team?
>
> Trying to get ideas for the head count of our DBA team
> here and wondering what the industry standard is.
>
> Thanks
>
> Cherie
>
> --
> Author:
> INET: Cherie_Machler_at_gelco.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Sep 14 2000 - 12:34:19 CDT