Rachel,

So we could distill your definitions down to:

Production DBA:   deals with real issues

Application DBA:  babysits developers

:-)



R> that's not a bad definition :)

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

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

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

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

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

R> this is just the "short" list

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robert Eskridge
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to