6 hours ago
Bengaluru, IndiaSenior / Staff+
Responsibilities
- Design, configure, maintain, and administer PostgreSQL databases across production, QA, and development environments.
- Perform PostgreSQL installation, upgrades, patching, migrations, replication, backups, security configuration, and maintenance operations with near-zero downtime where required.
- Diagnose outages and operational issues, provide detailed root-cause analyses, and support the on-call/L2 team.
- Build database infrastructure automation scripts and manage infrastructure across bare metal, AWS, GCP, AliCloud, and Kubernetes.
- Measure and optimize performance, throughput, resource utilization, capacity, and query execution plans.
- Develop database architecture and design solutions and evaluate new technologies, extensions, and features for scalable distributed databases.
- Benchmark database versions and technologies using pgbench or other open-source tools.
- Participate in a 12x7 FTE/L3 on-call support rotation.
Requirements
- MS in Computer Science, Engineering, or equivalent.
- 8–12 years of experience supporting PostgreSQL databases in high-volume, customer-facing environments.
- In-depth knowledge of PostgreSQL architecture, engine internals, MVCC, optimization, performance tuning, execution plans, parameters, and configuration.
- Hands-on experience with major and minor version upgrades, migrations, logical and physical replication, active-active replication, installation from source or RPM, and near-zero-downtime operations.
- Experience building and administering large-scale, high-transaction-volume infrastructure in mission-critical environments.
- Proficiency in SQL and at least one scripting language, such as Shell or Python.
- Experience administering users, permissions, role-based access, backup methodologies, and database security best practices.
- Strong hands-on experience with AWS RDS/EC2, GCP GKE, AliCloud services, and Kubernetes.
- Deep expertise in Oracle-to-PostgreSQL migration and associated challenges and solutions.
- Experience with CI/CD pipelines and Infrastructure as Code using Terraform or Ansible is a plus.
- Certified Kubernetes Administrator certification and AWS Certified Solutions Architect Associate certification are listed qualifications.
- Strong communication, collaboration, independent learning, problem-solving, and delivery skills.
Tech Stack
Categories
Site Reliability
About Apple
Apple designs and sells consumer electronics, software, and services for consumers and professionals worldwide, including iPhone, Mac, iPad, Apple Watch, and AirPods, plus platforms like iOS/macOS and services such as the App Store, iCloud, Music, and TV+. Its business combines device sales with services and subscriptions and in-house silicon design. Founded in 1976, Apple is headquartered in Cupertino, California, and trades on NASDAQ as AAPL.