Gourav Kumar

About Gourav Kumar

Experienced SQL Server Database Administrator and SSRS Developer I am a results-oriented professional with over 5 years of expertise in SQL Server database administration and development. I specialize in designing, implementing, and maintaining robust database systems to support mission-critical business operations. My skill set includes advanced SQL programming, performance tuning, and high-availability solutions.Core Competencies:SQL Server Administration: Expertise in backup and recovery, disaster recovery (DR), and high-availability (HA) solutions to ensure data integrity and system reliability.Performance Optimization: Skilled in query optimization, indexing strategies, and database performance tuning to enhance system efficiency.Database Development: Proficient in creating complex stored procedures, functions, triggers, and views to support application development and data processing.Data Modeling and Design: Strong foundation in database architecture, schema design, and normalization for scalable and secure data systems.Cloud Integration: Hands-on experience with Azure SQL, hybrid cloud environments, and database migration projects.I am dedicated to staying current with emerging technologies, ensuring that the database solutions I manage are secure, scalable, and aligned with business needs. With a proven ability to collaborate with cross-functional teams, I excel at delivering customized solutions that meet organizational goals.Professional Objective:I aim to leverage my expertise in SQL Server database administration and development to drive operational excellence and support data-driven decision-making for forward-thinking organizations.

Experience

1. Lead Infrastuctre Engineer

   Mphasis

   Mar 2025 — Present · Bengaluru, IN

   Database Administration- Managed 550+ MSSQL Server instances across production, development, and testing environments- Automated daily backups, restores, and disaster recovery plans, achieving **99.9% uptime** for critical systems- Monitored database health using tools like SQL Profiler, SentryOne, and custom PowerShell scripts- Performance Optimization- Reduced query execution time by **40%** through index tuning, execution plan analysis, and DMV diagnostics- Implemented partitioning strategies to optimize large-scale databases (10+ TB) for faster data retrieval- High Availability & Disaster Recovery- Configured and maintained AlwaysOn Availability Groups and Log Shipping, minimizing downtime during failovers- Led disaster recovery drills, ensuring RPO/RTO compliance for mission-critical applications- Security & Compliance- Enforced data security protocols, including TDE encryption, role-based access control (RBAC), and audit logging- Ensured compliance with GDPR and HIPAA standards for sensitive customer and healthcare data- Automation & Collaboration- Developed PowerShell/T-SQL scripts to automate routine tasks (backups, index rebuilds, alerts), saving 15+ hours/month- Collaborated with DevOps and development teams to design efficient database schemas and optimize stored procedures. Technical Skills-MSSQL Tools: SQL Server 2012–2019, SSIS, SSRS, SSAS -HA/DR: AlwaysOn AG, Log Shipping, Database Mirroring -Tools: SolarWinds DPA, Redgate SQL Monitor, Azure Data Studio -Scripting: PowerShell, T-SQL, Python -Cloud: Azure SQL Managed Instance, AWS RDS (Basic) Achievements- Migrated 20+ legacy databases to SQL Server 2019 with zero downtime during business hours- Resolved a recurring deadlock issue impacting customer-facing apps, improving transaction throughput by 35%- Trained junior DBAs on best practices for query optimization and server maintenance.

Education

• NTTF (Nettur Technical Training Foundation)

  DIPLOMA, Computer Science

  2016 — 2019

• Singhania University

  Bachelor of Technology - BTech, Computer Science