Cloud Database Administrator, Enterprise Systems

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

Summary

Posted:
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.

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