1. Know-How & Impact/

Oracle DBA & Performance Tuning Expert

Download PDF | LinkedIn Profile

Professional Profile #

Highly skilled Senior Oracle DBA and Performance Tuning Expert with nearly 30 years of specialized experience in the administration, optimization, and management of complex, mission-critical Oracle databases, including Exadata, RAC, and Oracle Cloud (OCI, Autonomous Database) environments. Deep expertise in performance analysis (AWR, ADDM, ASH), tuning complex SQL queries, instance optimization, and resolving performance issues. Foundational knowledge of practices related to backup & recovery (RMAN), security (TDE), installation, patching, migrations, and storage management (ASM), with performance tuning remaining the primary and in-depth area of expertise, crucial for the integrity, performance, and contribution to the high availability of Oracle systems in demanding, international corporate settings.

Technical Skills — Oracle DBA & Performance Tuning #

  • Oracle Database Administration: Oracle Database (from 8i to 21c, Autonomous), Oracle Exadata, Oracle RAC (Real Application Clusters), Oracle Data Guard, Oracle GoldenGate (basic knowledge).
  • Advanced Performance Tuning:
    • Analysis and Diagnostics: AWR, ADDM, ASH, Statspack, SQL Trace, TKPROF, Explain Plan.
    • SQL Tuning: Optimization of complex queries, Hints, SQL Profiles, SQL Plan Management (SPM).
    • Instance Tuning: Memory Management (SGA, PGA), Initialization Parameters, Wait Events Analysis.
    • Database Design for Performance: Indexing (B-tree, Bitmap, Function-based), Partitioning (Range, List, Hash, Composite), Compression.
  • High Availability and Disaster Recovery: RMAN (Backup, Recovery, Cloning), Oracle Data Guard, Flashback Technologies.
  • Database Security: Oracle TDE (Transparent Data Encryption), User and Privilege Management, Auditing.
  • Storage Management: ASM (Automatic Storage Management), Tablespace Management.
  • Installation, Patching, and Migrations: Installation of new instances, application of PSU/CPU/RU, version upgrades, cross-platform migrations.
  • Oracle Tools: Oracle Enterprise Manager (OEM) Cloud Control, SQL Developer, SQL*Plus, Toad.
  • Scripting: PL/SQL, SQL, Unix Shell Scripting (for DBA task automation).
  • Cloud: Oracle Cloud Infrastructure (OCI) — Compute, Storage, Networking, Database Services (VM DB, Bare Metal, Exadata CS, Autonomous Database).
  • Other Database Technologies: PostgreSQL (administration, performance tuning, partitioning, replication), MySQL (administration, configuration, replication, InnoDB optimization).
  • Operating Systems: Linux (Red Hat, Oracle Linux), Unix (AIX, Solaris), Windows Server.

Work Experience #

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

Senior Oracle DBA & Performance Tuning Expert / DWH Architect | Sole Director | 2021 – Present

  • MySQL & PostgreSQL DBA (for POSTE ITALIANE) | Jul 2025 – Present:

    • Administration and management of approximately 1,500 MySQL and PostgreSQL instances across production, staging, and development environments.
    • Performance monitoring, query tuning, replication management, and capacity planning at enterprise scale.

  • Oracle DBA & Tuning Expert (for GENERALI Assicurazioni) | Feb 2024 – May 2025:

    • Oracle database administration and advanced performance tuning for insurance-sector applications.
    • AWR/ADDM analysis, SQL optimization, and proactive bottleneck resolution on databases ranging from 500GB to 8TB.

  • Oracle DBA (for ATRADIUS) | 2022 – 2026:

    • Database administration and performance tuning supporting the Surety division Data Warehouse consolidating data from Italy, Spain, France, and Northern European countries.
    • Management of Oracle databases in OCI environments, supporting over 60K lines of PL/SQL ETL code with full daily ingestion completing in under 2 hours.

  • Oracle DBA (for FAI SERVICE) | 2021 – 2023:

    • Administration and tuning of Oracle 19c databases in OCI supporting ETL processes and Oracle Analytics Cloud dashboards.

  • DBA & Performance Tuning (Banking, Telepass, and other clients):

    • Oracle database optimization in OCI and Autonomous Database environments — reduced batch processing times from 4 hours to under 30 minutes on critical analytical workloads.
    • Designed and developed ETL/ELT flows integrating data from 15+ heterogeneous sources across datasets exceeding 2 billion rows.
    • RMAN management, Oracle OEM monitoring, installation and patching of Oracle databases.
    • Designed and implemented DWH solutions on PostgreSQL as cost-effective alternatives to Oracle architectures.

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

Senior Oracle DBA & Performance Tuning Expert (for TIM / HUAWEI) | 2020 – 2022

  • Administration and management of over 30 critical Oracle databases (70+ instances) on Oracle Exadata clusters (3/5 nodes) for a leading Telco client.
  • Direct responsibility for advanced performance tuning: AWR/ADDM analysis, SQL optimization, index management, partitioning, and compression.
  • Involvement in storage management (ASM) activities and Oracle TDE implementation for data security.
  • 24/7 “ON-CALL” support for resolving critical issues and maintaining high availability.

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

Senior Oracle DBA & Performance Tuning Expert / DWH Architect | 2013 – 2020

  • Provision of consulting services as Oracle DBA and Performance Tuning specialist for various clients.
  • Optimization of complex SQL queries and tuning of Oracle instances to improve the performance of critical applications.
  • Support in installation, configuration, patching, and upgrading Oracle databases.
  • Consultancy on backup and recovery strategies with RMAN.
  • Design and implementation of Oracle Data Guard configurations for high availability and disaster recovery, including switchover/failover procedures.
  • Management of small technical teams in migration and upgrade projects.

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

Project Oracle DBA / Performance & Tuning Expert (for Public Administration) | 2009 – 2013

  • Administration and optimization of Oracle databases supporting Public Administration applications.
  • Tuning of SQL queries and ETL processes for Data Warehousing systems.
  • Involvement in installation, patching, and database security management activities.

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

Oracle DBA / DWH Architect / SQL & PL/SQL Developer / Training Specialist | 1999 – 2009

  • DBA and Performance Roles (progressively increasing): Administration of Oracle databases for enterprise clients (TIM, Vodafone, Banca d’Italia, Generali).
  • Involvement in SQL Performance & Tuning, troubleshooting, and optimization activities.
  • Support for installation and configuration of Oracle instances, patch management.
  • As Training Specialist (2000-2001): Delivered courses on Oracle Database Administration and Performance & Tuning.

S.EL.DAT. S.P.A. — Rome, Italy #

Software Developer (for Telecom, Rover Italia) | 1997 – 1999

  • Client-server application development, Junior Oracle DBA, DB monitoring.

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 Courses:

  • Advanced SQL for Query Tuning and Performance Optimization — LinkedIn Learning (August 2020)
  • Data Wrangling, Analysis and AB Testing with SQL — Coursera, University of California Davis (April 2021)
  • Multiple Oracle 12c specialization courses (Administration, Security, Backup and Recovery, Advanced SQL, New Features) — LinkedIn Learning (2020)

Languages #

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

Soft Skills #

  • Analytical and Methodical Problem Solving
  • Priority Management and Adherence to Deadlines
  • Ability to Work Under Pressure
  • Clear and Effective Technical Communication
  • Attention to Detail and Precision
  • Continuous Learning and Technological Adaptability

I consent to the processing of my personal data pursuant to Art. 13 of EU Regulation 2016/679 (GDPR).

Rome, March 2026

Download PDF | LinkedIn Profile | Back to previous page