What are the responsibilities of a Database Administrator ?

Installing and upgrading the Oracle Server and application tools.Allocating system storage and planning future storage requirements for the database system.Managing primary database structures (tablespaces)Managing primary objects (table,views,indexes)Enrolling users and maintaining system security.Ensuring compliance with Oralce license agreementControlling and monitoring user access to the database.Monitoring and optimizing the performance of the database.Planning for backup and recovery of database information.Maintain archived data on tapeBacking up and restoring the database.Contacting Oracle Corporation for technical support.

Interview Candidate
Sep 6th, 2004
2
3574

Database security

Answer

Showing Answers 1 - 2 of 2 Answers

Prabha Sharma

Apr 13th, 2006

Defining physical and logical schema of database.
Take periodically backup of the database.
Assign authorization to the database users.
Define various method for storing and retrieving of data.

skumarpenugonda
Profile Answers by skumarpenugonda

Jul 7th, 2006

adding to the list
* involved in database design
* applying patch sets
* writing scripts to automate the routine DBA tasks
* configuring oracle net such as listeners and tnsnames
* data loading and unloading using exp/imp and sqlloader
* providing help to the application people or the end users in designing objects and writing queries and ORA- error debugging
* changing the configuration settings of the database according to the needs
* scheduling and running the jobs