Ajay Kumar Dwivedi
- ajaydwivedi.com
-
github.com/imajaydwivedi
-
(+91) 703-231-2749
-
Nagpur, Maharashtra, India
-
linkedin.com/in/imajaydwivedi
-
ajay.dwivedi2007@gmail.com
Professional Summary
With over 14 years of experience, I optimize SQL Server and
PostgreSQL databases and build DevOps CI/CD Pipelines to automate Infra
with scripting tools like PowerShell, Python, Ansible and GitHub
Actions.
Skills
Databases: SQLServer,
PostgreSQL, SQLite, RDS, Managed Instance, Aurora
Programming Languages: SQL,
PowerShell, Python,
JavaScript, HTML / CSS,
Shell Scripting
Tools and Frameworks: Git, Linux, Ansible, Flask,
Django, GitHub Actions, VS Code, Grafana, Prometheus, KVM
Virtualization, Container, Podman, Docker, Ubuntu, RHEL, PowerShell DSC,
Infrastructure as Code (IaC)
Cloud Platforms: AWS, Azure
High Availability & Disaster Recovery:
Clustering, Availability Groups, Mirroring, Log Shipping, Replication,
Disk Stripping, RAID, Multi Subnet Setup
Languages: English (proficient), Hindi (native)
Certifications
- Microsoft Certified Professional - Database Querying
-
Oct 2013
- Microsoft Certified Professional - Database Administration
-
Dec 2013
- BrentOzarUnlimited Mastering SQLServer
-
Nov 2022
- SQLSkills Blackbelt Professional
-
Jun 2023
Experience
- Senior Site Reliability Engineer
-
AngelOne
-
Feb 2022 - Present
- Optimized 10x SQL Server performance with D.E.A.T.H
Methodology.
- Automated Transparent Data Encryption (TDE) for 280+ servers.
- Reduced 20x query time by fixing problems like Ascending Key,
Kitchen Sink design, un-even threading, distributed query plans, MSTVFs,
etc.
- Built Monitoring & 45+ Alerts using PowerShell & Python for
SQLServers.
- Database Reliability Engineer
-
Arcesium
-
May 2020 - Feb 2022
- Designed PowerShell module to move 38 TB AG databases.
- Automated/Upgraded 30 SQL Instances, having Replication on top of AG
replicas formed of SqlClusters in 12 hours.
- Automated Script Out of entire SQLServer Instance for Disaster
Recovery Drills.
- Senior SQL DBA
-
TiVo
-
Feb 2018 - May 2020
- Saved 40+ hours by automating SQLServer deployment and configuration
using PowerShell.
- Reduced Replication Health & Latency issues by 10x with latency
infra.
- Reduced performance incidents by 5x by building Delta Index
Defragmentation automation for replicated & HADR databases.
- Senior SQL DBA
-
United Health Group
-
Oct 2016 - Feb 2018
- Saved $1.0 million/year via DB Space Capacity Automation.
- Reduced VLDBs maintenance time by 3x with effective backup
&defragmentation strategies.
- Senior SQL Developer
-
Ericsson Global
-
Jun 2015 - Oct 2016
- 3x Performance Improvement via advanced query optimization like
Recursive CTE and Table Partitioning.
- Mentored team on SQL Best Practices.
- SQL DBA Developer
-
TATA Consultancy Services
-
Mar 2011 - Jun 2015
- Built data migration pipelines using SSIS to move billions of
records.
- Built data warehouse refresh pipelines using Pentaho & Kettle
for Retail stores.
- Saved 20+ hours/week by Automating core DBA tasks using dynamic
SQL.
Education
- Bachelor of Engineering in Electronics & Communication
Engineering
-
Jul 2006 - Jun 2010
- RustamJi Institue of Technology
-
Gwalior, Madhya Pradesh
Awards and Honors
- Gold, International Collegiate Catching Fish
Contest (ICCFC)
-
2018
- First Prize, China National Scholarship for
Outstanding Dragons
-
2017, 2018
Projects
- SQLMonitor: Open source Enterprise grade SQLServer
monitoring tool
-
Jan 2021 - Present
- Built using TSQL, PowerShell, Python, and Grafana.
- Successfully monitoring 500+ SQLServers across environments.
- Sends alerts to Slack, PagerDuty or Email
- Inbuilt auto action to Clear & Resolve
- HadrSync: PowerShell module that synchronizes all
objects across Replicas in Availability Groups
-
Jan 2021 - Present
- Ensures zero sync issues during failovers/Drs.
- Detects & synchronizes even delta changes like changes in
passwords, definition etc.
Availability
Notice Period: 90 Days
Relocation: Open to Relocation
Remote: Open to remote opportunities
FINAL NOTE
I am passionate about designing efficient database systems and
solving complex performance challenges. I help organisations build
robust, fully automated infrastructure with PowerShell, Python and
Ansible.