Senior Database Engineer - Ad Platforms
Summary
Posted: 16 Aug 2024
Weekly Hours: 40...
Role Number:200548377
At Apple, we believe in the power of technology to enrich people's lives. Everything we build is designed to empower people, including our advertising platform. We deliver ads in a way that benefits both customers and advertisers helping people discover content, supporting creators, and protecting and respecting everyones privacy.
Our technology makes advertising possible on the App Store, Apple News, Stocks, and Apple TV. We help developers and marketers of all sizes drive app discovery across the App Store. Our display ads on Apple News and Stocks let advertisers promote their products alongside trusted content in a brand-safe environment, while supporting publishers and journalists. Sponsorship integrations and experiences in live sports on Apple TV help advertisers connect with captivated audiences. Everything we do is with the unwavering commitment to privacy you expect from Apple. Because when advertising is done right, it benefits everyone.
The Database Solutions team under Ad Platforms at Apple is drives database technologies selection, standards, patterns, and optimization to ensure the reliability, availability, performance, and efficiency of databases at scale.
The team partners closely with Ads engineering and other SRE and infrastructure teams to enable delivering product objectives via design, configuration, and maintenance of a fleet of databases that supports the Ad Platforms applications.
We are looking for Database Engineer candidates who will contribute to architecture and design solutions for multiple database technologies including Oracle, Postgres, and MySQL both on-premises and in AWS, and will provide exceptional support for fast-paced, sophisticated distributed database production and non-production environments supporting OLTP and OLAP systems.
Description
Description
Take ownership for fast-paced, complex, and distributed database environments (200+ Oracle, Aurora Postgres, and Aurora MySQL databases) supporting OLTP and OLAP systems across on-premises and AWS
Design, build, and continuously maintain high performance and highly available database and change data capture infrastructure
Migrate mission-critical database applications leveraging on-prem Oracle to using AWS Aurora Postgres
Work closely with development engineering teams in advancing their strategic initiatives, operational readiness, engineering
standards, designs, and performance
Support various database maintenance activities like database upgrades, patch management, user management, and backup
and recovery
Setup and maintain Oracle GoldenGate Active-Active environments for databases and Big Data
Configure Oracle Data Guard and RAC for high availability and implement zero data loss solutions
Implement infrastructure automation and scripting using tools like Shell, Python, and Terraform
Troubleshoot and resolve database performance issues and tune SQL queries proficiently
Database on-call for production and non-production during US hours as part of a 12x7 rotation
Minimum Qualifications
Minimum Qualifications
5 or more years of industry experience designing, managing, and supporting production databases at scale
3+ years supporting Oracle
2+ years supporting Aurora Postgres and Aurora MySQL
Extensive experience in handling architectural and design considerations such as performance, scalability and availability
Expertise in relational database engineering and administration for on-prem and RDS Oracle (19c, 12c), Aurora Postgres (12+), and Aurora MySQL (5.7+)
Strong knowledge in change data capture technologies (GoldenGate, Debezium)
Very skilled in database monitoring, tuning, and alerting with tools like Datadog, OEM, CloudWatch, Grafana, PagerDuty or similar technologies
Experienced in Infrastructure as Code via Terraform or similar technologies
Good knowledge of Linux/Unix internals, systems/application design & architecture
Strong analytical, critical thinking, and root cause analysis
Ability to communicate effectively, both written and verbal, with technical and non-technical multi-functional teams
Bachelor's degree in Computer Science or equivalent field
Key Qualifications
Key Qualifications
Preferred Qualifications
Preferred Qualifications
Graduate degree in Computer Science or equivalent field
Ad-Tech work experience
Experience with NOSQL technologies
Current AWS certifications
Education & Experience
Education & Experience
Bachelor's degree in Computer Science or equivalent is required; Master's degree preferred
Additional Requirements
Additional Requirements
- Ads technologies industry experience is a plus
- Experience with NOSQL technologies is a plus
- AWS certifications is a plus
More
Apple is an equal opportunity employer that is committed to inclusion and diversity. We take affirmative action to ensure equal opportunity for all applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, Veteran status, or other legally protected characteristics. Learn more about your EEO rights as an applicant
Apply Now
Posted: 16 Aug 2024
Weekly Hours: 40...
Role Number:200548377
At Apple, we believe in the power of technology to enrich people's lives. Everything we build is designed to empower people, including our advertising platform. We deliver ads in a way that benefits both customers and advertisers helping people discover content, supporting creators, and protecting and respecting everyones privacy.
Our technology makes advertising possible on the App Store, Apple News, Stocks, and Apple TV. We help developers and marketers of all sizes drive app discovery across the App Store. Our display ads on Apple News and Stocks let advertisers promote their products alongside trusted content in a brand-safe environment, while supporting publishers and journalists. Sponsorship integrations and experiences in live sports on Apple TV help advertisers connect with captivated audiences. Everything we do is with the unwavering commitment to privacy you expect from Apple. Because when advertising is done right, it benefits everyone.
The Database Solutions team under Ad Platforms at Apple is drives database technologies selection, standards, patterns, and optimization to ensure the reliability, availability, performance, and efficiency of databases at scale.
The team partners closely with Ads engineering and other SRE and infrastructure teams to enable delivering product objectives via design, configuration, and maintenance of a fleet of databases that supports the Ad Platforms applications.
We are looking for Database Engineer candidates who will contribute to architecture and design solutions for multiple database technologies including Oracle, Postgres, and MySQL both on-premises and in AWS, and will provide exceptional support for fast-paced, sophisticated distributed database production and non-production environments supporting OLTP and OLAP systems.
Description
Description
Take ownership for fast-paced, complex, and distributed database environments (200+ Oracle, Aurora Postgres, and Aurora MySQL databases) supporting OLTP and OLAP systems across on-premises and AWS
Design, build, and continuously maintain high performance and highly available database and change data capture infrastructure
Migrate mission-critical database applications leveraging on-prem Oracle to using AWS Aurora Postgres
Work closely with development engineering teams in advancing their strategic initiatives, operational readiness, engineering
standards, designs, and performance
Support various database maintenance activities like database upgrades, patch management, user management, and backup
and recovery
Setup and maintain Oracle GoldenGate Active-Active environments for databases and Big Data
Configure Oracle Data Guard and RAC for high availability and implement zero data loss solutions
Implement infrastructure automation and scripting using tools like Shell, Python, and Terraform
Troubleshoot and resolve database performance issues and tune SQL queries proficiently
Database on-call for production and non-production during US hours as part of a 12x7 rotation
Minimum Qualifications
Minimum Qualifications
5 or more years of industry experience designing, managing, and supporting production databases at scale
3+ years supporting Oracle
2+ years supporting Aurora Postgres and Aurora MySQL
Extensive experience in handling architectural and design considerations such as performance, scalability and availability
Expertise in relational database engineering and administration for on-prem and RDS Oracle (19c, 12c), Aurora Postgres (12+), and Aurora MySQL (5.7+)
Strong knowledge in change data capture technologies (GoldenGate, Debezium)
Very skilled in database monitoring, tuning, and alerting with tools like Datadog, OEM, CloudWatch, Grafana, PagerDuty or similar technologies
Experienced in Infrastructure as Code via Terraform or similar technologies
Good knowledge of Linux/Unix internals, systems/application design & architecture
Strong analytical, critical thinking, and root cause analysis
Ability to communicate effectively, both written and verbal, with technical and non-technical multi-functional teams
Bachelor's degree in Computer Science or equivalent field
Key Qualifications
Key Qualifications
Preferred Qualifications
Preferred Qualifications
Graduate degree in Computer Science or equivalent field
Ad-Tech work experience
Experience with NOSQL technologies
Current AWS certifications
Education & Experience
Education & Experience
Bachelor's degree in Computer Science or equivalent is required; Master's degree preferred
Additional Requirements
Additional Requirements
- Ads technologies industry experience is a plus
- Experience with NOSQL technologies is a plus
- AWS certifications is a plus
More
Apple is an equal opportunity employer that is committed to inclusion and diversity. We take affirmative action to ensure equal opportunity for all applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, Veteran status, or other legally protected characteristics. Learn more about your EEO rights as an applicant
Apply Now