Job Description
- Job Description:
- Helping our customers’ DBA teams when they need expert assistance
- Gathering relevant data and investigating issues to provide a detailed analysis of your findings in a digestible format by email, instant message or voice
- Performing screen-sharing sessions to help them quickly navigate and resolve issues for serious and production-impacting issues
- Authoring new blog posts on interesting topics for our open-source community
- Answering questions on our forum
- Creating new articles in our customer-facing knowledge base
- Hosting webinars
- Collaborating with some of the most well-known database experts
- Requirements:
- Good hands-on knowledge of PostgreSQL, PostgreSQL Provided tools and Contribution modules
- Be 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
- 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 equipment for your remote office
- Funds for career development (external training, certifications, conferences)
- Ongoing connectivity allowances
- Opportunity to participate in our equity incentive plan
- Support for a healthy work/life balance such as The Percona Adventure Team, Work-from-Anywhere, FlowDays, FryDays, and overall flexibility.
- Support for being socially responsible through our PAVE volunteering program and Women Transforming Technology.
Apply tot his job
Apply To this Job