Database Administrators

10G

A database administrator's responsibilities can include the following tasks:

·         Installing and upgrading the Oracle Database 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 Oracle license agreements

·         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 for technical support

dba主要责任：

1、 安装和升级数据库及应用软件。

2、 计划并分配给数据库所需系统储存。

3、 为应用程序设计并创建数据库主要储存结构。（tablespaces）

4、 为应用程序设计并创建数据库主要对象。（tables,views,indexes）

5、 根据应用程序的要求修改数据库的主要配置。

6、 管理用户和维护系统安全。

7、 确保与ORACLE许可协议。

8、 控制和监测用户访问数据库。

9、 监控并优化数据库的性能。

10、规划数据库的备份与恢复策略。

11、维护归档日志在磁带上。

12、备份与恢复数据库。

13、与ORACLE技术支持接触为数据库服务。