Apply on Employer Site

Percona · 2 months ago

Senior PostgreSQL Database Engineer (Remote)

United States

Full-time

Remote

Senior Level

Percona is a global team of elite engineers specializing in database support. The Senior PostgreSQL Database Engineer will assist customers' DBA teams with complex database issues, provide detailed analyses, and contribute to community knowledge through blog posts and articles.

ConsultingInformation TechnologyInternetInternet of ThingsIT ManagementOpen SourceSoftware

Growth Opportunities

Responsibilities

Helping our customers’ DBA teams when they need expert assistance with high complexity problems

Gather relevant data and investigate issues to provide a detailed analysis of your findings in a digestible format by email, instant message, or voice

Perform screen-sharing sessions to help them quickly navigate and resolve issues

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

Qualification

PostgreSQL expertisePerformance tuningHigh availability solutionsLinux administrationContainerizationKubernetesBackup solutionsCloud servicesSoftware developmentTroubleshooting skillsOpenSource contributionsCommunication skillsMentoring

Required

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

Preferred

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 within Percona Support on topics related to this position

Kubernetes-related certifications and training