Skip to content

Roles in database

August 3, 2009

Roles in database:

We have lot of roles and responsibilities in database. like
1. db owner
2. Audit Admin
3. Database system security officer
4. Database analysis offices
5. db access admin
6. db backup operator
7. db ddl admin
8. db security admin
9. process admin
10. db creator
11. disk admin

The DBA:
The job of the [[DBA]] seems to be everything that everyone else either doesn’t want to do, or doesn’t have the ability to do. DBAs get the enviable task of figuring out all of the things no one else can figure out. More seriously though, here is a list of typical DBA responsibilities:
1. Installation, configuration and upgrading of Oracle server software and related products
2. Evaluate Oracle features and Oracle related products
3. Establish and maintain sound backup and recovery policies and procedures
4. Take care of the Database design and implementation
5. Implement and maintain database security (create and maintain users and roles, assign privileges)
6. Perform database tuning and performance monitoring
7. Perform application tuning and performance monitoring
8. Setup and maintain documentation and standards
9. Plan growth and changes (capacity planning)
10. Work as part of a team and provide 7×24 support when required
11. Perform general technical trouble shooting and give consultation to development teams
12. Patch Management and Version Control
13. Installing and upgrading the Oracle Server and application tools.
14. Allocating system storage and planning future storage requirements for the database system.
15. Managing primary database structures (tablespaces)
16. Managing primary objects (table,views,indexes)
17. Enrolling users and maintaining system security.
18. Controlling and monitoring user access to the database.
19. Monitoring and optimizing the performance of the database.
20. Planning for backup and recovery of database information.
21. Maintain archived data on tape
22. Backing up and restoring the database.

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: