SQL DBA Admin

1) Monitor generated log and event files for messages indicating errors that will result in an incident

2) DR Database availability Monitoring

3) DR Database Query Monitor

4) Monitor database log replication

5) Monitor event logs/error details

6) Report Status of Log Replications as per agreed schedules

7) Session/Query/Log/Latch monitoring

8) Monitor the DB for failures and logged system events that indicate an imminent failure

9) Purging database Logs and trace files

10) Periodic config review to maintain consistent configurations

11) Review and recommendation to maintain availability

12) Monthly report on database availability

13) Monitor the DB for failures and logged system events that indicate an imminent failure.

14) Reinstall Database software

15) Reconfigure log Shipping

16) Transaction replication

17) Failover clustering

18) AlwaysON

19) DB encryption

20) Link Server

21) DB migration

Full time