educationalera

  • Increase font size
  • Default font size
  • Decrease font size
AddThis Social Bookmark Button

The database has logical structures and physical structures. Because the physical and logical structures are separate, the physical storage of data can be managed without affecting the access to logical storage structures.

Database Administrators

Each database requires at least one database administrator (DBA) to administer it. Because an Oracle database system can be large and can have many users, often this is not a one person job. In such cases, there is a group of DBAs who share responsibility.
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

Responsibilities of a Database Administrator

Fundamentally, the primary responsibility of a database administrator is superintending the installation and efficient operation of software and databases that are intended for use by many PC users. There are various particular obligations that a typical database administrator will carry out in just about in any business environment. Data storage, data security, data management, and backup are some of the main database administrator responsibilities that are needed to be performed.

General obligations of a database professional include participating in the installation of new databases. As a part of the database installation procedure, he sets up login credentials to authorized personnel, defines the privileges related with every authorized user, and makes sure that each workstation connected to the network is set up to gain access to the new database. This procedure normally comprises of a troubleshooting period wherein the database administrator diagnoses and resolves any issues that users come across with the new database.

Database administrators are also responsible for carrying out the management of the procedure which relates to creating backup records of data which is present in the databases of the system. This process comprises of more than just making provisions for an automatic backup and assuming that the backup is being executed according to the plan. A database administrator examines the backup files to ensure that the data is complete, the integrity of the data is secure, and the saved files can effortlessly be accessed and loaded in a situation where something goes wrong with the main database.

While dealing with databases and software, database administrators also ensure that provisions are made for new releases and upgrades periodically. They make sure that new versions or upgrades are made available, which would meliorate the efficiency of the present editions of databases. Usually, they are authorized to upload advanced versions and install them at a required time period. When an upgrade is available, they coordinate work with other IT professionals in the company to decide if the expense of replacing the present database software is worth the investment.

Recently, the obligations of database administrators have been elaborated in some software development companies. These database experts may be required to take a rough design and customize features and functionalities to more efficaciously serve the anticipations of the company. Since these kinds of assignments are more ordinarily concerned with a database analyst or designer, it is not uncommon for a database administrator in a small firm to take on these obligations.

Oracle DBA Tutorial

  • Overview of Administrator  an ORACLE DATABASE
  • Creating an Oracle Database
  • Starting UP and  Shutting Down
  • Managing  Oracle Process
  • Managing Control Files
  • Managing the Online Redo Log files
  • Managing Archived Redo Logs
  • Managing Tablespaces
  • Managing Datafiles and Tempfiles
  • Managing Tables
  • Managing Indexes
  • Managing Clusters
  • Managing View, Sequence and Synonyms
  • Managing User Privileges and Roles
  • Distributed Database Management

 


Oracle Certification

oracle_logo

The Oracle Certification Program is a professional certification program offered by the Oracle Corporation. There are three levels of Oracle Certification in several disciplines: Oracle Certified Associate (OCA), Oracle Certified Professional (OCP), and Oracle Certified Master (OCM).

Java Certification

java_logo

Sun Certified Professional (SCP) is a professional certification program by Sun Microsystems, a subsidiary of Oracle Corporation. There are two levels of java Certification in several disciplines: Sun Certified Java Associate (SCJA), Sun Certified Java Programmer (SCJP), and Sun Certified Java Developer (SCJD)

Red Hat Certification

red_hat_logo

The Red Hat Certification Program is Red Hat's professional certification program for Red Hat and general Linux related skills such as system administration on Red Hat Enterprise Linux Red Hat Certified Technician (RHCT)  and Red Hat Certified Engineer (RHCE)