RE: survey - DBA structure in your company ?

From: Herring Dave - dherri <>
Date: Thu, 2 Apr 2009 14:13:10 -0500
Message-ID: <>

We have a bit of a mix here. One config is we have a bunch of DBAs assigned to a "pool". That pool supports x number of clients and their databases. The folks in the pool are crosstrained on all clients and trade a pager weekly for off-hour support, so they handle all emergencies. During regular hours they have a small subset of clients/dbs that they support ongoing.  

The second config (which I'm a part of) is x number of DBAs are assigned to a client and they manage all dbs only for that client, trading support within the team. As with the first config, we support all facets of the DBA job, just in this case it's for one client (albeit a biggy).  

David C. Herring | DBA, Acxiom Automotive  

630-944-4762 office | 630-430-5988 cell | 630-944-4989 fax 1501 Opus Pl | Downers Grove, IL, 60515 | U.S.A. |    

[] On Behalf Of
Sent: Thursday, April 02, 2009 12:52 PM
Subject: survey - DBA structure in your company ?  

We are a reasonably large corporation, with 650 Oracle databases. We are having a bit of internal discussion going on concerning different support models:

(1) Having separation of duties for DBAs: one DBA area in responsible
for infrastructure across all databases and another group doing application DBA work across multiple application databases, closer to the applications and their data or
(2) Doing DBA work in silos: one DBA would be responsible for a certain
set of applications and databases end-to-end, responsible for all infrastructure and application data work for that set of applications

We currently have a structure like this:

We have systems DBAs that are responsible for the database infrastructure - installing the server software & patching, tuning at the instance level, monitoring db server capacity, backup & recovery, adding sizing datafiles, disaster recovery, database creation, user & security administration, 24x7 level 3 support.

We have application DBAs that are closer to the application data, and are responsible for creating and maintaining the application schema objects (tables, indexes, etc), some SQL statement tuning, logical backups (exp/imp) of application objects, data loads, 24x7 level 2 support.

I am curious what other folks are doing.

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.

Thank you.


Received on Thu Apr 02 2009 - 14:13:10 CDT

Original text of this message