MySQL Database Engineer

Job Description

Why Entersekt

Founded over 16 years ago, with more recent investments from Accel-KKR, Entersekt is a leader in digital banking fraud prevention and payment security, including mobile authentication, mobile app security, and 3D Secure authentication for issuers, acquirers and payment networks. We offer highly scalable products with a track record of success across multiple continents.

Entersekt enables secure digital transactions for leading financial institutions globally. We exist to create a world where everyone can transact digitally without fear or compromise. Currently, we protect the digital transactions of over 210 million active users on our platform and hold 120 active patents that recognize innovation in digital security, payments, and user experience. Entersekt offers customers secure authentication and digital payments experiences that remove unnecessary friction. Entersekt has a diverse product portfolio and aggressive roadmap that positions the company well to sustain competitive advantage as it expands globally with emphasis on North America and European markets.

The Ideal Candidate

The ideal candidate is a highly competent Database Engineer for both on-prem and AWS Cloud. The successful candidate has considerable hands-on experience managing multi-node, multi-TB, high-load clusters, and has worked in high-pressure environments interacting with Production, Development and Infrastructure teams to identify, chaperone and resolve issues in development and production. A deep understanding of and extensive work experience with Galera or Percona Cluster on MySQL and/or MariaDB is key. Relevant experience with industry security standards (PCI DSS, PCI 3DS) is a big plus.

The Role

As a MySQL Database Engineer at Entersekt, you will be part of a company that provides ²⁴⁄₇ support for mission-critical database systems for financial authentication solutions in the market. You will be responsible for performing daily database administration, database design and troubleshooting, replication, and performance tuning tasks for multiple MariaDB and MySQL Clusters in production and development.

Responsibilities

Database management:

• Design, implement, and maintain MySQL/MariaDB database clusters.
• Ensure the availability and performance of databases.
• Perform regular database capacity planning and ensure proper storage management.
• Replication between databases for high availability.

Database security:

• Implement and maintain database security measures to protect sensitive data.
• Manage user access and permissions.
• Implement and maintain auditing functions.

Backup and recovery:

• Develop and implement backup/recovery strategies.
• Regularly test and verify backups to ensure data integrity.
• Plan and execute database recovery procedures in case of failures.

Performance tuning:

• Monitor and optimize database performance.
• Identify and resolve performance bottlenecks.
• Collaborate with team to improve query performance.
• Tune database and platform configurations to utilize hardware capacity.

Database upgrades and patching:

• Plan and execute database upgrades.
• Determine short and long-term upgrade paths and strategies.
• Apply patches and updates to ensure database security and stability.

Troubleshooting:

• Diagnose and resolve database-related issues.
• Provide support to development teams in debugging database-related problems.

Skills and Experience

Successful candidates for this role will generally possess the following qualifications and skills:

• Bachelor’s degree in computer science, Information Technology, or a related field is preferred, but not required.
• Proven 3+ years’ experience as a Galera or Percona cluster Database Administrator in a production environment.
• Deep understanding of MySQL database architecture, administration, and performance tuning.
• Hands-on experience with Galera or Percona Cluster.
• Experience with data migration, backup, restore and recovery, resolving performance issues, blocking and deadlocks.
• Experience in implementing and monitoring MySQL Cluster to provide high availability for mission critical events, database mirroring, replication, and log shipping.
• Proficiency in scripting languages such as Bash, Python, or Perl for automation tasks.
• Deep knowledge and understanding of one or more UNIX-like operating systems (server-side).
• Experience with database security, backup and recovery, and disaster recovery planning.
• Familiarity with version control systems, such as Git, for managing database configurations and scripts.
• Exposure to the following would be advantageous:
  • Experience in the FinTech or financial services industry.
  • Experience from PCI DSS/PCI 3DS certification processes.
  • Familiarity with other cloud database technologies such as Aurora DB and Global Databases.
  • The FreeBSD operating system.
  • ZFS

Personality Attributes

• Excellent problem-solving skills and the ability to troubleshoot complex database issues.
• Strong communication and collaboration skills, with the ability to work effectively in a cross-functional team environment.
• Flexible, team player, goal-driven.
• Willing to take ownership of and proactively seek to improve on existing systems.
• Adaptability and self-motivation to excel in a mobile/remote-first team and company, demonstrating the capability to thrive in a distributed work environment while maintaining high productivity and communication standards.

We place a lot of value on how we treat prospective employees and appreciate the time and effort that goes into job hunting. That is why we aim to keep the hiring process as quick and seamless as possible while ensuring the best possible fit for both you and the company.

Working at Entersekt is truly a dream. You get exposed to cutting-edge technology, colleagues who are leaders in their fields, and an awesome working environment that includes flexible hours, remote work, and plenty of growth opportunities.

Apply for this position by following the “apply now” tab and or viewing our other roles at Entersekt Careers page.

Entersekt is an Equal Opportunity Employer:

We are committed to building an inclusive and diverse workforce that reflects the global communities we serve. For all South Africa-based roles, preference will be given to candidates from historically disadvantaged groups, in accordance with local Employment Equity objectives.