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 <bryny_at_dfweahs.net> 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: 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).
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: wisernet100_at_yahoo.com
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:41:16 CDT