SUNNY R. PATIL

• Aspiring Database Administrator with 7 years and 8 months of experience in managing and maintaining production SQL Server environments.
• Seeking a challenging role that involves technical problem-solving and database management responsibilities.

Technical Experience

• Extensive experience (7+ years) in handling production Microsoft SQL Server databases, including:
  Installation, configuration, maintenance, and administration of SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016, and 2019.
  Managing standalone and clustered environments.
• Azure Services Administration:
  Configuration and maintenance of Azure PaaS and IaaS database services.
  Hands-on experience with Azure Databricks, Azure Data Factory pipelines, and Synapse Analytics.
• MySQL and Cosmos DB Administration:
  Management, migration, and version upgrades for MySQL and Cosmos DB.
  Expertise in Cosmos DB cost optimization and cross-account migrations.
  Implemented cost management best practices for Cosmos DB environments.
• Database Maintenance and High Availability:
  Performed upgrades and migrations of SQL Server databases across versions.
  Implemented High Availability (HA) and Disaster Recovery (DR) solutions using:
  Log Shipping, Database Mirroring, SQL Server Clustering, and Always On Availability Groups.
  Designed and executed backup, recovery, and restoration strategies.
• Performance and Security:
  Troubleshooting and resolving performance issues at both server and database levels.
  Implementing SQL Server security, user management, and role-based access control.
• Automation and Monitoring:
  Configured and scheduled SQL Server Agent Jobs, Alerts, Operators, and Database Mail.
  Established automated maintenance plans:
  Weekly: Integrity checks, index rebuilds, update statistics.
  Monthly: Cleanup and history maintenance for optimal performance.
• Cross-Platform Integrations:
  Configured Linked Servers between SQL–SQL and SQL–Oracle environments.
• Cloud Backup and Restoration:
  Managed backup and restore operations for databases hosted on Azure Cloud.
• Stakeholder Collaboration:
  Interacted with management and business stakeholders to gather requirements and implement database solutions effectively.

• Azure SQL (PaaS & IaaS):
  Provisioned and maintained servers, elastic pools, and databases.
  Configured backup policies, performed database restores (PITR, LTR), and executed DR drills on Azure.
  Created Elastic Job Agents and automated data workflows using Azure Data Factory pipelines.
  Set up and optimized Databricks workspaces and clusters following best practices.
• SQL Server Administration:
  Installed and configured SQL Server 2005, 2008, 2008 R2, 2012, 2016, and 2019 across standalone and clustered environments.
  Performed regular monitoring of servers, backups, and maintenance jobs, ensuring issue resolution in real time.
  Managed database mail, operators, and alerts for proactive system notifications.
  Conducted database migrations and upgrades (2008 → 2012 → 2016 → 2019) and disk space optimization activities.
• High Availability (HA) & Disaster Recovery (DR):
  Implemented and maintained Log Shipping, Database Mirroring, Always On Availability Groups, and Clustering.
  Performed DR drill (switch-over/switch-back) activities to validate system resilience and recovery readiness.
  Configured Active-Passive SQL Clusters on Windows Server 2008 R2 and 2012 R2, and Always On with SQL FCI for SQL Server 2012 and 2016.
• Performance Tuning & Optimization:
  Analyzed and resolved locking, blocking, and deadlock issues.
  Reviewed query execution plans to identify full table scans and implicit conversions.
  Optimized queries by creating non-clustered indexes, improving performance and reducing resource overhead.
  Automated index defragmentation and statistics updates to maintain performance efficiency.
  Implemented Query Store and Dynamic Data Masking features in SQL Server 2016 for query analysis and data security.
• Monitoring & Maintenance:
  Conducted system health checks, monitored space utilization, and analyzed SQL Server and OS event logs for anomalies.
  Developed automated email alerts for low disk space, job failures, and daily backup status.
  Provided 24x7 support for critical production systems ensuring maximum uptime and reliability.
• Security & Access Control:
  Created and managed SQL logins and roles, ensuring least-privilege access per application requirements.
  Enforced SQL Server security policies and conducted regular audits to maintain compliance.