• Database Support

• Install
• Bug Fix Patch, Security patch
• Upgrade/Migrate
• Day to day data base Administration Activity - Monitor Killer queries ( temp usage), New accounts, space usage monitor, extend the space and extents, monitor daily reports for backup, monitor alters etc.

• System Support

• Install
• Bug Fix Patch, Security patch
• Upgrade/Migrate
• Day to day System Administration Activity -> new accounts, monitor space threshold alerts, tape backups.

• Levels of Support

• Level 0 -> This is the support group where host for the database is housed. This group will also part of Level1 Support
• Level 1 -> This is the support group which will be responsible for day to day support of db activities ( as a operating DBA, Operating System Administrator

• Shifts  

        There can be three shifts. Each will be 8 hours shift to cover the system in 24*7 mode.

DATABASE SUPPORT
 

Db can be categorised in as following depending upon the usage :

PRODUCTION – A production database will be used for fully working database applications and will house only "real" data.

INTEGRATION – An integration database will be used for testing pre-production database applications. Occasionally, the integration instance may be refreshed with production data.

DEVELOPMENT – A development database will be used for database and application development, testing of database features.
 

LEVELS OF SUPPORT

LEVEL0  DB Support

• Server Installation/Patch/Upgrade/Migrate  Database is either being installed, scheduled to be installed,to be patched for bug fix, or upgraded to next release.This will be supported by the Database support group where db server is hosted. Also patches will be applied by the same group.
• DB/System Down Time Schedules

          Patches/Upgrade will be scheduled with user community. Production Server at a two weeks notice. Developement and integration servers at a week notice.

• Backup/Recovery Support

        Dbs will be backed up on disk  Support group. Since host support group is involved in restore and recovery will be performed by same group.

LEVEL1  DB Support

This will be limited support i.e. effort will be made to keep the instance running and support will be provided  by database administrators responsible for the shift e.g.

• db accounts, privileges
• Storage support ( adding more space, increasing the number of extents) .
• Monitoring for alerts/cron jobs output etc.
• performance problems.
• Query tuning. Or monitoring killer queries and forward the query tuning recommendations to user

LEVEL0  System Support

• Installation  of OS/ Patches/Upgrade

        This support will be provided by host system admin group.

LEVEL1 System  Support

This will be limited support by the shift support group.

•  Monitoring system load
• Security monitor
• Space threshold alerts
• Creation of account

Other Miscellaneous Stuff

Log Book

An electronics log book can be mainted to log the activities or action taken on system and databases.

MAILING LISTS

Mailing lists for db group and system group can be maintained.

css-dsg@fnal.gov   03/04/2004   6:00PM