[Hiring] PostgreSQL Database Support Engineer @Percona

Role Description

Percona Support is a global, elite team of engineers who love getting to the bottom of weird and interesting database behaviour. 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.

What you’ll be doing:

• Teaming with some of the most well-known database experts in the industry.
• Developing your own skills and becoming more powerful with databases.
• Helping customers’ DBA teams when they need expert assistance.
• Gathering relevant data and investigating issues to provide detailed analysis.
• Performing screen-sharing sessions for serious and production-impacting issues.
• Authoring new blog posts on interesting topics for the open-source community.
• Answering questions on our forum and creating articles in our customer-facing knowledge base.
• Hosting webinars and other activities.

This is a remote role, so you can be located anywhere in the world. All you need is a decent, stable internet connection.

Qualifications

• 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 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 and apply fixes for known errors.
• Self-taught and enthusiastic to grow your skill set with new technologies.
• Availability to travel for occasional team meetings, conferences, or customer visits.
• Experience working with customers in English.
• Very desirable to have related Kubernetes knowledge.

Requirements

• MySQL knowledge.
• Experience working in SLA-bound operations.
• OpenSource Community contributions (could be a blog).
• Good practice with working over screen-sharing/phone.
• Patroni / Repmgr / Stolon.
• Cloud Services such as AWS and RDS, Azure, GCP.
• Percona Monitoring & Management (PMM) and other monitoring tools.
• Configuration management solutions such as Ansible, Puppet, or Chef.
• Good grasp of ANSI SQL 92 to 2016 and ability to write/rewrite SQL statements involving Window functions and recursive CTEs.
• Indexing methods including Full-Text Indexing.
• Contrib Modules of PostgreSQL.
• Most popular extensions - pg_repack, pg_partman, pg_audit, etc.
• Foreign Data Wrappers of PostgreSQL (postgres_fdw, oracle_fdw, tde_fdw, file_fdw, etc.).
• Advanced Linux troubleshooting tools (gdb, perf, strace, bpftrace, tcpdump, etc.).
• Experience programming in C.

Benefits

• Flexible work hours and various paid time off programs.
• All equipment for your remote office.
• Funds for career development (external training, certifications, conferences).
• Ongoing connectivity allowances.
• Opportunity to participate in our equity incentive plan.
• Support for a healthy work/life balance.
• Participation in the PAVE volunteering program and Women Transforming Technology.