Database Performance Consultant PostgreSQL

Job description

Who is Percona?Percona is a respected thought leader in the open source community.

We provide services and software for MySQL, MongoDB, PostgreSQL and Maria DB to open source users globally.Percona is remote-first and globally dispersed; we have 320 people in almost 50 countries.

We offer a collaborative, highly-engaged culture where your ideas are welcome and your voice is heard.

The growth and development of our staff is a top priority; we provide funding for training, certifications, conferences and more.

Discover what it means to work with some of the smartest people in the industry, who also know how to have fun and are always willing to lend a helping hand.

We offer flexible hours, the ability to work remotely and the amazing experience of working with a multinational team of experts.The Percona Support Team…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.

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.

You’ll stand out if you have the following:

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 Will 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

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

Percona is a respected thought leader in the open-source community.

We provide services and software for MySQL, MongoDB, PostgreSQL and MariaDB to open-source users globally.

Percona is remote-first and globally dispersed; 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.

The growth and development of our staff is a top priority; we provide funding for training, certifications, conferences and more.

Discover what it means to work with some of the smartest people in the industry, who also know how to have fun and are always willing to lend a helping hand.

We offer flexible hours, the ability to work remotely and the amazing experience of working with a multinational team of experts. Percona's Lifestyle: · Enjoy the freedom to work remotely from anywhere in the world!· With top talent sourced globally, you will enjoy an international and culturally diverse team· Flexibility in your working hours means you can prioritize your personal life, pursue hobbies, volunteer, and stay active· Our internal programs include groups like: · The Percona Adventure Team: This team embarks on unforgettable journeys to breathtaking locations around the world for activities such as mountain climbing, hiking, white water rafting and more.

· Women Transforming Technology is a grassroots program committed to building a supportive community of women in technology.

Their goals are to connect, empower and inspire women in all areas and levels of the organization.· Flow days: Fridays at Percona are for focusing on finding your workflow.

Meetings and distractions are limited on Fridays so you can focus on getting things done.· FryDays:   With Percona being so globally dispersed there are not many holidays that overlap for everyone.

FryDays are four Fridays each year where everyone at Percona can unplug and enjoy the same 3-day weekend.Percona is remote-only and globally dispersed – 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 paid time off, all your equipment for your remote office, funds for career development (external training, certifications, conferences) and the opportunity to participate in an equity incentive plan.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!Location: Remote, work-from-home position anywhere.

5-day work week including weekendParticipation with the on-call team schedule.

You will need to be able to travel to company events, conferences, etc.

as safety permits.

Required Skill Profession

Computer Occupations