SNO
|
ACTIVITY
|
1
|
Monitoring Connectivity
Failures/Availability
|
2
|
Monitoring of alert logs, trace
files and user dump files
|
3
|
Responding to database error
alerts
|
4
|
Responding to alerts for disk
space/table space
|
5
|
Adding removing servers to/from
monitoring
|
6
|
Responding to alerts for failed
jobs/failed backups
|
7
|
Enabling/Disabling database
monitoring
|
8
|
monitored threshold breaches, long
running queries, long connect times
|
9
|
Provisioning/De-provisioning
|
10
|
User account lock/unlock
|
11
|
Reset Password
|
12
|
Database Backup
|
13
|
Database Refresh
|
14
|
Providing adhoc export
dump/database backups
|
15
|
Executing adhoc Import/database
Load
|
16
|
Schema level refresh
|
17
|
Install/Upgrade/Remove RDBMS
Database Software
|
18
|
Create/Upgrade/Remove Database
|
19
|
Change Database Level Parameters
|
20
|
Updating/refreshing statistics
|
21
|
Extend/Shrink Databases
|
22
|
Database Migration
|
23
|
Create//Remove Schema
|
24
|
Schema changes via dba requests
|
25
|
Detection of dead lock and
resolution
|
26
|
Initial Troubleshooting and
re-starting broken database jobs
|
27
|
Starting and Shutting down
databases and/or database services
|
28
|
Creating and Managing Stand-by
databases
|
29
|
Initial Investigation of Database
Internal Errors/SQL Server errors
|
30
|
Killing user sessions
|
31
|
Any other incident that causes
break of database service to the client
|
Thursday, 26 September 2013
SQL DBA ACTIVITIES
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment