Architect

Overview

• We are seeking a self-driven, inquisitive & curious SRE Database Site reliability engineer that drives reliability, performance, and availability, including ensuring data security and access control of database systems leveraged by the frontend application and the business transactions in both SQL and NoSQL database systems
• This is a critical enabler achieving a high resiliency during operations and also continuously improving through design during the software development lifecycle.
• The SRE database support engineer is integral part of the global team with its main purpose to provide a delightful customer experience for the user of the global consumer, commercial, supply chain and enablement functions in the PepsiCo digital products application portfolio of 260+ applications, enabling a full SRE Practice incident prevention / proactive resolution model.
• The scope of this role is focussed on the Modern architected cloud native application portfolio
• It requires a blend of technical expertise of database administration / engineering, SRE tools, modern applications architecture, IT operations experience, and analytics & influence skills.

Responsibilities

• Reporting directly to the Modern IT Operations SRE enablement Associate Director, is responsible to enable & execute the pre-emptive diagnosis of an PepsiCo DPA applications towards service performance, reliability and availability expected by our customers and internal groups
• Ensure database availability, performance, and security in production environments.
• Instrument, monitor, pro-actively collaborate with development teams to optimize schema design, indexing, and query plans.
• Automate tasks using scripts or infrastructure-as-code tools.
• Understanding of cloud infrastructure and services.
• Ability to design and implement database replication and failover solutions.
• Providing insights along with troubleshoot and resolve database-related incidents and outages
• Stay up to date with emerging database technologies and best practices.
• Work closely with customer facing support teams to evolve & empower them with SRE insights
• Ability to collaborate effectively with development and operations teams.
• Participate in on-call support and orchestrating blameless post-mortems and encourage the practise within the organization
• Provides inputs to the definition, collection and analysis of data relevant products systems and their interactions towards output resiliency of the IT ecosystem especially related impacting customer statisfaction, Revenue or IT productivity
• Actively engage and drive AI Ops adoption across teams

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• 8–12 years of professional experience as a Database administrator and or / database SRE with application knowledge
• Hands-on experience with Microsoft SQL Server, PostgreSQL, MySQL, and at least one leading NoSQL technology such as MongoDB, Cassandra, or Couchbase.
• Proficiency in writing complex SQL queries, stored procedures, and functions.
• Experience building self-heal scripts or remediation runbooks (Python, PowerShell, Bash)- Azure Logic Apps, Azure Functions- Integration with ServiceNow and AppDynamics APIs-
• Exposure with replication, clustering, and high availability setups.
• Experience with cloud platforms (AWS, Azure, Google Cloud Spanner, etc.).
• Solid understanding of database security, auditing, and compliance requirements.
• Familiarity with DevOps tools and practices (CI/CD, version control, infrastructure automation).
• Excellent problem-solving and analytical skills.
• Strong communication and documentation skills.

• Certifications such as Microsoft Certified: Azure Database Administrator Associate, MongoDB Certified DBA, or similar.
• Experience with cloud platforms (AWS RDS, Azure SQL, Google Cloud Spanner, etc.).
• Exposure to containerized database deployments using Docker or Kubernetes.

Leadership and Soft skills:

Driving for Results: Demonstrates perseverance and resilience in the pursuit of goals. Confronts and works to resolve tough issues. Exhibits a “can-do” attitude and a willingness to take on significant challenges

Decision Making: Quickly analyses complex problems to find actionable, pragmatic solutions. Sees connections in data, events, trends, etc. Consistently works against the right priorities

Collaborating: Collaborates well with others to deliver results. Keeps others informed so there are no unnecessary surprises. Effectively listens to and understands what other people are saying.

Communicating and Influencing: Ability to build convincing, persuasive, and logical storyboards. Strong executive presence. Able to communicate effectively and succinctly, both verbally and on paper.