Database Engineer

Endava; Maharashtra; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Endava is seeking a skilled Database Engineer to join their technical team in India, Maharashtra. The successful candidate will have a strong background in relational databases like Oracle or DB2, as well as expertise in SQL and PL/SQL. This role combines both development and operational responsibilities, ensuring database reliability and performance in a real-time payment processing environment.

Key duties include developing scripts, investigating performance issues, and collaborating with teams for optimal database solutions. A commitment to innovation and inclusivity is central to Endava’s hiring approach.

Qualifications

• Proven experience working with Oracle or Oracle-compatible database systems.
• Experience with database performance troubleshooting and optimization techniques.
• Working knowledge of Git and GitHub workflows.

Responsibilities

• Develop and review SQL and PL/SQL scripts for various environments.
• Investigate and troubleshoot performance issues and query optimization.
• Collaborate with development teams to analyze database-related requirements.

Skills

Relational database systems (DB2 or Oracle)

SQL

PL/SQL

Database performance troubleshooting

Git and GitHub workflows

Education

Degree in Computer Science, Engineering, or related field

Tools

Git

GitHub

ELT processes

Job description

Overview

We are looking for a skilled and experienced Database Engineer to join our technical team working on a real-time payment processing platform. The ideal candidate has a strong background in relational database systems (DB2 or Oracle), hands‑on experience with SQL and PL/SQL, and an interest in database performance, tuning, and automation. This role involves both development and operational responsibilities, including code review, performance troubleshooting, ELT processes, and deployment automation. You will work closely with developers, DevOps, and QA teams to ensure the reliability and performance of the database systems.

Key Responsibilities

• Develop and review SQL and PL/SQL scripts (procedures, packages, functions) for both transactional and data warehouse environments.
• Investigate and troubleshoot performance issues, including query optimization, deadlocks, and lock timeouts.
• Maintain data warehouse synchronization processes (ELT), implemented using PL/SQL packages.
• Perform and support table partitioning and partition maintenance (manual and automated).
• Manage code versioning and changes through GitHub, participating in pull request reviews and approvals.
• Collaborate with development teams to analyze database-related requirements and offer optimal solutions.
• Ensure database scripts meet performance, scalability, and maintainability standards.
• Support incident investigation and root cause analysis for database-related issues in production.
• Work with other team members to continuously improve database automation, monitoring, and deployment practices.

Required Skills and Qualifications

• Degree in Computer Science, Engineering, or a related field, or equivalent professional experience.
• Proven experience working with Oracle or Oracle‑compatible database systems (e.g., DB2 with Oracle syntax).
• Strong knowledge of SQL and PL/SQL development and tuning.
• Experience with database performance troubleshooting and optimization techniques.
• Working knowledge of Git and GitHub workflows (pull requests, code review).
• Understanding of partitioned tables and long‑term data retention strategies.

Nice to have

• Previous experience in real‑time systems, payment processing, or banking environments.
• Familiarity with Flyway or other database versioning tools.
• Familiarity with ELT processes and data warehouse architecture.
• Experience with DB2 (Oracle‑compatible) systems specifically.
• Experience using shell scripting in Linux environments for automation tasks.
• Understanding of CI/CD concepts for database deployments.

At Endava, we’re committed to creating an open, inclusive, and respectful environment where everyone feels safe, valued, and empowered to be their best. We welcome applications from people of all backgrounds, experiences, and perspectives—because we know that inclusive teams help us deliver smarter, more innovative solutions for our customers. Hiring decisions are based on merit, skills, qualifications, and potential. If you need adjustments or support during the recruitment process, please let us know.