What is a Database Administrator? It is a person who is responsible for a database. Where the DBA has a duty to manage, provide access to anyone who will access the database, etc.. In other words, the Database Administrator (DBA) is a database admin.

The obligation of a database administrator is quite heavy, but it is in accordance with the rights which he acquired. A DBA must know everything about the database, SQL commands and understand about the blocks of PL / SQL. However, if there is a problem on the database system, the DBA is what will solve the problem.

Here are some tasks of a Database Administrator jobs (DBA):
  • Installing and Upgrading Oracle software system.
  • Installation and maintenance of applications running on the Oracle system.
  • Creating a database, tablespace, table, view, index and other database objects.
  • Create and monitor user and system usage, including the security system (security).
  • Monitoring the use of space (disk) and planning the future development of hardware and software.
  • Monitoring the performance of the system (performance tuning) and change the system parameters and optimize the extent required
  • Creating a strategy and implement backup and recovery.

In essence, to become a database administrator must master about the database itself, about the relationship, optimization, manage constraints, functions & stored procedures.

That was a brief description of the What is a Database Administrator (DBA). If there are errors or omissions please justified or added. May be useful

0 komentar

Related Posts Plugin for WordPress, Blogger...