Database operations

Onboarding

Included in fixed price:

Part of initial onboarding:

Establishing maintenance routines

Oracle

Rebuilding indexes
Analyze tables
SQL Server
Rebuild indexes
Reorganize indexes
Update index statistics
Cycle error log
Adjust autogrowth settings
DBCC Checkdb
Cleanup MSDB history tables

Establishing monitoring routines

Backup
Data export
Error logs
Database file status
Up time
Archive or transaction log status
Space capacity
Data growth
CPU load
Blocking sessions
Data or buffer cache
Waits monitoring
File I/O
Session load
Memory usage

Establishing alarm thresholds

Initial resource tuning (CPU, memory, disk and setup)
Analyzing database instance health and adjusting resources

Part of daily routines

Checking database instance health
Analyzing warnings and alarms

Part of weekly routines

Check of maintenance routines
Adjusting thresholds in monitoring and maintenance

Part of monthly routines

Check of license usage
Check of patch status
Reporting on uptime of database environment
Reporting on growth rate and capacity

Incident based

Correcting database issues that causes downtime and loss of service

Additonal cost:

Upgrading and patching of database systems
Creating, removing and moving databases
Establishing and running restore tests
Export and import of data
Creating and configuring integrations
Development and maintenance of custom code
Application or SQL tuning and analysis
Requested changes in the databases, included but not limited to adding or removing users, creating or removing databases or contents of databases
Attending meetings
Consulting and advising