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