Should have 7+ years of DBA experience in installation, configuration & administration of MS SQL Server (2005 and 2008 R2) production & development environments.
Experience in troubleshooting and resolving database integrity issues, performance issues, deadlock issues, logshipping issues and connectivity issues.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler, performance dashboard, spotlight and other related monitoring and troubleshooting tools.
Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands.
Experience in Database mirroring (Build, Roll, maintenance & troubleshooting) & Replication (Transactional & Peer to Peer).
Knowledge of SQL Server tools (Profiler, DTA, SSMS, SAC, SSCM, Perf-Mon, DMVs, system sprocs)
Knowledge of indexes, index management, and statistics.