Senior Oracle Database Developer
Avenga · Poland · hybrid
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.