APPS DBA SCOPE OF WORK

S/No Management Service for Oracle Database – Scope of Work  
   
1 Database Installation and upgradation of Oracle Server Software and related products  
2 Database configuration including configuration of background processes  
3 Database performance optimization & fine tuning  
4 Configuring the Database in Archive log mode  
5 Configuring RMAN Backup  
6 Configuring Hot Backup  
7 Maintaining Database in archive log mode  
8 Devising Database backup strategy  
9 Monitoring & checking the Database backup & recovery process  
10 Database troubleshooting  
11 Database recovery incase of crash  
12 Setting up standby and test Database if required  
13 Database security  
14 Enabling auditing features wherever required  
15 Table space management  
16 Database Analysis report  
17 Configuring & usage of front end tool & connectivity to oracle  
18 Troubleshooting of front end tool if required  
19 Database health monitoring  
20 Log monitoring in scheduled manner  
21 Quarterly backup & recovery test  
22 Setting up Oracle Enterprise Manager for automated monitoring  
23 Installing OEM agents  
   
S/N Daily Activity  
   
1 Verify all instances are up & working using Oracle Enterprise Manager  
2 Look into new alert log entries and checking for any errors in case of issues or any alerts reported  
3 Verify the success of the Database backup  
4 Verify the success of the Database archiving to tape  
5 Check table space usage  
6 Checking if there is enough disk space for the data files to grow  
7 Monitoring temporary segments usage  
8 Checking for DB links that are inaccessible  
9 Finding invalid objects and fixing them  
10 Checking session locks  
11 Monitoring overall Database health & performance  
12 Identifying tables with chained rows & rectifying them  
13 Monitoring users and transactions  
14 Escalating issues and providing feedback and suggestions  
   
S/N Weekly Activities  
   
1 Check users with objects in system table space  
2 Check users except Sys & System as a default table space  
3 Check disabled constraints, procedures, functions, packages & triggers  
4 Check foreign keys with non matching column definitions  
5 Identify de-fragmentation in table space  
6 Look for security policy violations  
7 Archive all alert logs, Trace files to history  
   
S/N Monthly Activities  
   
1 Checking redo log optimal size based on transactional activities  
2 Analyze tables and indexes for better performance  
3 Identifying non-system tables with no primary key  
4 Identifying non-system tables with excessive indexes causing performance issue  
5 Listing unusable indexes and index usage  
6 Review tuning opportunities based on stats pack report  
   
S/N Quarterly Activities  
   
1 Measuring Database growth summary  
2 Backup verification on test database  
   
S/N Adhoc Activities  
   
1 User creation  
2 Granting and Revoking access  
3 Allocating and deallocating space  
4 Creating project specific (objects, tables, indexes etc) in test and production schema  
5 Applying user-creation and any other security policies as defined  
6 Identifying and optimizing the queries causing bottlenecks  
7 Scheduling jobs  
8 Participation in any database design discussion and providing recommendations  
9 Feedback and reviews  
10 Aligning the backup and recovery process according to the client reuirements  
11 Providing reports for compliance (GSD, TEM etc)  
12 Taking export / rman backups  
13 Stopping and Starting databases for changes