DBA role varies extensively between companies.
However a DBA should be able to do all (*most) of the tasks and admin
listed in Oracles "Administrators Guide" which is downloadable from
oracle free.
Its really environment specific beyond that - as well as experience.
Can a programmer/analyst do
Backup and recover databases
Administer general OS and write scripts (housekeeping,
monitoring)
Evaluate performance problems
Tune the SGA and evaluate each component of the SGA
Install and patch
Help developers with PL/SQL
Configure appropriate technology stacks including TNSNAMES/LDAP
Administer objects within the database - tables,indexes
(various), packages, other objects - based on space management,
chaining/migration, spaced use, validity, security, impact.
Define and implement use of new feature based on a problem ??
i.e how to decide whether to implement partitioning.
And this is really just the basic level of DBA. Don't forget that you
have advanced feature such as streams, RAC, replication, dataguard.
This is more aimed at 24x7 and High Availablity/Replication - and can
take years of specific DBA experience.
Regards
John Fak
Oracle DBA
_____________________
Accenture Workforce Solutions
mobile: +44 (0)778 655 1214
landline: +44 (0)207 844 6981
mailto:john.[Email address protected]
-----Original Message-----
From: bralston
[mailto:oracledba-ezmlmshield-x50329637.[Email address protected]
Sent: 31 August 2004 14:00
To: LazyDBA Discussion
Subject: Dba's Role in a company
All, I am working for a smaller startup company that needs a dba.
However,
the executive tier can't seem to understand what differentiates a DBA
from
an oracle programmer/analyst. Does anyone have any documentation or
input
into this discussion that might be helpful????
Thanks,
Brad
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.
Oracle LazyDBA home page