MySQL Database Engineer

Job description

## Why Verifone For more than 30 years, Verifone has established a remarkable record of leadership in the electronic payment technology industry. Verifone is one of the leading electronic payment solutions brands and among the largest providers of electronic payment systems worldwide. Verifone has a diverse, dynamic, and fast-paced work environment in which employees are focused on results and have opportunities to excel. We take pride in working with leading retailers, merchants, banks, and third-party partners to invent and deliver innovative payment solutions around the world. We strive for excellence in our products and services and are obsessed with customer happiness. Across the globe, Verifone employees are leading the payments industry through experience, innovation, and an ambitious spirit. Whether it’s developing the next generation of secure payment systems or finding new ways to bring electronic payments to emerging markets, the Verifone team is dedicated to the success of our customers, partners, and investors. It is this passion for innovation that drives every Verifone employee toward personal and professional success. Verifone is proudly an in-office work culture as we see immense benefits to career development and business results from our colleagues being physically co-located. ## What's Exciting About the Role Verifone is seeking an experienced MySQL DBA 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 lead the team from a technical and development perspective. ## 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. They will be 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. The candidate should understand the application functionality, business logics and work with application stake holders to understand the requirement and discuss with the new application features and propose the right solutions. He must 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 - Maintain stable performance via server optimizations - 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 stake holders 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 ## Required Qualifications/Skills - Minimum 8 years of experience managing MySQL - Experience with MySQL Active/Active cluster setup, Database Upgrade and Migrations, Scripting - Experience administrating MySQL on Linux platform - Experience with MySQL version upgrades in production environments with a zero or very minimum application down time - 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. ## Preferred Skills (Not Mandatory) - Experience working with PCI (Payment Card Industry Data Security) standards - ITIL environment experience - 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 ## Our Commitment 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.