Wrishav

WORK EXPERIENCE

SQL Server DBA Lead

Deltacubes Technologies

01/2021 - Present, Kolkata, India

Achievements/Tasks

Working on SQL Server 2012, 2014, and later versions Architecture and Technical concepts related to Database Administration involving AlwaysOn, SQL Clustering, Replication, Log Shipping, and Mirroring.

Automating the installation, up-gradation, patching, implementing backup/recovery, and site failover.

Reduced 35% incidents with PowerShell automation in the last Quarter.

Database maintenance, troubleshooting, and in-depth expertise in solving database contention problems (deadlocks, blocking, etc).

Troubleshooting long-running queries with the help of

wait types and execution plans.

SQL Server DBA with AWS/Azure

Accenture

04/2017 - 01/2021, Kolkata,India

Achievements/Tasks

Performance Tuning saved $1000000 for the client with table partitioning, MAXDOP re-configuration, Index removal/addition, update statistics, Memory configuration, and Temp DB Configuration.

Migration from on-premises to Azure PaaS and IaaS services for almost 1500 SQL instances.

Participated in disaster recovery & business continuity planning.

Setup automatic SQL server health check and auto- healing for SQL server.

Worked on MariaDB, MongoDB, PostgreSQL, RDS, Redshift, and Redis databases as well as a secondary support POC.

SQL Server DBA and Azure Administrator

Tech Mahindra

12/2013 - 03/2017, Hyderabad, India Achievements/Tasks

Configured DB sync between on-prem and SQL server

hosted on Azure VM.

Recovered databases after catastrophic failures 5 times. Configured pro-active monitoring with App Dynamics.

Changing connection string from the web. config files post failover to the secondary node for Mirroring servers.

Performed Index rebuild and Optimization tasks as planned activities.

SKILLS

MSSQL DBA

SSIS

SSRS

SSAS

Automation

 

PowerShell

Azure Managed Instances

Python

 

Azure

Azure SQL

Blob

Replication

 

clustering

virtual machine

SQL Scripting

 

Cloud DBA

Always On

MariaDB

MongoDB

 

PostgreSQL

DevOps

Redshift

Jupyter

 

Docker

Kubernetes

Apache Spark

Agile

 

JSON

XML

Scrum

Log Shipping

Mirroring

CERTIFICATES

DP-300: Administering Relational Databases on Microsoft Azure (09/2020 - 09/2022)

AWS Certified Solutions Architect - Associate (06/2019 - 06/2022)

AZ-104: Microsoft Azure Administrator (06/2021 - 06/2023)

AZ-400: Designing and Implementing Microsoft DevOps Solutions (06/2021 - 06/2023)

EDUCATION

Bachelor in Computer Application

Annamalai University

2014 - 2016,

Diploma in Electronics & Telecommunication Engineering Ramakrishna Mission Shilpamandira

2010 - 2013,

SELF LEARNT TECHNOLOGIES

Power BI

Azure DevOps

Docker & Kubernetes

Python

 

Jenkins

CI/CD pipeline

Apache Spark