Description
A Person with at least 5+ years of experience administrating and supporting Microsoft SQL Server.
Working experience with the latest versions of SQL Server (ie 2005, 2008 R2) as well as the following topics:
Administration of SQL Server
Server configuration
o Trace flags
o Server settings
o Security options
SQL Server best practices
o Memory settings
o Database design
o Index fragmentation
o Statistic
SQL Server maintenance
- Installation of SQL Server
- Server design
Hardware requirements
- Storage
- Memory
- NIC
Disaster recovery strategies
- Point in time data restore
- Log Shipping
High Availability options
Database mirroring
Troubleshooting various types of issues
- Performance
- Server Down
- Connectivity
- Misconfiguration
- Blocking
- Deadlocking
- Data corruption
Additional topics of interest
- Understanding T-SQL language, PowerShell
- Windows 2008 R2 features (DFSR, Memory management, Virtualization)