About this role
<div> <p><span style="font-family:tahoma, arial, helvetica, sans-serif;font-size:14.0pt"><strong>Type of contract:</strong> employment contract</span></p> </div> <div> <p><span style="font-family:tahoma, arial, helvetica, sans-serif;font-size:14.0pt"><strong>Salary range:</strong> 11 700 - 18 750 PLN gross/m</span></p> <p> </p> </div> <p><strong><span style="font-family:tahoma, arial, helvetica, sans-serif">What will you do?</span></strong></p> <p> </p> <p><span style="font-family:tahoma, arial, helvetica, sans-serif">We're looking for a PL/SQL Engineer to join a project for a client in the banking sector.</span></p> <p><span style="font-family:tahoma, arial, helvetica, sans-serif">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.</span></p> <p> </p> <p><strong><span style="font-family:tahoma, arial, helvetica, sans-serif">Your tasks</span></strong></p> <p> </p> <ul> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Design, develop, and maintain Oracle database schemas and applications</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Optimize database performance and ensure data integrity</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Develop and implement database solutions to support business needs</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Collaborate with application developers to integrate database solutions</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Perform database tuning and troubleshooting</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Manage and optimize containerized applications using OpenShift</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Build and deploy applications using standard build tools</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Implement/Maintain CI/CD pipelines using Jenkins/GitHub Actions and Maven/Gradle</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Design and implement applications with a focus on observability and supportability</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Present work effectively to both technical and non-technical audiences</span></li> </ul> <p> </p> <p><strong><span style="font-family:tahoma, arial, helvetica, sans-serif">Your skills</span></strong></p> <p> </p> <ul> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">3-4 years of hands-on experience in Data Warehousing</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Expertise in Oracle databases, including ExaCC and production-level experience with Oracle 19c (or other versions)</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Very good SQL and PL/SQL skills, with proficiency in complex analytics and bulk operations, including practical knowledge of partitioned tables and materialized views</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Performance tuning - nice to have</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Experienced in troubleshooting production database issues; confident collaborating with DBAs and constructively challenging recommendations when needed</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Understanding of the inner workings of the Oracle database</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Practical experience with both OLTP and Data Warehouse platforms, with tailored approaches to design, coding, and tuning</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Comfortable engaging with data modelers to review, critique, and evolve database designs based on new requirements</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Skilled at analyzing complex legacy code and implementing streamlined, reusable solutions</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Very good command of English (frequent communication with English-speaking customers)</span></li> </ul> <p> </p> <p><strong><span style="font-family:tahoma, arial, helvetica, sans-serif">Nice to have</span></strong></p> <p> </p> <ul> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Java</span></li> </ul> <p> </p> <p><strong><span style="font-family:tahoma, arial, helvetica, sans-serif">We offer you</span></strong></p> <p> </p> <ul> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Contract of employment</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Hybrid work in one of our locations: Lodz, Poznan, Krakow, Warszawa, Wroclaw (2 office days per week) </span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Working in a highly experienced and dedicated team</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Benefit package that can be tailored to your personal needs (private medical coverage, sport & recreation package, lunch subsidy, life insurance, etc.)</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">On-line training and certifications fit for career path</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Access to e-learning platform</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">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)</span></li> <li><span style="font-family:tahoma, arial, helvetica, sans-serif">Social events</span></li> </ul>