Senior Database Consultant, MySQL

About the 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 ability to translate complex database and infrastructure concepts into clear, meaningful insights for both highly technical engineering teams and business stakeholders. What you will receive: Love your career: Competitive total rewards 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, there’s no daily travel requirement to an office! 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. HiringDisclaimer The successful applicant will need to fulfill the requirements necessary to obtain a background check. Accommodations are available upon request for candidates taking part in any aspect of the selection process. AI Disclaimer Pythian may utilize Enterprise Generative Artificial Intelligence (AI) tools or features throughout its hiring process. These tools help us manage high volumes of applications efficiently and may be employed to review applications, analyze resumes, and assist with other recruitment steps. While Pythian uses AI in its hiring process, it does not substitute for human judgment. Our Talent Acquisition Team reviews all AI-generated recommendations, and the system is subject to regular bias audits to ensure fairness and compliance with all applicable employment and human rights laws. All final hiring decisions are made by, and remain the responsibility of, human decision-makers. By applying for this position, you consent to Pythian’s use of these AI tools in the evaluation of your application. You have the right to request a human review of any solely AI-driven decision or to request an accommodation. Should you require further details regarding the processing of your data, please reach out to us. Apply directly on RemoteJobs.org : https://remotejobs.org/remote-jobs/senior-database-consultant-mysql-pythian