PostgreSQL Administrator

Summary

Join Pythian's open-source team as a PostgreSQL Consultant (DBC) in Bengaluru, India, working either hybrid or remotely. You will provide comprehensive support for database and application infrastructure to diverse clients. Collaborate with customer teams, create database standards, optimize queries, and monitor database environments. Troubleshoot complex issues, utilize performance tuning techniques, and identify areas for improvement. Beyond technical tasks, you'll contribute to the open-source community through blogging, knowledge base articles, and webinars. Pythian offers competitive compensation, flexible remote work, professional development opportunities, and a focus on employee well-being.

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
• 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
• Work closely with the 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, creating new articles in our customer facing knowledge base for more frequently seen issues, and hosting webinars amongst other things like participating in conferences and meetups promoting Pythian to the open source community

Preferred Qualifications

• 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 and salary package
• Flexibly work remotely from your home, there’s no daily travel requirement to an office!
• Collaborate with some of the best and brightest in the industry!
• Hone your skills or learn new ones with our substantial training allowance; participate in professional development days, attend training, become certified, whatever you like!
• We give you all the equipment you need to work from home including a laptop with your choice of OS, and an annual budget to personalize your work environment!
• You will have an annual wellness budget to make yourself a priority (use it on gym memberships, massages, fitness and more)
• You will receive a generous amount of paid vacation and sick days, as well as a day off to volunteer for your favorite charity