ABHISHEK SINGH
GURUGRAM
Summary
Senior Database Architect & Specialist with 14+ years of experience delivering enterprise-scale data platforms across SQL Server, PostgreSQL, and MySQL in on-premises and cloud environments (Azure IaaS/PaaS—Azure SQL Database, Managed Instance, Azure VMs, Synapse; AWS—EC2, RDS, Aurora).
Designing Solutions to achieve Minimum Downtime SQL Database upgrades
Core Expertise in configuring high availability and disaster recovery (Cross-Region) solutions to ensure Business Continuity leveraging Always On Availability Groups (traditional & distributed), WSFC, and cluster-less AG configurations
Expert in performance engineering and query optimization, utilizing Query Store, DMVs, Extended Events, and execution plan analysis to drive measurable improvements in system efficiency and reliability.
Strong believer of automation and platform standardization, using PowerShell, ARM templates, and Terraform to deliver scalable, repeatable, and low-risk deployments.
Collaborating cross-functionally to deliver secure, resilient, and high-performance database platforms for mission-critical applications
Overview
14
14
years of professional experience
Work History
SENIOR SQL DATABASE SPECIALIST & ARCHITECT
MAJID AL FUTTAIM
GURUGRAM
09.2024 - Current
- Leading enterprise-wide database operations across Microsoft SQL Server (2016/2019/2022/2025 – On-Premises) and Azure SQL Databases, Managed Instances, Azure VMs, Synapse, ensuring scalability, stability, and performance of mission-critical financial and customer-facing systems.
- Working exposure to other RDBMS platforms (PostgreSQL, MySQL) and cloud ecosystems including AWS (EC2, RDS, Aurora).
- Architecting and implementing high availability, disaster recovery, and business continuity solutions across same-region and cross-region environments using Always On Availability Groups (traditional & distributed), WSFC, and cluster-less configurations, enabling near-zero downtime and resilient platform design.
- Leading performance optimization initiatives through advanced query tuning, indexing strategies, and workload analysis using Azure Database Watcher, Query Store, DMVs, Extended Events, and execution plan analysis, resulting in improved system efficiency and reduced latency.
- Architecting and executing zero/minimal downtime database upgrade / migration strategies using Distributed AG, cluster-less AG configurations, mirroring, and optimized backup/restore approaches based on application constraints and infrastructure design.
- Designing and delivering robust backup, recovery, and DR strategies aligned with business SLAs, ensuring 24/7 availability and minimal data loss across critical workloads.
- Owning end-to-end SQL Server compliance and audit initiatives across multiple operating entities, including version standardization, backup adherence, and security configurations; producing executive summaries and driving remediation plans.
- Defining and executing remediation strategies to close audit gaps, collaborating with cross-functional teams to achieve full compliance and strengthen governance posture.
- Designing and implementing centralized auditing and logging frameworks to capture SQL instance and database-level schema changes, security permissions, and data operations, significantly improving traceability, security, and regulatory compliance.
- Driving automation and standardization using Azure Arm Templates, PowerShell and Terraform to reduce manual effort, minimize operational risk, and improve deployment consistency across environments.
SENIOR DATA PLATFORMS ARCHITECT
SAXO GROUP
GURUGRAM
11.2018 - 09.2024
- Managed organization-wide database engines : SQL Server 2016/2019/2022 (ON-PREMISES), AZURE SQL Databases, AZURE SQL Managed Instances.
- Administered data platform consisting of hundreds of OLTP databases with few databases spanning over 40 TB in production, testing and development environments, running on Microsoft SQL Servers with up to 3 TB memory.
- Responsible for security, performance and high availability, ensuring 24/7 operation of the bank.
- Served as a hub for knowledge sharing and guidance for our developers and business units.
- Handled data masking, encryption, deployments, monitoring and alerting tool development.
- Focus on automation, performance optimization, and advanced troubleshooting
SQL SERVER DBA
Tata Consultancy Services
GURUGRAM
11.2014 - 11.2018
- Installed SQL Server 2012/2008R2/2008/05 on standalone, AOG environments with latest service packs.
- Upgraded SQL server databases from 2000/2005 to 2008R2/2012.
- Experience in working and troubleshooting Very Large databases in OLTP Environment.
- Extensively worked with SQL Profiler, Perfmon, DMVs, Extended Events to tune the databases, queries, performance related issues like memory CPU and I/O issues.
- Re-org/Rebuilding the indexes at regular intervals for better performance.
- Involved in troubleshooting and fine-tuning of databases for its performance.
- Configuring TEMPDB on files and capacity planning of databases.
- Migration of SSIS packages and SSRS reports from 2005 to 2008R2/2012.
SQL SERVER DBA
OPEN ACCESS TECHNOLOGY INDIA
MOHALI
01.2012 - 11.2014
- Experience with Database Backup, Recovery and Disaster recovery procedures on SQL server 2008R2.
- Experience in MSSQL Server 2008R2 Enterprise edition installation and configuration on Developer systems, Integration systems, Release systems.
- Configuring high availability solutions on production systems such as Log shipping and have knowledge of other high availability solutions like Database Mirroring, Cluster and Replication.
- Automating the SQL Server backups, Rebuilding and Reorganizing the indexes, check database integrity, Cleanup history through Maintenance Plans.
- Performing and monitoring daily database operations and set-up backup schedules.
- Verify the free space on each drive of the servers. Often times, log files will grow because of monthly jobs.
Education
POST GRADUATION DIPLOMA IN IT
SYMBIOSIS
01-2014
B.TECH - COMPUTER SCIENCE AND ENGINEERING
HIMACHAL PRADESH UNIVERSITY
01-2010
Skills
- SQL SERVER 2012 -2025
- AZURE SQL DATABASES
- AZURE SQL MANAGED INSTANCES
- AZURE SYNAPSE
- AWS (EC2, RDS , AURORA)
- PostgreSQL
- AZURE DEVOPS (CI/CD PIPELINES)
- HIGH AVAILIBILITY
- CROSS REGION DISASTER RECOVERY
- PERFROMANCE TUNING
- QUERY STORE \ DMV'S \ XEVENTS
- POWERSHELL
- TERRAFORM
- AZURE ARM TEMPLATES
- SERVICE NOW
- FRESHWORKS
Timeline
SENIOR SQL DATABASE SPECIALIST & ARCHITECT
MAJID AL FUTTAIM
09.2024 - Current
SENIOR DATA PLATFORMS ARCHITECT
SAXO GROUP
11.2018 - 09.2024
SQL SERVER DBA
Tata Consultancy Services
11.2014 - 11.2018
SQL SERVER DBA
OPEN ACCESS TECHNOLOGY INDIA
01.2012 - 11.2014
POST GRADUATION DIPLOMA IN IT
SYMBIOSIS
B.TECH - COMPUTER SCIENCE AND ENGINEERING
HIMACHAL PRADESH UNIVERSITY