Swapnil Naik
Angestellt, MSSQL SME, Infosys Consulting
Heidelberg, Deutschland
Über mich
Thank you for viewing my profile. Having 7+ years of experience of working in a dynamic work environment and extensive knowledge of SQL & Azure. Focused on promoting business growth by providing superior value and service to the customer. • Worked with Customers across the world in a multinational professional Services Firm, E-commerce, Finance, Telecommunication, Postal & Logistics, and Sports & Fitness domains • Responsible for designing, sizing, documenting, installation and support of Windows as an OS and MS SQL as the database. • Experienced in the migration of SQL Server databases from on-premise to AZURE Iaas/PaaS. • Provided DB support during Migration of projects from Oracle DB to SQL DB • Databases migration from PostgreSQL to SQL on premises. • Creating and maintaining SQL IaaS and PaaS databases • Extensive knowledge on PostgreSQL, NoSQL • Experienced in PowerBI tool and scripting in PowerShell and Python • Experienced in Azure DevOps, Ansible and Jenkins
Werdegang
Berufserfahrung von Swapnil Naik
Bis heute 1 Jahr und 6 Monate, seit Nov. 2022
MSSQL SME
Infosys Consulting
2 Jahre und 2 Monate, Sep. 2020 - Okt. 2022
Site Reliability Engineer
Verivox GmbH / ProSiebenSat.1 Media SE
• 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.
1 Jahr und 6 Monate, Apr. 2019 - Sep. 2020
Senior Azure SQL DBA
Globant
• 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.
9 Monate, Mai 2016 - Jan. 2017
Database Administrator
Angel Broking
• 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.
1 Jahr und 4 Monate, Jan. 2015 - Apr. 2016
Database Administrator
OnePointOne
• 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.
Ausbildung von Swapnil Naik
5 Jahre und 2 Monate, Juni 2009 - Juli 2014
Information technology
Shivaji University
Sprachen
Englisch
Fließend
Deutsch
Grundlagen