Senior Oracle Database Developer

AVENGA (Agencja Pracy, nr KRAZ: 8448) Warszawa 2026-11-02
  • Very strong Oracle Database and PL/SQL expertise
  • Hands-on experience with performance tuning and troubleshooting
  • Comfortable working in Linux environments
  • Understanding of banking architectures and mission-critical systems
  • Able to analyze business requirements and translate them into technical solutions
  • Experience with CI/CD and modern development practices

  • 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

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

    ,[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, system integrations] Requirements: Oracle database, SQL, PL/SQL, Data modeling, Performance tuning, Oracle, REST API, SOAP, XML, XSD, JSON, Message queue, ETL, Linux, Unix, Bash script, SFTP, Git, Azure DevOps, Jenkins, CI/CD Pipelines, Jira, Confluence, Security, GDPR, Data management, High availability, HA, Elixir, Express, SEPA, Swift, System integration, CI/CD