Sql Server Database Administrator

VINAY KUMAR

***************@*****.*** 872-***-****

SENIOR DATABASE ADMINISTRATOR CLOUD DATABASE ARCHITECT DEVOPS DATA OPS ENGINEER

Versatile and results-driven data platform professional with over 6 years of expertise in architecting, deploying, and managing modern data ecosystems across Microsoft Azure, Google Cloud Platform

(GCP), and AWS. Specialized in SQL Server, PostgreSQL, MySQL, and Oracle, with proven success in automating database infrastructure, implementing high availability, and optimizing performance for critical enterprise workloads. Strong background in DevOps integration, cloud migrations, and compliance- driven data security.

TECHNICAL SKILLS

• Databases: SQL Server, Azure SQL, PostgreSQL, MySQL, Oracle, Google Cloud SQL

• Cloud Platforms: Microsoft Azure, Google Cloud Platform (GCP), AWS RDS

• DevOps & CI/CD: Azure DevOps, Git, Jenkins, Terraform, Kubernetes

• Monitoring & Performance: SQL Profiler, Extended Events, Query Store, Grafana, Prometheus, Redgate, Azure Monitor

• Automation & Scripting: PowerShell, Bash, Python, cron jobs, SQL Agent Jobs, Ola Hallengren Scripts

• Security & Compliance: TDE, Data Masking, Row-Level Security, IAM, HIPAA, GDPR, SOC 2, ISO 27001

• Tools & Frameworks: SSRS, SSMS, SSIS, SSAS, SQL Sentry, Redgate, CI/CD pipelines PROFESSIONAL EXPERIENCE

Illinois State Board of Elections – Senior Data Platform Engineer Mar 2025 – Present Springfield, IL Contract On-site

• Serving as the sole SQL Server administrator responsible for complete lifecycle management of the database environment

• Designing and implementing Always On Availability Groups for HA and DR across mission- critical systems

• Migrating legacy systems to Azure SQL and hybrid cloud infrastructure for scalability and cost efficiency

• Enforcing enterprise-wide security protocols including TDE, auditing, and row-level access contro

• Automating backups, indexing, and integrity checks using PowerShell, SQL Agent Jobs, and custom scripts

• Monitoring workloads with Query Store, SQL Profiler, and Extended Events to optimize query performance

• Collaborating with DevOps teams to integrate database updates into CI/CD pipelines

• Maintaining full technical documentation, SOPs, and recovery strategies for internal and audit use

• Leading weekly database health reviews and capacity planning initiatives

• Supporting 24/7 mission-critical systems with proactive incident handling and escalation management

• Enhancing reporting systems using SSRS for operational transparency and metrics delivery

• Training new developers and analysts on SQL standards and database practices

• Driving cost-saving initiatives by optimizing cloud resource usage and database licensing

• Coordinating infrastructure changes with network and storage teams to ensure compatibility

• Ensuring all environments remain compliant with state-mandated governance and audit regulations Illinois Department of Innovation & Technology (DoIT) – Senior Cloud SQL Engineer Feb 2024 – Dec 2024 Illinois, US Contract On-site

• Supported large-scale SQL Server deployments across Azure VMs, Azure SQL, and AWS RDS

• Automated index and statistics management using Ola Hallengren scripts and PowerShell

• Optimized I/O performance via collaboration on storage configuration and tiering strategies

• Delivered enterprise reporting using SSRS, integrated with Power BI and data warehouses

• Implemented security measures using TDE, data classification, and IAM policies

• Tuned performance using SQL Profiler, Extended Events, and Query Store

• Built cross-region replication and HA solutions reducing system latency and ensuring uptime

• Developed audit documentation, runbooks, and DR playbooks for internal reviews

• Integrated Grafana and Prometheus for visual performance monitoring

• Tuned complex stored procedures and batch operations for critical agency applications

• Enabled version control for schema deployments via DevOps pipelines

• Participated in large-scale production incident resolution and root cause analysis

• Created audit-compliant database access review scripts for sensitive data

• Enhanced BI pipelines for inter-departmental data sharing and analytics Ventois Inc. – Cloud Database Specialist

Aug 2023 – Feb 2024 Shrewsbury, MA Onsite Contract

• Administered PostgreSQL, MySQL, and SQL Server databases in GCP, Azure, and on-prem environments

• Designed and implemented HA with read replicas, failovers, and PITR backups

• Automated maintenance tasks using Python, Bash, and cron jobs

• Enforced encryption and IAM roles aligned with SOC 2 and ISO 27001 standards

• Integrated Azure Monitor and GCP Cloud Monitoring for alerting and health checks

• Led migration efforts from on-prem to Azure SQL, with near-zero downtime

• Developed and documented SOPs, disaster recovery plans, and rollback strategies

• Tuned high-traffic applications through query refactoring and index design

• Participated in DevOps sprints, supporting schema versioning and CICD integration

• Built automation for permission audits and IAM logging via Terraform

• Supported Kubernetes deployments by managing container-native databases

• Collaborated with backend teams to refactor schemas for microservices architecture

• Enabled full visibility into data flows for compliance and auditing

• Managed DR tests and business continuity readiness across regions Dell Technologies – Database Administrator & DevOps SQL Engineer Dec 2018 – Dec 2021 Full-time On-site

• Administered Oracle, and PostgreSQL databases across production, staging, and dev environments

• Migrated enterprise systems to Azure SQL improving scalability and DR

• Designed Always On Availability Groups, clustering, and multi-region failovers

• Automated deployments, patches, and backups using PowerShell, SQL Agent, and CI/CD workflows

• Configured monitoring solutions using SQL Sentry, Redgate, and Azure Monitor

• Implemented TDE, data masking, and RBAC for secure and compliant access

• Led performance tuning efforts for business-critical workloads

• Conducted post-incident reviews and built dashboards for visibility and metrics tracking

• Collaborated with QA and app teams to ensure integration stability and schema consistency

• Delivered audit and DR documentation as part of internal and external reviews

• Built cross-team strategies for storage optimization and cost forecasting

• Enhanced customer support with fast incident resolution and proactive response frameworks

• Maintained a scalable multi-tenant database framework supporting SaaS applications

• Integrated CI/CD pipelines with Git and Azure DevOps for seamless delivery AWARDS & RECOGNITION

• Recognized as Best Performer of the Year at Illinois Department of Innovation & Technology – Aug 2024

• Received Employee of the Quarter award twice at Dell Technologies for automation and incident resolution excellence-2019, 2021

• Earned Top Contributor Award for enterprise-wide SQL optimization and HA strategy at Ventois Inc-Feb 2024

EDUCATION

Master of science in Information Technology (January 2022 - May 2023) Clark University, Worcester, MA

CERTIFICATIONS

• Microsoft Certified: Azure Database Administrator Associate

• Google Cloud Certified: Professional Data Engineer

• AWS Certified Database – Specialty

Contact this candidate