Cloud Database Administrator

Job Description

Overview: PepsiCo Data BI & Integration Platforms is seeking a midlevel Database Cloud Platform technology leader, responsible for overseeing the deployment, and maintenance of big data and analytics cloud infrastructure projects on Azure/AWS for its North America, LATAM and Global (Finance, Integrated Business Planning, Consumer & Commercial, Sales, Sustainability) PepsiCo Foods/Beverages business. The ideal candidate will have hands-on experience with Azure/AWS services – Infrastructure as Code (IaC), platform provisioning & administration, cloud network design, cloud security principles and automation. Responsibilities: Design, deploy and optimize cloud-based infrastructure using Azure/AWS services that meet the performance, availability, scalability, and reliability needs of our applications and services. Database Administration: Manage and maintain database instances, including installation, configuration, patching, and upgrades. Performance Tuning: Monitor database performance, identify bottlenecks, and implement optimizations. Security: Implement and maintain database security measures, such as user authentication, access control, and encryption. Backup and Recovery: Establish and maintain backup and recovery procedures to ensure data protection. Data Migration: Migrate data from existing databases to Azure/AWS cloud platforms. Capacity Planning: Plan and manage database resources to ensure scalability and availability. Automation: Automate database management tasks to improve efficiency. Troubleshooting: Troubleshoot database issues and resolve performance problems. Database Design and Development: Design, develop, and implement databases in Azure/AWS. User Account Management: Create and manage user accounts, granting appropriate permissions. Reporting and Monitoring: Generate database reports, monitor database activity, and track key performance indicators (KPIs). Develop Infrastructure as Code (IaC) to automate provisioning and management of cloud resources. Write and maintain scripts for automation and deployment using PowerShell, Python, or Azure/AWS CLI. Work with stakeholders to document architectures, configurations, and best practices. Knowledge of cloud security principles around data protection, identity and access Management (IAM), compliance and regulatory, threat detection and prevention, disaster recovery and business continuity. Qualifications: Bachelor’s degree in computer science. At least 4 to 6 years of experience in IT cloud infrastructure, architecture and operations, including security, with at least 2 years in a technical leadership role Strong knowledge of cloud architecture, design, and deployment principles and practices, including databases, data warehouses, and DevOps. Expertise in Azure/AWS networking and security fundamentals, including network endpoints & network security groups, firewalls, external/internal DNS, load balancers, virtual networks and subnets. Proficient in scripting and automation tools, such as PowerShell, Python, Terraform, and Ansible. Excellent problem-solving, analytical, and communication skills, with the ability to explain complex technical concepts to non-technical audiences. Certifications in Azure/AWS platform administration, networking and security are preferred. Strong self-organization, time management and prioritization skills A high level of attention to detail, excellent follow through, and reliability Strong collaboration, teamwork and relationship building skills across multiple levels and functions in the organization Ability to listen, establish rapport, and credibility as a strategic partner vertically within the business unit or function, as well as with leadership and functional teams Strategic thinker focused on business value results that utilize technical solutions Strong communication skills in writing, speaking, and presenting Capable to work effectively in a multi-tasking environment. Fluent in English language.