Anoop Agarwal

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.

Experience

1. Sql Server Dba & Data Engineer Query Optimization Etl Pipelines Troubleshooting

   Segen

   Jul 2022 — Present

   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

  1989 — 1993

• Symbiosis Institute of Management Studies

  PGDBA, Marketing

  1995 — 1997

Skills

• Ssrs
• Sql Tuning
• Software Project Management
• Servers
• Itil
• Ssis
• High Availability
• Team Management
• Database Design
• Extract, Transform, Load (Etl)
• Sql
• Business Intelligence
• Etl
• Visual Basic
• Cluster
• Database Administration
• Unix
• Microsoft Sql Server
• Databases
• Oracle
• Cloud Computing
• Disaster Recovery