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
