Oracle Database Developer

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.

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

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.

• 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