Oracle Database Developer

Quick Facts

• Role: Oracle Database Developer

• Focus: Oracle Database development, ETL/ELT, PL/SQL optimization, and Oracle APEX

Description

Develop and maintain Oracle Database solutions, including new business initiatives and ongoing support under SLA for Oracle databases. You will support ETL/ELT development and refactoring, optimize database and processing performance, ensure security and data integrity compliance, and participate in code reviews and troubleshooting.

Responsibilities

• Maintain and deploy ETL processes in Oracle and Big Data environments

• Design, implement, and optimize ETL/ELT processes

• Build applications using Oracle APEX

• Monitor and optimize performance of databases and data-processing jobs

• Ensure solutions comply with security requirements and data integrity rules

• Diagnose and resolve data-layer incidents

• Optimize performance of processes, queries, and PL/SQL procedures

• Maintain code quality and compliance with corporate and internal quality standards

• Manage source code with Git and Flyway

• Support integration testing and UAT

• Collaborate with analysts and testers during delivery

• Participate in CI/CD (code review, deployment of fixes, repository maintenance, branch management in Git)

• Document database structures and processes

Requirements

• Minimum 5 years of experience as an Oracle database developer

• Very good knowledge of relational databases (preferred Oracle)

• Advanced PL/SQL knowledge, including transactions, Oracle AQ, XML/JSON processing, partitioning, and data versioning

• Experience designing and implementing ETL solutions

• Experience with ETL orchestration tools (preferred Apache Airflow)

• Proficiency in writing, optimizing, and debugging complex PL/SQL scripts

• Knowledge of code versioning tools (Git, Flyway, Liquibase)

• Ability to work in a team and with external client stakeholders

• Independence and responsibility for assigned tasks

• Problem-solving and logical thinking skills

• Experience actively using AI coding/support tools (Codex, Claude, Gemini, Copilot), including building complex and accurate prompts

Benefits

• Project opportunity in the energy industry