Lead MySQL Database Administrator
Tech Stack / Keywords
Firma i stanowisko
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 focused on results. The company works with leading retailers, merchants, banks, and third-party partners to invent and deliver innovative payment solutions globally. Verifone employees lead the payments industry through experience, innovation, and an ambitious spirit, developing secure payment systems and expanding electronic payments to emerging markets.
Wymagania
- 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 zero or minimal application downtime.
- Experience designing and architecting MySQL environments using frameworks such as Galera Cluster or Percona XtraDB.
- Experience deploying database monitoring using tools like PMM, New Relic, Datadog, Nagios, Grafana, ELK, AppD.
- Experience with Infrastructure as Code (IaC) tools such as Terraform, Ansible, Puppet, Chef.
- Proficiency with cloud infrastructure, AWS RDS or equivalent.
- Automation/scripting skills in modern languages 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.
- Experience with data analytics and Business intelligence.
Obowiązki
- Ensure database management policies, processes, and procedures are established and followed, adhering to ITIL good practice principles and PCI standards.
- Review system design changes to ensure adherence to service standards and recommend changes for stability, availability, and efficiency.
- Understand application functionality and business logic; collaborate with application stakeholders to discuss requirements and propose solutions.
- Liaise and collaborate with release management teams, support teams, and infrastructure DBAs.
- Design, install, deploy, and manage MySQL on physical, virtual, AWS EC2 / RDS / Aurora.
- Build MySQL clusters with high availability, active-active cluster setup in large scale and multi-datacenter environments with minimum RPO/RTO for DR scenarios.
- Design and implement uniform backup strategy and business continuity plans using Percona XtraDB or custom automation scripts with monitoring and alerting.
- Define thorough and validated database monitoring and alerting with documentation.
- Setup high availability with Master-Master/Master-slave replication.
- Maintain stable performance via server optimizations.
- Guide engineering teams on best practices for 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 incident and change processes, prepare documentation, and peer review planned production tasks.
- Support application release process and automations.
- Mentor and develop other engineers on MySQL skills.
Inne informacje
This hybrid role is open to hiring candidates located in Bucharest, Romania; London, United Kingdom; Riga, Latvia; and Warsaw, Poland. Verifone is committed to creating a diverse environment and is an equal opportunity employer. All qualified applicants will receive consideration without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. Verifone complies with all fair employment practices regarding citizenship and immigration status.
Verifone
5 aktywnych ofert