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 qualified 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 troubleshooti
📌 Database Engineer (Pune)
🏢 Endava
📍 Pune