Summary
Overview
Work History
Education
Skills
Personal Information
Timeline
Generic

Vinod Rao

Hyderabad

Summary

- Database Administrator with over 8 years of experience managing MSSQL Server (2008R2–2022) and Microsoft Azure (IaaS, PaaS) environments, along with AWS RDS and EC2. - Expertise in high-availability solutions (Always On Availability Groups), database migrations, performance tuning, and disaster recovery operations. - Skilled in automation scripting, database security, user management, and 24/7 support for critical applications to meet SLA requirements. - Strong problem-solving skills with a proven ability to collaborate across teams and adapt to new technologies. Knowledge of SQL Server Distributed Always On Availability Groups for multi-site high availability and disaster recovery. Familiar with architecture, configuration, and failover concepts of Distributed AGs in hybrid and cross-datacenter environments

Overview

8
8
years of professional experience

Work History

SQL Server DBA

Everest DX(PepsiCo Project), Hyderabad
04.2024 - Current
  • - Ensure robust database security and user management per PepsiCo standards, implementing strict access controls.
  • - Support high-availability solutions, including Always On Availability Groups, to ensure minimal downtime.
  • - Develop automation scripts for maintenance and monitoring tasks, improving operational efficiency.
  • - Conduct disaster recovery (DR) drills and ensure compliance with business continuity and disaster recovery (BCDR) policies.
  • - Perform regular health checks, backup verifications, and performance tuning for critical database environments.
  • - Participate in weekly client meetings to discuss process improvements and project updates.

Senior Associate (SQL DBA)

Genpact India Pvt Ltd, Hyderabad
05.2021 - 04.2024
  • - Installed and configured SQL Server instances, applied service packs, and updated port numbers for enhanced security.
  • - Monitored and troubleshooted Always On Availability Groups, ensuring high availability for critical applications.
  • - Planned and executed backup and recovery strategies, resolving issues with failed backups and database restoration.
  • - Managed database creation, user permissions, and resolved space issues by optimizing log files and server resources.
  • - Provided 24/7 on-call support, performing daily log checks and troubleshooting production server errors.
  • - Led database migrations, including pre- and post-migration activities, ensuring seamless transitions to Azure and on-premises environments.

Vigilant Compu tech Technologies Inc, Hyderabad
09.2017 - 05.2021
  • - Supported critical production and pre-production databases, ensuring uptime and performance for client applications.
  • - Configured SQL Server installations, alerts, and maintenance plans tailored to client requirements.
  • - Executed in-place SQL Server upgrades and applied patches to maintain compliance with standards.
  • - Performed database refreshes from production to staging/development environments, supporting development and test teams.
  • - Managed user permissions, resolved blocking issues, and collaborated on change requests for production updates.
  • - Documented knowledge base articles for L2/L3 support and participated in client meetings for process enhancements.

Education

B. Tech - Computer Science

JNTU Kakinada

Skills

  • - RDBMS: SQL Server 2008/2008R2/2012/2014/2016/2017/2019/2022
  • - Cloud Platforms: Microsoft Azure (IaaS, PaaS), AWS (RDS, EC2)
  • - Operating Systems: Windows Server 2016/2012/2008R2/2008
  • - Key Competencies: Always On Availability Groups, Database Migration, Backup/Recovery, Performance Tuning, Automation Scripting, Clustering (Active/Active, Active/Passive)

Personal Information

Languages Known: English, Hindi, Telugu

Timeline

SQL Server DBA

Everest DX(PepsiCo Project), Hyderabad
04.2024 - Current

Senior Associate (SQL DBA)

Genpact India Pvt Ltd, Hyderabad
05.2021 - 04.2024

Vigilant Compu tech Technologies Inc, Hyderabad
09.2017 - 05.2021

B. Tech - Computer Science

JNTU Kakinada
Vinod Rao