Cloud Database Administrator

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.

**Responsibilities**:

- 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.