Swapnil Naik

• Handling SQL Servers, PostgreSQL, MySQL and Percona Databases on multiple Data-Center. • Maintaining Zabbix, Grafana and ElasticSearch monitoring tool. • Maintaining and Optimizing Database Migration Jobs • Creating and Maintaining Elastic Search Indexes. • Implementing Linux servers with Ansible and Jenkins Pipeline.

• Providing solutions and implementing best practices for Azure Virtual Machines, Backups, Azure SQL PaaS databases. • Responsible for the Management of 200+ azure VM IaaS Database Servers. • Performing DR Drill activities on SQL PaaS databases. • Providing Performance tuning solutions on High Level Applications. • Performing migrations activities for multiple applications.

• 24x7 Production Support and Monitoring. • Monitoring the Health and Performance of servers. • Daily Maintenance of SQL Servers included reviewing SQL error logs, Event Viewer. • Creating daily handovers and monthly server health reports.

• Has Providing DBA support for application development, maintenance and up gradation. • Responsible for the Management of 75 VM IaaS Database Servers with maximum database size is approx. 4.1 TB • Implementing Geo-replication, Auditing, TDE, automatic tuning on SQL PaaS database • Creation of Virtual Machines, Virtual Networks, Storage, Backups (VM level & File- Folders level) on Azure as per requirement. • Creating Active Directory Account with constrained access.

• Responsible for the Management of 40 Database on-premise Servers with maximum database size is approx. 1 TB. • 24x7 Production Support and Monitoring. • Backing up of critical databases and set DR on it. • Table achieving and partitioning table to improve I/O performance. • Importing data, logins and jobs to Databases through SSIS.

• Responsible for the Management of 15 DB Servers with maximum database size is approx. 300 GB. • Installation & up-gradation of SQL Server 2005 and SQL Server 2008/ SQL Server 2008 R2. • Daily Maintenance of SQL Servers included reviewing SQL error logs, Event Viewer. • Creating daily handovers and monthly server health reports. • Configuring, Monitoring and troubleshooting Transition and Merge Replication • Performing all backup strategies and crash recovery of the databases.