Database Engineer (Postgres 10.0 or later), Apple Media Products

Santa Clara Valley (Cupertino), California, United States
Software and Services

Summary

Posted:
Role Number:200124671
Do you love designing high-performance database architecture? Optimizing real-time query performance? Providing data that results in real innovation and change? If you do, then read on. Our team provides data-driven insights to Apple employees throughout the Services organization — App Store, Music, Video, Books, Podcasts, and more. We're looking for a Database Engineer to continue the excellent work we've done building our data platform, so that we can continue to drive innovation and improve our product decision making processes. Our tools are used by Apple engineers to improve search, recommendation, and fraud detection algorithms, and our data visualizations provide key insights to executives so that they can produce Apple-quality customer experiences. This role will work closely with data engineers and software engineers both on our team and cross-functionally. Our team is geographically and chronologically diverse, so we're looking for someone self-motivated and focused. We thrive on encouraging feedback and constructive criticism.

Key Qualifications

  • Requirements:
  • Expertise in administering Postgres (version 10.0 and later) on VMs
  • Expertise in performance tuning SQL queries
  • Expertise in OLAP database architecture
  • Experience with star schemas
  • Experience ingesting ETL data
  • Experience managing multiple application environments (production, QA, staging)
  • Experience with tools in the Postgres ecosystem
  • Experience with Postgres security best practices
  • Bonuses:
  • Experience with non-relational data stores
  • Experience with Ruby on Rails
  • Experience with Hadoop or other big data platforms

Description

Maintain and improve our high level of database query performance. Build and scale new data-centric features for our users. Integrate with large-scale data stores outside of our team. Ingest multi-dimensional ETL data. Explore and implement cloud DBaaS solutions. Improve deployment pipelines for our database environments. Improve fault tolerance. Improve database monitoring capabilities. Implement automated testing for data reliability

Education & Experience

BA/BS or higher in computer science or equivalent work experience.

Additional Requirements