Typical DBA's Day to Day Activities

Typically Oracle DBA performs below activities. List can more lengthy, just wanted to give overview to understand.

• Data guard, ASM, RAC configuration, troubleshoot and support.
• Golden gate setup in bidirectional and unidirectional replication.
• Database cloning, DG setup, PIT recovery using RMAN.
• Fine Tuning of Production Queries to boost data retrieval.
• Creating databases (including setting parameters, distribution of datafiles etc.)
• Managing all Daily database maintenance issues.
• Devised backup and recovery strategy for this 24 x 7 availability.
• Oracle 9i, 10g, 11g, 12c installation on Linux, Aix, Window, Cloud (aws.amazon.com) Environment.
• Deploying backup (hot and cold) mechanisms and recovery procedures.
• Loading data between databases (Export and Import, SQL Loader).
• Tuning Oracle Instance using STATSPACK (before 10g), OEM, ADDM, ASH and AWR Utility.
• Improving performance by creating appropriate indexes - This is App DBA specific
• Oracle database replication using stream - Old way for replication.
• Managing growth of the database tables, compacting and free space reclamation.
• Scheduling jobs queues - This is App DBA specific
• Developing various Database Monitoring Scripts.
• Creating materialized views for reporting applications - This is App DBA specific
• Creating Partition table, external organized table for report - This is App DBA specific
• Creating system and schema triggers for monitoring data objects handling and security and DML triggers for implementing complex business requirements.
• Implementing security policy and profile.
• Solving connectivity issues and networking problems.
• Writing shell scripts for OS level maintenance of Oracle database.
• Periodic Maintenance and up gradation of Applications as per the requirements.
• Developing functions/procedures, Triggers and packages (PL/SQL).

   And Many more its upto individual how much interest he shows accepting challenges. In Oracle each tools can go foremost deep level. Its contnuous learning and exploring............