Rahul Digwasiya

Background

About Rahul Digwasiya

Profile: SQL Server DBA Architect 20 years' experience on Microsoft SQL Server (On-Premises & Cloud platforms - AWS EC2, AWS RDS for SQL Server, Azure SQL Database and Azure SQL MI). Exposure to AWS RDS for PostgreSQL. Automation using T-SQL, PowerShell, Windows, AWS CLI & Azure Cloud Shell scripting. My domain experience includes Banking & Finance, Media & Entertainment, Manufacturing, Healthcare and Online Travel. I managed a team of 12 SQL Server DBAs for a USA based client of HCL (Media & Entertainment domain) for administration of instances and 8500+ databases. I managed a team of 15 DBAs for a USA based client (Investment bank) of IBM for administration of 1200+ SQL Server instances. Automation and Projects 1. SQL Server health check scripts 2. Resumable Online Rebuild Index 3. Database Encryption with TDE using EKM/HSM 4. Encryption of data in motion from ERP to SQL Server 5. Automated Backup/Restore of SQL Server database 6. Automated Backup/Restore of PostgreSQL database 7. Backup files upload/download from AWS Fsx share to S3 Bucket 8. Database Restore from Backup in AWS S3 Bucket 9. Database Restore from Backup in Azure BLOB Storage SQL Server expertise 1. Installation & Patching 2. Configuration 3. Up-gradation 4. Database migration 5. Security 6. Auditing 7. Log Shipping 8. Database Mirroring 9. Database Replication 10. Fail-over clustering 11. Availability Groups 12. Backup & Recovery 13. Database corruption 14. Transparent Data Encryption 15. Table Partitioning 16. Blocking and Deadlocks 17. Performance monitoring 18. Query & SP code tuning 19. Full Text Search 20. Filestream 21. Change Tracking 22. Change Data Capture 23. Resource Governor 24. Policy based Management 25. Extended Events 26. Management Data Warehouse 27. Utility Control Point (UCP) 28. Kerberos Authentication 29. UMS / SQLOS 30. Query Store 31. Live Query Statistics 32. Buffer Pool Extension 33. In-Memory Tables 34. Temporal Tables 35. Dynamic Data Masking 36. Row level Security 37. Always Encrypted 38. Column store Indexes 39. Distributed Availability Group 40. Memory Dumps analysis 41. Remediation of vulnerabilities Tools Profiler,Performance Monitor,Performance Dashboard,SolarWinds,AppDynamics,BPA,SQLIOSim, IDERA SQL Safe, Quest Litespeed, Tivoli Storage Manager, Data Protector, NetBackup, OVSD,OVSC,HPSM, Icinga,Grafana, BMC Patrol,SCOM,dbspi,Nagios, ServiceNow,Remedy,ClearQuest,ClearCase,Autosys, Azure Portal, Azure Storage Explorer, AWS Management console, AWS S3 Browser, FSX, DataSync, S3 File Gateway, Windows Admin Center