Gyanendra Yadav
Pune,
Summary
Seasoned SQL Server Admin with 13 years of experience, including SQL Server on Linux, focused on cloud migration, performance tuning, and complex upgrades. Proven ability to lead cloud migrations to Azure/GCP and reduce resource costs. Skilled in team management and end-to-end project execution, from design through delivery. Strong record of stakeholder collaboration and proactive problem-solving.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Senior SQL Server DBA
MSCI
02.2022 - Current
- Managing SQL Server environments across On-Premises, Azure and GCP on Windows and Linux VMs, optimized for mission-critical, terabyte-scale databases
- Leveraged GCP and Azure services for patch and vulnerability management
- Led the setup of GCP-to-Azure Distributed Availability Group (DAG) to ensure business continuity and load balancing
- Integrated CommVault IntelliSnap with Pure Storage to refresh terabyte-scale databases in minutes, reducing downtime and enhancing operational efficiency
- Increased client satisfaction through extensive analysis of project requirements and delivering high-quality results.
- Developed standard operating procedures and improvement exercises, reducing trouble tickets by 30-40%
- Handling critical P1/P2 incidents with urgency, orchestrating war room calls to restore application availability and minimize downtime
- Mentored junior associates, fostering professional growth and helping them reach their full potential
Lead SQL Server DBA
Reckitt / Infosys Technologies
09.2016 - 02.2022
- Led large-scale cloud transformation project, migrating on-prem databases to Azure, including SQL Server and IBM DB2
- Designed and implemented HADR solutions leveraging SQL Clustered AG, Clusterless AG, and IBM DB2 HADR
- Led upgrade and migration of 100+ SQL Server instances, modernizing Windows and SQL Server infrastructure
- Responsible for end-to-end SQL Server administration, including design, installations, configurations, and performance tuning for versions 2012 through 2019
- Played crucial role in ransomware recovery project (‘NotPetya’), ensuring rapid recovery of 350+ SQL Servers
- Collaborated closely with international clients to ensure project delivery aligned with business needs
- Introduced agile practices using Azure DevOps, streamlining team processes and improving project management
- Successfully completed cloud migration project, moving critical databases to Azure with minimal downtime
- Improved database performance through query optimization and index tuning
SQL Server DBA
AstraZeneca / Infosys Technologies
10.2011 - 08.2016
- Installed, configured, and maintained SQL Server instances from 2000 through 2012, supporting Data Centre Migration projects
- Implemented SQL Server failover clusters with multi-node setups and managed HADR configurations including Replications, Log Shipping, and Mirroring
- Migrated and upgraded SQL Server environments, including cross-database migration from Oracle 10g to SQL Server 2012
- Handled partitioning, performance monitoring, and system optimization using SQL Profiler and tuning tools
- Conducted security audits, managed access control, and ensured compliance during third-party audits from KPMG and Ernst & Young
- Led the successful migration of SQL Server failover clusters during a critical Data Centre relocation
Education
Bachelor of Engineering - Electronics And Communications Engineering
Anna University
Chennai, India05-2011
Skills
- Cloud – Azure and GCP
- Cloud Migrations - SQL IaaS & PaaS
- SQL Server 2012 to 2022
- SQL Server Design and Administration
- SQL Server on Linux
- HADR (Clusters, AG, DAG)
- Performance Tuning & Query Optimization
- Azure DevOps, Git, Python
- Jira, Confluence, PagerDuty, ServiceNow
- CommVault, SQLSentry, SCOM
- License Management & Cost optimization
- Project Leadership & Team Collaboration
- Client Interaction & Stakeholder Management
- Incident,Problem & Change Management
Certification
- Fundamentals of Red Hat Enterprise Linux
- Google Cloud Fundamentals: Core Infrastructure
- IBM Certified Database Associate – DB2 LUW 11.1
- Process Certification of Incident, Problem, and Change Management (ITIL)
- 70-462, Administering Microsoft SQL Server 2012/2014
Timeline
Senior SQL Server DBA
MSCI
02.2022 - Current
Lead SQL Server DBA
Reckitt / Infosys Technologies
09.2016 - 02.2022
SQL Server DBA
AstraZeneca / Infosys Technologies
10.2011 - 08.2016
Bachelor of Engineering - Electronics And Communications Engineering
Anna University
Similar Profiles
Adrián David Cantú MárquezAdrián David Cantú Márquez
Equity Data Management Analyst at MSCIEquity Data Management Analyst at MSCI
Harendra SinghHarendra Singh
Vice President at MSCIVice President at MSCI
MANSI V MANJREKARMANSI V MANJREKAR
Financial Analyst at MSCIFinancial Analyst at MSCI