Anoop Agarwal
Sql Server Dba & Data Engineer Query Optimization Etl Pipelines Troubleshooting @Segen
Signup · Get unlimited contacts
WORK HISTORY
Sql Server Dba & Data Engineer Query Optimization Etl Pipelines Troubleshooting @Segen
Resolved deadlocks, tuned indexes, and removed performance bottlenecks to improve production stability and throughput by 20–30%.Implemented log shipping and replication across 200+ GB datasets to enable offloaded reporting and near-real-time insights without impacting source systems.Directed migration of databases to Azure Managed Instance, executing pre- and post-migration validation to ensure zero downtime and data integrity.Migrated an API-driven Synapse ingestion pipeline to Microsoft Fabric, rearchitecting the flow as API → Bronze →Silver using Fabric Lakehouse and Spark notebooks to preserve schema parity and pipeline SLAs.Built scalable ingestion pipelines with Azure Data Factory and Microsoft Fabric (API/CSV → Bronze; Spark notebooks → Silver) and developed automated Silver-layer reports to support timely business decisions. Automated capacity scaling for Microsoft Fabric using Azure Logic Apps, cutting operational costs by ~50%.
EDUCATION
Maharashtra Institute of Technology
B E, Electronics and telecomunications
Symbiosis Institute of Management Studies
PGDBA, Marketing
SKILLS
ABOUT ANOOP AGARWAL
With over 20 years of experience in database management and cloud data engineering, I am deeply committed to crafting robust, high-performance solutions. My journey has been marked by a dedication to SQL Server DBA roles and the evolving landscape of Fabric Data Engineering. Specializing in SQL Server Azure SQL), I\'ve honed my skills in performance tuning, high availability/disaster recovery (HA/DR), and seamless migrations.At Segen Ltd, my efforts led to a 20–30% improvement in SQL Server performance through strategic deadlock resolutions and index tuning. I successfully directed zero-downtime migrations to Azure Managed Instance and built comprehensive ETL pipelines using Microsoft Fabric. These initiatives not only transformed raw data into analytics-ready formats but also reduced operational costs by approximately 50%.My core expertise includes SQL Server management, query optimization, SSIS/SSRS integration, Azure Data Factory orchestration, Databricks utilization, and Microsoft Fabric deployment. I excel in governance, security protocols, and automation tools like Logic Apps and SolarWinds DPA.I am passionate about blending traditional DBA fundamentals with cutting-edge data engineering practices to deliver reliable and cost-effective platforms. Let\'s connect—I’m eager to share insights on database optimization and explore new opportunities in cloud data engineering.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.