Database Engineer

Role Overview

Valor Paytech is seeking an experienced DB Engineer to ensure our databases remain available, secure, and stable. The Database Engineer will continuously test data integrity to guard against corruption and perform regular updates to keep pace with evolving database technologies, while supporting performance, scalability, and reliability across our environments.

Key Responsibilities

Database Administration & Maintenance

•     Monitor the health of database servers through both automated and manual processes.

•     Perform environment setup and configuration, along with proactive monitoring and maintenance.

•     Perform database administration and maintenance, including installation, configuration, backups, upgrades, and patching.

•     Set up and maintain automatic backup and recovery mechanisms using cronjobs.

•     Administer and maintain end-user accounts, permissions, and access rights.

Performance & Optimization

•     Recommend and implement solutions for performance monitoring and tuning.

•     Evaluate the performance of stored procedures, identify time- and resource-consuming areas, and provide input to application developers to address them.

•     Analyze access patterns and propose the best combination of indexes, constraints, foreign keys, and queries.

•     Review SQL code written by application developers to ensure compliance with coding standards, best practices, and maximum performance.

•     Review, optimize, and develop queries based on requirements.

Reliability & Troubleshooting

•     Analyze problems, anticipate future problem areas, and implement solutions.

•     Investigate and identify the root cause of software problems reported by stakeholders.

•     Troubleshoot database and Linux server issues by analyzing logs and using command-line utilities.

•     Maintain scalability (clustering) and availability (replication), including working knowledge of Galera cluster.

•     Proactively identify technical opportunities and enhancements while addressing major incidents in a timely manner.

•     Participate in an on-call rotation providing 24x7 support, including off-hours maintenance windows.

Data Governance & Security

•     Manage and ensure the integrity, security, and retention of data.

•     Create deployment and rollback scripts for all database objects, manually or auto-generated.

Collaboration & Delivery

•     Support the development of long- and short-term requirements for database administration and design.

•     Participate in the change control process for all planned application and technical activities.

•     Work with report writers to provide the data needed for reports.

•     Take on full roadmap items, work with other functional teams, and deliver high-quality results on time.

•     Direct the organization of requirements and data into a usable database schema, including development of ad hoc queries, scripts, and updates to existing queries.

•     Work closely with the application development team, including query review and version control via GitLab.

Required Qualifications

•     Bachelor's degree in Computer Science or a related discipline is required; equivalent experience may substitute for the education requirement.

•     3+ years of experience with relational databases such as MariaDB, MySQL, NoSQL, and above.

•     3+ years of experience with automation using shell scripting (Shell, Perl, Python, etc.).

•     Working understanding of technologies including MariaDB/MySQL, NoSQL, and PostgreSQL (MongoDB, Cassandra, etc.).

•     Working technical knowledge and experience with current Linux operating systems.

•     Strong problem-solving and analytical skills.

•     Proficient in relational databases, backup, and recovery.

•     Comfortable with shell scripting and related scripting procedures.

Preferred Qualifications

•     Strong hands-on experience with MySQL; PostgreSQL is a plus but optional.

•     Experience with Aurora/RDS, ProxySQL, and Percona / PMM / Grafana.

•     Knowledge of Galera cluster for clustering, scalability, and replication-based availability.

•     Experience working with application development teams, including query review and GitLab.

•     Strong exposure to Linux resource and process monitoring, and scripting basics (shell, Python, or similar).

Key Competencies

•     Analytical & Problem-Solving Mindset

•     Database Reliability & Performance Tuning

•     Automation-First Approach

•     Ownership & Incident Response

•     Collaboration with Development Teams

Technical Environment

Databases: MariaDB, MySQL, NoSQL, PostgreSQL (MongoDB, Cassandra), Aurora/RDS

Clustering & Availability: Galera Cluster, Replication

Monitoring: Percona, PMM, Grafana

Proxy/Access: ProxySQL

Scripting: Shell, Perl, Python

Operating Systems: Linux

Version Control: GitLab