Postgres DB Engineer

Hyderabad, Telangana, India
Software and Services

Summary

Posted:
Role Number:200205298
The people here at Apple don’t just build products — they build the kind of wonder that’s revolutionized entire industries. It’s the diversity of those people and their ideas that encourages 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. 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 Kubernetes.

Key Qualifications

  • 6+ years supporting Postgres databases in a high volume customer facing environment
  • Strong experience in optimizing and performance tuning of Postgres including drill-down analysis
  • Hands-on experience in configuring and supporting replication
  • Background in building large infrastructure supporting a high volume of transactions in a mission-critical environment
  • Extraordinary experience administering multi-terabyte databases
  • Proficiency with SQL, Shell/Python/Perl/GO
  • Strong communication skills and ability to work effectively across multiple business and technical teams
  • Ability to thrive in a fast-paced, tight deadline delivery timeline
  • Aptitude to independently learn new technologies
  • Must have experience in AWS (RDS/EC2)
  • Out of the box thinking. Must be able to think multiple solutions to same problem.

Description

We are looking to hire extraordinary individuals to join the Global Data Services team to lead the Postgres database platform. In this role you will help build and run the RDBMS platform that delivers Apple services to all of its customers around the world and help us build the Apple experience on a global scale. The expectations from the job position would be: - You will be responsible for administration of production, QA and development database infrastructure - Data Services: Provide database architecture and design solutions. - Database Infrastructure Setup, Configuration, upgrading/Patching, Monitoring and troubleshooting - Build the automation scripts for database infrastructure - Implementing standard methodologies for DR and Backups - Measurement and optimization of system performance Capacity planning and forecast management - Participate in new technology/feature evaluation, design, and development of highly scalable distributed databases - Be able to do performance benchmarking between either two versions of same database technology or two different database technologies - Manage the databases deployed in Cloud Infrastructure including AWS and Kubernetes - Position may require 12x7 on-call support rotation with other team members. - AWS Certified Solutions Architect - Associate is nice to have

Education & Experience

BS in Computer Science or equivalent experience

Additional Requirements