Oracle Database Developer (ETL/PLSQL)

Quick Facts

• Fully remote
• Rate up to 130 PLN/hour
• Minimum project duration: 12 months

Description

You will support the development of data processing and data integration solutions using Oracle Database, PL/SQL and ETL technologies. Your tasks include designing and improving database-related processes, optimizing queries, ensuring efficient data processing mechanisms, and analyzing errors and technical issues.

Responsibilities

• Design, implement and optimize ETL/ELT processes
• Maintain and deploy ETL processes
• Monitor and optimize database performance and data-processing performance
• Ensure solutions comply with data security and data integrity requirements
• Diagnose and resolve data-layer incidents
• Optimize performance of PL/SQL procedures, scripts and queries
• Maintain code quality and compliance with corporate/internal coding standards
• Manage source code in Git with Flyway
• Support integration testing and UAT
• Collaborate with analysts and testers in the delivery process
• Participate in CI/CD (code review, deploying fixes, maintaining repositories/branches in Git)
• Document database structures and processes

Benefits

• Private healthcare
• Co-financing for a sports card

Requirements

• Minimum 5 years experience as an Oracle database developer
• Very good knowledge of Oracle relational databases
• Advanced PL/SQL including transactions, XML and JSON data processing, partitioning, and data versioning
• Experience designing and implementing ETL solutions
• Experience with ETL orchestration tools (preferred Apache Airflow)
• Ability to write, optimize and debug complex PL/SQL scripts
• Knowledge of code/versioning tools (Git, Flyway, Liquibase)
• Teamwork skills and ability to work with an external customer
• Independence and responsibility for assigned tasks