PostgreSQL Database Support Engineer

Job 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. Apply tot his job