RE: Roles and Responsibilities

From: Loughmiller, Greg <GLoughmiller_at_presolutions.com>
Date: Wed, 05 Sep 2001 05:29:20 -0700
Message-ID: <F001.0038310E.20010905050605@fatcity.com>

How about some of these...

Administer data...
plans for database-related implementation and upgrades ensure the database integrity, security and availability (backups!! standby databases, OPS)
Use data dictionary to ensure data integrity and security Recover corrupted data (use the backups now) Use tuning tools to improve database performance (understand the information Oracle provides)
Maintain physical data models from logical data models Implement and maintain physical database systems (build new systems, new databases)
Perform application RDBMS tuning. (tune the SQL...) Assist development staff
Evaluate database management systems and versions (go to 9i?) Monitor assigned development projects to ensure compliance with standards. Work with Sys Admins to configure and balance the environment. Secure the operational databases and monitor Develop and implement data and database related standards, procedures and guidelines
Perform logical and physical data modeling Manage database objects
Design relational database models
Coordinate testing activities.
Maintain development, test and production environments Ensure that test data is current and functioning Monitor database efficiency and ensure optimal performance (monitor, report, revise, and refine)
Capacity Planning. (need more memory, disks, CPU) Manage the process of configuration Management for the databases(physical and logical)

Plan/schedule for DBMS installation
Install/upgrade DBMS

Plan/implement the production database operating environment(s) Establish database support procedures
Provide day-to-day database support for production systems

Provide information on new database technology to management Evaluate new database technology
Support production databases using tools/utilities to tune, optimize performance and resolve technical database issues Develop and implement database standards and guidelines. Provide technical expertise and direction Provide technical direction for customer support purposes

Kind of long, kind of wordy... But I used these at a previous job for Job descriptions/functions in building a career path for DBA's (entry, Jr, Sr,etc).. Not sure if this is what you are looking for..

This data came from several different sources. We just "pulled it together" and added a few items related to our environment... But it was used in building the job descriptions/career path(the HR stuff) for a centralized Oracle DBA team...

HTH Greg

-----Original Message-----
Sent: Tuesday, September 04, 2001 6:36 PM To: Multiple recipients of list ORACLE-L

Hi.....
My boss asked me to supply him with a detail paper on what DBA functions, roles and responsibilities.
Could you please tell me any information or the websites for that kind of information ?
Tia.

Aldi

Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Aldi Barco
INET: ipal_at_hotmail.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Loughmiller, Greg
INET: GLoughmiller_at_presolutions.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------