DB Engineer

Valor PayTech; Chennai District; Hybrid; 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 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.

The role includes administration, maintenance, backup/recovery, performance optimization, reliability troubleshooting, data

Qualifications

• Bachelor's degree or equivalent in Computer Science or related field.
• 3+ years with relational databases (MariaDB/MySQL) and NoSQL.
• 3+ years shell scripting (Shell, Python, Perl, etc.).
• Working knowledge of MariaDB/MySQL, NoSQL, PostgreSQL.
• Strong Linux OS experience and problem-solving skills.

Responsibilities

• Monitor health of database servers and perform maintenance.
• Install, configure, backup, upgrade, and patch databases.
• Set up automatic backups and recovery with cronjobs.
• Manage user accounts, permissions, and access rights.
• Analyze performance and optimize queries and indexes.
• Review SQL code for performance and standards.
• Troubleshoot issues and participate in 24x7 on-call support.
• Collaborate with development teams and support data governance.

Skills

Analytical problem-solving

Ownership incident response

Collaboration with development teams

Problem-solving

Linux command-line proficiency

Education

Bachelor's degree in Computer Science or related field

Tools

MariaDB/MySQL

NoSQL

PostgreSQL

Aurora/RDS

ProxySQL

GitLab

Grafana

Linux

Job description

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.

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.
  

Qualifications
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