MS SQL SERVER DBA

Location:

Mumbai, Maharashtra, India

Posted:

May 17, 2021

Contact this candidate

Resume:

VIKRANT.N.TUPE

A-*** Bhardwaj, Saptrushi Park, Swapna Nagari,

Mulund(w), Mumbai-400080.

Email: ***********@*****.***

Phone: +91-977*******

DOB: 12/07/1990, Gender: Male

Current location: Mulund

To work in a responsible and multifunctional position skillfully applying my knowledge and accomplish projects involving Database management with an extensive use of SQL SERVER technology.

●5 years 3 month of experience in Database Administration for very large and complex databases in SQL Server 2016,2014,2012, SQL Server 2008 R2 and 2008.

●Experience in handling and maintaining production MSSQL Database Servers.

●Configured SQL backup on AWS S3 bucket and Azure blob Storage

●Attached Detached disk on Azure VM

●Migrated On-Prem SQL Server on Azure SQL

●Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL server 2014 and SQL server 2016.

●Experience in applying SQL server service pack on standalone and cluster server.

●Experience in upgrading & migrating SQL Server.

●Good experience with implementing High Availability of database servers using Log Shipping, Database Mirroring, SQL server Cluster.

●Experience in identifying and removing database corruption.

●Have good experience in scheduling index maintenance task (Rebuilding and reorganizing) based on fragmentation level.

●Experience in implementing SQL Server security and Object permissions like creation of users, granting permissions and assigning roles to users.

●Experience in Automating Database maintenance plans for checking database Integrity.

●Experience in Scheduling and Configuring SQL Server agent Jobs, Alert, operators and Database Mail Configuration.

●Experience in scheduling various alerts on production environment to quickly resolve issues.

●Experience in troubleshooting of database issues & blocking issues.

●Experience in planning, organizing and implementing periodical purging of tables.

●Experience in resolving performance related issue.

●Extensive experience with Monitoring, Tuning and analyzing DB performance issues.

●Experience in configuring, monitoring and troubleshooting SQL server clustering.

●Experience in Database backup and disaster recovery procedures.

●Experience in configuring linked servers between SQL to SQL and SQL to Oracle database servers

●Experience in DR-Drill (Switch-over and Switch-back) activities.

Currently working with CXIO Technologies Pvt.Ltd As a Cloud Operations Engineer (Cloud DBA) from 11th June 2020 till date

●Database: MSSQL Server 2008, 2008 R2, 2012,2014,2016.

●Database Tools: SQL Server Enterprise Manager, SQL Server Management Studio, SQL Server Profiler, Database Tuning Advisor, SQL Server Business Intelligence Development Studio, Reporting services configuration Manager, Site 24*7, cloud protect

●Azure Cloud: Cloud Migration from on-prem SQL to azure SQL

●Operating System: WINDOWS SERVER 2008/2008R2/2012/2012R2, Linux.

Worked in Tata Consultancy Pvt.Ltd from 10th Apr 2019 – 8th June 2020

●Installation of SQL Server 2008/2008R2/2012/2014/2016/2017 and patch management on various Windows platform.

●Implemenetd SCOM monitoring tool for Pro active monitoring .

●Configuring, monitoring and troubleshooting SQL server clustering.

●Database maintenance, monitoring and troubleshooting SQL Server.

●Implementing SQL Server hardening and managing permissions related to logins & users.

●Database mail alert configured for Low Disk space, Failed Job, SQL server restart, long running queries, deadlock alert, high CPU utilization, Blocking and high memory utilization.

●Database server migration from SQL Server version 2008 to 2012 and SQL Server from version 2008 to 2014.

●Database movement from one drive to another drive for Disk space management.

●Created jobs to perform index de-fragmentation, re-indexing and update the index statistics.

●Experience in performing integrity and consistency checks

●Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, index tuning wizard.

●Configured SQL server 2012 Active-Passive clustering on windows server as a high availability solution.

●Configured SQL server Always on SQL 2012 on windows server 2012 as a high availability solution.

●Performed Disaster recovery (DR) drill and implemented DR plan.

Worked in Clover Infotech pvt.ltd from Dec 2015 - March 2019

●Installation of SQL Server 2008/2008R2/2012 and patch management on various Windows platform.

●Database maintenance, monitoring and troubleshooting SQL Server.

●SQL server database hardening and documentation as per Client requirement.

●Implementing and managing permissions related to logins & users.

●Mirroring and log shipping implementation on multiple servers.

●Database server migration from SQL Server version 2005,2008 to SQL server 2012

●Database movement from one drive to another drive and Table compression for Disk space management.

●Created jobs to perform index de-fragmentation, re-indexing and update the index statistics.

●Performed Disaster recovery drill (DR Drill).