The Database Consultant (DBC) Role
The Database Consultant (DBC) will, as part of a team-based approach, provide comprehensive support for all aspects of database and application infrastructure to various clients. Our collaborative MySQL environment encourages teamwork to solve complex problems and develop innovative solutions. Cross-functional training in NoSQL, Site Reliability Engineering, and DevOps methodologies is encouraged.
Responsibilities:
- Work closely with customer teams to understand their needs, both for projects and long-term support.
- Create and document database standards, optimize queries, indexes, and data structures.
- Monitor and support database environments, serving as an escalation point for complex troubleshooting and production support.
- Use vendor-provided tools and Pythian-developed accelerators to tune database performance and optimize applications.
- Diagnose and resolve database performance issues using performance monitors and tuning techniques.
- Identify opportunities for improvement and recommend solutions.
- Collaborate with the site reliability engineering team to configure and deploy high-availability and disaster recovery solutions.
- Cross-functional training in MongoDB, Ansible, and Python is encouraged.
- Contribute to the community by authoring blog posts, creating articles for the knowledge base, hosting webinars, and participating in conferences and meetups.
Qualifications:
- 5-8 years of experience as a Database Consultant, with expertise in installing, configuring, and upgrading MySQL databases.
- Debugging skills, experience with MongoDB, and scripting/automation tooling are highly desirable.
- Ability to work well in a team and independently.
- Quick learner with adaptability.
- Strong customer service skills, attention to detail, and analytical abilities.
- Effective organizational skills and sound work ethics.
- Excellent documentation skills.
- Understanding of IT service standards like ITIL is a plus.
- Scripting (bash/python) and Ansible experience are advantageous.
- Outstanding written and verbal communication skills.
- Contributions to open-source projects related to databases or infrastructure are a plus.
Benefits:
- Career growth: Competitive salary, blog opportunities, and volunteer days.
- Work/life balance: Flexible remote work with a stable internet connection.
- Collaborative environment: Work with industry experts.
- Professional development: Training allowances, certification opportunities, and development days.
- Home workspace: Equipment and budget for a personalized home office.
- Well-being: Wellness budgets, paid vacation and sick days, and volunteer days.