Shrinath Badigare

SQL Server DBA / Azure SQL Administrator with 10+ years of experience in database administration, installation, upgrades, backup and recovery, performance tuning, maintenance, security, high availability, disaster recovery, and production support. Hands-on experience supporting Microsoft SQL Server 2005 through 2022 across Production, QA, Development, standalone, and clustered environments. Strong experience in database creation and administration, data/log file placement, file growth management, database configuration, capacity planning, disk-space troubleshooting, and routine maintenance.

Experienced in SQL Server security, user and role management, object permissions, auditing, SQL Server Agent jobs, alerts, Database Mail, and operational monitoring. Experienced in backup/recovery, Log Shipping, Database Mirroring, Failover Clustering, and Always On Availability Groups for high availability and disaster recovery. Strong troubleshooting experience covering performance, blocking, deadlocks, connectivity, replication, database integrity, transaction log, and job-related issues.

Experience tuning T-SQL queries using execution plans, SQL Profiler, DMVs, Extended Events, and monitoring tools; experienced with index maintenance and table partitioning for large databases.

Experience with SQL Server migration, major production deployments, cutover planning, SSIS package deployment/support, and PowerShell-based DBA automation. Azure SQL experience across Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs (IaaS), including migration, monitoring, troubleshooting, alerts, point-in-time restore, and database refresh activities.

Experience supporting 100+ Azure SQL databases with database sizes up to 8 TB, and providing 24x7 production support, mentoring, documentation, and operational guidance. Monitored database and infrastructure resource utilization, identified underutilized resources, and recommended right-sizing and capacity optimization initiatives to reduce unnecessary cloud/infrastructure costs and help achieve budget savings. Hands-on experience supporting Snowflake administration, including code deployments, role-based access management, user provisioning, and security/permission management.

Senior Database Administrator at Cameo Global Communications Pvt. Ltd. (2023-07 – Present)

Senior Consultant at Tetrasoft India Pvt. Ltd. (2022-09 – 2023-07)

Senior Database Administrator at Sagarsoft (India) Limited (2022-04 – 2022-09)

• Built and configured SQL Server environments, installed required service packs/client components, created databases, and placed data/log files appropriately.
• Troubleshot application connectivity issues, SQL Agent job failures, backup failures, database integrity issues, and database refresh requests.
• Performed database restores for user requests and disaster recovery activities, including validation of backup and restore processes.
• Handled suspect-mode databases and routine optimization and integrity maintenance activities.
• Worked on backup/restore, replication, mirroring, SQL Server clustering, server migration, and SQL Server upgrades.
• Configured and troubleshot HA/DR technologies including Database Mirroring, Log Shipping, and Failover Clustering.
• Monitored SQL Server performance using SQL Profiler and Performance Monitor and investigated CPU and memory-related issues.

SQL Server DBA / Azure SQL Administrator at Aptude Software Solutions India Pvt. Ltd. (2017-02 – 2022-03)

• Reviewed role-based access and resolved user permission issues while following least-privilege access practices.
• Managed Snowflake security by provisioning users and granting appropriate roles and permissions based on approved access requirements.
• Supported Snowflake administration, including code deployments and production deployment activities.
• Administered SQL Server 2012–2019 and Azure SQL environments across IaaS and PaaS platforms.
• Monitored SQL Server health, SQL Agent jobs, database availability, performance, and user requests in production environments.
• Performed performance tuning using execution plans, SQL Profiler, DMVs, Extended Events, and monitoring tools.
• Assisted developers with query tuning and schema refinement and investigated SQL errors, blocking, and performance problems.
• Planned and executed SQL Server upgrades and migrations, including migrations to SQL Server 2017 and 2019.
• Installed and configured SQL Server 2019 and applied cumulative updates and scheduled maintenance.
• Configured high-availability and disaster-recovery solutions, including a four-node Availability Group cluster.
• Supported SQL Server migration to Microsoft Azure Cloud and participated in DR planning and testing.
• Automated recurring DBA activities using PowerShell and maintained operational documentation.
• Provided 24x7 support for critical production systems and supported release deployments and after-hours maintenance.
• Mentored team members and supported knowledge transfer and documentation activities.

SQL Server DBA at Aspire Systems (2015-11 – 2016-08)

• Implemented and configured HA solutions including Log Shipping and Database Mirroring.
• Installed and configured SQL Server Enterprise 2008 and 2014 on Windows Server 2012 in clustered and standalone environments.
• Performed SQL Server service pack installations and routine DBA operations.
• Managed incident, change, and service-request tickets based on SLA and business criticality.
• Created and enforced SQL Server DBA best practices and operational guidelines.
• Created and tested business continuity and disaster recovery setups for mission-critical applications.
• Participated in DR exercises and performed index maintenance for database performance.
• Worked with monitoring teams to investigate and resolve SQL Server alerts using Spotlight.

SQL Server DBA at IBM (Payroll: Cryptograph Technologies Pvt. Ltd.) (2015-06 – 2015-10)

• Implemented SQL Server security, user creation, object permissions, and role assignments.
• Monitored SQL Server Agent jobs and verified successful execution in production.
• Validated database backups and confirmed successful storage in secure locations.
• Monitored production servers for blocking and other operational issues.
• Configured SQL Server alerts for potential production problems.
• Performed test restores to validate backup recoverability and monitored server disk space.

Computer Facilitator at Fortune Butterfly Educational Society (2014-06 – 2015-04)

Master of Computer Application in MCA – GRIET (JNTUH)

Bachelor of Science in MPCs – Vivekananda Degree College (OU)

Intermediate in MPC – Nalanda Junior College

SSC – The King's School