Management Service for Oracle Database – 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