Re: So, What is a 'Production DBA'?

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Wed, 29 May 2002 12:50:14 -0800
Message-ID: <F001.0046EBC9.20020529125014@fatcity.com>

that's not a bad definition :)

seriously, everyone will have their own definition, mine is:

production dba -- responsible for all databases that are considered "production". this includes but is not limited to:

backups
recovery testing
contingency testing
production performance tuning (should mostly be database tuning as SQL really should be tuned at the development stage, with information passed back from the production DBA)
documentation of all procedures
space management on production systems, including capacity planning and projection of growth
change management
monitoring external data loads into production database health checks on production database

application dba -- responsible for all databases in which developers have access. responsibilities:

SQL tuning (not SQL coding!)
database design, in conjunction with the developers any and all changes to the application schema working with the production DBA to ensure production performance (see SQL tuning!)
backups (these might be weekly offline backups, as development is usually less critical but then again maybe not) as deadlines creep closer, the "weekends off" may not be

this is just the "short" list

I've usually been both the production and application dba where I've worked.

Rachel

• Peter Barnett <regdba_at_yahoo.com> wrote:
  > We are having this debate. What is a 'Production
  > DBA'? Right now all of the DBAs do some of
  > everything. In an effort to focus more DBA time on
  > infrastructure, damagement is floating the idea of
  > Production and Applications DBAs. The DBA group has
  > loosely translated this into the group that is always
  > on-call and the group that gets their weekends off.
  >
  > I would appreciate some input from those of you who
  > are Production DBAs.
  >
  >
  >
  > =====
  > Pete Barnett
  > Lead Database Administrator
  > The Regence Group
  > pnbarne_at_regence.com
  >
  > __________________________________________________
  > Do You Yahoo!?
  > Yahoo! - Official partner of 2002 FIFA World Cup
  > http://fifaworldcup.yahoo.com
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.com
  > --
  > Author: Peter Barnett
  > INET: regdba_at_yahoo.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).
  

  ---

Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.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 Wed May 29 2002 - 15:50:14 CDT