Sonu Kumar

Sonu Kumar Email and Phone Number

SQL Database Engineer - Performance Tuning | Expert in Query Optimization @ Sonata Software
bangalore, karnataka, india
Sonu Kumar's Location
Bengaluru, Karnataka, India, India
About Sonu Kumar

At Sonata Software, we prioritize database efficiency, where I specialize in enhancing SQL performance through meticulous query optimization and troubleshooting. My role revolves around collaborating with developers to streamline SQL queries and proactively address performance issues, ensuring our systems operate with optimal efficiency for our valued clients.Holding a Bachelor's degree in Engineering from Nitte Meenakshi Institute of Technology, I blend academic knowledge with certifications in Azure Fundamentals and Azure Data. My ambition is to harness these competencies to bolster Sonata Software's innovation and maintain our leading edge in database engineering.

Sonu Kumar's Current Company Details
Sonata Software

Sonata Software

View
SQL Database Engineer - Performance Tuning | Expert in Query Optimization
bangalore, karnataka, india
Employees:
4671
Sonu Kumar Work Experience Details
  • Sonata Software
    Sql Database Engineer - Performance Tuning
    Sonata Software May 2022 - Present
    Bengaluru, Karnataka, India
    •Expertise in Query Optimization, Performance tuning, DMV'S, analysing Locks.•Verifying and tuning SQL Queries written by developers by using execution plan, Database tuning advisor and improving efficiency in database including reindexing, updating statistics.•Troubleshooting escalated performance issue on production environment for premier/VIP customer•Intensive experience in Monitoring and tuning SQL server and database performance tuning using SQL Server Management… Show more •Expertise in Query Optimization, Performance tuning, DMV'S, analysing Locks.•Verifying and tuning SQL Queries written by developers by using execution plan, Database tuning advisor and improving efficiency in database including reindexing, updating statistics.•Troubleshooting escalated performance issue on production environment for premier/VIP customer•Intensive experience in Monitoring and tuning SQL server and database performance tuning using SQL Server Management Studio. •Identify the root cause of performance issue(Blocking, High CPU, Deadlock) and resolving them•Fixing hygiene issue for every Severity -2 Incidents & post-mortem review. •Assisting and collaborating solution Architect/ACE engineer to solve Azure SQL Performance/Availability issue on ERP and CRM side.•Ensuring minimal downtime for DB migration and failover.•Troubleshooting issue to with log file full and database size increasing beyond threshold.•Experience in solving database issue with index fragmentation, Optimization of Query, Index tuning, Update statistics, SQL Error. Show less
  • Sonata Software
    Azure Sql Dba And Sql Performance Engineer
    Sonata Software Apr 2020 - Apr 2022
    India
    •Expert in analysing and fixing SQL Server performance issue such as high CPU, memory, blocking, wait stats, deadlock & storage issue.•Analysing SQL Execution plan, Performance reports and troubleshooting performance issue using Query store and extended events. •Optimize slow queries by creating Index, update stats, Query Hints & plan guides.•Debug complex customers issue using Kusto Explorer.•Creating DB maintenance plan. DB Backup and restoration… Show more •Expert in analysing and fixing SQL Server performance issue such as high CPU, memory, blocking, wait stats, deadlock & storage issue.•Analysing SQL Execution plan, Performance reports and troubleshooting performance issue using Query store and extended events. •Optimize slow queries by creating Index, update stats, Query Hints & plan guides.•Debug complex customers issue using Kusto Explorer.•Creating DB maintenance plan. DB Backup and restoration activity•proficiency in creating and managing SQL server Agent Jobs•Analysing clients environment and providing recommendation on SQL performance metrics like CPU, Memory & SQL server configuration in case of overall performance issue•Helped app team/customer support to debug common SQL Server issue before reaching out to Engineering team•Helped database monitoring team to detect & create alert for DB performance and Availability issue before customer raised an Incident •Applying Microsoft recommended best practices on SQL Server•Providing 24/7 on call supports for customers of Microsoft. •Troubleshooting database connectivity issue.•Troubleshooting escalated issue on production environment for premier or VIP Customers of Microsoft within SLA. •Performing SQL DB Tier Upgrade/Downgrade & Hyperscale Migration ensuring minimal downtime. •Assisting support engineer in resolving broad business and SQL server technology problem in a timely manner •Experience in using SQL DMV to identify SQL server issue.•Strong knowledge in SQL Concepts and T-SQL scripting •Administering thousand of azure SQL DB for different customers.•Speaking with clients/application and development team regarding SQL issue till it gets resolved.•Review every customer reported incidents and add Automation alert to detect those specific issue and self heal before customer gets impacted Show less
  • Sonata Software
    Azure Cloud Engineer
    Sonata Software Nov 2019 - Mar 2020
    Bengaluru, Karnataka, India
    Create, manage and optimize resources in Azure including virtual machine, storage accounts &networking components. This involves using the Azure portal
  • Sonata Software
    Etg
    Sonata Software Sep 2019 - Nov 2019
    Sonata Software trained on various software technologies and tools

Sonu Kumar Education Details

Frequently Asked Questions about Sonu Kumar

What company does Sonu Kumar work for?

Sonu Kumar works for Sonata Software

What is Sonu Kumar's role at the current company?

Sonu Kumar's current role is SQL Database Engineer - Performance Tuning | Expert in Query Optimization.

What schools did Sonu Kumar attend?

Sonu Kumar attended Nitte Meenakshi Institute Of Technology.

Who are Sonu Kumar's colleagues?

Sonu Kumar's colleagues are Vidya Voichal, Kishor Bg, Nuthan Kumar K, Mahesh Hugar, Periyasamy K, Sai Kiran Ediguttu, Sriram Chadaram.

Not the Sonu Kumar you were looking for?

  • Sonu Kumar

    Software Engineer @Accenture || Full Stack Engineer Intern@Cognizant || Chandigarh University
    Aurangabad
  • Sonu Kumar

    Senior Shopify Developer | Liquid | App Development
    Delhi, India
  • Sonu kumar

    Machine Learning Engineer(Ai) @Terradx Technologies | Assistant Head Placement Coordinator @Iit Patna | Mtech Ai | Iit Patna
    Patna
  • Sonu Kumar

    4X- Google Cloud Certified | Professional Data Engineer| 2.8+ Yoe @ Tata Consultancy Services | | Etl Developer | Abinitio | Informatica Powecenter | Unix | Trw - Lineage
    Kolkata

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.