Skip to content

Percona

PostgreSQL Database Support Engineer

Posted Updated

Description

  • 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

Benefits

  • Learning academy to encourage personal and professional growth
  • Wellness counselling program and allowance to all Perconians
  • Work remotely and choose the hours that suit you best
  • Flow day dedicated to uninterrupted focus and productivity
  • FryDays every quarter (a 3-day weekend to disconnect and enjoy life)
  • Be a skilled with some of the PostgreSQL ecosystem of tools and technologies
  • Some experience with high availability solutions (replication, routers, proxies, etc)
  • Experience working with customers in English
  • Exposure and practice with zero-downtime procedures
  • Availability to travel for the occasional team meeting, conference or customer visit
  • 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
  • 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
  • Very desirable to have related Kubernetes knowledge
  • Good understanding of monitoring requirements
  • Demonstrable experience of administering Linux based systems
  • Good hands-on knowledge of PostgreSQL, PostgreSQL Provided tools and Contribution modules
  • Self-taught and enthused to grow your skill set with new technologies as the industry continues to evolve
  • 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
  • Percona Monitoring & Management (PMM) and other monitoring tools
  • Cloud Services such as AWS and RDS, Azure, GCP
  • 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
  • Contrib Modules of PostgreSQL
  • Indexing methods including Full-Text Indexing
  • Foreign Data Wrappers of PostgreSQL (postgres_fdw, oracle_fdw, tde_fdw, file_fdw etc)
  • Most popular extensions - pg_repack, pg_partman, pg_audit etc
  • Advanced Linux troubleshooting tools (gdb, perf, strace, bpftrace, tcpdump, etc)
  • Experience programming in C

Skills

Apply

Apply to PostgreSQL Database Support Engineer at Percona

Create a free account first, or go straight to the employer.

Free RoleWatch account

  • Get an email when new jobs match your search
  • Save jobs and track every application
  • See how well your CV matches each job

Already have one?

No account needed. Opens the employer's own site in a new tab.

See also

Support jobs by country — openings, pay and top skills →