Senior Oracle Database Developer

Avenga; Polska; On-site; PLN 180,000 - 260,000; Full time

Job summary

Avenga is seeking an experienced Oracle Database Developer to join a team responsible for critical banking systems and integrations. You will design, develop, and maintain Oracle database solutions, optimize SQL/PL/SQL, and support high-availability environments.

The role covers performance tuning, data modeling, and complex integrations (REST/SOAP/XML/JSON) within Linux/Unix environments. You will collaborate with analysts, testers, and DBAs on deployments and documentation.

Qualifications

• Extensive experience with Oracle Database in HA environments.
• Strong SQL and PL/SQL development skills.
• Experience with database design and data modeling.
• Hands-on performance tuning and indexing.
• Experience with REST/SOAP/XML/JSON integrations.
• Knowledge of banking systems and payment processing.

Responsibilities

• Design, develop, and maintain Oracle database solutions.
• Create and optimize SQL and PL/SQL code.
• Develop procedures, functions, packages, and triggers.
• Analyze and optimize database and application performance.
• Support integrations between banking systems.
• Investigate and resolve production issues.
• Participate in deployments and releases.
• Cooperate with analysts, testers, and DBAs.
• Prepare technical documentation and effort estimations.

Skills

Oracle DB

Oracle 12c/19c/21c

Advanced SQL

Analytical queries

CTE

MERGE

PL/SQL

Procedures

Functions

Packages

Triggers

Exception handling

Data modeling

Performance tuning

Indexing

Partitioning

Scheduler

Data Pump

Schema management

REST API

SOAP

XML

JSON

Oracle AQ

Message queues

ETL

System integration

Linux

Bash

Log analysis

Cron

SCP/SFTP

Git

Azure DevOps

Jenkins

CI/CD

Jira

Confluence

SQL Developer

TOAD

Tools

Git

Azure DevOps

Jenkins

CI/CD

Jira

Confluence

SQL Developer

TOAD

Job description

Avenga is an international engineering firm helping businesses operate with AI at the core. With 6,000+ experts worldwide, we combine engineering expertise with AI-native thinking to turn ambitious ideas into real-world impact across industries, technologies, and markets.

At the core of the role

We are looking for an experienced Oracle Database Developer to join a team responsible for critical banking systems and integrations. This role is ideal for a professional who enjoys working with large-scale databases, performance optimization, complex integrations, and high-availability transactional environments.
Core skills you’ll bring

• Oracle Database

  • Oracle Database 12c / 19c / 21c

  • Advanced SQL

    • Analytical queries

    • CTE

    • MERGE

  • PL/SQL

    • Procedures

    • Functions

    • Packages

    • Triggers

    • Exception handling

  • Data modeling

  • Performance tuning and indexing

  • Table partitioning

  • Oracle Scheduler

  • Oracle Data Pump

  • Schema and database object management

Performance & Troubleshooting

• Query execution plan analysis (EXPLAIN PLAN)

• AWR Reports

• ASH Reports

• Session monitoring

• Lock and deadlock analysis

• SQL performance tuning

• PL/SQL optimization

Integration & Data Exchange

• REST API

• SOAP

• XML / XSD

• JSON

• Oracle AQ

• Message queues

• ETL processes

• System-to-system integrations

Linux / Unix

• Linux command line

• Bash scripting

• Log analysis

• Cron jobs

• Process diagnostics

• SCP / SFTP file transfers

Development Tools

• Git

• Azure DevOps or Jenkins

• CI/CD pipelines

• Jira

• Confluence

• SQL Developer

• TOAD

Security

• Oracle privileges, roles, and grants

• Data encryption

• Access auditing

• GDPR compliance

• Sensitive data management

Banking Knowledge

• Transaction processing systems

• High Availability (HA)

• Disaster Recovery

• Batch processing

• Payment systems (ELIXIR, Express ELIXIR, SEPA, SWIFT)

• Core banking system integrations

The impact you'll create

• Design, develop, and maintain Oracle database solutions

• Create and optimize SQL and PL/SQL code

• Develop procedures, functions, packages, and triggers

• Analyze and optimize database and application performance

• Support integrations between banking systems

• Investigate and resolve production issues

• Participate in deployments and releases

• Cooperate with analysts, testers, and DBAs

• Prepare technical documentation and effort estimations

People are at the core of Avenga. We provide equal opportunities regardless of race, ethnicity, gender identity, sexual orientation, disability, age, religion, or any other characteristic. We are committed to a respectful environment where everyone can be themselves, share their ideas, and feel that they belong.