Oracle DBA – Responsibilities

The below are the Oracle dba responsibilities:

  1. Evaluate the Database Server Hardware: Evaluate how Oracle and its applications can best use the available computer resources. This evaluation should reveal the following information:
    • How many disk drives are available to Oracle and its databases
    • How many, if any, dedicated tape drives are available to Oracle and its databases
    • How much memory is available to the instances of Oracle you will run (see your system’s configuration documentation)
  2. Install the Oracle Software: As the database administrator, you install the Oracle database server software and any front-end tools and database applications that access the database. In some distributed processing installations, the database is controlled by a central computer (database server) and the database tools and applications are executed on remote computers (clients). In this case, you must also install the Oracle Net components necessary to connect the remote machines to the computer that executes Oracle.
  3.  Plan the Database: As the database administrator, you must plan:
    • The logical storage structure of the database
    • The overall database design
    • A backup strategy for the database
  4. Create and Open the Database: When you complete the database design, you can create the database and open it for normal use. You can create a database at installation time, using the Database Configuration Assistant, or you can supply your own scripts for creating a database.
  5.  Back Up the Database: After you create the database structure, carry out the backup strategy you planned for the database. Create any additional redo log files, take the first full database backup (online or offline), and schedule future database backups at regular intervals.
  6.  Enroll System Users:After you back up the database structure, you can enroll the users of the database in accordance with your Oracle license agreement, create appropriate roles for these users, and grant these roles.
  7.  Implement the Database Design:After you create and start the database, and enroll the system users, you can implement the planned logical structure database by creating all necessary tablespaces. When you complete this, you can create the objects for the database.
  8. Back Up the Fully Functional Database:Now that the database is fully implemented, again back up the database. In addition to regularly scheduled backups, you should always back up your database immediately after implementing changes to the database structure.
  9. Tune Database Performance:Optimizing the performance of the database is one of your ongoing responsibilities as a DBA. Additionally, Oracle provides a database resource management feature that enables you to control the allocation of resources to various user groups.

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.