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).