Oracle Developer

Quick Facts

Role: Oracle Developer (SQL/PLSQL, Oracle Database, integrations, ETL & messaging)

Work mode: Hybrid — 1 day per week from the Warsaw office

Compensation: 1100–1300 PLN net/day (depending on experience and skills)

Description

You will develop, maintain, and optimize Oracle Database–based systems that support key banking processes. The work includes SQL/PLSQL development (procedures, functions, packages, triggers, batch processes), performance diagnostics using AWR/ASH and execution plans, and integrations using REST/SOAP plus ETL and Oracle AQ messaging.

Responsibilities

• Develop, maintain, and optimize Oracle Database systems supporting core banking workflows
• Design and implement SQL and PL/SQL solutions, including procedures, functions, packages, triggers, and batch jobs
• Analyze and optimize SQL query performance and PL/SQL code in production environments
• Monitor system behavior, analyze logs, and diagnose performance issues and production errors
• Review execution plans and AWR/ASH reports to identify database bottlenecks
• Implement integrations between banking systems using REST API, SOAP, XML, JSON, and data-exchange mechanisms
• Design and operate ETL processes and Oracle AQ / message-queue based solutions
• Collaborate on rollouts of new functionality and changes in the bank’s central systems
• Prepare technical documentation and support business requirement analysis

Requirements

• Higher education (preferably IT, information systems, or STEM)
• Very good knowledge of Oracle Database 12c/19c/21c
• Strong, multi-year experience with SQL and PL/SQL development and maintenance
• Ability to write advanced SQL queries (CTEs, analytic functions, MERGE) and optimize performance
• Practical experience with Oracle development: procedures, functions, packages, triggers, and exception handling
• Experience with data modeling, schema design, indexing, and table partitioning
• Performance analysis experience using EXPLAIN PLAN, AWR Reports, ASH Reports, and monitoring of sessions/locks/deadlocks
• SQL and PL/SQL optimization experience in high-availability, high-transaction systems
• Integration technology knowledge: REST API, SOAP, XML, JSON, XSD, and data exchange processes
• Experience with Oracle AQ, message queues, ETL, and integrations with central systems

Benefits

• Long-term collaboration
• Technical training, certifications, and skill development
• Mentoring Competence Center community from day one, including conferences and knowledge sharing
• Clear career path
• Employee benefits package: Multisport, private medical care, life insurance
• Friendly team environment with integration events and team-building activities