Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Sonu Kumar

Bengaluru

Summary

Meticulous SQL Performance Engineer with 4 years of experience optimizing Azure SQL database performance, adept at identifying bottlenecks and implementing effective solutions to enhance system efficiency. Seeking to leverage expertise in SQL tuning, query optimization, and database administration to contribute to the success of a dynamic organization.

Overview

4
4
years of professional experience
1
1
Certificate

Work History

SQL Performance Tuning

Sonata Software Limited
Bengaluru
2022.05 - Current
  • Analyze database performance metrics and identify areas for improvement
  • Optimize SQL queries to reduce execution time and improve resource utilization
  • Develop and implement indexing strategies to enhance query performance
  • Work closely with developers to review database schema design and suggest optimizations
  • Performing database tuning activities including parameter tuning, memory management, and storage optimization
  • Troubleshoot database performance issues and implement corrective actions
  • Document performance optimization techniques and best practices for knowledge sharing
  • Identify the root cause of performance issues (Blocking, High CPU, Deadlock) and resolving them
  • Troubleshooting issues with log size full and database size increasing beyond the threshold
  • Experience in solving database issues with index fragmentation, Optimization of queries, Index tuning, Update statistics, SQL Error
  • Troubleshooting escalated issues on production environment for premier or VIP Customers of Microsoft within SLA
  • Moved 1000's of a database from a Business Critical (BC) pool to a Hyperscale tier in SQL Server

Azure SQL DBA

Sonata Software Limited
Bengaluru
2020.04 - 2022.04
  • Experience in Monitoring and troubleshooting performance issues like long-running queries, CPU, Memory and I/O issues
  • Experience in creating and maintaining Azure SQL databases using the right tiers
  • Migrated on-premise SQL databases to AZURE Portal
  • Monitored Azure databases on weekly basis to cut costs on DTU basis
  • Implemented database integrity checks, updating statistics and reindexing
  • Monitoring and scheduled jobs on production and staging environment
  • Configure SQL / DB MAIL for sending server / database alerts
  • Responsible in Monitoring and Troubleshooting SQL Server Performance issues
  • Used the query store and Execution Plan to improve the optimization of the T-SQL code
  • Provided 24 x 7 Production support for the database and application issues
  • Installation and Configuring MSSQL Server 2005/2008/2008 R2/2012 on Dev, Test and Production boxes
  • Scheduling the Backups and performing the restoration
  • Support for huge Databases
  • Good exposure with SQL Server High Availability Always ON Availability Groups, DB mirroring, log shipping and clustering
  • Experience in supporting Very Large Database (VLDB) more than 2 to 4 TB and troubleshooting problems
  • Expertise in reading and understanding execution plan and fixing the query to execute with low cost
  • Scheduled Full and Transactional log backups for the user defined and system databases using the Database Maintenance Plan Wizard.

Azure Cloud Engineer

Soanata Software Limited
Bengaluru
2019.12 - 2020.03
  • Designed and configured Azure Virtual Networks (VNets), subnets, Azure network settings
  • Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets
  • Manage and Create Storage Account in Azure Portal
  • Strong foundational knowledge in cloud computing principles, specifically focused on Microsoft Azure
  • Excellent communication and teamwork abilities with a strong desire to learn and grow in a fast-paced environment
  • Participated in team meetings and provided updates on project progress and challenges.

Education

BE (A) - Electronics And Communications Engineering

Nitte Meenakshi Institute of Technology
08.2019

Skills

  • MS SQL Server Administration
  • T-Sql
  • Sql Backup & Restore
  • Query Optimization
  • Database Design
  • Database Management
  • Indexing Strategies
  • Normalization techniques
  • Database security
  • Server Configuration Tuning
  • Collaboration and Communication
  • Database Migration & Upgrades
  • Monitoring & Troubleshooting
  • High Availability and Disaster Recovery
  • Memory Management
  • TempDB Optimization

Certification

  • Microsoft Azure Fundamentals, 01/2023 - Present, AZ-900
  • Microsoft Azure Data Fundamentals, 03/2023 - Present, DP-900
  • Microsoft Azure AI Fundamentals, 07/2023 - Present, AI-900
  • Administering Microsoft Azure SQL Solutions, 01/2024 - 01/2025, DP-300

Timeline

SQL Performance Tuning

Sonata Software Limited
2022.05 - Current

Azure SQL DBA

Sonata Software Limited
2020.04 - 2022.04

Azure Cloud Engineer

Soanata Software Limited
2019.12 - 2020.03

BE (A) - Electronics And Communications Engineering

Nitte Meenakshi Institute of Technology
  • Microsoft Azure Fundamentals, 01/2023 - Present, AZ-900
  • Microsoft Azure Data Fundamentals, 03/2023 - Present, DP-900
  • Microsoft Azure AI Fundamentals, 07/2023 - Present, AI-900
  • Administering Microsoft Azure SQL Solutions, 01/2024 - 01/2025, DP-300

Similar Profiles

  • Mamillapalli Karthikeya

    Mamillapalli KarthikeyaMamillapalli Karthikeya

    Consultant at Sonata Software LimitedConsultant at Sonata Software Limited

    View Profile
  • VAMSI BANDI

    VAMSI BANDIVAMSI BANDI

    Project Manager at Sonata Software LimitedProject Manager at Sonata Software Limited

    View Profile
  • Anil Kumar

    Anil KumarAnil Kumar

    Lead Digital Engineer at Sonata Software LimitedLead Digital Engineer at Sonata Software Limited

    View Profile
Sonu Kumar