Ajay Kumar Dwivedi
- ajaydwivedi.com
-
github.com/imajaydwivedi
-
(+91) 986-853-4271
-
Hyderabad, Telangana, India
-
linkedin.com/in/imajaydwivedi
-
ajay.dwivedi2007@gmail.com
Profile
Site Reliability Engineer with 15+ years of experience, I automate
infrastructure using DevOps CI/CD pipelines leveraging scripting tools
like PowerShell, Python, Ansible, GitHub Actions, Containers etc. I
build monitoring and alerting systems using tools like Python,
PowerShell, Flask, Prometheus and Grafana for both On-Prem and Cloud
platform (AWS & Azure).
Core Competencies
- AWS | Ansible | RDS | Python
- SQL | PostgreSQL | Monitoring | CI/CD
- Infrastructure as Code | Automation | Kubernetes | Terraform
- EC2 | Cloud Infrastructure | On-Call | Capacity Planning
- Customer-Facing
Skills
- Databases: SQLServer, PostgreSQL, SQLite, RDS,
Azure SQL, 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)
Experience
- Tessell
-
February 2026 – September 2026
-
Principal Solution Architect - SQL Server
- Designed CentOS-2-RHEL Migration automation using Python &
Ansible for PostgreSQL
- Wrote SAGA workflows using Kubernetes & dockerized environment
to build Tessell Database As a Service platform on AWS and Azure.
- Built DBaaS for deploying SQLServer on AWS EC2 & Azure VM
- Wrote Python-based SAGA workload to build Tessell DBaaS on Cloud
Infrastructure
- Worked with customers to debug production bugs & implement fixes
during 24x7 on-call support
- Added Monitoring feature for Data & Log file growth using
SQLExporter, Prometheus & Victoria Metrics
- Added enhancements to support Change Data Capture &
transactional Replication
- AngelOne
-
February 2022 – February 2026
-
Senior Site Reliability Engineer (DevOps)
- Automated AWS RDS/Aurora PostgreSQL database deployment &
maintenance using Terraform
- Built SQLMonitor monitoring tool with dashboards that helped in
capacity planning & estimate required space for next couple of years
based on past growth
- Automated multi datacenter HA & Standalone PostgreSQL setup
using Ansible
- Automated disk, connectivity, patroni health, and backup alerts for
PostgreSQL servers using Python
- Saved 80 hours/week SRE effort with single click GitHub Action based
PostgreSQL Cluster deployment & Configuration using Ansible
Playbook.
- Automated common database teams activities like installation,
configuration, monitoring and alerting using PowerShell, Flask, Python,
TSQL, Grafana, and PagerDuty for On-Prem and Cloud Managed
Instances
- Developed DB AI Agent using Ollama (LLM) and LangChain for
Performance Monitoring & Troubleshooting
- Created GitHub Repo based baselining of servers to ease monitoring
and baselining using Prometheus and Grafana
- Baselined all Windows & Linux servers using Prometheus and
Grafana
- Arcesium
-
May 2020 – February 2022
-
Database Reliability Engineer
- Resolved 100s of incidents by moving 38 TB AG databases with
PowerShell.
- Automated/Upgraded 30 Critical SQLClusters/AGs in 12 hours avoiding
week long downtime.
- Improved database reliability with automated ScriptOut of entire
SQLServer Instances for Disaster Recovery.
- Built automations to prevent common issues like tempdbSaver,
LogSaver etc.
- TiVo
-
February 2018 – May 2020
-
Database Administrator
- Reduced 80% performance incidents by building Delta Index
Defragmentation automation for replicated & HADR databases.
- Saved 40+ hours by automating SQLServer deployment and configuration
using PowerShell.
- Reduced 80% transactional replication issues with latency
infra.
- United Health Group
-
October 2016 – February 2018
-
Senior SQL DBA
- Fixed multiple critical customer-facing performance & deployment
issues by directly interacting with them
- Saved $1 million/year via DB Space Capacity Automation.
- Improved 50% performance issues with reduced VLDBs maintenance
time.
- Ericsson Global
-
June 2015 – October 2016
-
Technical Lead
- 3x Performance Improvement via advanced query optimization like
Recursive CTE and Table Partitioning.
- Led 18+ developers for best practices and guidelines.
- TATA Consultancy Services
-
March 2011 – June 2015
-
SQL DBA Developer
- Saved 20+ hours/week by Automating core DBA tasks using dynamic
SQL.
- Moved 250+ large tables with each having billions of records using
SSIS in 45 hours.
- Built data warehouse ETL pipelines using Pentaho & Kettle for
high volume Liquor Retail stores.
Projects
- SQLMonitor
-
January 2021 – Present
-
Open source Enterprise grade SQLServer monitoring tool (GitHub)
- Built using TSQL, PowerShell, Python, and Grafana.
- Successfully monitoring 500+ SQLServers across environments.
- Observability alerts to Slack, PagerDuty and Email
- Inbuilt auto action to Clear & Resolve
- AI Agent
-
October 2025 – Present
-
AI Agent to help application users troubleshoot database performance
issues interactively through portal & Slack (GitHub)
- Built using Python, LangChain, Ollama, and SQLMonitor
- Successfully handling developers/application users in Database
Performance tuning
- HadrSync
-
January 2021 – Present
-
PowerShell module that synchronizes all objects across Replicas in
Availability Groups (GitHub)
- Ensures zero sync issues during failovers/DRs.
- Detects & synchronizes even delta changes like changes in
passwords, definition etc.
Certifications
- Microsoft Certified Professional - Database Querying (October
2013)
- Microsoft Certified Professional - Database Administration (December
2013)
- BrentOzarUnlimited Mastering SQLServer (November 2022)
- SQLSkills Blackbelt Professional (June 2023)
Education
- Bachelor of Engineering in Electronics & Communication
Engineering
-
July 2006 – June 2010
-
RustamJi Institute of Technology, Gwalior, Madhya Pradesh
Awards and Honors
- Tech Titan, AngelOne for 10x Performance
Optimization on Prod SQLServer (2022)
- Sapphire, United Health Group for Innovation and
automations (2017)
Availability
Notice Period: 7 Days | Open to Relocation | Open to remote
opportunities