10/20/2026 updated
100 % available
PL/SQL Developer | Oracle Database Developer
Poznań, Poland
Only remote
Engineer - Technical and Computer Science Education, Poznan University of Technology (2013-2017)About me
PL/SQL / Oracle Database Developer and Apex Oracle Developer with nearly 5 years of commercial experience in developing database-driven business systems.
Business Intelligence DevelopmentDatabase DesignDatabase DevelopmentPostgreSQLOracle Business Intelligence Enterprise EditionOracle DatabasesOracle SQL DeveloperOracle ApexPL-SQLSQL DatabasesBusiness Intelligence Development StudioDatabase Performance AnalyzerSQL OptimizationBi PublisherGame Design
PL/SQL Development
Extensive experience in developing PL/SQL business logic including packages, package bodies, procedures, functions, triggers, cursors and exception handling for production applications.
Oracle Database Design
Strong expertise in relational database modelling, PK/FK constraints, views, materialized views and Oracle Scheduler, including design and implementation of complex database structures for large-scale systems.
SQL Query Optimisation
Proficiency in writing and optimising complex SQL queries involving joins, subqueries, CTE/WITH clauses and practical query optimisation using EXPLAIN PLAN to significantly improve execution performance.
Oracle APEX
Practical experience in designing and developing Oracle APEX applications, including CRM systems built from scratch and complex business logic for production environments.
BI Publisher
Experience in creating reporting outputs using BI Publisher as part of database-driven business systems.
Version Control with Git/GitHub
Regular use of Git and GitHub for maintaining and versioning database objects across development, test and production environments.
PostgreSQL
Knowledge of PostgreSQL applied in personal database project development, including relational model design with approximately 50 tables and 10-15 views.
Django
Backend development experience using Django as part of a browser-based application project built on a PostgreSQL database.
HTML/CSS and JavaScript
Additional knowledge of HTML/CSS and JavaScript as supplementary frontend technologies.
DDL/DML Deployment Scripting
Preparation and management of DDL/DML deployment scripts across DEV, TEST and PROD environments as part of the full change lifecycle.
Extensive experience in developing PL/SQL business logic including packages, package bodies, procedures, functions, triggers, cursors and exception handling for production applications.
Oracle Database Design
Strong expertise in relational database modelling, PK/FK constraints, views, materialized views and Oracle Scheduler, including design and implementation of complex database structures for large-scale systems.
SQL Query Optimisation
Proficiency in writing and optimising complex SQL queries involving joins, subqueries, CTE/WITH clauses and practical query optimisation using EXPLAIN PLAN to significantly improve execution performance.
Oracle APEX
Practical experience in designing and developing Oracle APEX applications, including CRM systems built from scratch and complex business logic for production environments.
BI Publisher
Experience in creating reporting outputs using BI Publisher as part of database-driven business systems.
Version Control with Git/GitHub
Regular use of Git and GitHub for maintaining and versioning database objects across development, test and production environments.
PostgreSQL
Knowledge of PostgreSQL applied in personal database project development, including relational model design with approximately 50 tables and 10-15 views.
Django
Backend development experience using Django as part of a browser-based application project built on a PostgreSQL database.
HTML/CSS and JavaScript
Additional knowledge of HTML/CSS and JavaScript as supplementary frontend technologies.
DDL/DML Deployment Scripting
Preparation and management of DDL/DML deployment scripts across DEV, TEST and PROD environments as part of the full change lifecycle.
Languages
EnglishGoodPolishNative speaker
Project history
Design and development of a PostgreSQL database for a browser-based strategic-economic game. Database model designed from scratch with approximately 50 tables and 10-15 views. Design of PK/FK relationships, constraints and game-domain structures. Backend development using Django.
Designed and developed PL/SQL business logic for production applications. Created packages, procedures, functions, triggers, views and scheduled jobs. Designed database structures and relationships for new functionality. Developed and maintained complex SQL queries. Analysed production issues and debugged PL/SQL/database logic. Modified existing data models while maintaining compatibility with production data. Analysed requirements and translated business rules into database and application logic. Prepared DDL/DML deployment scripts across DEV, TEST and PROD environments. Participated in release preparation, testing and production support. Maintained database object versions using Git/GitHub.
Designed and implemented the main PL/SQL calculation engine for a banking customer risk assessment system operating on hundreds of thousands of customer records. The engine collected customer data across multiple risk categories, compared attributes against configurable dictionaries, calculated individual risk scores, aggregated scores using category weights and assigned final risk levels. Implemented calculation history for historical risk decision reconstruction. Developed validation logic, periodic customer verification, related-person processing and BI Publisher outputs. Also designed database structures and PL/SQL logic for an Oracle APEX CRM system and maintained complex business logic for a large production system for a ceramic tile manufacturer.