Not sure I agree with prior statements. The Production DBA is the single person(s) responsible for the livelihood and availability of production database environments. He/She/It is the first line of contact should a database-centric application either not perform to expectations or crash. The Production DBA is responsible for environment tuning/performance/optimization, disaster recovery, backup/recovery, security, generic administration, etc. They are also responsible for enforcing production standards for all application development teams and ensuring that all is smooth. In many cases the Production DBA has the same responsibilities for the development environment to ensure that all guidelines are followed as software is transitioned from Development to test to validation and finally production.
The Application DBA is responsible for the overall integrity of a specific application. They are responsible for the physical implementation of the logical data model for that application, application-specific performance issues, application-specific security issues, etc. Note the theme: application specific. This could include any application, even Oracle eBusiness Suite. Application DBAs are DBAs!!! However, many are just starting out in the field so this position was created by many organizations to let them get their feet wet. The primary difference between the two. One absolutely needs a pager and doesn't sleep. The other does. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -----Original Message----- Sent: Wednesday, May 29, 2002 5:41 PM To: Multiple recipients of list ORACLE-L Subject: Re: Re[2]: So, What is a 'Production DBA'? well application dba tunes sql as well.... and makes sure that the ddl operations the developers want don't send the production dba on a rampage --- Robert Eskridge <[EMAIL PROTECTED]> wrote: > 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). __________________________________________________ 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: [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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen 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).