Around 6.0 years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2005, 2008, 2012.
Performed architecture and configuration analyses of DEV, QA, and PROD environments including: disk configurations and RAID levels to support OLTP and Data Warehouse applications.
Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
Expertise in T-SQL writing stored procedures, triggers and functions
Proficiency and expertise in SQL Server Replication, Log Shipping, Database Mirroring, Backup/Recovery, Disaster recovery and planning.
Worked with Indexing, Statistics, Locking, and Blocking on queries and isolation levels.
Experience with Database Performance Tuning, Query optimization, client/server connectivity, and other network issues/ database consistency checks using DBCC.
MS SQL Server 2000/2005/2008/2012
Data Warehouse Designing And Maintenance
SQL Server Administration
SQL Server Development
Monitoring & Troubleshooting
SQL Server Health Check
Backup and Restore