Database Engineer (PostgreSQL SRE)
Apple · Software and Services
Apply ↗Skills
["AWS""GCP""Kubernetes""PostgreSQL""Python""SQL""Scala"]Technology stack
{"programming_languages": ["Python""Scala""SQL"]"frameworks": []"databases": ["PostgreSQL"]"cloud": ["AWS""GCP"]"infrastructure": ["Kubernetes"]"data_tools": []"ai_ml": []"other_tools": []}Description
We are part of Apple’s Information Systems and Technology (IS&T) division, and are based primarily in Sunnyvale, California with teams in Austin (TX), Seattle, Bangalore and Hyderabad India working as a single global team. The job is located in Bangalore, India.
Requirements
["5-8 years supporting Postgres databases in a high volume customer facing environmentIn depth understanding of PostgreSQL architecture.", "Database Infrastructure Setup, Configuration, upgrading/Patching, Monitoring and troubleshooting", "Handle day-to-day operations and issues provide the detailed RCA for outages.", "InDepth understanding of MVCC and how it's handled in PostgerSQL", "Upgrade databases major/minor version and migrations with near to zero downtime.", "Experience on HA (High Availability) Configuration and strong knowledge of High Availability and Disaster Recovery concepts", "Hands-on experience in configuring and supporting replication (logical/physical/active-active )", "Strong experience in optimizing and performance tuning of Postgres including drill-down analysis and awareness of execution plan", "Measurement and optimization of system performance Capacity planning and forecast management", "Provide database architecture and design solutions.", "Experience with PostgreSQL Security best practice implementations", "Implement standard methodologies Backups (pg_dump/restore , online backup, incremental backup)", "Ability to thrive in a fast-paced, tight deadline delivery timeline", "Participate in new technology/extension/feature evaluation, design, and development of highly scalable distributed databases", "Performance benchmarking via pgbench or other opensource tool", "Should able to manage the databases deployed in Cloud Infrastructure including AWS/GCP and Kubernetes", "Preferred: Certified Kubernetes Administrator (CKA)", "Preferred: AWS Certified Solutions Architect - Associate", "Preferred: Python knowledge"]
Roles & responsibilities
[]
About