Home | Oracle DBA
  • #


    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


    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


    • 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