Spread the love

profile for Ajay Dwivedi at Stack Overflow, Q&A for professional and enthusiast programmers profile for Ajay Dwivedi at Database Administrators Stack Exchange, Q&A for database professionals who wish to improve their database skills and learn from others in the community

“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

Hire Me To Save Your Money