Summary
Posted: Oct 18, 2023
Weekly Hours: 40
Role Number:200508564
The people here at Apple don't just build products - we craft the kind of wonder that's revolutionized entire industries. It's the diversity of those people and their ideas that supports 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. Would you like to be a part of one of the world's fastest growing data warehouses for the world's largest company? Does the prospect of being challenged with sophisticated database design and optimization problems excite you? The Global Business Intelligence (GBI) team within Apple's IS&T organization has a very large Enterprise Data Warehouse (EDW) to support analytical and reporting needs of hundreds of global Apple users. This is an extraordinary opportunity for an inquisitive, experienced and results-oriented database expert to work on our EDW platform to provide a scalable, high-performance and active data-warehousing platform. You are self-driven, highly motivated, innovative, have a good work ethic and have a consistent track record of designing and leading large, complex data warehouses. The position will involve close interaction with development, product, database administrators and support teams. This person will review database designs to ensure that they are optimized for performance, scalability and be a thought leader and champion in automation. This role will provide second-level support to address any platform wide performance and stability issues.
Want more jobs like this?
Get Data and Analytics jobs in Cupertino, CA delivered to your inbox every week.
Key Qualifications
- 5+ years experience in relational cloud based database technologies like Snowflake
- Ability to identify system level bottlenecks in the database and recommend solutions
- Object oriented programming experience in Python/Java or Scala
- Analyze production workloads and develop strategies to run Snowflake database with scale and efficiency
- Experience in Snowflake performance tuning, capacity planning, managing cloud spend and utilization is a plus
- Manage all aspects of database security both at infrastructure and application level
- Ability to articulate and enforce Snowflake best practices and find ingenious way of enforcing them
- Manage Cross regional data replication and be an expert at database recovery features
- Ability to define and automate DBA functions
- Experience with AWS or GCP or Azure cloud specifically in compute , storage and security services
Description
Participation in Physical Model reviews with the development teams to provide inputs on improving performance Continuous analysis of the database environment to capitalize on system-wide tuning opportunities Act as an inspiring leader and conduct brown bag lunch sessions for development teams to create awareness regarding the value proposition of new and upcoming features Performance optimization of database resources intensive ETL and individual user queries Drive new features testing, rollout and `adoption Workload Management analysis and improvement to meet response-time SLA's as well as optimize resource consumption Influence, establish best engineering practices through solid design decisions, processes and automation
Education & Experience
BS in Computer Science or equivalent
Additional Requirements
Pay & Benefits
- At Apple, base pay is one part of our total compensation package and is determined within a range. This provides the opportunity to progress as you grow and develop within a role. The base pay range for this role is between $138,900.00 and $256,500.00, and your base pay will depend on your skills, qualifications, experience, and location.
Apple employees also have the opportunity to become an Apple shareholder through participation in Apple's discretionary employee stock programs. Apple employees are eligible for discretionary restricted stock unit awards, and can purchase Apple stock at a discount if voluntarily participating in Apple's Employee Stock Purchase Plan. You'll also receive benefits including: Comprehensive medical and dental coverage, retirement benefits, a range of discounted products and free services, and for formal education related to advancing your career at Apple, reimbursement for certain educational expenses - including tuition. Additionally, this role might be eligible for discretionary bonuses or commission payments as well as relocation. Learn more about Apple Benefits.
Note: Apple benefit, compensation and employee stock programs are subject to eligibility requirements and other terms of the applicable plan or program.
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.