Database Engineer - PostgreSQL Site Reliability Engineering

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.

Minimum Qualifications

MS in Computer Science / Engineering or Equivalent. 8 - 12 years of experience supporting PostgreSQL databases in a high-volume, customer-facing environment In-depth understanding of PostgreSQL architecture and the internal workings of the PostgreSQL engine Strong experience in PostgreSQL optimization and performance tuning, including drill-down analysis and execution plan awareness Deep understanding of MVCC and how it is implemented in PostgreSQL Ability to perform major and minor version upgrades and migrations with near-zero downtime, while selecting the right approach for each situation Strong awareness of various types of maintenance operations, including when and how to perform them Hands-on experience configuring and supporting replication (logical, physical, active-active) Able to perform PostgreSQL installation via source code or RPM Strong knowledge of PostgreSQL parameters and tune those parameters and configurations to optimize performance, throughput, and resource utilization Manage day-to-day operations and issues, and extend expertise to provide the required support to the on-call/L2 team, including finding detailed RCAs for outages Experience implementing PostgreSQL security best practices Background in building and administering large-scale infrastructure supporting high transaction volumes in a mission-critical environment

Preferred Qualifications

Able to manage user administration, permissions, and role-based access grants Able to implement standard backup methodologies (pg_dump/restore, online backups, Incremental backups, Differential backups ) Proficient in SQL and at least one scripting language (Shell, Python) Strong communication skills and the ability to collaborate effectively across business and technical teams Ability to thrive in a fast-paced environment with tight delivery timelines Aptitude for independently learning and implementing new technologies for maximum benefit Strong hands-on experience with AWS (RDS/EC2), GCP (GKE), and AliCloud-related services Creative, out-of-the-box thinker, able to devise multiple solutions to the same problem Responsible for administering production, QA, and development database infrastructure Provides database architecture and design solutions Handles database infrastructure setup, configuration, upgrades/patching, monitoring, and troubleshooting Builds automation scripts for database infrastructure Measures and optimizes system performance, including capacity planning and forecasting Participates in evaluation, design, and development of new technologies, extensions, and features for highly scalable distributed databases Able to perform performance benchmarking between different versions of the same database technology, or between different database technologies, using pgbench or other open-source tools Able to manage databases deployed across cloud infrastructure, including AWS, GCP, AliCloud, and Kubernetes May require participation in a 12*7 FTE/L3 on-call support rotation with other team members Awareness of AI tolling and MCP servers. Deep expertise into the Oracle to PostgreSQL migration and associated challenges and solutions. Experience with CI/CD pipelines and Infrastructure as Code (Terraform, Ansible) is a plus Certified Kubernetes Administrator (CKA) AWS Certified Solutions Architect Associate

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.