Senior Oracle Database Developer

O projekcie 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.

Zakres obowiązków

• 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

Wymagania

• 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