PostgreSQL Database Support Engineer

May 7

Apply Now

Receive Emails with Similar Jobs

Percona

WebsiteLinkedInAll Job Openings

Enterprise • Software as a Service (SaaS) • Database Technology

Percona is an open source database software, support, and services company that helps enhance the performance and reliability of databases and applications. The company provides a variety of tools and services tailored for MySQL, MongoDB, and PostgreSQL databases, offering managed services, consulting, and training to support enterprises in managing their complex database environments. Percona is recognized for its commitment to open source solutions, ensuring that clients maintain control and secure access to their data without being locked into commercial licenses. Their solutions focus on scalability, proactive performance tuning, high availability, and security, serving thousands of customers with varied database needs. With a strong emphasis on community engagement and continuous innovation, Percona is dedicated to driving success and efficiency in database management.

201 - 500 employees

Founded 2006

🏢 Enterprise

📋 Description

• Percona Support is a global team of engineers. • You’ll be teaming with some of the most well-known database experts in the industry. • Opportunity to develop your own skills. • Not a boring, entry-level role. • Main responsibility will be helping customers’ DBA teams. • Gather relevant data and investigating issues. • Provide a detailed analysis of findings. • Authoring new blog posts on interesting topics for the open-source community. • Answering questions on the forum. • Creating new articles in the customer-facing knowledge base. • Hosting webinars amongst other things. • This is a remote role with a stable internet connection required.

🎯 Requirements

• Good hands-on knowledge of PostgreSQL, PostgreSQL Provided tools and Contribution modules • 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 • 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, identifying and applying fixes for known errors, and when necessary, capacity to think outside of the box • Self-taught and enthused to grow your skill set with new technologies as the industry continues to evolve • Availability to travel for occasional team meeting, conference or customer visit • Experience working with customers in English • Very desirable to have related Kubernetes knowledge • 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 • Various paid time off programs • All your equipment for your remote office • Funds for career development (external training, certifications, conferences) • Ongoing connectivity allowances • Opportunity to participate in equity incentive plan • Support for a healthy work/life balance • PAVE volunteering program • Women Transforming Technology.