Senior PostgreSQL Database Engineer

Senior PostgreSQL Database EngineerPercona 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.About You:You have deep, hands-on, expert knowledge of PostgreSQL, including PostgreSQL provided tools and contributor modulesYou are proficient with the wider PostgreSQL ecosystem of tools and technologies, such as pgvector, repmgr, barman, pglogical, Patroni, pgBouncer, and similar/related toolsYou have experience with performance tuning, including server configuration, query optimization, and table and index tuningYou 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 systemsYou have experience with containerization and Kubernetes, including deployment, administration, and troubleshooting problems encountered when using PostgreSQL under that environmentYou 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 issuesYou are self-taught, self-directed, and enthusiastic about growing your skillset with new technologies as the industry evolvesYou are available to travel internationally for occasional team meetings, conferences, or customer visitsYou are fluent in communicating with customers in English, both in verbally and in writingWhat 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 technologiesAdvanced Linux troubleshooting tools (gdb, perf, strace, bpftrace, tcpdump, etc)Experience with Percona's other core database products, including MySQL, MongoDB, and Valkey/RedisPrior experience using Percona's software, including PMM and our database distributionsExperience working in SLA-bound technical support operationsOpenSource Community contributionsPrior success working remotely and using screen-sharing, phone, Slack, Zoom, and similar technologies in that environmentExperience with cloud services such as AWS and RDS, Azure, GCPExcellent grasp of ANSI SQL 92 to 2016 and ability to write/rewrite SQL statements involving Window functions and recursive CTEsIndexing methods including Full-Text IndexingExperience 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 positionKubernetes-related certifications and trainingWhy Percona?At Percona, we believe an open world is a better world. Our mission is to enable everyone to innovate freely, by providing the best open source database software, support, and services. We make databases and applications run better through a unique combination of expertise and open source software built with the community for you. Our technical teams are experts in MySQL, MongoDB, PostgreSQL, and MariaDB.Percona is proud to be a remote-only and globally dispersed workforce – we have colleagues in more than 50 countries We offer a collaborative, highly-engaged culture where your ideas are welcome and your voice is heard.Our staff receives generous benefits including flexible work hours and various paid time off programs, all your equipment for your remote office, funds for career development (external training, certifications, conferences), ongoing connectivity allowances, and the opportunity to participate in our equity incentive plan. We also have benefits that support a healthy work/life balance such as The Percona Adventure Team, Work-from-Anywhere, FlowDays, FryDays, and overall flexibility. We also support being socially responsible through our PAVE volunteering program and Women Transforming Technology.If you love the idea of working with a high-growth tech company that is one of the best in the business and known globally as a leader in the open-source database space, let's talkConnect with us and stay up to date on our latest news and developments by following us on LinkedIn and Twitter. We look forward to connecting with you