Database Engineer

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 were 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 perspectivesbecause 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.

Remote Work :

No

Employment Type :

Full-time