• Pre-installation Tasks

• Installing Oracle Server and Patch Mgmt

• Installing & Maintaining DB Tools

• Uninstallation

• Database Patch / Patchset Installation

• Database Setup

• Database Clean up / Removal

• DB Cloning

• Start up and shutdown of Database instances

• Maintaining Database replication / standby / clusters

• Job scheduling

• Verify all Instances are running

• Look for any new alert log entries

• Verify that SNMP is running

• Look for Trace files

• Session Monitoring

• Query or Transaction monitoring

• Lock and Latch monitoring

• Activity / Redo Log monitoring

• Job monitoring and Purging Job history

• Replication / Stand by monitoring

• Object Monitoring

• Verify free space in table spaces

• Verify rollback segments

• Reorganization of DB to remove fragmentation

• Rebuild of indexes

• Analyze of objects

• Purging of DB logs and trace files

• Verify that Server has enough resources for acceptable performance

• Periodic Report Generation on Database Health

• Identify bad growth projections

• Identify space-bound objects

• Review contention for CPU, memory, network, and disk resources

• Generating statistics

• Look for objects that break rules.

• Ensure that all indexes use an index table space

• Ensure that all tables have unique primary keys.

• Look for harmful growth rates

• Examine tuning opportunities.

• Look for I/O Contention

• Review fragmentation by investigating row chaining and other areas of fragmentation

• Database Objects Creation / Review

• Check for unusable indexes

• User / Schema Creation

• User Management

• Roles and Privileges Management

• Look for security policy violations

• Look in Net8 logs for errors and other issues

• Privileges & Access controls on Database

• Verify that the database archiving to tape was successful.

• Verify that the database backup was successful

• Backup execution and monitoring

• Archive all alert logs to history

• Conduct Backup , restoration drills for backup verification

• Database Connectivity issues

• Slow response

• Operations timed out

• Dead locks

• Database Hangs

• Database incident and error resolution

• Archiver Process Stuck

• Database incident and error resolution

• Vendor Management

• System Performance Monitoring

• Maintaining Environment details

• Shell Scripting for DB related work