|
Technical
Skills
Servers IBM:
SP2, POWER4, POWER5, POWER6, POWER7, p570, p595. SUN: V880, T5220, E10K,
E15K, M5000, M9000. HP: HP-9000 Superdome. Intel:
32bit, 64bit.
Operating
Systems: AiX, Solaris, HP-UX, Linux (Redhat, Oracle Enterprise Linux, CentOS, Ubuntu ).
Storage
Area Networks: IBM Shark, IBM DS8000 - DS8800, Hitachi, EMC2
Symmetric.
Programming:
Shell Script, SQL, PL/SQL, RMAN.
Data modeling tools: Erwin, ORACLE Designer.
Oracle
RDBMS:
Certifications: OCP 9i, OCP 10g.
Installation/Management: 7.3, 8, 8i, 9i/RAC, 10g/RAC, 11g/RAC.
Backup/Recovery: Rman, User Managed Backup/Recovery.
High Availability: OPS, RAC, CRS, Grid Infrastructure, Data Guard, Replication,
Automatic Storage Management (ASM).
Tuning: operating system, network, database parameters, SQL and PL/SQL.
Tools: Oracle Enterprise Manager (EM), DBVerify, LogMiner,
Tkprof, SQL*Loader, import/export, Data Pump, Automatic Workload
Repository (AWR), Automatic Database Diagnostic Monitor (ADDM).
Database
Architect:
- Planning: logical and physical data modeling, normalization, replication, integrity and security.
- Capacity Planning: performance analysis of database servers and storages in standalone and clustered environment. - Capacity Management: I have engineered and developed a tool which supports the planning department during the capacity management process of standalone and clustered configurations.
Professional
experiences as Oracle DBA/Data Architect - Trivadis:
(06/2011 - present) I'm currently working as Senior RAC DBA/Data Architect on different customer projects.
Credit-Suisse:
(09/2007 - 05/2011) I started working on
Data Warehouse team where I faced several challenging activities, after 15 months I had the opportunity to move in a new group
which was created for engineering "Database Grid Computing", implementing Oracle Grid Infrastructure, RAC and RAC One Node databases in different platforms based on 11gR1 and 11gR2.
H3G:
(07/2003 - 08/2007) I have worked at the same time in engineering
and operation, acquiring maturity and experience about transactional
databases (OLTP) active 24/7 with high availability architectures based on RAC and Data Guard.
Telecom
Italia IT: (02/2003 - 06/2003) I was member of the team the
"Great DBs". During this period, I faced several issues
related to performance, backup/recovery and management of
Data Warehouse databases in standalone and Oracle parallel server configuration.
Ugo
Bordoni foundation: (12/2002 - 01/2003) I participated to the
National Frequency project, having the responsibility to design and
implement the databases for managing the radio frequencies
held by Communication Ministry.
Private
general hospital Umberto I: (09/2002 - 11/2002) After a recovery
intervention, the client requested my presence on site for an
assessment of all Oracle databases.
Commerz
Bank: (07/2002 - 08/2002) I supported the developers during the
realization of the new call center "Bank On Line" based on
SIEBEL.
Camuzzi
(actually ENEL GAS): (05/2002 - 07/2002) I did review and tuning
of the databases used by the CRM application SIEBEL.
CONSIP:
(04/2002 - 07/2002) I participated to the
development and test phase of the Management Control project
realized using Oracle Application and one in house developed Data
Mart.
Help
Company:(03/2000 - 02/2002): I was in charge to develop and
manage the databases in use by the company.
Short-term activities:
recovery, tuning, new installations and migrations on UNIX and Linux
platform at the following companies: Poste Italiane, ENPAF, La
Sapienza Università di Roma, ASL Roma and Rome Town hall.
|