Pythian is hiring a
PostgreSQL Database Consultant

Summary

The job is for a PostgreSQL Database Consultant at Pythian. The role involves providing complete support for database and application infrastructure to various customers, working collaboratively to solve complex puzzles, creating and documenting database standards, optimizing queries, indexes, and data structures, monitoring and supporting database environments, troubleshooting complex issues, identifying areas of opportunity, recommending improvements, authoring blog posts, creating articles for the knowledge base, hosting webinars, and participating in conferences and meetups. The benefits include a competitive total rewards package including an annual bonus plan, substantial training allowance, community-minded opportunities, and collaboration with top minds in the industry.

Requirements

• Knowledge and experience in installing, configuring and upgrading PostgreSQL & MySQL databases & tools relevant in PostgreSQL Administration
• Experience administering PostgreSQL & MySQL in virtualized and cloud environments, especially AWS, GCP or Azure
• Experience with scripting (bash/python) and software development (C++, Java, Go)
• Automation technologies such as Ansible, Terraform, Puppet, Chef, SALT experience

Responsibilities

• Work as part of Pythian's open source team and supply complete support for all aspects of database and application infrastructure to a variety of customers
• Collaborate with customer teams to understand their needs, in both a project based and long term support capacity
• Create and document database standards, create optimized queries, indexes, and data structure
• Monitor and support database environments and serve as an escalation point for complex troubleshooting and interactive production support
• Use database vendor provided tools and Pythian developed accelerators to performance tune various database system, specific queries and applications scenarios
• Diagnose and address database performance issues using performance monitors and various tuning techniques
• Identify areas of opportunity and recommend appropriate improvement suggestions
• Author new blog posts on interesting topics for our open-source community to digest, create new articles in our customer facing knowledge base for more frequently seen issues, and host webinars amongst other things like participating in conferences and meetups promoting Pythian to the open source community

Preferred Qualifications

• Previous remote working experience a plus
• Debugging skills and the 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
• Very good documentation skills
• Nice to haves include; Understanding of current IT service standards such as ITIL. Being a contributor to Open Source projects relevant to PostgreSQL, MySQL or other database or infrastructure software

Benefits

• Competitive total rewards package including an annual bonus plan
• Outstanding people: Collaborate with the industry’s top minds
• Substantial training allowance: Hone your skills or learn new ones; participate in professional development days, attend conferences, become certified, whatever you like!
• Community minded: Blog during work hours ; take a day off and volunteer for your favorite charity