Summary
Overview
Work History
Education
Skills
Certification
Awards
Timeline
Generic

Ram Kumar G

Farmington Hills,MI

Summary

Accomplished Sr. Database Administrator with extensive experience at Pi-Square Technologies, specializing in high availability and performance optimization. Expert in Azure SQL and disaster recovery solutions, I excel in troubleshooting and automation, ensuring seamless operations and robust security for critical databases. Proven ability to lead migrations and enhance system reliability.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Sr Database Administrator

Pi-Square Technologies
Michigan
11.2021 - Current
  • Provided 24/7 Level 3 support for 800 SQL Servers, ensuring high availability and minimal downtime.
  • Managed SQL Server builds and operations for 70 clients across VMs, physical, and cloud environments.
  • Handled incidents, service requests, and change tickets in compliance with SLAs.
  • Managed SQL Server patching (CU, security updates) for database security and compliance.
  • Tuned performance and resolved issues like CPU, blocking, and deadlocks using SQL Profiler, DMV, and PerfMon.
  • Installed and hardened SQL Server 2012-2022 in clustered/non-clustered environments in Azure/GCP.
  • Led migrations to Always On Availability Groups (AOAG) and SQL version upgrades.
  • Configured and managed high availability and DR solutions (AOAG, Log Shipping, Failover Clustering).
  • Set up automated monitoring and alerts for proactive issue resolution.
  • Administered Azure SQL Databases for performance, scalability, and high availability.
  • Led migration of on-prem SQL Servers to Azure SQL Managed Instance and SQL Database.

Sr. Database Administrator

CBRE SOUTH ASIA pvt ltd
10.2017 - 10.2021
  • Provided 24/7 Level 3 support for 400 SQL Servers, including on-prem and Azure SQL Database environments.
  • Collaborated with business teams to design and configure SQL databases in hybrid environments (on-prem & Azure).
  • Managed Azure SQL Database performance, scaling, and high availability solutions like Always On and Geo-replication.
  • Managed incidents, service requests, and change tickets using ServiceNow, adhering to SLAs and ITIL practices.
  • Implemented high availability and disaster recovery solutions using Always On, Log Shipping, and Azure Site Recovery.
  • Troubleshot and optimized SQL performance using DMVs, SQL Profiler, PerfMon, and Azure Monitor.
  • Set up automated alerts for critical SQL parameters (disk space, blocking, replication) using Azure Monitor and Red Gate SQL Monitor.
  • Performed SQL Server patching to maintain up-to-date security, including Azure-specific updates.
  • Resolved backup failures (full, differential, transaction log) to ensure data protection and compliance.
  • Troubleshot SQL performance issues like space, log capacity, and TempDB full to ensure system stability.
  • Managed Azure-integrated SQL Server environments, supporting cloud backup and disaster recovery.

Sr. Database Administrator

Gavs Technologies pvt ltd
04.2016 - 08.2017
  • Managed complex SQL Server environments to ensure high availability and performance across production databases.
  • Troubleshot and resolved backup failures (Full, Differential, Transaction Log), ensuring data protection and compliance with backup policies.
  • Addressed issues like Data File/Log File Full and transaction log capacity warnings to optimize database performance.
  • Resolved critical database issues including TempDB Full errors, corruption, and recovery failures to minimize downtime.
  • Managed SQL Server Mirroring, Log Shipping, and Always On Availability Groups (AG) for high availability and disaster recovery.
  • Responded to customer-raised incidents (IR), resolving Log Shipping sync issues, job failures, and memory allocation problems.
  • Investigated and resolved SQL Server or Agent service failures to maintain consistent uptime and performance.
  • Worked with Azure SQL Database environments, implementing cloud-based backup and high availability solutions for critical workloads.

Database Administrator

Genpact
01.2010 - 01.2013
  • Installed, upgraded, and configured SQL Server instances (2008R2, 2012, 2014) in clustered and non-clustered environments, managed version upgrades, applied security patches, and performed configuration changes to enhance performance and security.
  • Actively participated in Change Management processes, following ITIL standards to plan, execute, and document changes while minimizing service disruption.
  • Built and configured Always-On Availability Groups (AOAG), Log Shipping, and Database Mirroring for high availability and disaster recovery.
  • Managed SQL Server configurations, maintenance, and cluster management to ensure security, performance, and fault tolerance for critical workloads.
  • Installed and managed SQL Server components (SSIS, SSRS, SSAS) as per customer requirements to enhance functionality.
  • Managed complex SQL Server environments for optimal performance.
  • Troubleshot and resolved SQL Server backup failures.
  • Resolved performance issues related to data files and logs.

Education

MBA - Human Resources Management

Andhra University
Visakhapatnam
06-2022

Skills

  • MS SQL SERVER DBA
  • AZURE SQL DBA
  • High Availability
  • Database Optimization
  • Indexing
  • Security
  • Database Installation
  • Configuration
  • Upgrades and Patching
  • Documentation and Reporting
  • Backup and Recovery
  • Performance Tuning
  • Clustering
  • Disaster Recovery
  • ETL
  • Automation
  • Documentation
  • Azure SQL
  • Cloud Integration
  • Always-on
  • Log-shipping
  • Monitoring and Maintenance
  • Data Migration
  • Troubleshooting

Certification

AZ-900 – Microsoft Azure Fundamentals – Certification Number - 105C39-7B84VD

DP-900- Microsoft Azure Data Fundamentals – Certification Number – 9318C5-ZD7084

DP- 300 – Microsoft Azure Database Administrator Associate – Certification Number – 09AHFF-114075.

Awards

  • Star Performer, Awarded by Pisquare Technologies Datacenter for optimizing 800+ SQL databases.
  • Best Innovator, Recognized by Pisquare Technologies for automating database maintenance, significantly improving efficiency.
  • Honored with Excellence, Received this award at CBRE for SQL performance tuning, enhancing query execution speed by 40%.

Timeline

Sr Database Administrator

Pi-Square Technologies
11.2021 - Current

Sr. Database Administrator

CBRE SOUTH ASIA pvt ltd
10.2017 - 10.2021

Sr. Database Administrator

Gavs Technologies pvt ltd
04.2016 - 08.2017

Database Administrator

Genpact
01.2010 - 01.2013

MBA - Human Resources Management

Andhra University

Similar Profiles

  • SIDDHARTH AHUJA

    SIDDHARTH AHUJASIDDHARTH AHUJA

    Marketing at Pi-TechnologiesMarketing at Pi-Technologies

    View Profile
  • Anil Kumar Sahu

    Anil Kumar SahuAnil Kumar Sahu

    Manager-HR & Admin at E Square System & Technologies Pvt. Ltd.Manager-HR & Admin at E Square System & Technologies Pvt. Ltd.

    View Profile
  • Shivam Patsariya

    Shivam PatsariyaShivam Patsariya

    Digital Media & Design Intern at Square Root Technologies (Advance Ontario)Digital Media & Design Intern at Square Root Technologies (Advance Ontario)

    View Profile
Ram Kumar G