Amitkumar Yadav
With over 8+ years of experience as a SQL Server Database Administrator, Junior Azure SQL Database Administrator with a focused skill set developed over 3 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.
Airoli
Summary
Seeking a challenging role as a Senior SQL Server Database Administrator in a progressive organization where I can leverage my extensive 8+ years of experience to provide leadership in database management, contribute to strategic decision-making, and drive continuous improvement.
Total 8+ years of experience as a SQL Server Database Administrator With over 8+ years of experience as a SQL Server Database Administrator, Junior Azure SQL Database Administrator with a focused skill set developed over 3 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.
Overview
10
10
years of professional experience
1
1
Certification
3
3
Languages
Work History
Deputy Manager
SBICAP Securities
10.2024 - Current
- Led the design and implementation of high-availability and disaster recovery solutions, including AlwaysOn Availability Groups, Log Shipping, and Replication.
- Conducted advanced performance tuning and query optimization using execution plan analysis, indexing strategies, and resource utilization metrics.
- Owned capacity planning for SQL Server environments, forecasting growth trends and proactively scaling infrastructure to meet business demands.
- Acted as the final escalation point for critical incidents, performing detailed Root Cause Analysis (RCA) and implementing permanent fixes to prevent recurrence.
- Managed and resolved high-priority tickets through Service Manager, ensuring timely response and resolution aligned with SLAs and ITIL practices.
- Drafted and executed Plans of Action (POA) for major incidents, migrations, and upgrades, ensuring minimal downtime and effective risk mitigation.
- Enforced database security policies, including encryption, access control, and auditing, to ensure compliance with regulatory standards (e.g., GDPR, HIPAA, SOX).
- Implemented Transparent Data Encryption (TDE) on databases in current environments to secure data at rest and meet compliance requirements.
- Automated routine administrative tasks using PowerShell and T-SQL, improving operational efficiency and reducing manual effort.
- Designed and validated backup and recovery strategies to meet RTO/RPO requirements, including regular restore testing and comprehensive documentation.
- Implemented enterprise-grade monitoring solutions and generated health check reports to proactively manage database performance and availability.
- Mentored and guided L1/L2 DBAs, conducted technical training sessions, and reviewed change requests for quality and compliance.
- Participated in Change Advisory Board (CAB) meetings, ensuring risk mitigation and rollback planning for production deployments.
- Collaborated with cross-functional teams, including application developers, infrastructure engineers, and business stakeholders, to align database solutions with organizational goals.
- Led cross-functional initiatives to enhance operational efficiency, streamline processes, and improve service delivery.
- Developed and implemented strategic plans to achieve organizational goals and objectives, aligning database architecture with long-term business vision.
- Mentored junior staff, fostering professional growth, knowledge sharing, and enhancing overall team performance.
- Analyzed data trends and system metrics to inform decision-making, optimize resource allocation, and improve service delivery.
- Maintained documentation and knowledge base articles for internal use, ensuring continuity and ease of onboarding for new team members.
- Evaluated and implemented new database technologies and features, staying current with SQL Server advancements and industry best practices.
Senior Database Administrator
Wipro Limited
01.2022 - 10.2024
- Installation & Configuration of SQL Server /2008 R2/2012/2014/2016/2017/2019 standalone installations and Azure db.
- Azure SQL PAAS, IAAS – Server, Database creation and maintenance.
- Backup policy configuration on azure.
- Database movement and Database restore (PITR, LTR).
- Job creation through Elastic job agent.
- Experience in server level tuning, query level tuning and troubleshooting performance issue using SQL Server Profiler, Database Tuning Adviser.
- Providing 24x7 technical database supports for SQL Database systems.
- Experience on applying the latest service packs & hot fixes.
- Continuously monitoring and updating the Backup & Recovery strategy and monitoring scheduled jobs of backup and restore procedure for database.
- Having experience on database backup and restorations.
- Configured Linked servers SQL to SQL & SQL to Oracle.
- Implemented Dynamic masking on SQL 2016 DB.
- Implemented Query store to analyse regressed queries and force plan if new plan of query is taking more time for query execution.
- Experience on high Availability solutions like, Log Shipping, Clustering and Always On.
- Migration of UAT server and Production servers.
- Knowledge on Replication & DB Mirroring.
- Security Hardening Role.
- Resolving Space management issues like Database and log file space issues.
- Implemented database refresh and troubleshooting orphaned users.
- Having experience on creating login, resetting password, giving roles to user.
- Working on file movement activities as per request with application teams.
- Database consistency check using DBCC utilities.
- Troubleshooting transaction logs and Tempdb when full.
- Monitoring SQL Server agent jobs/maintenance plans.
- Resolving tickets with in SLA.
- Having good experience to keep best handover.
- To keep maintain all server’s password into sheet.
- Resolving the Disk space issues and finding the root cause and implementing the permanent fixes.
- Good experience in configuring the all kinds of backups.
Senior Technical Consultant
Clover Infotech Pvt Ltd
02.2018 - 01.2022
- Responsible for day-to-day tasks like re-indexing, checking integrity, backup, and recovery.
- Performed Multiple Installation of SQL Server 2008R2/2012/2014/2016/2017.
- Strong Experience in Backup, Recovery strategy.
- Performed no of Patch Management on standalone, cluster Server and Always ON Server.
- Performed no of SQL server Migration including version (2008r2,2012,2014,2016,2017,2019).
- Implemented SQL server best practices, pre and post Migration checks.
- Creating SQL objects like Tables, Stored Procedures, Views, and Indexes.
- Implemented SQL Server Hardening and Managing permissions related to logins & users.
- Creating SQL Jobs, Maintenance plans, linked servers.
- Database mail alert configured for Low Disk space, Failed Job, SQL server restart, long running queries, deadlock alert, high CPU utilization, Blocking and high memory utilization.
- Configured log shipping, replication, DB mirroring, SQL Always On.
- Review Windows Event Logs, SQL Server Error Logs and Agent Log to Identity the critical errors and resolve them.
- Created jobs to perform re-indexing and update the index statistics.
- Configured audit & trigger on SQL database server from security point of view.
- Experience in performing integrity and consistency checks.
- Experience in troubleshooting SQL issues.
- Experience in SSRS & SSIS server issues troubleshooting.
- Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
- Performed Disaster recovery (DR) drill and implemented DR plan.
- Having Experience in Fixing Database Corruption Issue.
SQL Server Database Administrator
Nityo Infotech Services Pvt. Ltd
04.2017 - 01.2018
- Performed Multiple Installation of SQL Server 2008R2/2012/2014/2016.
- Providing application support to various critical applications such as HRMS, CRM, Esigner, BOMS etc.
- Performing BOD & EOD activities and taking Backups of databases.
- Monitoring MS SQL server Jobs.
- Coordinating for Application Support issues with different Application teams.
- Ensuring the completion of all business-related critical backend task.
- Developing SQL queries for Ad-hoc data which is to be provided of all the applications used in organization.
- Fixing bugs for critical tasks executed on daily basis.
- Also developing the queries for audit purpose monthly/quarterly.
Junior Software Engineer
InnovTech Software Enterprises
12.2015 - 03.2017
- Installing and configuring hardware and software.
- Diagnose and troubleshoot software and hardware problems.
- Provide support for hotel industry software.
- Perform SQL Database Backup and Restore.
- Application Software Monitoring.
- Resolving network issues.
- Provide data using T-SQL as per business requirement.
- Following up with clients to ensure the problem is resolved.
Education
B.E - EXTC
CLSSS
Mumbai06-2015
HSC - undefined
Maharashtra
06-2009
SSC - undefined
Maharashtra
06-2007
Skills
Installation & Configuration of SQL Server
Interests
Travelling
playing cricket
cooking
Personal Information
- Date of Birth: 1992-07-05
- Gender: Male
- Nationality: Indian
- Marital Status: Married
Personal data processing
I hereby declare that the above furnished information is true to the best of my knowledge.
Certification
AWS
Timeline
Deputy Manager
SBICAP Securities
10.2024 - Current
Senior Database Administrator
Wipro Limited
01.2022 - 10.2024
Senior Technical Consultant
Clover Infotech Pvt Ltd
02.2018 - 01.2022
SQL Server Database Administrator
Nityo Infotech Services Pvt. Ltd
04.2017 - 01.2018
Junior Software Engineer
InnovTech Software Enterprises
12.2015 - 03.2017
HSC - undefined
Maharashtra
SSC - undefined
Maharashtra
B.E - EXTC
CLSSS