PostgreSQL Database Support Engineer (Remote)

Position Overview

• Location Type: Remote
• Employment Type: Full-Time
• Salary: Not specified

Percona Support is a global, elite team of engineers who love getting to the bottom of weird and interesting database behavior. We understand our customers’ business needs and the nuances of their technical environments. This allows us to help our customers see the big picture and identify opportunities to improve their overall database infrastructures. This is not a boring, entry-level role where you’ll just be triaging the boring and monotonous. Your main responsibility will be helping our customers’ DBA teams when they need expert assistance. You’ll do that by gathering relevant data and investigating issues to provide a detailed analysis of your findings in a digestible format by email, instant message or voice. For more serious and production-impacting issues, you’ll perform screen-sharing sessions to help them quickly navigate and resolve issues. When you’re not fixing things, you’ll be authoring new blog posts on interesting topics for our open-source community to digest, answering questions on our forum, creating new articles in our customer-facing knowledge base for more frequently seen issues, and hosting webinars amongst other things. This is a remote role, so you can be located anywhere in the world. All you need is a decent, stable internet connection.

Requirements

• Good hands-on knowledge of PostgreSQL
• PostgreSQL Provided tools and Contribution modules
• Skilled with some of the PostgreSQL ecosystem of tools and technologies
• Knowledgeable about performance tuning, query optimization, & index tuning
• Know-how of backup solutions such as pg base backup, pgBackRest and WAL-G, etc., and also the Point-in-Time-Recovery
• Some experience with high availability solutions (replication, routers, proxies, etc)
• Exposure and practice with zero-downtime procedures
• Good understanding of monitoring requirements
• Demonstrable experience of administering Linux based systems
• Ability to troubleshoot methodically, identifying and applying fixes for known errors, and when necessary, capacity to think outside of the box to resolve complex issues
• Self-taught and enthused to grow your skill set with new technologies as the industry continues to evolve
• Availability to travel for the occasional team meeting, conference or customer visit
• Experience working with customers in English

Responsibilities

• Teaming with database experts as mentors and teammates.
• Helping customers’ DBA teams with expert assistance.
• Gathering relevant data and investigating issues.
• Providing a detailed analysis of findings in a digestible format (email, instant message, voice).
• Performing screen-sharing sessions to resolve issues.
• Authoring new blog posts on interesting topics for the open-source community.
• Answering questions on the forum.
• Creating new articles in the customer-facing knowledge base.
• Hosting webinars.

Desirable Skills & Experience

• MySQL knowledge
• Experience working in SLA-bound operations
• OpenSource Community contributions
• Good practice with working over screen-sharing/phone
• Patroni / Repmgr / Stolon
• Cloud Services such as AWS and RDS, Azure, GCP
• Percona Monitoring & Manage