Apoorva K M
Bengaluru
Summary
Results-driven Tech Support Engineer with extensive Azure Synapse Analytics and SQL Server expertise. Proven ability to optimize performance tuning, implement disaster recovery plans, and deliver secure, compliant solutions.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Tech Support Engineer
Microsoft
Bengaluru
06.2022 - Current
- Provided technical support and guidance for Azure Synapse Analytics, including Azure Synapse Studio, Dedicated SQL Pools (formerly SQL DW), and Serverless SQL Pools.
- Hands-on experience in data warehousing concepts, architecture, and best practices for enterprise-scale solutions.
- Assisted customers in optimizing Data Warehouse Units (DWUs) and workload management using resource classes to improve performance and cost efficiency.
- Troubleshot complex issues such as slow-running queries, connectivity errors, and workspace configuration problems, delivering actionable solutions to enhance reliability.
- Guided customers in feature implementation, RBAC permissions, and access control across the Synapse portal, storage accounts, and linked services.
- Configured diagnostic settings and integrated Log Analytics for proactive monitoring and telemetry.
- Implemented Managed Virtual Network and Private Endpoints for secure connectivity, and resolved issues during deployment and configuration.
- Collaborated with cross-functional teams and SMEs to clarify requirements and deliver secure, compliant solutions.
- Provided workarounds for feature gaps, and ensured smooth deployment of configurations in customer environments.
- Basic knowledge of Azure Data Factory, Azure Data Explorer, and Databricks for data integration and transformation workflows.
- Strong communication and collaboration skills, enabling effective engagement with global customers and internal teams.
SQL Server Database Administrator
TCS
Bengaluru
06.2019 - 05.2022
- Served as an SQL Server Database Administrator for 3 years, supporting MS SQL Server versions such as 2019, 2017, 2016, 2014, 2012, 2008 R2, and 2008 in production, test, and development environments.
- Experience in database administration on production servers, with server configuration, maintenance, and troubleshooting capabilities.
- Experience in High Availability / Disaster Recovery Solutions (HADR): Failover Clustering, AlwaysOn Availability, High Availability, and Log Shipping.
- Experience in upgrading/migrating lower versions of MS SQL Server to higher versions of MS SQL Server.
- Experience in monitoring the health and performance of SQL servers using naive and other third-party tools.
- Experience in supporting and maintaining large databases, and troubleshooting their problems.
- Responsible for securing SQL Server, user management, assigning permissions, and roles.
- Experience in backup and recovery, and security.
- Experience in working independently, as well as in team-oriented environments.
- Conducted knowledge-sharing sessions for junior resources in the team.
- Conducted knowledge-sharing sessions for junior resources in the team.
- Experience in resolving blockings and deadlocks.
- Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, and adding scheduled jobs to re-index and update statistics in databases, in the installation and configuration of 2008, 2008 R2, 2012, 2014, 2016, 2017, and 2019 Standalone and Failover Cluster instances of SQL Server.
- Experience in working on cloud environments like Azure and AWS.
- Supported 24/7 rotational shifts.
Education
Bachelor of Engineering - Computer Science
BITM
Ballari06-2019
Skills
- Microsoft SQL Server
- Always On high availability configurations
- Log shipping and failover clustering strategies
- Decommissioning databases effectively
- Patching SQL Server environments
- Managing logins and permissions efficiently
- Installing SQL Server instances
- Fragmentation analysis and index rebuilding techniques
- Issue monitoring and troubleshooting skills
- Implementing disaster recovery plans
- Optimizing performance tuning practices
- Index maintenance strategies for efficiency
- Data migration methodologies
- Effective backup and recovery processes
- Azure Synapse Analytics knowledge
- Data warehousing in cloud environments
- General cloud computing skills
- Technical troubleshooting abilities
- Dedicated SQL pool management in Azure Synapse Analytics
- Azure synapse workspace
- Guidance on managed virtual networks
- Deploying private endpoints for security
- Effective linked service integration
- Efficient access control practices
- Data warehouse units allocation strategies
- Effective resource class utilization techniques
- Detailed log analytics understanding
- Enhanced connectivity solutions
Certification
Microsoft certified
AZ-900 – Microsoft Azure Fundamentals
DP-300 – Administering Microsoft Azure SQL Solutions
DP-900 – Microsoft Azure Data Fundamentals
AI-900 – Microsoft Azure AI Fundamentals
Microsoft SQL Server 2016.
AZ-900 – Microsoft Azure Fundamentals
DP-300 – Administering Microsoft Azure SQL Solutions
DP-900 – Microsoft Azure Data Fundamentals
AI-900 – Microsoft Azure AI Fundamentals
Microsoft SQL Server 2016.
Technical Skills
- Secondary skills: HTML, C, and C++ programming
- Software tools: SQL Server Management Studio (SSMS), Microsoft System Center Operations Manager (SCOM), ServiceNow, and Azure Data Studio
Timeline
Tech Support Engineer
Microsoft
06.2022 - Current
SQL Server Database Administrator
TCS
06.2019 - 05.2022
Bachelor of Engineering - Computer Science
BITM