Database Administrator (Microsoft SQL Server)

PepsiCo Inc.; Hyderabad; On-site; INR 2,500,000 - 4,200,000; Full time

Job summary

PepsiCo Inc. in Hyderabad is seeking a highly skilled Microsoft SQL Server Database Administrator to manage, optimize and secure mission-critical SQL Server environments across on‑premises and cloud platforms. You will drive high availability, performance, security and reliability for business-critical applications.

The role requires hands-on experience with Always On, FCI, backups, disaster recovery, and automation using PowerShell and IaC, plus cloud deployments on Azure and AWS.

Qualifications

• Bachelor’s or master’s degree in computer science or equivalent work experience.
• Over 10 years of Database Administration experience.
• Certifications in Microsoft SQL Server DB Administration and cloud certifications.

Responsibilities

• Install, configure, upgrade, patch, and maintain SQL Server environments.
• Configure Always On Availability Groups, FCI, Log Shipping, Replication, and Mirroring.
• Design backup and recovery strategies and support disaster recovery.
• Analyze and optimize performance through indexing, tuning, and plan analysis.
• Automate DBA tasks using PowerShell, IaC, and CI/CD where applicable.
• Ensure security with RBAC, encryption, and patch management.
• Collaborate with cross-functional teams for incident resolution and documentation.

Skills

SQL Server DB Administration

T-SQL

Query tuning

PowerShell scripting

Cloud computing

Security best practices

Education

Bachelor’s or Master’s in CS

Microsoft SQL Server DBA certification

AWS/Azure/GCP certifications

Tools

SSMS

Azure Monitor

SolarWinds DPA

Azure Automation

AWS RDS for SQL Server

Job description

Overview

We are seeking a highly skilled Microsoft SQL Server Database Administrator (SQL DBA) to manage, maintain, optimize, and secure mission-critical SQL Server database environments across on-premises and cloud platforms. The ideal candidate will be responsible for ensuring high availability, performance, scalability, security, and reliability of enterprise database systems while supporting business-critical applications.

Responsibilities

Database Administration

• Thorough knowledge in Install, configure, upgrade, patch, and maintain Microsoft SQL Server environments.
• Experience in configuring and maintaining SQL Server Always On Availability Groups, Failover Cluster Instances (FCI), Log Shipping, Replication, and Database Mirroring.
• Hands-on on database refreshes, migrations, and upgrades with minimal downtime.

Backup, Recovery & Disaster Recovery

• Design and implement backup and recovery strategies using native SQL Server tools and enterprise backup solutions.
• Support business continuity planning and database resilience initiatives.

Performance Tuning & Optimization

• Analyze and optimize database performance through indexing, query tuning, execution plan analysis, and resource management.
• Perform capacity planning and recommend infrastructure improvements.

Cloud & Automation

• Manage SQL Server databases hosted on:
  • Azure SQL Database
  • Azure SQL Managed Instance
  • SQL Server on Azure Virtual Machines
  • AWS RDS for SQL Server
• Automate DBA tasks using PowerShell, T-SQL, Azure Automation, and scripting tools.
• Support Infrastructure-as-Code and DevOps initiatives where applicable.
• Participate in database deployment automation and CI/CD integration.

Security & Compliance

• Implement database security best practices, including role-based access control (RBAC).
• Manage encryption technologies such as Transparent Data Encryption (TDE), Always Encrypted, and TLS/SSL.
• Perform vulnerability assessments and apply security patches.
• Support compliance requirements, auditing, and data governance initiatives.

Monitoring & Operational Support

• Collaborate with application, infrastructure, cloud, and security teams to resolve incidents.
• Develop and maintain operational documentation and standard operating procedures.

Qualifications

• Bachelor’s or master’s degree in computer science or equivalent work experience
• Over 10 years of Database Administration
• Cloud Computing / Distributed Systems
• Certifications in Microsoft SQL Server Database Administration
• AWS/Azure/GCP certifications

Required Skills

• 10+ years of experience administering Microsoft SQL Server databases.
• Strong expertise with SQL Server 2016/2019/2022.
• Experience with:
  • Always On Availability Groups
  • Failover Clustering
  • Replication
  • Log Shipping
  • Database Mirroring
• Strong knowledge of:
  • T-SQL
  • Query tuning
  • Execution plan analysis
  • Index optimization
  • Performance troubleshooting
• Hands-on experience with backup and recovery strategies.
• Experience managing SQL Server in Azure and/or AWS cloud environments.
• Knowledge of Windows Server administration and PowerShell scripting.
• Experience with database migrations, upgrades, and consolidation projects.
• Familiarity with monitoring tools such as:
  • SQL Server Management Studio (SSMS)
  • SQL Server Profiler
  • SolarWinds DPA
  • Azure Monitor