DB Engineer (Chennai)

DB Engineer (Chennai)

24 Sep
|
Valor PayTech
|
Chennai

24 Sep

Valor PayTech

Chennai

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.
- Solid problem-solving and analytical skills.
- Proficient in relational databases, backup, and recovery.
- Comfortable with shell scripting and related scripting procedures.

Preferred Qualifications

- Robust 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

📌 DB Engineer (Chennai)
🏢 Valor PayTech
📍 Chennai

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: db engineer (chennai) / chennai

Subscribe to this job alert:

Get the latest job offers by email for: db engineer (chennai) / chennai