Oracle-L: RE: Re[2]: So, What is a 'Production DBA'?

From: Karniotis, Stephen <Stephen_Karniotis_at_compuware.com>
Date: Thu, 30 May 2002 05:54:04 -0800
Message-ID: <F001.0046F664.20020530055404@fatcity.com>

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:	Stephen.Karniotis_at_Compuware.com
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 <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).



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: Stephen_Karniotis_at_compuware.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 Thu May 30 2002 - 08:54:04 CDT