Swapnil Jagtap

Microsoft Certified Azure Database Administrator Associate (DP-300) with 4.4+ years of hands-on experience administering SQL Server 2017–2022, Azure SQL Database, and Azure SQL Managed Instance at Accenture. Proven expertise in High Availability (Always On Availability Groups), Disaster Recovery, Azure SQL migration (DMS/DMA), performance tuning, query optimization, and P1/P2 production incident management. Strong background in Azure Monitor, SQL Insights, Log Analytics, TDE encryption, Dynamic Data Masking, Azure Active Directory authentication, and cost optimization.

Skilled in automation using T-SQL, PowerShell, and Jenkins CI/CD pipelines.

SQL Server DBA / Azure SQL Database Administrator - Accenture - Pune, India

(2021-12)

• Manage and administer Azure SQL Database and Azure SQL Managed Instance (SQLMI) ensuring 99.9%+ availability, security compliance, and cost optimization across enterprise workloads.
• Execute Azure SQL Database migrations from on-premises SQL Server using Azure Data Migration Service (DMS) and Database Migration Assistant (DMA) with full data integrity validation and near-zero downtime.
• Configure and manage Azure SQL Elastic Pools to optimize resource utilization; analyze DTU/vCore consumption and deliver right-sizing recommendations to reduce cloud spend.
• Implement and maintain Azure SQL security controls including TDE, Dynamic Data Masking, Row-Level Security, Always Encrypted, and SQL Auditing to meet SOX/GDPR compliance requirements.
• Configure Azure Active Directory (AAD) authentication and RBAC for Azure SQL; manage server-level and database-level firewall rules and private endpoint configurations.
• Monitor Azure SQL health and performance using Azure Monitor, SQL Insights, Log Analytics Workspace, and custom metric alerts; set up diagnostic settings to capture query performance and resource metrics.
• Optimize Azure SQL query performance via Query Performance Insight, Automatic Tuning, and manual execution plan analysis — achieved ~25% performance improvement on critical workloads.
• Manage Azure SQL Geo-Replication and Active Geo-Replication for cross-region DR; conduct regular failover tests to validate RTO/RPO objectives.
• Implement Azure Backup for SQL databases with long-term retention (LTR) policies; automate backup verification and restore testing using PowerShell and Azure Automation Runbooks.
• Perform Azure SQL cost optimization by analyzing resource utilization, resizing service tiers, implementing the serverless compute tier, and enabling Reserved Capacity pricing.
• Administer 50+ SQL Server production databases (2017, 2019, 2022) including installation, configuration, patching, and version upgrades across dev, UAT, and production environments.
• Design, implement, and maintain HA/DR solutions using Always On Availability Groups (AAG) and Log Shipping; conduct scheduled failover drills to validate readiness.
• Execute Full, Differential, and Transaction Log backup strategies with regular restore testing; document DR runbooks and validate Point-in-Time Recovery (PITR) procedures.
• Troubleshoot and resolve performance bottlenecks including blocking, deadlocks, long-running queries, missing indexes, parameter sniffing, and resource contention using DMVs, Extended Events, and SQL Profiler.
• Conduct index tuning (clustered, non-clustered, filtered, columnstore) and T-SQL query rewrites to optimize stored procedures and batch jobs across high-load workloads.
• Manage SQL Server security including login/role administration, server and database auditing, TDE, and access reviews in compliance with enterprise security and regulatory policies.
• Respond to and resolve P1/P2 production incidents; perform Root Cause Analysis (RCA) with detailed post-incident documentation and permanent fix implementation.
• Automate database maintenance workflows — index rebuilds, statistics updates, integrity checks, backups, and deployments — using PowerShell and Jenkins CI/CD pipelines, reducing manual effort by ~40%.
• Monitor database environment health using SQL Server Agent alerts, custom T-SQL monitoring scripts, and third-party tools for proactive capacity planning and trend analysis.
• Collaborate with application developers, DevOps engineers, and infrastructure teams to review deployment scripts, manage schema changes, and support production release cycles.

Bachelor of Engineering - Mechanical Engineering - RMD Sinhgad School of Engineering, Pune University