Oracle PL/SQL Developer
Download PDF | LinkedIn Profile
Professional Profile #
I write advanced PL/SQL for data-intensive applications and Data Warehouses that hold under load.
ATRADIUS: 60,000+ lines of PL/SQL ETL coordinated end-to-end, full daily ingestion brought from 4+ hours to under 2 with BULK COLLECT/FORALL and partition-aware DML. FINWAVE: PL/SQL packages for financial applications with millions of daily transactions. Banking + Telepass: PL/SQL code optimization with Hierarchical Profiler on data-intensive workloads over 2 billion rows.
Thirty years inside PL/SQL. Packages, procedures, functions, triggers. FORALL, BULK COLLECT, Dynamic SQL, Analytic Functions, CTEs. Tuning with TKPROF, Explain Plan, SQL Profiles. Technical mentoring of junior developers. What I bring: PL/SQL code that runs data-intensive workloads without breaking points.
Technical Skills #
- Languages: Advanced PL/SQL · Advanced SQL (Dynamic SQL, Analytic Functions, CTEs) · Unix Shell Scripting.
- PL/SQL Development: Packages · Procedures · Functions · Triggers · Records · Collections · Object Types · Error and exception handling · Bulk processing (FORALL, BULK COLLECT) · Dynamic SQL (DBMS_SQL, Execute Immediate) · Hierarchical Profiler for code optimization.
- SQL Tuning: Explain Plan · SQL Trace · TKPROF · Hints · SQL Profiles · query rewriting · indexes · understanding of database design impact on PL/SQL performance.
- Tools & DB: SQL Developer · Toad · SQL*Plus · Oracle Database 8i → 21c · Autonomous Database · Oracle Cloud Infrastructure (OCI) · Git/GitHub.
- Related concepts: Data Warehousing (ETL/ELT) · Data Integration · relational and multidimensional data modeling (Kimball, Inmon).
Work Experience #
2022 – Present — IDEA DB CONSULTING S.R.L. — Rome, Italy (Full Remote Europe) #
Senior Oracle PL/SQL Developer & DWH Architect
PL/SQL Developer (for ATRADIUS) | 4 years
60,000+ lines of PL/SQL code (packages, procedures, functions) for the Surety division DWH (4 European countries). Reusable PL/SQL templates with built-in checkpoints for real-time ETL pipeline tracking. Daily ingestion brought from 4+ hours to under 2 with BULK COLLECT/FORALL and partition-aware DML.
PL/SQL Developer (for FINWAVE S.p.A.) | 2 years
PL/SQL packages for financial transaction processing applications handling millions of daily operations; advanced query optimization and PL/SQL code tuning for high-volume financial data pipelines.
PL/SQL Developer (for FAI SERVICE) | 2 years
ETL procedures in PL/SQL on Oracle 19c in OCI for billing, customer segmentation and cost/revenue tracking; PL/SQL modules feeding Oracle Analytics Cloud dashboards with aggregated KPIs.
PL/SQL Development (Banking, Telepass and other clients) | 1 year
PL/SQL business logic packages for banking-sector DWH applications on datasets over 2 billion rows. PL/SQL code optimization with Hierarchical Profiler to identify bottlenecks on critical paths.
2020 – 2022 — NIMIS CONSULTING S.R.L. — Rome, Italy (Full Remote) #
Senior Oracle DBA & Performance Expert with Development Focus (for TIM / HUAWEI) | 2 years
Specialist support to TIM/HUAWEI development teams on Oracle Exadata databases: PL/SQL code and SQL query optimization for critical applications, analysis and tuning of high-volume PL/SQL batch processes, PL/SQL scripts for monitoring and administration tasks.
2013 – 2020 — FREELANCE / INDEPENDENT CONSULTANT — Rome, Italy (Full Remote Europe) #
Senior Oracle PL/SQL Developer & DBA / DWH Architect (Consulting companies and Direct clients) | 7 years
Custom PL/SQL solutions for Banking, Telco and services clients: packages for ETL logic, data processing procedures, PL/SQL APIs, intensive optimization of PL/SQL and SQL code for existing systems, training and mentoring of junior developers on PL/SQL best practices.
2009 – 2013 — AUSELDA AED GROUP S.P.A. — Rome, Italy #
Oracle PL/SQL Developer & DWH Specialist (for Public Administration) | 4 years
Development of PL/SQL components for DWH systems and management applications for Public Administration, with evolutionary and corrective code maintenance and optimization of ETL processes based on PL/SQL and Oracle Warehouse Builder (OWB).
1999 – 2009 — ORACLE ITALIA S.R.L. — Various Locations, Italy & Madrid, Spain #
SQL & PL/SQL Developer / DWH Architect / DBA / Training Specialist | 10 years
Intensive PL/SQL development for DWH, BI and custom application projects for enterprise clients (Telco, Finance, Pharmaceutical): PL/SQL packages for complex business logic, ETL data loading procedures with Oracle Warehouse Builder, BI Reports and HTMLDB (Apex) interfaces. About 1 year of international experience in Madrid. Training Specialist on Oracle SQL and PL/SQL (Basic and Advanced) in 2000-2001.
1999 — ETNOTEAM S.P.A. — Rome, Italy #
Web Developer / Oracle SQL & PL/SQL Developer
Web portals and client-server applications with strong interaction with Oracle databases, using SQL and PL/SQL for backend logic.
1997 – 1999 — S.EL.DAT. S.P.A. — Rome, Italy #
Software Developer / Junior DBA | 2 years
Client-server application development with Oracle backend and first experiences with SQL and PL/SQL — the starting point of the Oracle journey.
Education and Training #
- Faculty of Computer Engineering (Software Engineering) | University of Rome Tre, Rome | 1994 – 2000
- Scientific High School Diploma (EQF Level 4) | Liceo Scientifico Isacco Newton / Manieri Copernico, Rome | 1988 – 1993
- Advanced English (C1/C2) | The British Council (Level 4A), Rome | 2003 – 2004
Selected Training and Continuing Education: Project Management & Scrum Agile — Randstad/Forma.temp (May 2024) · Data Wrangling, Analysis and AB Testing with SQL — Coursera, UC Davis (April 2021) · Advanced SQL for Query Tuning and Performance Optimization — LinkedIn Learning (August 2020) · Oracle 12c specialization (Advanced SQL, New Features) + Learning Git and GitHub — LinkedIn Learning (2020).
Languages #
Italian — Native · English — C1/C2 (Fluent, professional) · Spanish — C1 (Fluent) · Romanian — C1 (Fluent) · French — A1/A2 (Basic)
Soft Skills #
Analytical approach and orientation to complex problem solving · writing clear, efficient and maintainable code · advanced debugging and troubleshooting · understanding of functional and technical requirements · effective collaboration in development teams · attention to detail and software quality · technical mentoring of junior developers.
I consent to the processing of my personal data pursuant to Art. 13 of EU Regulation 2016/679 (GDPR).
Location: Rome, Italy
Last Update: June 2026