Amol Patil Email & Phone Number

Pune, Maharashtra, India

• Performed Migrations/upgrades from lower versions of SQL server 2008 and 2008R2 to the higher versions 2012, 2014, 2016, 2019 and 2022 depending up on application compatibility.
• Performed standard database maintenance activities such as backup/restore, re-indexing, log file management, security patching, etc.
• Responsible for maintenance of all the SQL Servers, SQL Azure Pass servers and managed instances in the Environment.
• Migrated databases from On-premises to Azure using bacpac files, DMA, lift and shift methods.
• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
• Implemented Always-ON (AAG) on SQL Server 2012,2016,2019 and 2022 servers and configuration of Always-ON on Azure VM’s by setting load balancer, health probe, DNS etc.

Pune, Maharashtra, India

• Global SQL Management console project is used to connect all the SQL servers with the whole information of SQL server related to maintenance, performance, security etc. like job status, logs and service accounts info.
• Archiving synchronization: Archiving server holds backup of all production (Vishay) servers. Archiving tool is using for synchronizing data with production servers daily.
• This tool is running on archiving server for comparing data from all production servers with itself and checks deviation. If it found missing data on archiving server, it restores it from production servers and update.
• Work with the Designers to gain a proper knowledge of the requirements.
• Demonstration of the project. Creation of SQL accounts and assigned privileges to SQL user.
• Code analysis: Created procedures, views, functions, queries.

Pune, Maharashtra, India

• Managing SQL Server Security, Database Permissions, and adding/revoking permissions to users.
• Applying Database, windows patches and Performing Health Check on the instances followed by a smoke test soon after a patch is applied.
• Meet the SLA (Service Level Agreement) established.
• Day-to-day administration of live SQL Servers.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Responsible for monitoring and making recommendations for performance improvement which in turn requires index creation and modification, file group modifications, and adding scheduled jobs to re-index and update.

Bachelor Of Engineering - Be, Computer Engineering

Hsc, Computer Science, A

Ssc