Things a dba should do

So I have been looking at what it is that a dba needs to do on a regular basis and when does the task need to be performed. Here is what I have come up with so far.

• Daily Tasks

   
• Review emails for failure notifications
  
  Review emails for user issues/tickets
  
  o Confirm that data is available
  o Review daily morning logs for
   Login issues
   Errors
  o Confirm Backups
   Full
   Differential
   Transaction Logs
  o Confirm Scheduled jobs
  o Review Mirroring
  o Review log shipping
  o Review Snapshots
  o Delete Snapshots
  o Review Windows Event Logs
  o Review Audit/Trace logs if set up
  o Review Sql Server Log files
  o Review Sql Agent Log Files
  o Review Cluster/Mirror logs
  o Troubleshoot issues

Weekly Tasks
o Review articles, blogs
o Review Monday logs
 Space
 DBCC checkdb
 Rebuild indexes
 Reorganize indexes
 Update statistics
 Gather security audit data into an audit table
 Review security audit data
o Confirm sp_configure settings document
o Review Code for weekly rollout
o Confirm email functionality
o Weekly Code rollout
o Review new objects
o Rollout new objects
o Review scripts
o Rollout Scripts
o Create/Review metadata baseline
o Review Change history
• Monthly Tasks
o Roll the alert logs
o Microsoft Security Patch Tuesday (Second Tuesday of the month)
o Review and test security patches
o Rollout Security Patches if required
o Build monitor baselines
 Cpu
 Memory
 Network
o Compare previous baselines to current for potential performance issues
o Test restores/recovers
o Test Cluster failovers
o Review products coming up, download standard patches and beta releases
o Perform server audits
 Confirm with License Manager or Asset manager John Humphries any unknown servers
 Confirm what is on what server, databases, applications
 Confirm what edition, version and patch level for the database
 Confirm what os edition, version and patch level
 User/Group permissions
• Quarterly Tasks
o Review Service Packs
o Test Service Packs
o Rollout Service Packs
o Review Standard Patches
o Test Standard Patches if patch is desired
o Rollout Patches if patch is desired
• Semi-Annual Tasks – starting June 1 & January 1
o Review end of product support
o Pre-License Review June
o Post-License Review January
o Pre Review dr docs June
o Post Review dr docs January
o Prep for upgrade to new version
 June Develop plan and methodology
 January Review upgrade rollout
• Annual Tasks -- starting October 1
o Formal License Review
o Dr test
o Upgrade to new versions
• On demand tasks
o Overlay/refresh data
o Installations
o Data modeling tasks
o Server Request forms
o Backup Request forms