Hello
I'm an IT Manager/Tech Author when I'm not on Google, and I've had the
pleasure(?) of hiring several DBAs/ Senior DBAs in my time, and I've
also acted as line manager to several, and have had to deal with the
promotion issues involved.
Below I've appended the job descriptions I used for them. Note that
these will vary depending on factors like the size of the systems
being supported, whether shift work is needed, whether on-call support
is required etc, but these are a good starting point.
Also note the differences - the SDBA has more management
responsibilities, on a wider range of systems, and is also likely to
manage, or at least supervise, other DBA's
For promotion up the scale, a DBA will generally need a couple of
years experience, a history of efficient control of their systems, an
aptitude for taking on responsibility, and a good technical knowledge,
showing a willingness to keep abreast of changes in technology.
They'll also be expected to show a willingness to lead, possibly
through having to mentor a more junior member of staff than
themselves.
All of this comes from my own personal experience (20 years in IT, 10
on ORACLE systems) but you'll find an ORACLE link at the bottom that
will help you further - its got all you'd ever want to know (and
probably some you don't) about ORACLE DBAs
Willie
____________________________________________________________________
ORACLE DATABASE ADMINISTRATOR
Primary responsibilities:
The DBA is responsible for installing and upgrading the Oracle server
and related Oracle tools on the servers for which he is liable. (NOTE
The servers for which the DBA is responsible are usually defined in
the employment contract)
The DBA is responsible for insuring <THE COMPANY> is in compliance
with the Oracle license agreement.
The DBA is responsible for creating primary database storage
structures (tablespaces), once application developers have
designed/purchased an approved application.
The DBA is responsible for allocating system storage and planning for
future storage requirements for the database systems on the servers
for which he is liable
The DBA is responsible for monitoring and optimizing the performance
of the database and offering assistance to developers in optimizing
their applications, queries, etc.
The DBA is responsible for planning for backup and recovery of the
databases. NOTE ( The DBA may or may not have responsibility for the
actual physical backup or physical retention of that information)
The DBA is responsible for the design, creation, and structural
integrity of all ORACLE databases on the servers for which he is
responsible and all objects in the production environment that are
used for official business purposes. This includes tables, views,
indexes, sequences, etc. from approved information given by
application developers or vendors of purchased systems.
The DBA is responsible for ensuring that all software components are
at approved release levels.
The DBA may provide assistance, but is not responsible for the design
and creation of ORACLE database objects created by other ORACLE users.
Any ORACLE database object created in production by an ORACLE user
[other than the DBA], is considered non-official and will not be
supported by the DBA.
The DBA is responsible for the batch loading of data into official
production ORACLE tables from approved data files, etc. given by
development staff of vendors of applications. The DBA will ensure that
the data loaded into ORACLE tables is as accurate as the data source.
The DBA is not responsible for the validity of data loaded into ORACLE
tables by any manual data entry process.
The DBA may provide information and assistance in accessing ORACLE
database objects by other applications and tools such as Microsoft
Excel, Microsoft Access, etc. The DBA will not be responsible for the
validity of the results from these applications.
_______________________________________________________________
SENIOR ORACLE DATABASE ADMINISTRATOR (SDBA) JOB DESCRIPTION
Primary responsibilities:
The SDBA is responsible for managing the installing and upgrading of
all the Oracle servers and related Oracle tools of <THE COMPANY>
The SDBA is responsible for insuring <THE COMPANY> is in compliance
with the Oracle license agreement.
The SDBA is responsible for managing the creation of primary database
storage structures (tablespaces), once application developers have
designed/purchased an approved application.
The SDBA is responsible for allocating system storage and planning for
future storage requirements for all of the database systems of <THE
COMPANY>
The SDBA is responsible for ensuring the backup and recovery of the
databases.
The SDBA is responsible for the design, creation, and structural
integrity of all ORACLE databases of <THE COMPANY> and all objects in
the production environment that are used for official business
purposes. This includes tables, views, indexes, sequences, etc. from
approved information given by application developers or vendors of
purchased systems.
The SDBA is responsible for ensuring that all versions of and
components of ORACLE software are at release levels recommended by
ORACLE
The SDBA is responsible for the day to day management of DBA staff
__________________________________________________________________________
The place to go for ORACLE DBA info/articles/jobs etc
IT Toolbox ORACLE Knowledge Base
http://oracle.ittoolbox.com/default2.asp
Google Search Strategy
://www.google.com/search?hl=en&lr=&ie=ISO-8859-1&q=%22ORACLE+DBA%22+%22roles+and+responsibilities%22
://www.google.com/search?hl=en&lr=&ie=ISO-8859-1&q=%22ORACLE+DBA%22+%22roles+and+responsibilities%22 |
