Senior Database Consultant, MySQL

About this role

Why Pythian:

At Pythian, we are experts in strategic database and analytics services, driving digital transformation and operational excellence. Pythian, a multinational company, was founded in 1997 and started by ensuring the reliability and performance of mission-critical databases. We quickly earned a reputation for solving tough data challenges. We were there when the industry moved from on-premises to cloud environments, and as enterprises sought more from their data, we expanded our competencies to include advanced analytics.

Today, we empower organizations to embrace transformation and leverage advanced technologies, including AI, to stay competitive. We deliver innovative solutions that meet each client’s data goals and have built strong partnerships with Google Cloud, AWS, Microsoft, Oracle, SAP, and Snowflake. The powerful combination of our extensive expertise in data and cloud and our ability to keep on top of the latest bleeding edge technologies make us the perfect partner to help mid and large-sized businesses transform to stay ahead in today’s rapidly changing digital economy.

Why you:

As a Senior Database Consultant you will work within a globally dispersed team to supply complete support for all aspects of database and application infrastructure to a variety of Pythian’s customers.

If this is you, and you wonder what it would be like to work at Pythian, reach out to us and find out!

Intrigued to see what a life is like at Pythian? Check out #pythianlife on LinkedIn and follow @loveyourdata on Instagram!

Not the right job for you? Check out what other great jobs Pythian has open around the world! Pythian Careers

What you will be doing:

• Coordination, analysis, design, implementation, and administration of database solutions, including database server configuration and maintenance.

• Analyzing customer’s infrastructure and processes and recommending to customers, best practices for improvements to current operational processes and procedures to ensure that databases remain operational for maximum uptime and recoverability.

• Administration of backup procedures and disaster recovery plans, provides proactive monitoring to head off potential issues before they become incidents, responds to monitoring alerts, and carries out troubleshooting of operational problems.

• Overseeing of backup, clustering, mirroring, replication, failover, and restoration and recovery of corrupted databases, develops and reviews action plans (such as maintenance, deployment, upgrades, etc.), and completes all relevant client documentation. Develop a thorough understanding of all relevant customer information including warnings, handoffs, briefing notes, etc.

• Assists the Lead Database Consultant with respect to Incident Management, Problem Management and Problem Resolution, implements Changes and Service Requests, and designs/implements technical procedures for complex changes.

• Prepare customer status and incident reports, responding to customer requests and enquiries, and maintains alignment with a customer’s operating procedures. e.g., change control, follows hourly requirements of customer allotments and alerts Team Lead to any pacing concerns.

• Maintain any customer specific assets such as soft or hard access tokens, access cards and any other hard or soft asset provided.

• Takes a lead role in the teams maintenance and alignment of Pythian process requirements including, handovers, documentation and process acknowledgements, and incident reviews.

• Enhancement of Pythian tools and processes, suggesting and possibly designs/implements new monitoring checks, enhancements to DBA toolkits, and other process improvements such as Initial Reviews, Performance Reviews, Audits, etc.

• Participate in sales support activities such as presales, proposal preparation and tech calls etc.

• Take on a lead role in contributing to Pythian’s external profile in the preparation of marketing collateral including web site material and presentations at conferences or trade shows, participate in local user groups and be active on the technology blogging front.

• Mentoring and Training of existing Database Consultant team members, providing on-going help and mentoring of new employees as part of a “buddy system”, and taking a lead role in the preparation and presentation of employee training courses etc.

What we need from you:

Technical Experience & Core Skills

•
Senior-Level Expertise: 7+ years of overall experience in a Database Reliability Engineer (DBRE), Site Reliability Engineer (SRE), or production Database Administrator (DBA) role.

•
Software Engineering & Frameworks: Strong proficiency in Object-Oriented Programming (OOP) with Python (or Go), including practical knowledge of the Django framework for tooling or application development.

•
Cloud Infrastructure: Hands-on experience designing, deploying, and managing scalable infrastructure within AWS.

•
Automation & Infrastructure as Code (IaC): Deep understanding of automation principles using Terraform, Bash scripting, and robust Unix/Linux system administration.

•
Modern Tool Stack: Practical experience working with containerization and orchestration (Docker, GKE), secrets management (Vault), and database proxy/load balancing tooling (e.g., ProxySQL), utilizing GitLab for CI/CD.

Consulting & Professional Capabilities

•
Consultative Customer Focus: Exceptional client-facing skills with a proven ability to manage customer expectations, navigate complex priorities, and act as a trusted technical advisor.

•
Analytical Problem Solving: A systematic approach to troubleshooting; ability to identify hidden patterns, root causes, and underlying issues in complex, distributed environments.

•
Continuous Optimization: A proactive mindset dedicated to assessing existing process flows, methods, and standards to drive system performance and architectural improvements.

•
Tailored Communication: Strong communication skills with the…