Google-Certified SQL & Cloud Data Architect
Resume:
Aug **** – Present
ABHISHEK JAIN
412-***-**** LinkedIn United States
SUMMARY
Google Certified Professional Architect and Certified Database Administrator (DBA) with over 15 years of experience architecting, managing, and optimizing enterprise SQL Server and cloud data infrastructures. Proven expertise in maximizing system availability, executing seamless cloud migrations (Azure/GCP), and modernizing traditional database environments to support real-time analytics and scalable AI/ML data pipelines. Strong track record of leading high-performing teams and delivering 24/7 support for mission-critical production environments.
AREAS OF EXPERTISE
Database & Architecture: Design, Installation & Configuration, Capacity Planning, Security Baseline & Encryption (TDE), VLDB Management, Table Partitioning. HADR Solutions: Always On Availability Groups, Failover Cluster Instances (FCI), Log Shipping, Database Mirroring, Replication (Transactional, Merge, Snapshot). Performance Tuning: Query Optimization (T-SQL), Index Management, Bottleneck Analysis (CPU, Memory, I/O), DMVs & DMFs, Database Consistency Checks (DBCC). Cloud & Data Pipelines: Azure SQL Managed Instances, AWS (RDS, EC2), GCP (BigQuery, Cloud Storage), Change Data Capture (CDC), Datastream, ELT/ETL Pipelines (SSIS). AI & Analytics Focus: Data Pipeline Orchestration for LLMs, Vector Search Indexing, Scaling Infrastructure for ML Workloads.
PROFESSIONAL EXPERIENCE
SQL Server DBA / Data Infrastructure Lead
Rogue Fitness Columbus, United States
AI Data Infrastructure Modernization: Designed and optimized Azure SQL and GCP BigQuery pipelines to feed high-throughput corporate data into downstream AI/ML models and Large Language Models
(LLMs).
Vector & Search Optimization: Evaluated and implemented database strategies, including specialized indexing and schema optimizations, to handle embeddings and vector search data structures for internal AI applications.
Real-Time Data Streaming: Built and maintained low-latency data replication pipelines using GCP Datastream to sync heterogeneous databases, streaming real-time Change Data Capture (CDC) data into BigQuery for near real-time AI analytics and business intelligence.
•
•
•
1
****.*****@*****.***
DATABASE ADMINISTRATION CLOUD DATA ARCHITECT
Jun 2017 – Jul 2023
Dec 2015 – Jun 2017
Apr 2011 – Nov 2015
Jul 2009 – Nov 2010
Enterprise Database Administration: Installed, configured, and supported MS SQL Server 2016 through 2022 across physical, virtual, and clustered environments. Cloud Migration: Spearheaded the upgrade and migration of legacy databases from SQL Server 2012 to Azure SQL and modern SQL Server versions on cloud platforms. HADR & Performance Tuning: Configured and supported Always On Availability Groups, log shipping, and replication. Resolved critical resource contentions involving CPU, memory, and I/O while optimizing SQL Server DBA
Cardinal Health (TCS) Dublin, United States
Large-Scale Upgrades: Managed major database upgrades and migrations spanning SQL Server 2008 through 2019 across complex clustered and physical/virtual environments. Security & Auditing: Implemented strict SQL Server authentication modes, customized logins, granular roles, and comprehensive audit policies matching corporate compliance standards. Performance Engineering: Diagnosed and resolved highly concurrent deadlocks, blocking issues, and query performance bottlenecks using SolarWinds DPA and native tools. Data Warehousing & BI: Developed, deployed, and managed robust SSIS and SSRS packages to seamlessly extract and export operational data to enterprise data warehouses. Multi-Cloud Administration: Supported critical workloads across a hybrid environment including Azure, AWS RDS, EC2 instances, and GCP.
SQL Server DBA
EATON (TCS) Noida, India
Security & TDE Implementation: Designed server and object-level baseline security policies; implemented column-level encryption and Transparent Data Encryption (TDE). Automation & Maintenance: Scripted automated infrastructure maintenance jobs via PowerShell, SQL Server Agent, and Task Scheduler (backups, index rebuilds, integrity checks). Disaster Recovery Execution: Successfully relocated Production, QA, and Dev environments across data centers utilizing database mirroring with zero data loss. SQL Server DBA
CSC (now DXC Technology) Noida, India
Failover Clustering: Successfully installed, managed, and maintained traditional multi-node SQL Server Failover Cluster Environments.
VLDB Management: Handled Very Large Databases (VLDBs) exceeding 1TB using advanced table partitioning, multiple file-groups, and data compression. Distributed Environments: Configured linked servers for cross-platform distributed queries and integrated workloads across Azure and Hyper-V.
Database Specialist
XL Insurance (now AXA XL) Gurugram, India
RDBMS Development: Cooperated with developer teams to design tables, schemas, views, stored procedures, functions, and transactional replication systems.
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
2
complex T-SQL queries.
Parallel Migration: Executed parallel migrations from SQL Server 2008 to 2012, utilizing DBCC commands to guarantee post-migration data integrity. TECHNICAL CERTIFICATIONS
Google Certified Professional Cloud Architect
Certified Database Administrator (DBA)
EDUCATION
Post Graduate Diploma in IT IMT Ghaziabad (GPA: 71.65%) B.Sc. (Hons) in Electronic Science Hans Raj College, Delhi University (GPA: 81.87%) AWARDS & ACCOLADES
CSC Accolades: 5-time recipient for outstanding performance in client-focused delivery. You Have Earned It Award (XL Group): Awarded for driving major improvements in customer service capability.
SHL-Appreciation Award: Received for achieving excellent, defect-free project deliveries. Pat on the Back Award (Perot Systems): Awarded for enthusiastic and additional delivery effort. Academic Honors: Held 3rd Position overall in Graduation (Delhi University) and 1st Position in Intermediate Exams, receiving the prestigious Indira Award from the Govt. of Delhi.
•
•
•
•
•
•
•
•
•
•
3
Contact this candidate