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
05.2022 - 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
04.2020 - 04.2022
- 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
12.2019 - 03.2020
- 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
05.2022 - Current
Azure SQL DBA
Sonata Software Limited
04.2020 - 04.2022
Azure Cloud Engineer
Soanata Software Limited
12.2019 - 03.2020
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
SUMANTH VARMA KALLEPALLISUMANTH VARMA KALLEPALLI
Systems analyst at Sonata Software LimitedSystems analyst at Sonata Software Limited
Mamillapalli KarthikeyaMamillapalli Karthikeya
Consultant at Sonata Software LimitedConsultant at Sonata Software Limited
Abdul Rawoof MohammedAbdul Rawoof Mohammed
Senior Engineer at Sonata Software LimitedSenior Engineer at Sonata Software Limited