Ajay Kumar Dwivedi

13+ Years of Exp. Lives in Nagpur, India. Loves Building Automations & Resolve SQLServer/PostgreSQL Performance Issues.

I help clients to ensure Database Systems are Issue Free, Always Available, and running at Peak Performance State all the time.

ajaydwivedi.com . imajaydwivedi.github.io . linkedin.com/in/imajaydwivedi . ajay.dwivedi2007@gmail.com . +91 9868534271


EMPLOYMENT

Senior Site Reliability Engineer, AngelOne (Feb 2022 - Present)

Database Reliability Engineer, Arcesium (May 2020 - Feb 2022)

Senior SQL Server DBA, TiVo (Feb 2018 - May 2020)

Senior SQL Server DBA, United Health Group (Oct 2016 - Feb 2018)

Senior SQL Server Developer, Ericsson (Jun 2015 - Oct 2016)

SQL Server DBA/Developer, TATA Consultancy Services (Mar 2011 - June 2015)

Education

Bachelor of Engineering, RGPV University, Bhopal (July 2006 - Apr 2010)

Fundamentals & Mastering Bundle, BrentOzar Unlimited (Dec 2021 - Nov 2022)

SQLSkills Blackbelt Bundle, SQLSkills.com (Dec 2022 - Present)

OPEN SOURCE PROJECTS

SQLMonitor: Automation to baseline SQL Server using TSQL, PowerShell, Perfmon & Grafana

SQLMonitor-AlertEngine: Advanced smart alert system to get Slack/Email/PagerDuty alerts for SQLServer issues/events.

SQLDBA-SSMS-Solution: TSQL/PowerShell script for day to day DBA support work.

SQLDBATools: PowerShell module to automate common DBA tasks and advanced alert setup.

HadrSync: PowerShell module to synchronize everything from Primary/Principal replicas to Secondary/Mirror/DR replicas in Always On/Mirror setup.

Credential Manager: Infra that provides storage/retrieval functionality similar to Windows Credential Manager. This is very helpful in environment where a proper vault/credential management software is not present.

Space-Capacity-Automation: Stored Procedure that would add/restrict data and log files on new and old disk drives automatically without DBA intervention.

Additional Experience And Awards

Languages and Technologies

Technologies

Tools

Scripting

Operating System

Programming Models


Download the CV in PDF format . Last update February 2024.
This CV uses my Markdown Resume.
Light 🌕 Dark 🌑