Sonu Kumar

Azure SQL Database Administrator with 5 years of experience specializing in Azure SQL performance tuning, query optimization, database migrations, and high availability (HADR) solutions. Proficient in DTU-based and vCore Azure SQL models, incident resolution, and leveraging tools like Query Store, Azure Monitor, and Kusto Query Language (KQL) for performance insights. Proven track record in scaling over 10,000 databases, automating backups, and resolving Sev 2-4 incidents.

Certified in Azure cloud technologies (DP-300, AZ-104) with excellent troubleshooting and collaboration skills

Senior Azure Database Administrator

Sonata Software Limited, Bengaluru, India (09/2022 – Present)

Azure Database Administrator

Sonata Software Limited, Bengaluru, India (09/2020 – 08/2022)

• Expertise in SQL Performance Tuning: Optimized Microsoft Dynamics F&O and CRM databases by troubleshooting long-running queries, high CPU usage, deadlocks, memory issues, and TempDB space constraints.
• Database Scaling & Migration: Successfully upscaled and downscaled 10,000+ Azure SQL databases based on workload demands and migrated on-premises SQL databases to Azure using DMA, DMS, and SSMS.
• High Availability & Disaster Recovery (HADR): Configured Active Geo-Replication and Auto-Failover Groups, ensuring database resilience and failover readiness.
• Backup & Recovery Management: Configured Point-in-Time Restore (PITR), Long-Term Retention (LTR), and automated backup strategies for critical databases.
• Advanced Query Optimization: Conducted APRC investigations, optimized execution plans using Query Store, and utilized Database Tuning Advisor (DTA) for indexing strategies.
• Database Monitoring & Alerts: Implemented real-time monitoring using Query Performance Insight, Azure Monitor, and set up alerts for DTU usage, CPU, and database growth.
• Security & Compliance: Managed RBAC, Azure Defender, database auditing, data masking, and Row-Level Security (RLS).
• Incident Management & Support: Provided 24/7 production support, resolving Sev 2–4 incidents, database failures, and optimizing performance bottlenecks.

Sonata Software Limited, Bengaluru, India (09/2019 – 08/2020)

• Managed Azure virtual machines, networking (VNets, NSGs), and storage solutions.
• Configured Azure Application Gateway, Load Balancers, and Traffic Manager.
• Provisioned and maintained cloud resources, ensuring security and performance efficiency.

Technical Skills

• Azure SQL Database: Performance tuning, indexing, DTU & v-Core optimization
• SQL Server: Query Store, Execution Plans, T-SQL, Extended Events, CDC
• Azure Infrastructure: Virtual Machines, Networking, Active Directory, Azure Monitor
• Security & Compliance: Role-based access control (RBAC), data masking, encryption
• Automation & Scripting: PowerShell, SQL Agent Jobs, Database Maintenance Plans

Certifications

• DP-300: Administering Relational Databases on Microsoft Azure (Jan 2024)
• AZ-104: Microsoft Azure Administrator (Apr 2024)
• AZ-500: Microsoft Azure Security Technologies (Expected Nov 2024)
• AZ-305: Designing Microsoft Azure Infrastructure Solutions

Bachelor of Engineering: Electrical, Electronics and Communications Engineering, 08/2019 Nitte Meenakshi Institute of Technology Bengaluru