Pritam Roy
Support Engineer at Microsoft
Bengaluru
Summary
Adept Tech Support Engineer SE with a proven track record at Microsoft India, excelled in leading teams to enhance SQL Server and Azure SQL VM performance. Skilled in SQL Server and Azure Networking. Mentoring 30-35 junior engineers. Demonstrates strong analytical abilities and a results-driven approach, ensuring high customer satisfaction and team efficiency.
Overview
9
9
years of professional experience
4
4
years of post-secondary education
Work History
Tech Support Engineer SE
Microsoft India (R&D) Pvt Ltd
Bengaluru
11.2021 - Current
- Providing mentorship to a group of thirty (30) individuals within my leadership role.
- Providing SQL server design and Azure Network Solutions to customers.
- Working as Technical Advisor / Support for Microsoft EMEA and IST delivery and managing and resolving cases raised by the EMEA and IST customers on MS SQL Server, Azure SQL VM (IaaS) and Azure Networking.
- Working on various Azure Networking cases like latency, cloud connectivity, cloud to On-premises connectivity, designing and solutions.
- Working on various cases for MS SQL Server like performance, high availability, core, SQL Connectivity, Replication and Azure SQL VM (IaaS).
- Access to different MS tools (like pssdiag, tss, SQL Networking Kit etc.) found freely in GitHub for collecting and analyzing the logs for any kind of issues internal to MS SQL Server, especially for performance and high availability cases.
- Proficient with Wireshark\Nmap and packet drop analysis.
- Managing the cases for the EMEA team from India delivery team and assisting the team with the case resolution, decreasing case idleness, assigning cases to resources, and maintaining and working on various reports like customer CPT case report, case idleness report, case rating report for EMEA team from India delivery perspective.
- Working on reviewing cases worked by the resources of EMEA and IST team and trying to understand any kind of issues from customer perspective regarding any resource working on any case.
- Working with the product development team for MS SQL Server, Azure Core and Azure Networking in identifying and developing fixes for product bugs.
- Identifying storage latency by taking perfmon, storport and Xperf traces.
- Authentication trace analysis.
Information Security Analyst
Tata Consultancy Services
Kolkata
06.2019 - 11.2021
- Cost effective regular backup automation for 350+ Servers.
- Reviewed project requests describing database user needs to estimate time and efforts required to accomplish projects.
- Maintained complex queries, views, and stored procedures in multi-database environment with little supervision.
- Collaborated with system architects, design analysts and others to understand business and industry requirements.
- Identified innovative and automated approaches to routine tasks, making suggestions that were widely received.
- Built useful reporting deliverables to properly document analysis results and provide performance improvement feedback.
- Set up and controlled user profiles and access levels for each database segment to protect important data.
- Disaster recovery and environment build
- Analyzed existing SQL queries to identify opportunities for improvements.
- Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
SQL Server Database Administrator
IBM India Pvt Ltd
05.2015 - 05.2019
- Installation and configuration of SQL Server standalone , default and named instances on servers for SQL Server 2016, SQL Servers 2014, 2012, 2008R2 instances. Performing pre-installation checks as standard installation per-requisites. After installation perform post-installation checks.
- Configuring databases. Configuring logins and users, configuring and maintaining permission levels and other server roles. If DB has been refreshed then keep track of used logins and fixing their orphaned users.
- To follow database Backup and Restoration strategy as per client policy and configure maintenance plans accordingly.
- Monitoring the HA features such as Always-On health, Windows cluster event logs and application logs, mirroring and replication monitor, agent jobs. Performing basic troubleshooting.
- Performing MongoDB health check.
- Performing instance level monitoring using SQL Profiler, Activity monitor, DMVs and SSMS Dashboard reports.
- Performing server level monitoring and tuning such as memory settings, monitoring CPU usage and Disk I/O activity etc. using DMVs and Ignite tool. Basic understanding of “PerfMon”.
- Performing day-to- day basic troubleshooting tasks for the backup failures, index job failures, integrity check failures and patching.
- Create Linked Servers to SQL Servers, apply Service Packs and security patches.
- Creating ticket and coordinating with window server, storage, Backup and network team to fix the client issue accordingly, to maintain the SLA.
- Provide 24*7 Production support as well on call support for SQL Server Databases.
- Deploy SSIS package\SSAS files as per client requirement.
- SSRS configuration, provide access as per client requirement.
- Monitor and optimize operational resources in SQL server.
Education
B.Tech - Electrical Engineering
West Bengal University of Technology
Howrah 07.2009 - 08.2013
Skills
Microsoft SQL server
Azure
Azure Networking
Active Directory
Azure Active Directory
Storage
Wireshark\Nmap
Linux
IIS
DNS
VMWare
PowerBI
Windows Server
Nutanix
Performance Tuning
Capacity planning
Certification
Microsoft Certified: Azure Network Engineer Associate
MCSA
Azure Foundation
Timeline
Tech Support Engineer SE
Microsoft India (R&D) Pvt Ltd
11.2021 - Current
Information Security Analyst
Tata Consultancy Services
06.2019 - 11.2021
SQL Server Database Administrator
IBM India Pvt Ltd
05.2015 - 05.2019
B.Tech - Electrical Engineering
West Bengal University of Technology
07.2009 - 08.2013
Similar Profiles
Santosh Kumar GoliSantosh Kumar Goli
Senior Software Engineer at Microsoft India R&D Pvt LtdSenior Software Engineer at Microsoft India R&D Pvt Ltd
Ubaid UllahUbaid Ullah
Sr Support Engineer at Microsoft India R&D Pvt LTDSr Support Engineer at Microsoft India R&D Pvt LTD
Kumar NavneetKumar Navneet
Senior Software Engineer at Microsoft India (R&D) Pvt. LtdSenior Software Engineer at Microsoft India (R&D) Pvt. Ltd