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.• monitoring the database consistency at regular intervals.• Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.• Experience working with Performance Metrics and Plan Management in SQL Azure.• Monitored data activities such as database status, logs, space utilization, extents, Checkpoints, locks, and long transactions.• Adhered to Change Control Procedures and developed & executed scripted changes requests in accordance with change control procedures.• Performed Query Optimization to increase the performance by tuning SQL queries.• Implemented and maintained Database mirroring and Log shipping.• Perform Administrative tasks in SQL Server using PowerShell script, including installation of SQL.• Setup Azure Machines to meet security requirements such as Firewall, intrusion detections, etc.• Experience in Change Management and Problem Management which ensures/tracks code changes.• Worked on Server cleanup activity at Enterprise level using PowerShell scripts.• Azure Data Factory experience, Postgre SQL, My SQL• Participate in an on-call rotation for support of systems outside of normal business hours

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, password status etc. This project is used to show information about the SQL servers conveniently to the users .no need to connect every server and check manually to get information. for this project the back-end functionality will be used SQL and entirely new front end will be crafted using ASP .net.• 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 into database of archiving server.• 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. • Deployment of all SQL objects on all SQL servers.• Implemented high availability using Log shipping and Database mirroring.• Maintained SQL failover clustering for the production environments.• Rebuilding the indexes at regular intervals for better performance• Designed and implemented comprehensive Backup plan and disaster recovery. • Perform SQL Server service pack and Windows Service pack upgrades.• Working with customers on Application rollouts and server migrations.• Troubleshoot performance problems and fine-tuning of databases.• Involved in Index Analysis and Performance Tuning.• Implementation of company password policy for all SQL users as well as maintaining SQL service accounts• Worked on Always on high availability solution for SQL 2012

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 statistics in databases.• Monitoring SQL agent and batch jobs and troubleshooting then in case of any failures.• Worked on SQL Server migration from SQL Server 2008 /2005 to SQL server 2012. • Checking consistency in the database using DBCC utility. Rebuild the indexes and check index fragmentation and performing Reorg and Rebuild as per the recommendations.• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools & Application support.• Monitoring SQL server performance using SQL Profiler and by checking blockages and deadlocks.• Involved in designing Views, Stored Procedures, Functions and Tables required for project.• Responsible for the designing the advance SQL queries, procedure, scripts etc. • Performed failover exercises for Log Shipping and Mirroring.• Handled numerous change management requests.• Prepared and maintained SQL server installation and configuration documents.

Bachelor Of Engineering - Be, Computer Engineering

Hsc, Computer Science, A

Ssc