At a Glance
- Tasks: Lead MySQL database management, ensuring performance, security, and high availability.
- Company: Join Verifone, a leader in innovative software solutions.
- Benefits: Enjoy a hybrid work schedule and opportunities for professional growth.
- Other info: Diverse and inclusive workplace committed to equal opportunity.
- Why this job: Make a real impact on database performance and tackle complex challenges.
- Qualifications: 8+ years managing MySQL with strong technical leadership skills.
The predicted salary is between 70000 - 90000 £ per year.
Verifone is seeking an experienced MySQL lead who will be responsible for ensuring database performance, high availability, and security of clusters and single instances of MySQL instances. You will also be responsible for orchestrating upgrades, backups, HA/DR, and provisioning database instances. You will work closely with other teams, including application architects/Sr. Developers and application support engineers for architecture design and SQL optimization, establishing and documenting best practices.
We look for dedicated and versatile engineers who are passionate about working in a company whose culture is dedicated to delivering innovative software products that solve our customers' most challenging business needs. As a Lead DBA, you'll have the opportunity to make significant and direct impact on our database performance, applications, and solve some of the most complex challenges in cloud and on-prem environments, while leading the team from a technical and development perspective. We do allow a hybrid work schedule.
Key Responsibilities- You will be responsible for ensuring that database management policies, processes and procedures are established and followed, adhering to ITIL good practice principles and are subjected to continuous improvement as per PCI standards.
- Responsible for reviewing system design changes to ensure they adhere to expected service standards and recommend changes to ensure maximum stability, availability and efficiency of the supported applications.
- Understand the application functionality, business logics and work with application stakeholders to understand the requirement and discuss with the new application features and propose the right solutions.
- Liaise closely and work in collaboration with the release management teams, support teams and the infrastructure DBAs.
- Design, Install, Deploy and Manage MySQL on Physical, Virtual, AWS EC2/RDS/Aurora.
- Build MySQL clusters with a high availability, active-active cluster setup in a large scale and multi datacenter environments having minimum RPO/RTO on a DR scenario.
- Design and implement uniform backup strategy and business continuity plans across the MySQL environments using Percona XtraDB or custom automation scripts with reliable monitoring and alerting mechanisms.
- Define thorough and validated database monitoring and alerting, along with documentation for future references.
- Setup high availability with Master-Master/Master-slave replication.
- Guide engineering teams to best practices on server configurations and SQL tuning.
- Maintain security and compliance via OS and database version upgrades.
- Work with application stakeholders to create effective database solutions.
- Create and maintain adhoc reports.
- Adhere to the incident and change process, prepare thorough documentation, and peer review planned production tasks.
- Support application release process, and automations.
- Mentor and develop other engineers on MySQL skills.
- Minimum 8 years of experience managing MySQL.
- Experience with MySQL Active/Active cluster setup, Database Upgrade and Migrations, Scripting.
- Experience with MySQL version upgrades in production environments with a zero or very minimum application downtime.
- Experience with design & architecting MySQL environments using any framework such as Galera Cluster or Percona XtraDB.
- Experience deploying database monitoring using at least one of PMM, New Relic, Datadog, Nagios, Grafana, ELK, AppD, etc.
- Infrastructure as Code (IaC) such as Terraform, Ansible, Puppet, Chef.
- Proficiency with cloud infrastructure, AWS RDS or equivalent.
- Automation/scripting skills in a modern language like Python, Shell scripting, Go, Java, Rust.
- Proficiency in CI/CD pipelines such as Jenkins, Github Actions, Gitlab.
- Advanced experience with database performance tuning including SQL tuning, hardware configuration and capacity planning.
- Strong technical leadership, mentoring and time management skills.
- Experience working with PCI (Payment Card Industry Data Security) standards.
- Deep experience with SQL, stored procedures, functions, triggers, batch jobs, reporting, analytics.
- Experience managing PostgreSQL, SQL Server, and/or Oracle.
- Experience and knowledge with NoSQL and data engineering technologies such as Kafka, Redis, Snowflake, Databricks, Spark, Redshift, ETL, etc.
- Experience with data analytics and Business intelligence.
Verifone is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. Verifone is also committed to compliance with all fair employment practices regarding citizenship and immigration status.
Lead MySQL Database Administrator in London employer: Verifone
Verifone is an exceptional employer that fosters a culture of innovation and collaboration, making it an ideal place for a Lead MySQL Database Administrator to thrive. With a commitment to employee growth, you will have the opportunity to mentor others while working in a hybrid environment that promotes work-life balance. The company values diversity and offers a supportive atmosphere where your contributions directly impact the performance and success of cutting-edge software solutions.
StudySmarter Expert Advice🤫
We think this is how you could land Lead MySQL Database Administrator in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and engage in online forums. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Prepare for interviews by practising common questions and scenarios related to MySQL database management. We recommend doing mock interviews with friends or using online platforms to get comfortable with your responses.
✨Tip Number 3
Showcase your skills through projects or contributions to open-source databases. This not only enhances your portfolio but also demonstrates your passion and expertise in MySQL to potential employers.
✨Tip Number 4
Apply directly through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who take the initiative to connect with us directly.
We think you need these skills to ace Lead MySQL Database Administrator in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to highlight your MySQL experience and relevant skills. We want to see how your background aligns with the responsibilities mentioned in the job description, so don’t hold back on showcasing your achievements!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re excited about the role and how you can contribute to our team. We love seeing passion and personality, so let your enthusiasm for database management come through.
Showcase Your Technical Skills:Don’t forget to highlight your technical expertise, especially in areas like MySQL clustering, performance tuning, and automation. We’re looking for someone who can hit the ground running, so make sure we see your relevant skills front and centre.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re keen on joining our team at StudySmarter!
How to prepare for a job interview at Verifone
✨Know Your MySQL Inside Out
Make sure you brush up on your MySQL knowledge, especially around performance tuning, high availability setups, and backup strategies. Be ready to discuss your past experiences with MySQL clusters and how you've handled upgrades or migrations in production environments.
✨Showcase Your Collaboration Skills
Since the role involves working closely with application architects and support engineers, prepare examples of how you've successfully collaborated with cross-functional teams. Highlight any instances where your input led to improved database performance or application stability.
✨Demonstrate Your Problem-Solving Abilities
Be prepared to tackle hypothetical scenarios during the interview. Think about complex challenges you've faced in cloud or on-prem environments and how you resolved them. This will show your potential employer that you can think critically and act decisively under pressure.
✨Familiarise Yourself with Compliance Standards
Since the role requires adherence to PCI standards, make sure you understand these regulations and how they apply to database management. Discuss any relevant experience you have in maintaining security and compliance, as this will be a key aspect of the job.
