Hi,
I don't know where the following came from, but I think it does a good job
of describing what a DBA does.
WHAT EXACTLY IS A DBA?
The position of Database Administrator -- DBA for short -- means many things
to many people. In a small development shop the duties are much broader
than in a highly stratified major corporation. Whether a company is doing
development or adopting a third part package will also determine the needs
of the DBA position. Knowing what is expected of the position and knowing
how the position envisioned fits within the company hierarchy is critical.
In "ORACLE 8.0 Administration and Management" I list the following as a list
of DBA job functions:
- Installing and upgrading the ORACLE Server and application tools.
- Allocating system storage and planning future storage requirements for
the database.
- Creating primary database storage structures (tablespaces) once
developers have
designed an application.
- Creating primary database objects (tables, views, indexes) once
application
developers have designed an application.
- Modifying the database structure, as necessary, from information given by
application developers.
- Enrolling users and maintaining system security.
- Ensuring compliance with Oracle License agreements.
- Controlling and monitoring user access to the database.
- Monitoring and optimizing the performance of the database.
- Planning for backup and recovery of database information.
- Maintaining archived data on appropriate storage devices.
- Backing and restoring the database.
- Contacting Oracle Corporation for technical support.
regards
Jerry Gitomer
WCK wrote in message <37339F48.6AB1_at_pacific.net.sg>...
>Hi,
>
>I would really like to know what are the job responsibility of a DBA?
>beside monitoring, backup, tuning, user/group creation.
>
>I am currently taking care of a oracle 7.3 rdbms loaded in with vendor's
>products, and because of the size of my company, I don't to know many
>folks from my area about DBA. Thanks for the advice in advance.
>
>WCK
Received on Fri May 07 1999 - 11:43:26 CDT