PL/SQL Engineer

The position is for a Mid Oracle Database Engineer to join a project for a client in the banking sector, focusing on credit risk and a custom database model built on Oracle.

• 3-4 years of hands-on experience in Data Warehousing
• Expertise in Oracle databases, including ExaCC and production-level experience with Oracle 19c or other versions
• Very good SQL and PL/SQL skills, with proficiency in complex analytics and bulk operations
• Practical knowledge of partitioned tables and materialized views
• Experience troubleshooting production database issues and collaborating with DBAs
• Understanding of the inner workings of the Oracle database
• Practical experience with both OLTP and Data Warehouse platforms, with tailored approaches to design, coding, and tuning
• Ability to engage with data modelers to review and evolve database designs
• Skilled at analyzing complex legacy code and implementing streamlined, reusable solutions
• Very good command of English for frequent communication with English-speaking customers

Nice to have:

• Java
• Performance tuning

• Write SQL queries and PL/SQL procedures
• Perform data analysis and query optimization
• Support migration to Google Cloud Platform (GCP) in the near future
• Design, develop, and maintain Oracle database schemas and applications
• Optimize database performance and ensure data integrity
• Develop and implement database solutions to support business needs
• Collaborate with application developers to integrate database solutions
• Perform database tuning and troubleshooting
• Manage and optimize containerized applications using OpenShift
• Build and deploy applications using standard build tools
• Implement and maintain CI/CD pipelines using Jenkins/GitHub Actions and Maven/Gradle
• Design and implement applications with a focus on observability and supportability
• Present work effectively to both technical and non-technical audiences