SQL Server DBA Daily Activities Long Term Activities SQL Server Projects

Today I got a survey from one of the SQL Server Products company from which I was able to gather below details which will help someone...

SQL Server DBA Day-to-Day Activities:
Backup / Recovery / High Availability planning and management
Finding and fixing performance problems
Identifying and rolling out database schema, stored procedure, and data changes
Evaluating resource consumption (CPU, I/O, Disk, etc.) and planning for future requirements
Tuning and optimizing your SQL Server environment
Writing queries and/or stored procedures
Security and vulnerability assessment of your SQL Server environment
HIPAA/PCI/SOX/regulatory compliance
Restoring dev/QA servers from production
Performing other routine maintenance (defragmenting indexes, managing capacity, physical server maintenance)


SQL Server DBA Long-Term Activities:
Growth of your SQL Server environment in number of databases or instances
Security and vulnerability assessment of your SQL Server environment
Recovery from disaster or lost data
Knowing your whole environment – how many servers you have and what they’re being used for
Data growth/capacity planning
Managing users and authorization
Performance Monitoring and Analysis
Query tuning
Consolidating your SQL Server environment
Virtualization
Migrating/Deploying new SQL Servers
Budget and/or staff cuts

SQL Server Projects:
SQL Server Consolidation
Virtualization
HIPAA/PCI/SOX/regulatory compliance
SQL Server Clustering
Replication, Database Mirroring or Log Shipping
Business Intelligence
Database Migrations from another vendor (Oracle, DB2, Sybase, etc.)
Deploying SQL Server 2008 into production