The Postgres Database Team is responsible for design configuration and maintenance of fleet of Postgres databases under Data Services. We are engaged in interacting with application team to understand their requirements and suggesting optimal database solution to them. The Postgres databases are deployed across baremetal AWS and are part of Apples 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.
5-15 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 its 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 (pgdump/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
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.