03 Oct
|
Valor PayTech
|
Chennai
03 Oct
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 setting 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.
• P
📌 DB Engineer (Chennai)
🏢 Valor PayTech
📍 Chennai