Description
PRINCIPLE ACCOUNTABILITIES:
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
o 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)
Note: Should have EU passport and be ready to travel to US for transition for the first 2-3 weeks of contract.