#

ORACLE DBA

Home | Oracle DBA
  • #

    DATABASE ADMINISTRATORS

    A database administrator’s responsibilities can include the following tasks:
    • Installing and upgrading the Oracle server and application tools
    • Allocating system storage and planning future storage requirements for the database system
    • Creating primary database storage structures (tablespaces) after application developers have designed an application
    • Creating primary 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 your Oracle license agreement
    • 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 tape
    • Backing up and restoring the database
    • Contacting Oracle Corporation for technical support

  • SECURITY OFFICERS

    In some cases, a site assigns one or more security officers to a database. A security officer enrolls users, controls and monitors user access to the database, and maintains system security. As a DBA, you might not be responsible for these duties if your site has a separate security officer.
    • Entering, modifying, and deleting data, where permitted
    • Generating reports from the data

    APPLICATION DEVELOPERS

    • Designing and developing the database application
    • Designing the database structure for an application
    • Estimating storage requirements for an application
    • Specifying modifications of the database structure for an application
    • Relaying the above information to a database administrator
    • Tuning the application during development
    • Establishing an application’s security measures during development

#
#
#
#
#
#
#
#
#