Description
Summary: * Total 16+ Years of IT experience and 9+ years as MS SQL Server DBA. * Experience in Database Backup, Recovery and Disaster Recovery procedures. * Experience in providing Good production support for 24 x 7. * Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities, Capacity Planning. * Expert in installation, upgrade and configuration of MS SQL Server and databases in clustered and standalone environment. * Having very good experience as Lead role for onshore and offshore model. * Automate export CSV file and send mail using Database mail using T- SQL. * Experience working with MS SQL Server 2000, 2005, 2008, 2008 R2 and 2014 versions. * Expertise in Migration and up gradation from lower version to higher versions like 2014/2016. * Having very good expertise in windows batch and power shell scripts. * Prepared templates for migration process Non Production and Production environments. * Expertise to enhance the SOP's for Migration process checklist using SSMA * Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL server 2005/2016. * Implemented Database Mirroring as a High Availability Solution. * Implemented different types of Replication Models like Snapshot, Merge and Transactional. * Experience in implementing RAID 1-5 & 10 technologies. * Experience in creating packages, jobs, sending Alert using SQL Mail and Database mail. * Creation and Maintenance of Databases, Creating Roles and managing user Permissions, resolving deadlocks * Experience cloud AWS SQL Server installation, maintenance and configuration. * Worked on SAN (VNX, EMC, IBM and HP Arrays) for SQL Server Databases and good understanding in capacity planning. * Worked experience in HPSD, ITSM and ITG ticketing tools. * Experience in Microsoft SQL Server CLUSTERING and experience in Tracing SQL Server events and SQL Profiler to McAfee monitor events in an instance of Microsoft SQL Server and AWS * Highly proficient in working with users to gather requirements, analyze them, and subsequently use design tools to model the requirements. * Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and Unattended Installations. * Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and related errors.
Accomplishments
Highlights:
Keywords
