Database Consultant (OSDB)

What you will be doing:

• 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 systems, 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.
• Work with our site reliability engineering organization to help configure and deploy high-availability and disaster recovery solutions for critical applications to meet customers needs.
• Cross-functional training in Mongo, Ansible and Python are encouraged.
• When you're not fixing things, you'll be authoring new blog posts on interesting topics for our open-source community to digest, 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.
• Achieve your billable target of 85% and your effective utilization target of 85%. Your targets are subject to modification by Pythian, in its sole discretion, to meet its business needs.

What we need from you:

• This section reflects our “wish list” of skills & experiences. We understand that no one checks every box — and that’s okay! At Pythian, we value growth, curiosity, and the opportunity to learn on the job. While we don’t include a technical test as part of this interview process, we ask that you complete the questionnaire on the next page as honestly as possible. Your responses help us better understand your strengths and where we can support your development as you grow with our team and customers.
• 3-5 years of overall experience required as a Database Administrator (DBA)
• The position requires specialized knowledge and experience in installing, configuring and upgrading MySQL databases& Administration. Debugging skills, MongoDB and Scripting/automation tooling experience is a huge plus.
• Strong ability to work in both a team oriented environment and also under minimal supervision.
• Strong ability to adapt and to learn quickly.
• Good customer service focus with the ability to handle customer expectations and priorities.
• Disciplined in their learning process.
• Self-motivated.
• Keen attention to detail.
• Good analytical, evaluative, and problem-solving abilities.
• Effective organizational skills.
• Demonstrate sound work ethics.
• Very good documentation skills.
• Nice to have - Understanding of current IT service standards such as ITIL.
• Scripting (bash/python) and Ansible experience is a huge plus.
• Excellent written and verbal communication skills.
• Contributor to Open Source projects relevant to MySQL, MongoDB or other database or infrastructure software.

What do you get in return?

• Love your career: Competitive total rewards and salary package. Blog during work hours; take a day off and volunteer for your favorite charity.
• Love your work/life balance: Flexibly work remotely from your home, All you need is a stable internet connection.
• Love your coworkers: Collaborate with some of the best and brightest in the industry!
• Love your development: Hone your skills or learn new ones with our substantial training allowance; participate in professional development days, attend training, become certified, whatever you like!
• Love your workspace: 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!
• Love yourself: Pythian cares about the health and well-being of our team. You will have an annual wellness budget to make yourself a priority (use it on gym memberships, massages, fitness and more). Additionally, you will receive a generous amount of paid vacation and sick days, as well as a day off to volunteer for your favorite charity.