SummaryPosted: Dec 11, 2024Role Number:200582908Imagine what you could do here. At Apple, great ideas have a way of becoming great products, services, and customer experiences very quickly. Bring passion and dedication to your job and there's no telling what you could accomplish! The Database Engineering team under Data Services at Apple is responsible for providing Engineering Solutions to a large fleet of mission critical databases. The Data Services team is looking for candidates who will provide architecture and design solutions for multiple database technologies with expertise in Oracle, distributed databases like CockroachDB (CRDB) and will be in charge of fast-paced, sophisticated distributed database environments. This position demands the best and brightest Database engineers! Join us, and help build and run database platforms that deliver Apple services to all of its customers around the world and build the Apple experience on a global scale.DescriptionDescriptionWould you like to work in a fast-paced environment where your technical abilities will be challenged on a day to day basis? Do you want your work to make a difference in the lives of millions of people who use Apple's products and services? If so, we are looking to hire extraordinary individuals to join the Data Services team as a Datastore Engineer. The ideal candidate will work with multi-functional teams, locally and remotely, to design, develop, and support product and process development efforts for our next-generation services and products. The expectations from the job position would be: Design, architect, build and continuously maintain a high performance and highly available database infrastructure. Work closely with Application and Internal Infrastructure teams in advancing their strategic initiatives, operational readiness, engineering standards and designs. Support various database maintenance activities like Database Upgrades, Patch Management, User Management and Backup and Recovery. Troubleshoot and resolve database Performance issues and tune SQL queries proficiently. Deep understanding of various Oracle tuning areas (SGA, PGA, SQLs, IO, Latches, Locks) is a must. Setup and maintain Active-Active environments for databases within and across geographic locations. Configure and implement physical and logical replication solutions for zero data loss using Oracle Dataguard FSFO, Oracle Golden Gate, CockroachDB CDC, SharePlex, etc. Configure and maintain highly complex database systems involving Oracle Real Application Clusters (RAC). Drive disaster recovery tests for CockroachDB clusters by manually turning down pieces of to test its overall resilience to failures. Identify avenues for automation for mundane and recurring database tasks and implement automated solutions. Take ownership for fast-paced, complex and distributed database environments supporting OLTP systems across multiple platforms. Troubleshoot complex technical problems under pressure, implement solutions that are massively scalable, while managing multiple customer groups. Participate in rotational on call support, as necessary.Minimum QualificationsMinimum Qualifications7+ Years of work experience in IT Industry, with expertise in Large scale Database implementations including Oracle and Distributed Database Technologies like CockroachDB.Experience in designing and managing databases with a strong understanding of database concepts, troubleshooting skills and root cause analysis.Experience in handling architectural and design considerations such as performance, scalability and availability.Strong knowledge of High Availability architecture using Oracle DataGuard/FSFO, multi-region deployments using CockroachDB, Load balancer / Net Scaler configurations, Application Continuity.Extensive experience in handling data replication using Oracle Golden Gate, CockroachDB CDC, SharePlex with hands on experience in deploying Active active Setups, Conflict Detection, Log Dump analysis, etc.Deep understanding of Performance Tuning, including SQL Execution plans, wait events, Performance debugging features/tools, etc.Strong exposure in Oracle RAC, ASM and Storage/Networking.Hands-on experience in database migration to CockroachDB and designing table structures.Strong knowledge of Linux/Unix Internals, Systems/Application Design & Architecture.Expertise in working with major cloud providers (AWS, GCP, etc.) and Cloud APIs.Strong experience in automation/scripting using Shell/Perl/Python.Key QualificationsKey QualificationsPreferred QualificationsPreferred QualificationsKnowledge of other RDBMS technologies is a plus.Knowledge of Database deployments on Kubernetes is a plus.Strong analytical, critical thinking, and problem-solving skills.Excellent written and verbal communication skills, solid collaboration skillEducation & ExperienceEducation & ExperienceAdditional RequirementsAdditional RequirementsMore