DBA Tasks

Here is the list of DBA’s tasks

• Take database backup
• performance tuning via OEM or SQL tuning adviser
• create logical objects like table, procedure, package etc
• create database
• delete database
• schedule jobs and check for error
• refresh test database from production backup
• create report database from production backup
• check standby database for error
• automate task via scripts or job like backup and refresh of database
• upgrade database
• grant privilege to user
• create schema and objects
• deploy script for application release that is developed by vendor or developer