

“I Optimize Databases & Build Infrastructure Automation” – Ajay Kumar Dwivedi

My Experience
With over 14 years of experience, I optimize SQLServer and PostgreSQL databases and build DevOps CI/CD Pipelines to automate Infra with scripting tools like PowerShell, Python, Ansible and Github Actions.
Some Open Souce Projects-
- SQLMonitor: Automation to baseline SQL Server using TSQL, PowerShell, Perfmon & Grafana
- SQLDBA-SSMS-Solution: TSQL/PowerShell script for day-to-day DBA support work.
- 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 an environment where 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.
Some Useful Links
- Resume – https://ajaydwivedi.com/go/resume
- LinkedIn Profile – https://linkedin.com/in/imajaydwivedi
- GitHub Projects – https://github.com/imajaydwivedi
- YouTube Videos – https://ajaydwivedi.com/go/youtube
- Rewards – https://ajaydwivedi.com/go/rewards
- Join Slack – https://ajaydwivedi.com/join/slack
- Slack Me – https://ajaydwivedi.com/go/slack
- #sqlmonitor Channel – https://ajaydwivedi.com/sqlmonitor/slack