DBA Check List

Below is an outline of the items that need to be considered for a DBA role. Being a DB Developer/DBA I find this list to be a great starting point. Depending on the type of environment you have some of these items may be overkill or just not needed.

Link to full pdf version

• General DBA Best Practices
• Best Practices for Becoming an Exceptional SQL Server DBA
  
• Day-to-Day
  
• Installation
  
• Upgrading
  
• Security
  
• Job Maintenance
  SQL Server Configuration Settings
  
• Database Settings
  
• Replication


• High Availability Best Practices
  
  • General High Availability
    
  • Disaster Recovery
    
  • Backup
    
  • Clustering
    SQL Server Mirroring
    
  • Log Shipping
  
  
• Performance Tuning Best Practices
  
  • Performance Monitoring
    
  • Hardware Performance Tuning
    
  • Indexing
    
  • SQL Server 2008 Compression Best Practices
    
  • SQL Server 2008 Data Collector Best Practices
    Best Practices for Resource Governor
  
  
• Application Design and Coding Best Practices
  
  • Database Design
    
  • Queries and Stored Procedures
    
  • Transact-SQL
    
  • SQL Server CLR
    
  • XML
  
  
• SQL Server Component Best Practices
  
  • SSIS
    
  • Reporting Services
    
  • Analysis Services
    
  • Service Broker
    
  
  

Source article