RE: POLL: Database to DBA ratio

[Deshpande, Kirti]

Title: RE: POLL: Database to DBA ratio

In our environment, each DBA supports a certain number of databases  that are his/her 'primary' databases (all the way from Test/Dev/Accept/Production). The same person is 'secondary' or 'tertiary' for others. We follow a standardized setup (somewhat modified OFA) for *all* of these databases, with standardized, but different, passwords for sys/system/production schema accounts that can be easily 'figured out' by DBA team members. Those are changed routinely!  All DBAs are on call all of the time. Every 2 hours the automated paging mechanism/Operations is made 'aware' of who's available via our own DBA Web App, that keeps track of who's in and who's out as well as the 'primary','secondary','tertiary' matrix by database names.     This is working great for over 5 years now....     - Kirti    -----Original Message----- From: Chuck Hamilton [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 6:04 PM To: Multiple recipients of list ORACLE-L Subject: Re: POLL: Database to DBA ratio With such a large # of databases to support, how do you divide up the work? Does everyone administer all of the databases, or are databases assigned to a DBA? How do you handle on-call? ----- Original Message ----- From: Adams, Matthew (GECP, MABG, 088130) To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 12, 2003 2:40 PM Subject: RE: POLL: Database to DBA ratio 350 Oracle Databases spread across US and Europe. 14 full time, 4 part time. 75% of applications are designed and built in-house. -----Original Message----- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 12, 2003 1:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: POLL: Database to DBA ratio We have over 400 databases,  90%+ are Oracle under various versions, platforms. Today have 19 DBAs. Two weeks from now there will be 17. Rightsizing to continue in the 2nd Quarter.... - Kirti -----Original Message----- Sent: Wednesday, March 12, 2003 12:09 PM To: Multiple recipients of list ORACLE-L We have 7 DBAs.  105 production databases (97 24x7), ranging from 2 GB OLTP to 800 GB data warehouses.  395 devl/alpha/beta databases ranging in size from very small (1 GB) to production-sized.  About 1/3 of the production databases have at least 1 (usually more) development effort going on at any given time. Most of our time (lives?) is spent just keeping things up and running.  The on-call guy averages between 50 to 100 pages per week (record is in the 230-range).  Tuning and testing new stuff is fairly uncommon - as we have time.