Swabhiman Das

• Analyzing and Optimizing Prebuilt SQL Stored Procedure and Queries to achieve maximum performance benefits by analyzing Execution Plans or Changing query patterns
• Segregating OLAP workload from legacy database design to Azure Dedicated SQL Pool and Configuring Dataflow / Data - Transformation Pipeline on Azure Synapse Analytics to support Business Reporting
• Creating and Fixing Complex Tabular Data Models to gain optimal run time in Azure Analysis Servers
• Migrating On-Premise SQL Server to Azure SQL .
• Configured High Availability group for new SQL server 2016 on Azure VM
• Implementing Dynamic Data masking and Always Encryption to Secure Sensitive financial information
• Developing SQL Stored Procedures, Tables, Analysis Server models and Simple Power-BI reports by understanding corporate tax User Stories or Business Logics
• Troubleshooting and fixing SQL code bugs by analyzing API calls and Extended Event Traces
• Developing Azure Cosmos Retrieval Queries, Partitioning and Indexing strategy for Performance gain
• Automating SSAS full refresh and DACPAC deployment jobs by using PowerShell and scheduled through Azure Runbook
• Implemented proactive monitoring solutions to identify potential issues before they escalated into critical problems, minimizing disruptions to daily operations.
• Reduced data storage costs for clients by designing and implementing efficient data compression techniques.
• Supported business growth with scalable database architectures that accommodated increasing data volumes without compromising performance or reliability.
• Facilitated smooth software integration projects by working closely with developers, providing guidance on proper use of databases within their applications.
• Deployed and decommissioned environments for multi or single applications.

• Managed and Led Team of 20+ SQL server Support Engineer as Part of Microsoft Customer Service and Support (CSS) Team
• Exhibited exceptional troubleshooting skills resulting in heightened customer satisfaction (CSAT) through effective issue resolution and handled customer escalation appropriately.
• As part of Improvement process, released many public facing Troubleshooting guides (TSG) in Tech community to help global customer
• Involved in Three-Layer Troubleshooting Comprising of Azure Networks, OS to identify SQL server I/O bottlenecks and Runtime latency.
• Configuring and Troubleshooting Private End point or Managed Endpoint alongside helping them to configure P2S or S2S VPN to allow connection from end user to Azure SQL.
• Configuring and Troubleshooting SQL Server and Azure SQL High Availability and Disaster Recovery Strategy by Using Log Shipping, Clustering, Always ON, Geo Replications and Auto Failover Groups.
• Analyzing SDP logs, Cluster Logs and SQL dumps For Root cause analysis.
• Configuring and Troubleshooting Distributed Database Designs by using SQL server Replication, Azure SQL Data Sync and Elastic Query Capabilities.
• Helped Customer to Automate database specific Workflow like Import-Export, DACPAC generations, backup-restore by using PowerShell (runbook) and SQL server / Azure SQL Agent.
• Configuring and troubleshooting Mail servers for Alerting and Notification in SQL server Managed Instance and SQL server on premise Server.
• Configuring Custom Auditing and Monitoring Using Azure Monitor, SQL Audit Capabilities and Azure Log analytics.
• Troubleshooting SQL server CPU, IO, Memory, Space, Log Utilization, Recovery, Installation and Temp DB Issues
• Troubleshooting Issue under Security Scope like: SQL Authentication and Authorization, Dynamic Data Masking, Data Classifications, Always Encryptions and Tabular Data Encryption
• Handling Customer Escalation by collaborating with Cross technology and Functional Team /Escalation team or with SQL Server Product Group to ensure Business KPI, CSAT and SLAs.
• Conducted root cause analysis of technical issues, implementing preventive measures for future occurrences.
• Enhanced customer satisfaction by resolving complex technical issues promptly and effectively.
• Served as escalation point for challenging technical inquiries, demonstrating expertise in product knowledge and problem-solving abilities.
• Explained technical information in clear terms to non-technical individuals to promote better understanding.
• Worked directly with clients in rollout and post-rollout stages to train and support new applications and system

• Designing production database (ER) with complex constraints to avoid violations to the physical and logical schema
• Defining condition and imposing Policy to make the Production SQL server Compliant as per the company Standards
• Administrating and Securing Over 200+ production Database server for a Us based broadcasting organization
• Finding and troubleshooting Slow running query with analyzing the execution plan
• Setting appropriate isolation to avoid long wait or Blockings with the help of Extended events, Profiler, alerts, and SQL agent
• Securing SQL server by managing the authentication and authorization, considering the least privilege principle
• Automating Daily Backup/Restore, Database Refresh, Resource health and Maintenance jobs for easier admin task flow with the help of Power shell
• Implementing HADR technique Log-shipping, Availability group and replication to maintain the RTO and RPO of the Prod SQL servers.
• Built databases and table structures for web applications.
• Designed and implemented effective database solutions and models to store and retrieve data.
• Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.
• Used GDP on validation protocols, test cases and changed control documents.
• Designed advanced analytics ranging from descriptive to predictive models to machine learning techniques.
• Identified opportunities for cost savings through effective capacity planning and resource allocation decisions in large-scale database environments.

Led Uk based product company to move their existing On-premises Data platform to cloud by Evaluating and Assessing On-premises SQL servers and finding out Compatibility issue and Feature issue for migration

• Collecting performance benchmarks for on-premises SQL server and Deciding Right SKU in Azure for Migration
• Working with Development and Prod team to Review and rebuild Migration blockers like Compatibility, Features, Unsupported SPs, and Jobs
• Carrying out POC for Online/Offline migration strategy for Test/Dev/Prod with Minimal Down time requirement by configuring S2S and EXPRESSROUTE
• Migrating on-Premises SQL server to Azure by Using DMS, DMA and SSDT for Post migration Schema Comparison
• Helping client to troubleshoot post-Migration Performance issue for Stored procedures.
• Provided ongoing support to clients throughout their entire migration journey, from initial inquiry to arrival in their new country.
• Collaborated with clients to gather necessary evidence for applications, ensuring comprehensive and accurate submissions that increase chances of success.
• Analyzed customer data parcels for compliance with specifications, providing analysis of detected gaps.