Oracle Database Administrator

Administering an Oracle Database:-

Here we will discussed environment and tasks of an Oracle Database administrator (DBA). It also discusses DBA security and how you obtain the necessary administrative privileges.
A small site can have one database administrator who administers the database for application developers and users related issues. 

Database Administrator:-
Database requires at least one database administrator (DBA). An Oracle Database system can be large and can have many users. The DBA responsibilities is very important .
A database administrator’s responsibilities can include the following tasks:

–>Creates and maintains all database required for development, testing, education and production usage.

Performs the capacity planning required to create and maintain the database.
–>Plans and impalements the backup and recovery of the database.
–>Performs database re-organizations as required to assist performance and ensure   maximum uptime of database.
–>Administers all database objects, including tables, indexes, view, package, procedure and sequence.
· –> Installing new versions of the oracle RDBMS and upgrading/migrating the Oracle Database server and application tools  to access the oracle database.
·  –> 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.

The DBA should posses the following skills.

1>A good knowledge of the database structures and physical database design.
2> A good knowledge of the operating systems.
3> Ability to do the performance tuning operating system as well as database.
4> Good exposer on Database backup and recovery.
5>sound knowledge of application at your sites.
6>Good knowledge of all oracle tools.

Security Officers.
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.  
 Network Administrators:-
A network administrator, for example, administers Oracle networking products, such as Oracle Net Services.
Application Developers:-
 Application developers design and implement database applications. Their responsibilities    include the following tasks:
·         –>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 this information to a database administrator
·         –>Tuning the application during development
·         –>Establishing security measures for an application during development
Application Administrators:-

Application administrators to administer a particular application. Each application can have its own administrator.

Database Users:- 

Database users interact with the database through applications or utilities. A typical user’s responsibilities include the following tasks:
           –>Entering, modifying, and deleting data, where permitted.
·         –>Generating reports from the data.

Leave a Comment