The Apple Postgres team needs to develop and contribute to PostgreSQL, the world's most popular open-source relational database, to power Apple's cloud-based relational databases service. This service hosts PostgreSQL databases that are critical for various Apple workloads, including Services, Manufacturing, and AIML, and needs to offer enterprise-class performance, availability, and durability.
Requirements
- Fundamentals of system-level hardware and networking components (storage devices and controllers, network interfaces) in server class systems.
- Operating systems concepts (process scheduling, disk and network I/O, performance).
- Understanding of database concepts (relational algebra, query optimization, consistency models, isolation levels, crash and recovery semantics).
- Advanced concepts such as failure detection, load balancing, request pipelining and operational semantics of high-throughput systems
- Performance engineering, understanding of advanced testing methodologies, familiarity with debugging and profiling tools
- High level of proficiency in C, C++, Rust
- Advanced understanding of data structures and algorithms in storage and indexing, coding in C, C++
Responsibilities
- develop and contribute to PostgreSQL
- develop and operate Apple’s cloud-based relational databases' service hosting PostgreSQL databases
- push the limits of open-source PostgreSQL
- contribute to all major components of PostgreSQL, including query execution, storage, replication, high-availability, scaling, administration, new feature development and all other aspects of the database
- deploy work at massive scale, serving millions of queries per second over many petabytes of data
- ensure reliable administration
- help mentor junior engineers
Other
- curious, enthusiastic and collaborative developers with an extraordinary degree of care and rigor in engineering
- excellent communication
- ability to partner closely with our Database Engineering and SRE teams
- high degree of customer focus when engaging with internal customers
- ability to work effectively with colleagues based in other locations
