1. Take care of failed jobs like backup or weekly maintenance and fix them
2. Monitor disk space issues
3. Shrinking Log files to free the disc space
4. Monitor and fix replication issues/ Log shipping issues
5. Create users and grant access as per approval
6. Monitor SQL severe alerts produced by monitoring tool
7. Deploy the approved change requests tasked
8. Refresh QA or dev servers as per the need basis
9. Create change requests required for DBA team such as to stop server for patching or failover etc
10. Stop-start SQL agent jobs as per the app team need and approval
11. Create DBS and Db objects as per the request
12. Solve day to day production issues like blocking, deadlocking, Server not responding, job failing
13. Take care alerts produced by third party monitoring tools
14. Clear the production bottlenecks by running pre-approved scripts in server to update data manually when needed.
15. Removing logins related to resigned employees
16. Patching Servers with service packs and cumulative updates and hotfix as needed.
No comments:
Post a Comment