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