Remote PostgreSQL Administrator

Summary

Join Pythian, a global leader in data and cloud solutions, as a PostgreSQL Database Consultant. As a key member of our open-source team, you'll provide complete support for database and application infrastructure to various customers. Collaborate with customer teams, create database standards, optimize queries, and troubleshoot complex issues. Contribute to the community by authoring blog posts, creating knowledge base articles, and hosting webinars.

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

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 our customers
• 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
• Cross-functional training in NoSQL, Site Reliability Engineering and DevOps methodologies are encouraged

Benefits

• Competitive total rewards package with excellent take home salaries, shifted work time bonus (if applicable) and an annual bonus plan!
• Hone your skills or learn new ones with an annual training allowance; 2 paid professional development days, attend conferences, become certified, whatever you like!
• 3 weeks of paid time off and flexible working hours
• All you need is a stable internet connection!
• We give you all the equipment you need to work from home including a laptop with your choice of OS, and budget to personalize your work environment!