- Monitor database queries for efficiency
- Try and minimise slave replication lags
- Troubleshoot SQL Server service outages as they occur, including after-hours and weekends if need be
- Configure SQL Server monitoring utilities to minimize false alarms
- Install and configure new SQL Servers
- Deploy database change scripts provided by third party vendors
- When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
- Document the company’s database environment