Software Data Architect, PostgreSQL Database AiDP

The people here at Apple dont just craft products - they build the kind of wonder thats revolutionized entire industries! Its 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!nnAI u0026 Data Platforms (AiDP) is ISu0026Ts 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 ISu0026T build solutions more efficiently and streamline the adoption and embedding of generative AI across PostgreSQL team at Apple is looking for an experienced committer to the PostgreSQL open source project to help lead the technical direction of PostgreSQL at Apple. The engineers on our team develop and operate Apples cloud-based relational database service hosting PostgreSQL databases that power some of Apples most important workloads in Services Manufacturing AI/ML and many more. You will be joining a team of experts working on modern database technologies distributed systems and storage engineering helping push the limits of open-source PostgreSQL to deliver enterprise-class performance availability and durability to our customers as well as ensuring reliable administration at scale. Your work will be deployed at massive scale serving millions of queries per second over many petabytes of data across our data centers worldwide and impacting the experiences of many millions of users of key Apple is a rare opportunity to continue your open source contributions to the worlds most popular open source relational database on behalf of our team at Apple. You will be the recognized technical authority for PostgreSQL internals at Apple setting direction across the engine representing Apple in the global PostgreSQL community and growing the next generation of contributors and committers at Apple.

The Apple Postgres team develops and operates a highly reliable cloud relational database service that serves all of Apple. As a PostgreSQL committer joining at this level you will act as an established technical authority and thought leader for PostgreSQL internals and features - anticipating and framing systemic challenges shaping technical direction across multiple teams and ensuring consistency and a high-quality bar in everything from query execution storage replication high-availability scaling and administration to new feature development and every other aspect of the will operate at the intersection of Apple and the upstream community driving an upstream-first strategy so that Apples needs are met in community PostgreSQL rather than through divergent implementations. You will advise engineering leaders and key stakeholders to align technical execution with business priorities and serve as the key resource whose judgment shapes critical decisions for the Postgres in this role is built on deep PostgreSQL expertise together with a strong command of the systems the database runs on and the discipline to keep it fast and reliable at scale:nn- PostgreSQL internals first-hand contribution-level knowledge of the engine whether in the query planner and executor storage and access methods WAL and recovery replication MVCC and concurrency or the extension and API surface.n- The systems the engine runs on the operating-system principles (process scheduling memory management disk and network I/O) and server-class hardware (storage devices and controllers network interfaces) that determine how PostgreSQL performs and stays durable.n- Behavior at scale how distributed high-throughput systems handle replication failure detection load balancing and request pipelining and the consistency isolation and availability trade-offs they must make.n- Engineering for performance and correctness profiling benchmarking and advanced testing methodologies together with fluency in the debugging tools needed to diagnose issues in development and role also requires excellent communication and the ability to partner closely with our Database Engineering and SRE teams a high degree of customer focus when engaging with internal customers and the ability to explain highly complex technical material clearly and concisely to leaders across the organization. The ability to work effectively with colleagues based in other locations is essential.

Mentor and grow engineers: a primary focus of this role. Grow the next generation of Apples PostgreSQL contributors into significant contributors to the community lead design and code reviews cultivate deep internals expertise across the team and play a key role in attracting developing and retaining top database engineering Apples needs with the communitys vision for PostgreSQL: Understand Apples relational database requirements deeply and shape them into proposals that strengthen PostgreSQL for everyone; drive consensus on their merits through open community discussions and review; and collaborate with other upstream committers to refine and land these improvements upstream keeping Apple on community PostgreSQL rather than on divergent private Apple in the PostgreSQL community: Be an active trusted voice in the community mailing lists during design and review discussions; represent Apple at major PostgreSQL conferences and events; grow Apples standing in the community as a major stakeholder of the internal technical direction and quality bar: Establish technical direction and standards for Apples PostgreSQL internals across query execution storage replication high-availability scaling and administration; anticipate systemic challenges before they surface and frame the approaches that resolve them; ensure consistency and a high standard of engineering across teams.

Current or former committer to the PostgreSQL open source sustained record of contributing features to PostgreSQL that have been well received in Computer Science/related fields with 10 years of relevant level of proficiency in C (and where relevant C or Rust).nAdvanced understanding of data structures and algorithms in storage and knowledge of the internals of technical leadership and the ability to set technical direction across teams.

MS or PhD in Computer Science/related fields (MS with 8 years or PhD with 5 years of relevant experience).nAuthorship of major PostgreSQL features or sustained maintainership of a significant subsystem of the of speaking at PostgreSQL developer conferences and of mentoring other of Linux Kernel development and performance optimizations