Database Engineer

Suede; Chennai; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Valor PayTech is seeking an experienced Database Engineer to ensure our databases remain available, secure, and stable. The role emphasizes data integrity, regular updates, and robust backups, while supporting performance and reliability across environments.

Responsibilities include monitoring health, performing maintenance, backups, upgrades, and query optimization. You will work with Linux, MariaDB/MySQL, NoSQL, PostgreSQL, Galera, ProxySQL, and Grafana, and participate in on-call rotation

Qualifications

• Bachelor's degree in Computer Science or related field.
• 3+ years with relational databases (MariaDB/MySQL) and NoSQL.
• 3+ years shell scripting (Shell, Python, Perl).
• Experience with Linux operating systems and backups/recovery.
• Strong problem-solving and analytical skills.
• Proficiency in database reliability and performance tuning.
• Familiarity with Galera cluster and GitLab for version control.

Responsibilities

• Monitor database health and automate maintenance tasks.
• Perform backups, upgrades, and patching; manage recovery.
• Tune performance; optimize indexes, constraints, and queries.
• Review SQL code for standards and efficiency.
• Investigate issues, on-call support, and incident response.
• Collaborate with developers and DevOps for reliability.

Skills

SQL

Shell scripting

Linux

Query tuning

GitLab

Performance monitoring

Data backups

Galera cluster

Education

Bachelors in Computer Science

Tools

MariaDB/MySQL

NoSQL

PostgreSQL

GitLab

ProxySQL

Grafana

Percona PMM

Galera

Job description

Valor PayTech fosters a vibrant and nurturing work atmosphere that motivates employees to innovate and excel. The culture is deeply rooted in collaboration and ongoing development, offering team members abundant opportunities for professional advancement and skill improvement. Emphasizing innovation excellence and cultural expansion, the company greatly values the diversity of its workforce, believing it to be a cornerstone of its success.

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.
• 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).
• Analytical & Problem-Solving Mindset
• Database Reliability & Performance Tuning
• Collaboration with Development Teams

Technical Environment

• Monitoring: Percona, PMM, Grafana
• Proxy/Access: ProxySQL
• Scripting: Shell, Perl, Python
• Version Control: GitLab