I am Microsoft certified SQL Server Database administrator having about 6 years of experience. Over 6 years of expertise as results-driven project and database management professional with first-rate skill in directing full cycles for complex, multi site programs. Expertise in Database Administration, System Analysis, Design, Development and Support of MS SQL Server 2014, 2012, 2008 R2, 2008 and 2005 in Production, Staging and Development Environments.
• Extensive experience in Installation and configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005.
• Configured Active/Active and Active/Passive clustering for failover.
• Performed Capacity Planning, data modeling and Logical/Physical database Design.
• Experience in Database Backup, Recovery and High Availability (Clustering, Log Shipping, Replication and Mirroring).
• Hands on experience in upgrading of SQL Server 2008 to SQL Server 2012 and SQL Server 2008 to SQL Server 2014 (side by side and in place).
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG (Always On Availability Groups).
• Extensively worked on Integration (SSIS) and Reporting Services (SSRS), Analysis Services (SSAS), Business Intelligence and good experience in data migration from Oracle/MS-Access/MS-Excel Sheets/MYSQL to SQL Server 2014/2012/2008.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and