Amit Yadav
Deputy Manager-IT at SBI Securities|| Ex-Wipro || Azure SQL DBA || AWS RDS || GCP || Performance Tunning || Always On || Mirroring || Log Shipping || Replication || SQL Clustering || Cloud Migration ||
- Role
- Deputy Manager of Information Technology at SBI Securities
- Location
- Mumbai, MH, IN
- LinkedIn followers
- 500 followers
About Amit Yadav
With over 7+ years of experience as a SQL Server Database Administrator, Junior Azure SQL Database Administrator with a focused skill set developed over 2 years. Proven experience in Azure Database Administration, SQL Server Installation, Configuration, and Management. I possess hands-on experience in Azure PaaS and IaaS services. I excel in installing, configuring, monitoring, and troubleshooting SQL Server environments. My proactive approach includes regular health check-ups, monitoring SQL errors in SCOM, SolarWinds tools and implementing SQL alerts for comprehensive system management. Proficient in managing logins, users, roles, and permissions, I have hands-on experience with database consistency checks, backup and restore procedures, and performance tuning, high availability solutions, and disaster recovery planning. My expertise includes not only technical proficiency but also a strategic approach in handling complex database environments.Key Skills-• Installation, configuration, and management of SQL Server versions to 2022. • Proactive health check-up and monitoring of SQL Server. • Applying patches and service packs on standalone and cluster servers. • Managing Logins, Users, Roles, and User Permissions. • Performing database consistency checks using DBCC commands. • Database Backup, Restore, Migration, and upgradation of SQL Servers. • Using SQL Server Profiler and Perfmon counters to trace performance-related issues. • Configuring, monitoring, and troubleshooting SQL Server clustering. • Configuring, monitoring, and troubleshooting SQL Server AlwaysOn. • Implementing, monitoring, and troubleshooting Log Shipping and DB Mirroring. • Experience in Azure SQL PAAS, IAAS - Server, Database creation, and maintenance. • Backup policy configuration on Azure. • Database movement and Database restore (PITR, LTR). • Regular monitoring of servers, including Backup Jobs, maintenance jobs, and troubleshooting. • Configuring Database Mail, Managing Operators, and alerts. • Analysing and providing solutions for locking, blocking, and deadlock-related issues. • Analysing duplicate, unused, and bad indexes to optimize server resources. • Index management, including creating non-clustered indexes and performing index defragmentation. • User creation and permission assignment based on application requirements.• Health checking and performance monitoring of systems. • Automated Email Notification setup for alerts and reports. • Experience in DR-Drill (Switch-over and Switch-back) activities.
Experience
Deputy Manager of Information Technology
Oct 2024 — Present · Mumbai, IN
Education
Vidyavardhini's College of Engineering and Technology
Bachelor of Engineering - BE, Electrical, Electronics and Communications Engineering
University of Mumbai
Bachelor's degree (B.E), ELECTRONICS AND TELECOMMUNICATION ENGINEERING
2015
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.