Database Engineer at Endava

Pune, maharashtra, India -

Full Time

Start Date

Immediate

Expiry Date

01 Oct, 26

Salary

0.0

Posted On

03 Jul, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, PL/SQL, Oracle, DB2, Database Tuning, ELT, GitHub, Table Partitioning, Query Optimization, Linux Shell Scripting, CI/CD, Flyway

Industry

IT Services and IT Consulting

Description

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. Additional Information 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.

Responsibilities

Develop and review SQL and PL/SQL scripts for transactional and data warehouse environments. Troubleshoot performance issues and maintain ELT processes to ensure system reliability and scalability.