Database Engineer (PostgreSQL SRE)

Database Engineer (PostgreSQL SRE)

Summary

AI & Data Platforms (AiDP) is IS&T's engine for AI-powered innovation. The team brings together data, application development, and machine learning — including generative AI — along with data services and customer success functions, to help IS&T build solutions more efficiently and streamline the adoption and embedding of generative AI across Apple.

The people here at Apple don’t just build products — they build the kind of wonder that’s revolutionized entire industries. It’s the diversity of those people and their ideas that encourages the innovation that runs through everything we do, from amazing technology to industry-leading environmental efforts. Join Apple, and help us leave the world better than we found it.

Imagine what you could do here. At Apple, extraordinary ideas have a way of becoming industry leading products, services, and customer experiences very quickly. Bring passion and dedication to your job and there's no telling what you could accomplish.

The Postgres Database Team is responsible for design, configuration and maintenance of fleet of Postgres databases under Data Services. We are engaged in interacting with application team to understand their requirements and suggesting optimal database solution to them. The Postgres databases are deployed across baremetal, AWS and Kubernetes.

Description

We are part of Apple’s Information Systems and Technology (IS&T) division, and are based primarily in Sunnyvale, California with teams in Austin (TX), Seattle, Bangalore and Hyderabad India working as a single global team.

The job is located in Bangalore, India.

Preferred Qualifications

Certified Kubernetes Administrator (CKA)
AWS Certified Solutions Architect - Associate
Python knowledge

Minimum Qualifications

5-8 years supporting Postgres databases in a high volume customer facing environmentIn depth understanding of PostgreSQL architecture.
Database Infrastructure Setup, Configuration, upgrading/Patching, Monitoring and troubleshooting
Handle day-to-day operations and issues provide the detailed RCA for outages.
InDepth understanding of MVCC and how it's handled in PostgerSQL
Upgrade databases major/minor version and migrations with near to zero downtime.
Experience on HA (High Availability) Configuration and strong knowledge of High Availability and Disaster Recovery concepts
Hands-on experience in configuring and supporting replication (logical/physical/active-active )
Strong experience in optimizing and performance tuning of Postgres including drill-down analysis and awareness of execution plan
Measurement and optimization of system performance Capacity planning and forecast management
Provide database architecture and design solutions.
Experience with PostgreSQL Security best practice implementations
Implement standard methodologies Backups (pg_dump/restore , online backup, incremental backup)
Ability to thrive in a fast-paced, tight deadline delivery timeline
Participate in new technology/extension/feature evaluation, design, and development of highly scalable distributed databases
Performance benchmarking via pgbench or other opensource tool
Should able to manage the databases deployed in Cloud Infrastructure including AWS/GCP and Kubernetes