Senior PostgreSQL Database Engineer (Remote)

Percona Support is a global team of elite 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. 

What you’ll do…

You will team with some of the most well-known database experts in the industry who are even better teammates, friends, and mentors. You’ll have the opportunity to hone your database skills and take your knowledge to the next level by facing the most complex problems within our group.

This is a senior role, requiring deep expertise and skill across several complex and challenging technical areas. You must be self-directed, with a high degree of attention to detail and critical thinking. You will have the opportunity to work with very large hardware on some of the most massive database deployments in the world, helping global Fortune 50 companies whose businesses depend on their databases.

Your main responsibility will be helping our customers’ DBA teams when they need expert assistance with high complexity problems. You’ll gather relevant data and investigate 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 will perform screen-sharing sessions to help them quickly navigate and resolve issues.

When you’re not solving customer problems, 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, and more.

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

What Have You Done:

• You have deep, hands-on, expert knowledge of PostgreSQL, including PostgreSQL provided tools and contributor modules

• You are proficient with the wider PostgreSQL ecosystem of tools and technologies, such as pgvector, repmgr, barman, pglogical, Patroni, pgBouncer, and similar/related tools

• You have experience with performance tuning, including server configuration, query optimization, and table and index tuning

• You are familiar with backup solutions and best practices including pg base backup, pgBackRest and WAL-G, Point-in-Time-Recovery, etc.

• You are experienced with high availability solutions, including replication, routers, proxies, etc.

• You have demonstrable experience administering Linux systems

• You have experience with containerization and Kubernetes, including deployment, administration, and troubleshooting problems encountered when using PostgreSQL under that environment

• You are able to troubleshoot methodically, identifying and applying fixes for known errors, and when necessary, demonstrating a capacity to think outside of the box to resolve complex issues

• You are self-taught, self-directed, and enthusiastic about growing your skillset with new technologies as the industry evolves

• You are available to travel internationally for occasional team meetings, conferences, or customer visits

• You are fluent in communicating with customers in English, both in verbally and in writing

What Will Make You Stand Out:

• Software development experience, including specifically C, C++, and Go, in order to understand the internal workings of PostgreSQL, Percona’s Operator for PostgreSQL, and related technologies

• Advanced Linux troubleshooting tools (gdb, perf, strace, bpftrace, tcpdump, etc)

• Experience with Percona’s other core database products, including MySQL, MongoDB, and Valkey/Redis

• Prior experience using Percona’s software, including PMM and our database distributions

• Experience working in SLA-bound technical support operations

• OpenSource Community contributions

• Prior success working remotely and using screen-sharing, phone, Slack, Zoom, and similar technologies in that environment

• Experience with cloud services such as AWS and RDS, Azure, GCP

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

• Experience with the foreign data wrappers of PostgreSQL (postgres_fdw, oracle_fdw, tde_fdw, file_fdw, etc.)

• Active desire to serve as a subject matter expert and mentoring resource with