PostgreSQL Database Support Engineer - AMERICAS (Remote)

Percona; Toronto; Remote; CAD 75,000 - 95,000; Full time

Job summary

Percona is seeking a PostgreSQL Database Support Engineer for a remote role within the Americas. This position involves assisting customers with database issues, authoring content for the open-source community, and working with a collaborative team of experts. Ideal candidates will have solid knowledge of PostgreSQL, experience with Linux, and a passion for problem-solving in databases.

Benefits

Flexible work hours

Paid time off programs

Career development funds

Connectivity allowances

Equity incentive plan

Qualifications

• Good hands-on knowledge of PostgreSQL and related tools.
• Demonstrable experience in administering Linux-based systems.
• Ability to troubleshoot methodically and resolve complex issues.

Responsibilities

• Assist customers’ DBA teams by gathering data and investigating issues.
• Author new blog posts and create articles for the knowledge base.
• Conduct screen-sharing sessions for significant issues.

Skills

PostgreSQL

Performance tuning

Query optimization

Backup solutions

Linux administration

Job description

Join to apply for the PostgreSQL Database Support Engineer - AMERICAS (Remote) role at Percona

1 week ago Be among the first 25 applicants

Join to apply for the PostgreSQL Database Support Engineer - AMERICAS (Remote) role at Percona

Percona Support is a global, elite team of engineers who love getting to the bottom of weird and interesting database behaviour. 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.

• THIS ROLE IS BASED IN THE AMERICAS TIME ZONE

What you’ll be doing…

You’ll be teaming 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 develop your own skills and become more powerful than you can possibly imagine…. with databases.

This is not a boring, entry-level role where you’ll just be triaging the boring and monotonous.

Your main responsibility will be helping our customers’ DBA teams when they need expert assistance. You’ll do that by gathering relevant data and investigating 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’ll perform screen-sharing sessions to help them quickly navigate and resolve issues .

When you’re not fixing things, 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 for more frequently seen issues, and hosting webinars amongst other things.

This is a remote role, so you can be located anywhere in the world. All you need is a decent, stable internet connection.

What Have You Done :

• 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 to resolve complex issues
• Self-taught and enthused to grow your skill set with new technologies as the industry continues to evolve
• Availability to travel for the occasional team meeting, conference or customer visit
• Experience working with customers in English
• Very desirable to have related Kubernetes knowledge

What Would Make You Stand Out :

• MySQL knowledge
• Experience working in SLA-bound operations
• OpenSource Community contributions (could be a blog)
• Good practice with working over screen-sharing / phone
• 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
• 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

Why 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 talk!

Connect 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!

Seniority level

Seniority level

Entry level

Employment type

Employment type

Full-time

Job function

Job function

Information Technology

Software Development

Referrals increase your chances of interviewing at Percona by 2x

Sign in to set job alerts for “Remote Support Engineer” roles.

Technical Support Engineer, Trilogy (Remote) - $60,000 / year USD

Application Engineer : NetSuite / Salesforce

Mississauga, Ontario, Canada CA$99,000.00-CA$106,500.00 2 weeks ago

Identity Access Management Consulta 0305-0515

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.