RE: Development vs. Production DBA

LOL -- developers deciding architecture design. Never really involved in implementing anything, all conceptual.

I am what you call a "production DBA", my personal bias on this is that leaving architecture decisions to developers could be a mistake, if you think long term. The Production DBA should be involved, and should have the ability to veto any hair-brained scheme that is proposed.

Patrice.

-----Original Message-----
Sent: Wednesday, November 19, 2003 12:20 PM To: Multiple recipients of list ORACLE-L

I don't know about a paper, but I've always made a distinction between these types of DBAs as well.

Development DBA responsibilities:

- initial DB design
- data modelling, data dictionary creation
- naming standards, datatype standards
- sql development
- working w/ front end developers, tuning queries 
- data load, legacy to current

Production DBA responsibilties:
- day to day administrative support: adding users, creating schemas, moving objects around

- backup/recovery
- disaster recovery
- monitoring
- Troubleshooting, working with Oracle Tech Support
- Database P&T concerns: buffer pools, tablespace objects, etc.

I would NOT force developers to funnel through the DBA to create objects in development. What a roadblock that could be. Instead, have the dba be available as a resource to the developers to handle query tuning concerns, answer SQL questions and the like.

my 2 cents.

Boss

>
> Group,
> If this was discussed before, I missed it.
> There is a discussion going on trying to define the duties of a
development
> vs. production DBA and where in-depth DBA involvement should occur. Is
there
> any papers that anyone can share w/me on this subject. IMHO a DBA should
be
> involved early on in the project to translate the functional requirements
> into a physical model using the features of the target version. I also
think
> that it should be the DBA's job to create the packages, procedures and
> triggers in the development and testing phases. To me,this would
facilitate
> the transition from testing to production. Our development DBA's are
> involved in the production side so are aware of our standards.
> Comments, opinions please.
>
> TIA
>
> Al Rusnak
> DBA - WEB Team/CISIS, Computer Operations
>
> * 804-734-8371
> * george.rusnak_at_deca.mil
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rusnak, George A. (SEC-Lee) CTR
> INET: george.rusnak_at_deca.mil
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Todd Boss
  INET: boss_at_i-sphere.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).