I am Microsoft Certified Technical Specialist SQL Server DBA with 6+ years of Experience • Providing 24*7 DBA support to production server(cluster), MIS, Testing, Development and UAT servers
• Ticket handling, updating (Incidents & SRs) on daily basis based on defined SLA
• Extensive experience in SQL Installation, up-gradation and applying patches for different versions and editions and also good experience in preparing POA’s & SOP’s for these activities
• Good experience in moving system databases and troubleshooting system databases issue. And also experience in file movement of Secondary Server databases which are in HA and DR.
• Good experience in planning backups within the available storage and restoring them in test environment through automated jobs
• Experience in implementing Database mirroring for high availability solutions.
• Experience in LogShipping for high availability solutions.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support. Resetting SA or Admin password through minimal server permissions
• Experience in creating automated backups, restoration DB’s, indexing & update stats through SQL Agent Jobs & Maintenance plans
• Experience in importing and exporting data from different data sources with automated scripts & packages
• Experience in creating SSIS packages and troubleshooting them when issues occurred