jobapplier

PostgreSQL Database Support Engineer

Percona

Skills

Required

  • PostgreSQL
  • Linux
  • monitoring
  • replication
  • routers
  • proxies
  • Kubernetes
  • MySQL
  • Ansible / Puppet / Chef
  • SQL

Preferred

  • Assisting customers' DBA teams
  • investigating issues
  • RDS
  • Azure
  • pg

Join our team as a PostgreSQL Database Support Engineer, where you'll provide expert assistance to our customers' DBA teams, investigate issues, and deliver detailed analyses. You'll also contribute to our open-source community by authoring blog posts, answering forum questions, and creating knowledge base articles. Enjoy benefits such as a learning academy, wellness counseling, remote work flexibility, and quarterly FryDays.

Indexing methods including Full-Text Indexing

Foreign Data Wrappers of PostgreSQL (postgres_fdw, oracle_fdw, tde_fdw, file_fdw etc)

Responsibilities

  • Assisting customers' DBA teams by gathering data and investigating issues to provide detailed analysis.
  • Performing screen-sharing sessions for serious and production-impacting issues to help customers navigate and resolve issues.
  • Authoring new blog posts, answering questions on forums, creating articles in the knowledge base, and hosting webinars.
  • Be a 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
  • Good practice with working over screen-sharing/phone
  • Patroni / Repmgr / Stolon
  • Cloud Services such as AWS and RDS, Azure, GCP
  • Most popular extensions - pg_repack, pg_partman, pg_audit etc

Requirements

  • 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
  • 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

  • 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
  • Contrib Modules of PostgreSQL
  • Advanced Linux troubleshooting tools (gdb, perf, strace, bpftrace, tcpdump, etc)
  • Experience programming in C

Preferred

  • OpenSource Community contributions (could be a blog)