8+ years of IT Experience in managing multiple MS SQL 2000 & 2005 & 2008 R2, 2012 servers in Oil &Gas and Pharma/Life Science domains.
Expert Level skills in providing 24x7 DBA support in Production, QA and Development environment.
Involved in day-to-day monitoring and maintenance, problem investigation and resolution, SQL and database optimization and tuning as well as researching, analyzing, and recommending patches, upgrades, and new technologies surrounding all aspects of data management using relational databases.
Migration experience with multiple databases/servers from SQL 2000 to SQL 2005 and SQL 2005 to SQL 2008 R2.
Experience and Knowledge on High availability & Disaster Recovery options like Replication/log shipping/Mirroring.
Implemented & managed database clustering, failover and load balance technologies as per client requirement.
Experience in Performance Tuning (System level/Database Level) and optimization.
Thorough understanding of blocking/lock issues, Tempdb Optimization, File group management.
Knowledge in SSIS and SSRS. Fixing the issues with SSIS and Report server issues.
Experience in working with VLDB databases upto 2TB, Managing Backups, Disk & Drive Space issues, managing indexes.