Administrators responsibilities - Administering and Managing an Oracle Database

Discussion

• Nirja Shah   -Posted on 27 Aug 15
  - Oracle has various types of users.
  
  - The types of users and their roles and responsibilities at a site can vary.
  
  - Database Administrator - Each database requires at least one database administrator (DBA) to administer it.
  - An Oracle database system can be large and can have many users, often this is not a one person job.
  - In such cases, there is a group of DBAs who share responsibility.
  
  - A database administrator's responsibilities can include the following tasks:
  1. Installing and upgrading the Oracle server and application tools
  2. Allocating system storage and planning future storage requirements for the database system
  3. Creating primary database storage structures (tablespaces) after application developers have designed an application
  4. Creating primary objects (tables, views, indexes) once application developers have designed an application
  5. Modifying the database structure, as necessary, from information given by application developers
  6. Enrolling users and maintaining system security
  7. Ensuring compliance with your Oracle license agreement
  8. Controlling and monitoring user access to the database
  9. Monitoring and optimizing the performance of the database
  10. Planning for backup and recovery of database information
  11. Maintaining archived data on tape
  12. Backing up and restoring the database
  13. Contacting Oracle Corporation for technical support

➨ Post your comment / Share knowledge