Senior PostgreSQL Database Engineer
About the role
Who you are
- 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 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
- A decent, stable internet connection
- 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
- 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 talk!
What the job involves
- 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
- 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
About Percona
Percona is widely recognized as a world-class open source database software, support, and services company. The organization is dedicated to helping businesses make databases and applications run better through a unique combination of expertise and open source software. Percona works with numerous global brands across many industries creating a unified experience to monitor, manage, secure, and optimize database environments on any infrastructure.
Percona equips organizations with the freedom to choose, the freedom to create, and the freedom to make a difference - helping them scale and innovate with speed as they grow.
Databases run better with Percona.
Senior PostgreSQL Database Engineer
About the role
Who you are
- 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 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
- A decent, stable internet connection
- 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
- 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 talk!
What the job involves
- 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
- 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
About Percona
Percona is widely recognized as a world-class open source database software, support, and services company. The organization is dedicated to helping businesses make databases and applications run better through a unique combination of expertise and open source software. Percona works with numerous global brands across many industries creating a unified experience to monitor, manage, secure, and optimize database environments on any infrastructure.
Percona equips organizations with the freedom to choose, the freedom to create, and the freedom to make a difference - helping them scale and innovate with speed as they grow.
Databases run better with Percona.