Data Warehouse Architect

Professional Profile #

I design and work on Data Warehouses with datasets ranging from hundreds of millions to billions of rows.

ATRADIUS: Surety division consolidated across 4 European countries, 60,000+ lines of PL/SQL ETL, full daily ingestion completed in under 2 hours. TIM/Huawei: 30+ critical Oracle databases on Exadata clusters, 70+ instances, up to 800 million phone-traffic records per day. Banking + Telepass: integration from 15+ heterogeneous sources, over 2 billion rows per cycle.

Thirty years inside Oracle and PostgreSQL. Kimball, Inmon, Star Schema, Snowflake, SCD Type 2. Sectors: Banking, Telco, Insurance, Public Administration. What I bring: architectures that hold under load and scale with the data as it grows.

Technical Skills #

DWH Methodologies: Multidimensional modeling Kimball and Inmon · Star Schema · Snowflake · Slowly Changing Dimensions (SCD Type 1/2/3) · Bus Matrix design.
Oracle Stack: Oracle Database 8i → 21c · Exadata · RAC · Data Guard · Autonomous Database (ADB) · Oracle Cloud Infrastructure (OCI) · Performance Tuning (AWR, ADDM, SQL Tuning Advisor) · ASM · RMAN · TDE.
PostgreSQL: PostgreSQL 14+ · Query Optimization · Table Partitioning · Logical Replication · VACUUM/Autovacuum tuning · pg_stat_statements · PgBouncer.
ETL/ELT and BI: PL/SQL-based ETL pipelines · Oracle Data Integrator (ODI) · Oracle Warehouse Builder (OWB, legacy) · Oracle Analytics Cloud (OAC) for semantic model, reports and dashboards.
Languages, OS and cross-functional: Advanced SQL and PL/SQL · Unix Shell Scripting · Linux (RHEL, CentOS, Oracle Linux), Unix, Windows Server · Project Management (Agile/Scrum) · team leadership 3-7 people · technical training.

Work Experience #

2021 – Present — IDEA DB CONSULTING S.R.L. — Rome, Italy (Full Remote Europe) #

Data Warehouse Architect | Oracle & PostgreSQL Expert | Sole Director

DWH Architect (for ATRADIUS) | 4 years
Surety division DWH architecture: 4 European countries consolidated on Oracle, full dimensional model and 60,000+ lines of PL/SQL ETL with daily ingestion under 2 hours.
DWH Architect (for FAI SERVICE) | 2 years
Snowflake Schema on Oracle Analytics Cloud with ETL on Oracle 19c in OCI, supporting dashboards for billing, customer segmentation and cost/revenue tracking.
DWH Design and Architecture (Banking, Telepass and other clients) | 1 year
Kimball/Inmon DWH architectures for Banking and Telepass: 15+ heterogeneous sources integrated, datasets over 2 billion rows per cycle, batches brought from 4 hours to under 30 minutes.
Cross-project activities
Tuning of complex SQL queries and Oracle DB optimization on OCI/Autonomous; technical training and mentoring on DWH best practices and Oracle/PostgreSQL.

2020 – 2022 — NIMIS CONSULTING S.R.L. — Rome, Italy (Full Remote) #

Oracle DBA | DWH Architect | Oracle Performance & Tuning Expert (for TIM / HUAWEI) | 2 years

Telco DWH architecture on 30+ critical Oracle databases (70+ instances on Exadata clusters) supporting 20+ million prepaid mobile subscribers. Fact tables ingesting up to 800 million phone-traffic records per day, advanced partitioning and compression for <500ms SLA on critical queries.

2020 – 2022 — IDEA DB CONSULTING S.R.L. — Rome, Italy (Full Remote) #

PL/SQL Expert | Oracle DBA & Tuning Expert (for FINWAVE S.p.A.) | 2 years

Advanced PL/SQL development and Oracle query tuning for financial applications with millions of daily transactions.

2013 – 2020 — FREELANCE / INDEPENDENT CONSULTANT — Rome, Italy (Full Remote Europe) #

Oracle DBA | Oracle Performance & Tuning Expert | DWH Architect (Consulting companies and Direct clients) | 7 years

Data Warehouses for Banking, Insurance and Telco clients on Oracle and PostgreSQL platforms, with Kimball/Inmon modeling. ETL/ELT pipelines handling 500M+ rows per load cycle; multicultural teams of 3-7 people coordinated with an Agile approach.

2009 – 2013 — AUSELDA AED GROUP S.P.A. — Rome, Italy #

Data Warehouse Architect | Performance & Tuning Expert | Oracle Project DBA (for Public Administration) | 4 years

DWH architecture (Kimball/Inmon) for Public Administration entities, with specialization in Oracle Warehouse Builder (OWB) and complex SQL query optimization.

1999 – 2009 — ORACLE ITALIA S.R.L. — Various Locations, Italy & Madrid, Spain #

Data Warehouse architecture and development for major clients in Telco (TIM, Vodafone, TRE), Finance (Banca d’Italia, Generali, RAS) and Pharmaceutical (Menarini), with Kimball/Inmon modeling and ETL on Oracle Warehouse Builder. About 1 year of international experience in Madrid at Vodafone Spain. Training Specialist on Oracle technical courses: SQL, PL/SQL, DBA and Performance Tuning (2000-2001).

1997 – 1999 — S.EL.DAT. S.P.A. — Rome, Italy #

Software Developer (for Telecom, Rover Italia) | 2 years

Client-server application development for Telecom and Rover Italia, with first experiences as Junior Oracle DBA and database monitoring — 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) · Data Science on GCP: Designing Data Warehouses — LinkedIn Learning (September 2020) · Oracle 12c specialization (Administration, Security, Backup & Recovery, Advanced SQL, Performance Optimization) — LinkedIn Learning (2020) · MySQL Installation and Configuration + Learning Git and GitHub — LinkedIn Learning (August 2020).

Languages #

Italian — Native · English — C1/C2 (Fluent, professional) · Spanish — C1 (Fluent) · Romanian — C1 (Fluent) · French — A1/A2 (Basic)

Soft Skills #

Analytical and creative problem solving · collaboration in international and fully remote contexts · project management (Agile/Scrum, requirements definition, prioritization, Gantt charts, ERD) · technical leadership of 3-7 people teams · technical mentoring · stakeholder engagement.

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

Download PDF | LinkedIn Profile | Back to previous page