| author | description | lang | header-includes | pagetitle |
|---|---|---|---|---|
Ajay Kumar Dwivedi |
SQLServer/PostgreSQL Database Design, Optimization & Automation |
English |
<link rel="icon" type="image/png" href="img/resume.png" /> |
Ajay Kumar Dwivedi |
SQL Server / PostgreSQL Database Administrator & Developer
Automation | Performance Tuning | Query Optimization | Monitoring
🌐 ajaydwivedi.com | 💻 GitHub | 🔗 LinkedIn
✉️ ajay.dwivedi2007@gmail.com | 📞 +91 7032312749
✅ 14 years of expertise in SQL Server and PostgreSQL databases.
✅ Specialist in Database Design, Performance Optimization, and Automation.
✅ Skilled in PowerShell, Python, and Grafana for monitoring and alerting.
✅ Ensures high availability, data integrity, and optimized database systems.
- 📊 280+ SQL Servers Baselined using self built SQLMonitor.
- 🚨 Developed Alert Engine tool via Flask, Grafana and Python.
- ⚙️ Optimized SQL Server performance with D.E.A.T.H Methodology (IO latency: 350ms → <9ms).
- 🔒 Automated Transparent Data Encryption (TDE) for 280+ servers.
- 🛠️ Tuned PostgreSQL queries for efficient parallel plans and indexing.
- 🛠️ Fixed MSSQL query problems like Ascending Key issue, Kitchen Sink design, uneven threading, distributed query plans, MSTVFs, etc.
- ⚙️ Automated bi-directional Transactional Replication for DR setup using PowerShell.
- 🛡️ Designed AlwaysOn Readiness Solutions using PowerShell & Grafana.
- 🚚 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.
- 🛠️ Fixed High CPU/Query Regression issues.
- 🛠️ Automated Script Out of entire SQLServer Instance
- 🛠️ Built DBA Inventory using Python, Django, and PowerShell.
- ⚙️ Automated SQLServer deployment using PowerShell.
- 💰 Saved $1.0 million/year via DB Space Capacity Automation.
- 🛡️ Managed VLDBs effectively under load.
- 🚀 3x Performance Improvement via advanced query optimization like Recursive CTE and Table Partitioning.
- 🧠 Mentored team on SQL Best Practices.
- 🎓 Bachelor of Engineering – RGPV University, Bhopal (2006–2010)
- 📚 SQLSkills Blackbelt Bundle – SQLSkills.com (2022 – 2024)
- 📚 Fundamentals & Mastering Bundle – BrentOzar Unlimited (2021–2022)
✅ CredentialManager – Safely use with credentails in automations.
✅ SQLMonitor – Baseline and monitor SQL Server.
✅ SQLMonitor-AlertEngine – Advanced alerting system.
✅ SQLDBA-SSMS-Solution – Daily DBA task scripts.
✅ HadrSync – Replica synchronization.
✅ Space-Capacity-Automation – Disk space management.
✅ SQLDBATools – PowerShell module to help with DBA activities.
| Skill Area | Proficiency |
|---|---|
| Database Systems | SQL Server, PostgreSQL |
| Automation Tools | PowerShell, Python, Bash |
| Monitoring Tools | Grafana, Prometheus |
| DevOps Tools | Docker, Ansible, Git |
| OS Expertise | Ubuntu, Windows |
| Web Frameworks | Flask, Django |
🏅 Multiple Automation Awards for innovative automation scripts.
📝 Technical Blog: ajaydwivedi.com
🎥 Live YouTube Tutorials: YouTube Sessions
👨🏫 Instructor Experience: Taught C/C++ (2008–2010)
I’m passionate about designing efficient database systems and solving complex performance challenges. Ready to bring expertise, innovation, and dedication to your organization.
✨ Let’s connect and discuss how I can add value to your team!