Description

🚀 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

📊 Professional Summary

✅ 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.

💼 Employment History

🎯 Senior Site Reliability Engineer | AngelOne (Feb 2022 – Present)

📊 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.

🎯 Database Reliability Engineer | Arcesium (May 2020 – Feb 2022)

🛡️ 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

🎯 Senior SQL Server DBA | TiVo (Feb 2018 – May 2020)

🛠️ Built DBA Inventory using Python, Django, and PowerShell.
⚙️ Automated SQLServer deployment using PowerShell.

🎯 Senior SQL Server DBA | United Health Group (Oct 2016 – Feb 2018)

💰 Saved $1.0 million/year via DB Space Capacity Automation.
🛡️ Managed VLDBs effectively under load.

🎯 Senior SQL Server Developer | Ericsson (Jun 2015 – Oct 2016)

🚀 3x Performance Improvement via advanced query optimization like Recursive CTE and Table Partitioning.
🧠 Mentored team on SQL Best Practices.

🎓 Education & Certifications

🎓 Bachelor of Engineering – RGPV University, Bhopal (2006–2010)
📚 SQLSkills Blackbelt Bundle – SQLSkills.com (2022 – 2024)
📚 Fundamentals & Mastering Bundle – BrentOzar Unlimited (2021–2022)

🛠️ Key Projects

✅ 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.

💡 Skills

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

🏆 Awards & Achievements

🏅 Multiple Automation Awards for innovative automation scripts.
📝 Technical Blog: ajaydwivedi.com
🎥 Live YouTube Tutorials: YouTube Sessions
👨‍🏫 Instructor Experience: Taught C/C++ (2008–2010)

📣 Final Note

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!