| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: So, What is a 'Production DBA'?
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: bryny_at_dfweahs.net
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 - 16:28:20 CDT
 |
 |