Jagadeesh R
Senior MSSQL Server Database Administrator
Chennai, IN.About
Highly accomplished Senior MSSQL Server Database Administrator with 6+ years of experience in managing complex database environments across On-Premise, Azure Cloud, and AWS Cloud platforms. Proven expertise in ensuring high availability, performance optimization, and robust security for over 1000 servers and 1200 databases totaling 1TB. Adept at troubleshooting critical issues, implementing high-availability solutions, and driving efficient database operations to support dynamic business requirements.
Work
Wipro Technologies India Pvt Ltd
|Senior SQL Database Administrator
Chennai, Tamil Nadu, India
→
Summary
Led database administration for critical SQL Server environments at Wipro Technologies, ensuring high availability and performance for a global client base.
Highlights
Managed and optimized over 1000 SQL Server instances and 1200 databases, totaling 1TB, across On-Premise, Azure, and AWS cloud environments to ensure continuous operations.
Resolved critical SQL Server issues, including blocking, deadlocks, and disk space problems, consistently meeting SLA targets and providing permanent fixes.
Implemented and troubleshooted high-availability solutions such as Log Shipping, Database Mirroring (High Safety, High Availability, High Performance), and Transactional Replication.
Restructured, designed, and developed stored procedures using T-SQL programming, enhancing database efficiency and performance.
Executed SQL Server patching on On-Prem and Azure VMs, and performed PROD to UAT/DEV migrations, ensuring seamless updates and environment consistency.
Computer Age Management Services (CAMS)
|SQL Database Administrator (Data Analyst)
Chennai, Tamil Nadu, India
→
Summary
Administered SQL Server databases for CAMS Mutual Funds, focusing on data integrity, performance, and operational efficiency within a financial services context.
Highlights
Managed and monitored SQL Server environments (2012-2019) for CAMS Mutual Funds, ensuring database health and optimal performance.
Troubleshot and resolved database issues, including blockings, deadlocks, and fragmentation, to maintain system stability and data integrity.
Scheduled and maintained routine jobs and maintenance plans, ensuring consistent database operations and data availability.
Monitored Always On databases and DB Mirroring status, performing weekly validations post-patching to ensure high availability.
3i infotech
|SQL Database Administrator
Chennai, Tamil Nadu, India
→
Summary
Managed SQL Server databases for S3 Partners, a market-leading financial data and technology company, ensuring robust data infrastructure and operational continuity.
Highlights
Supported SQL Server environments (2008-2016) for S3 Partners, managing critical financial data infrastructure.
Addressed and resolved database issues, including backup failures, disk space alerts, and connectivity problems, maintaining system reliability.
Performed script executions and provided 24/7 on-call support, ensuring rapid resolution of urgent database issues.
Utilized monitoring tools like Idera and Redgate to track database stability and metrics, proactively addressing potential issues.
Sykes India PVT LTD
|SQL Database Administrator
Bengaluru, Karnataka, India
→
Summary
Administered SQL Server databases for Sykes Enterprises, supporting customer-engagement services for Global 2000 companies across AMER/APAC regions.
Highlights
Maintained and managed SQL Server environments (2005-2016) across Windows 2003-2016 servers, supporting 15+ pre-production and testing applications.
Installed, configured, and upgraded SQL Server 2008/2008R2/2012 in development and testing environments, ensuring robust infrastructure for new applications.
Resolved daily tickets related to database creation, maintenance, disk space, integrity, and blocking, ensuring efficient operations and high system availability.
Implemented Database Mirroring with High Availability Mode in SQL 2012, enhancing disaster recovery capabilities and minimizing downtime.
Education
Sri Venkateswara University
→
M.Sc.
Computer Science
Grade: 86%
Madras University
→
B.Sc.
Computer Science
Grade: 62%
Languages
English
Telugu
Tamil
Certificates
Microsoft Certified Solutions Associate (MCSA) – SQL 2016 Database Administration
Issued By
Microsoft
Skills
Tools & Technologies
Service-Now, 4me, Idera, Redgate, Dynatrace, Site 24/7, Perfmon, Accord, Commits, Ticket it, SQL Profiler, BCP, Import/Export Wizards, Commvault Backup, AWS Systems Manager, Azure Web Portal, DBCC Commands, DMVs, PowerShell.
Operating Systems
Windows Server (2003, 2007, 2012R2, 2014, 2016, 2019).
Database Management
MSSQL Server (2005, 2008, 2008R2, 2012, 2014, 2016, 2017, 2019, 2022), Database Backup & Recovery, Disaster Recovery Plans, Database Security, Performance Tuning, Index Reorganization, Index Rebuild, Database Fragmentation, Space Management, Database Migration, T-SQL Programming, Stored Procedures.
Cloud Platforms
Azure Cloud (Azure SQL PaaS, Azure SQL MI, Azure VM SQL, Azure Vault Blob Storages), AWS Cloud (EC2, RDS, S3 Bucket), Cloud Administration.
High Availability & DR
Log Shipping, Database Mirroring (High Safety, High Availability, High Performance), Transactional Replication, HADR Always On, Hardware Solutions Clustering (Active-Passive), Point-in-Time Recovery (PITR).
Troubleshooting & Monitoring
SQL Server Blocking Issues, Deadlock Issues, Disk Space Issues, Log File Full, Data File Full, Connectivity Issues, Performance Insight, Cloudwatch Events, Enhanced Monitoring, OS Process List, Metrics, Alert Mechanism, Root Cause Analysis, SLA Monitoring.
Database Operations
Patch Management, Data Purging, Data Archiving, Data Partitioning, User Access Management, Routine Job Scheduling, Maintenance Plans.