Thursday 26 September 2013

SQL DBA ACTIVITIES

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

No comments: