Database Engineer

Valor PayTech; Chennai; Sur place; INR 1 200 000 - 2 400 000; Plein temps

Résumé du poste

Valor PayTech is seeking an experienced Database Engineer to ensure databases are available, secure, and stable. You will test data integrity, perform updates, and support performance and reliability across environments.

Responsibilities include monitoring health, backups, configuration, and access control; optimizing queries; troubleshooting Linux/DB issues; and participating in on-call rotations with a focus on data governance and security.

Qualifications

• Bachelor's degree in Computer Science or a related field, or equivalent experience.
• 3+ years with relational databases (MariaDB/MySQL) and NoSQL.
• Experience with shell scripting (Shell, Python, Perl).
• Knowledge of Linux, backups, and RDBMS maintenance.
• Ability to review SQL for performance and correctness.
• Experience with clustering/replication (Galera or similar).

Responsabilités

• Monitor DB health and perform routine maintenance and backups.
• Configure environments and ensure security and access control.
• Review SQL, optimize queries, and tune performance.
• Maintain clustering and replication for uptime.
• Support 24x7 on-call rotations.
• Collaborate with development for data needs and governance.

Connaissances

Database administration

Performance tuning

Linux

Shell scripting

GitLab

Data security

Analytical thinking

Formation

Bachelor's degree in Computer Science

Outils

MariaDB/MySQL

NoSQL

PostgreSQL

Aurora/RDS

ProxySQL

Grafana

GitLab

Description du poste

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