Re: survey - DBA structure in your company ?
Date: Thu, 2 Apr 2009 14:12:21 -0400
Message-ID: <9256898f0904021112y7e184328s4b72554053b55b53_at_mail.gmail.com>
I would advise against number two. Unless you have at least 2 DBA's per environment end-to-end. The problem is coverage for sick days, vacations, training, etc.
Are DBA's allowed to move between groups? ie, in your current environment, are DBA's allowed to switch from infrastructure to application?
Personally I like to support an environment end to end. Even if you break them apart like the options you propose there may be some overlap.
The best DBA group I was a part of was structured in an end-to-end fashion but once a year we had to juggle the environments. ie, there were around 10 DBA's supporting multiple environments each. At the end of the year you could elect to keep a couple of the environments but the rest went into a pool. Then we went around the room and each DBA picked a new environment from the pool that they would like to support. This solved the coverage issue and seemed to keep everyone happy.
On Thu, Apr 2, 2009 at 1:51 PM, <DEEDSD_at_nationwide.com> wrote:
>
> 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 02 2009 - 13:12:21 CDT