SQL Server DBA Daily Activities Long Term Activities SQL

SQL Server DBA Daily Activities Long Term Activities SQL

SQL Server DBA Daily Activities Long Term Activities SQL

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