ORACLE DATABASE ADMINISTRATOR (DBA
Oracle Database Administrator (DBA) is a multi-model Relational Database management system Developed by Oracle Corporation. Orade DBA is responsible for the organisation, integrity, management of a company's data with great knowledge of Database Management Systems (DBMS) to define, create, maintain, backup, and secure an organisation databases.
Trade database administrator has to perform Responsibilities in dudes
Installing new versions of the Oracle database and its tools, Installing tools required to access the Oracle database, Create new database users as required, Upgrading the database, Shutting down and Starting the database, Backing up and Recovering Data, Exporting and Importing Data, Managing Users, Managing security of the database, Monitoring the database, Creating database objects like databases, tables and views,, Plans and implements backup and recovery of the Oracle database, Provides technical support to application development teams, Enforces and maintains database constraints to ensure integrity of the database, Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures, Troubleshooting problems regarding the databases-applications and development tools.
ORACLE Database Administrator (DBA) 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 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.
- 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.
- Provide Technical support for Other Application Development Platforms