17 Oct
|
PepsiCo
|
Hyderabad
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 - 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.
- Solid 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 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.
📌 Database Administrator (Microsoft SQL Server) (Hyderabad)
🏢 PepsiCo
📍 Hyderabad