Shovan Kar

Senior Software Engineer

India17 yrs 7 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Over 17 years of experience in database optimization.
Achieved $24 million annual savings through resource optimization.
Expertise in managing over 7 million Azure SQL databases.

Stackforce AI infers this person is a SaaS Database Performance Optimization Expert.

Contact

Skills

Core Skills

Azure SqlMicrosoft Dynamics CrmPerformance Tuning

Other Skills

Microsoft Power AutomateService-Level Agreements (SLA)RCAKusto Query Language (KQL)Transact-SQL (T-SQL)Cost AnalysisResource OptimizationAutomationSystem StabilityMicrosoft SQL ServerSQLBusiness IntelligenceData WarehousingWindows PowershellWindows Cluster

About

With over 17 years of experience in application scalability, database optimization, and automation, I currently serve as a Senior Software Engineer at Microsoft. In this role, I contribute to the Dataverse Data Engine team, where we manage and optimize over 7 million Azure SQL databases supporting the cloud-based Dataverse platform for Dynamics CRM and FnO. My work focuses on enhancing database performance, implementing automation, and ensuring operational stability across a diverse and extensive system infrastructure. Leveraging expertise in Azure SQL, Microsoft Dynamics CRM, and root cause analysis (RCA), our team ensures the seamless operation of databases supporting mission-critical CRM and ERP solutions across multiple global data centers. I am driven by a commitment to optimizing resource utilization and delivering cost-saving solutions, including a notable $24 million annual savings through vCore reduction and pool consolidation.

Experience

17 yrs 7 mos

Total Experience

4 yrs 4 mos

Average Tenure

9 yrs 3 mos

Current Experience

Microsoft

4 roles

Site Reliability Engineer II @ Microsoft

Jan 2019 – Jul 2019 · 6 mos

Senior Software Engineer

Promoted

Mar 2018 – Present · 8 yrs 3 mos

Spearheaded automatic query tuning across a fleet of over 7 million Azure SQL Databases, enhancing performance and reliability.
Achieved $24 million/year in cost savings through vCore reduction and pool consolidation, optimizing resource utilization.
Co-developed a self-healing platform that mitigated over 9,000 ICM alerts monthly, ensuring high product stability.
Identified 30+ product bugs in both Azure SQL DB and Dynamics CRM product and led the fixes to completion.

Microsoft Power AutomateService-Level Agreements (SLA)Microsoft Dynamics CRMAzure SQLRCAKusto Query Language (KQL)+2

software Engineer II

Promoted

Jul 2017 – Sep 2022 · 5 yrs 2 mos

Working as a SWE-II for Dynamics CRM Common Data Platform team which serves as the data platform of Dynamics CRM Online Organization. The team owns ~ 700000+ production Azure SQL databases across the globe which serves as the Data Platform for Dynamics CRM, Dynamics AX and PowerApps products.
Key Responsibilities:
Working as the single point of contact for any database related issues from India team.
End to end ownership of database performance for OCE, APAC, EMEA, India region customers.
Driving various automations to tune database performance.
Hands on experience is database tuning both On-Prem and Azure SQL
Work with Azure SQL PG and provide feedback on the product.
Implement new database features to work in conjugation with Common Data Service (CDS) framework.
Ownership of various components of CDS.
Handling live-site issues, mitigation and RCA.
Investigation of ongoing product issues / Bugs and providing mitigation.
Conducting knowledge sharing sessions for team members.
Creating reusable artefacts for the team.