PL/SQL Engineer

What will you do?

We're looking for a PL/SQL Engineer to join a project for a client in the banking sector.

You'll work in the credit risk area, focusing on a custom database model built on Oracle. The role involves writing SQL queries and PL/SQL procedures, data analysis, query optimization, and potentially performance tuning. In the near future, you’ll also support the migration to GCP.

Your tasks

• 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/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

Your skills

• 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, including practical knowledge of partitioned tables and materialized views


• Performance tuning - nice to have


• Experienced in troubleshooting production database issues; confident collaborating with DBAs and constructively challenging recommendations when needed


• 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


• Comfortable engaging with data modelers to review, critique, and evolve database designs based on new requirements


• Skilled at analyzing complex legacy code and implementing streamlined, reusable solutions


• Very good command of English (frequent communication with English-speaking customers)

Nice to have

• Java

We offer you

• Contract of employment


• Hybrid work in one of our locations: Lodz, Poznan, Krakow, Warszawa, Wroclaw (2 office days per week) 


• Working in a highly experienced and dedicated team


• Benefit package that can be tailored to your personal needs (private medical coverage, sport & recreation package, lunch subsidy, life insurance, etc.)


• On-line training and certifications fit for career path


• Access to e-learning platform


• Mindgram - a holistic mental health and wellbeing platform


• Work From Anywhere (WFA) - the temporary option to work remotely outside of Poland for up to 140 days per year (including Italy, Spain, the UK, Germany, Portugal, and Bulgaria)


• Social events