Database Administrator MS SQL

PepsiCo; Kraków; On-site; PLN 250,920 - 306,680; Full time

Benefits offered by this job

Annual bonus

Comprehensive benefits package

Job summary

PepsiCo in Kraków seeks a skilled Microsoft SQL Server Database Administrator to manage and optimize mission-critical SQL Server environments across on-premises and cloud platforms. You will ensure high availability, security, and performance for business-critical applications.

The role covers configuration, backups, disaster recovery, performance tuning, and cloud migrations, with automation and DevOps collaboration. Strong SQL and Windows Server skills required.

Qualifications

• 5+ years of experience administering Microsoft SQL Server databases.
• Experience with SQL Server 2016/2019/2022.
• Experience with Always On, Failover Clustering, Replication, Log Shipping, and Database Mirroring.
• Knowledge of T-SQL, query tuning, and index optimization.
• Experience with backup/recovery strategies and cloud SQL Server environments.

Responsibilities

• Install, configure, upgrade, patch, and maintain SQL Server environments.
• Manage Always On Availability Groups, FCI, log shipping, replication, and mirroring.
• Design and implement backup and recovery strategies for business continuity.
• Analyze performance and perform tuning via indexing and execution plans.
• Automate DBA tasks with PowerShell, T-SQL, and Azure automation.

Skills

T-SQL

Query tuning

Execution plan analysis

Index optimization

Performance troubleshooting

PowerShell scripting

Windows Server administration

Cloud computing

Database migrations

Education

Bachelor’s or Master’s degree in computer science

Microsoft SQL Server Database Administration certifications

Tools

SSMS

SQL Server Profiler

SolarWinds DPA

Azure Monitor

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

• 5+ 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

Preferred Qualifications

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

Soft Skills

• Analytical, problem‑solving, communication, collaboration, proactive mindset.

Compensation and Benefits: The expected starting compensation range for this position is 278,800 PLN annually. Location, confirmed job‑related skills, experience, and education will be considered in setting actual starting salary. This role is eligible for an annual bonus of 15% of annual salary, based on performance and eligibility. In addition to salary, PepsiCo offers a comprehensive benefits package to support our employees and their families, subject to elections and eligibility.