Position : MS SQLDBA
Designation : DBA
Experience : 5 to 8 years
Work Location : Chennai
- 5 + years of experience in database development and administration in MS SQL Server environments.
- Strong experience in Database Administration in SQL Server (2000, 2005, 2008, R2 )
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
- Strong experience in Database Monitoring.
- Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
- Strong knowledge of Backups, Restores, Recovery Models, Database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
- Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
- Knowledge of sharepoint administration is also preferable.
- SQL Server Database Architecture. Enable to estimate Database space and size.
- Database Modeling (Physical & Logical Designing)