For each and every database, there must be at least one database administrator abbreviated as DBA to perform administration duties on it. Since an Oracle dynamic data system may be large and can have multiple users, often this is not a single person’s job. In similar cases, there is a group of Dynamic Data Administrators who share this responsibility.

Dynamic Data Masking

A database administrator’s duties 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 (table spaces) after application developers have designed a certain 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

A Dynamic Database Administrator can assume any of the following positions;

  1. Security Officers

In some cases, a site assigns one or more security officers to a database. A security officer enrols users, controls and monitors user access to the database, and maintains system security. As a Database Administrator, you might not be responsible for these duties if your site has a separate security officer.

  1. Network Administrators

Some sites have one or more network administrators. A network administrator can administer Oracle networking products, such as Oracle Net Services.

  1. General Database Users

Database users interact with the database through applications or utilities. A typical user’s responsibilities may include the following roles:

  • Entering, modifying, and deleting data, where permitted
  • Generating reports from the dynamic data

Tasks of a Database Administrator

The following tasks present a prioritized approach for designing, implementing, and maintaining an Oracle Dynamic data:

  • Evaluate the Database Server Hardware
  • Install the Oracle Software
  • Plan the Database
  • Create and Open the Database
  • Back Up the Database
  • Enrol System Users
  • Implement the Database Design
  • Back Up the Fully Functional Database
  • Tune Database Performance




Similar Posts:

Facebook Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>