The Database as a Service Team in the Platform and Shared Services organization is critical in ensuring the stability, performance, and reliability of the underlying database infrastructure that supports the organization’s applications and services.

As a Principal Postgres database engineer, you will be crucial in managing and optimizing our Postgres database systems to ensure high performance, reliability, and scalability. You will collaborate with cross-functional teams to design, implement, and maintain our Postgres database infrastructure. You will also automate database activities and provide self-service automation to developers.

• Database Management: Administer, maintain, and optimize Postgres database systems to ensure reliability, availability, and performance
• Performance Tuning: Identify and resolve performance bottlenecks, query optimization, and indexing to enhance database performance
• Database Design: Collaborate with application developers to design and implement efficient database schemas and data models
• High Availability and Disaster Recovery: Set up and maintain high availability configurations, including replication, clustering, and failover solutions
• Security: Implement and enforce database security best practices, including access controls and encryption
• Backup and Recovery: Develop and maintain database backup and recovery strategies to safeguard critical data
• Monitoring and Alerts: Implement monitoring tools and configure alerts to identify and address issues proactively
• Automation: Develop automation scripts and tools to streamline database administration tasks
• Documentation: Create and maintain clear and detailed documentation for database configurations, procedures, and best practices
• Research and Innovation: Stay up-to-date with the latest trends and technologies in PostgreSQL and database management to recommend improvements and optimizations
• Collaboration: Collaborate with cross-functional teams, including developers, DevOps engineers, and system administrators, to resolve database-related issues and support application development

Qualifications

• 10+ years of experience
• Bachelor’s in Computer Science or Computer Engineering

Experience/Skills

• Bachelor’s degree in Computer Science, Information Technology, or a related field
• 10+ years of hands-on experience as a Database Engineer, with a strong focus on PostgreSQL
• In-depth knowledge of PostgreSQL database architecture, administration, and performance tuning
• Proficiency in SQL, PL/pgSQL, and scripting languages like Python or Bash
• Experience with high availability and disaster recovery solutions
• Strong problem-solving and troubleshooting skills
• Familiarity with cloud-based database services (e.g., AWS RDS)
• Experience in building and running Postgres DB in Kubernetes and/or bare metal servers
• Working experience in Ceph and Rook is a big plus
• Excellent communication and teamwork skills
• Relevant certifications (e.g., PostgreSQL Certified Engineer) are a bonus