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 mee