Dr. Marco Mazzocchi
Bis 2013, Oracle database administrator and developer, UniCredit Business Integrated Solutions S.C.p.A. Zweigniederlassung Deutschland
Roma, Italien
Werdegang
Berufserfahrung von Marco Mazzocchi
7 Monate, Juni 2013 - Dez. 2013
Oracle database administrator and developer
UniCredit Business Integrated Solutions S.C.p.A. Zweigniederlassung Deutschland
Development of PL/SQL code units for the ETL processing of the credit risk management system Usage of hierarchical queries, regular expressions, collection pseudo-functions and analytic functions
Installation and “patching” of - Oracle Database 11g R2 on Enterprise Linux Server release 5.2 - Oracle Real Application Clusters 11g R2 on Sun Solaris 10 Data porting among different schemas and database releases through - manipulation of text file contents via sed and awk - shell and sqlplus scripts - exp, imp and Data Pump utilities Data replication through Oracle Streams SQL tuning
9 Monate, März 2011 - Nov. 2011
Consultant - Oracle database expert
Lottomatica
With reference to the migration of the billing process from Virtual Operating System to Oracle: - Development of PL/SQL code units - Enforcement of complex integrity checks on the tables population through dedicated triggers - Usage of XML in archiving data for minimizing the impacts related to changes on the tables structure - Reading and manipulation of text file contents via awk - Remote debugging of PL/SQL code units via Oracle SQL Developer
4 Monate, Nov. 2010 - Feb. 2011
Consultant - Oracle database expert
Terna
With reference to a control and reporting system aimed to verify accuracy and integrity of the data required for the billing process: - Development and test of PL/SQL packages e stored procedures - SQL tuning
9 Monate, Feb. 2010 - Okt. 2010
Consultant - Oracle database expert
Postel
With regard to a portal for browsing election results, loading of data related to the 2008's Italian political elections starting from a work sheet provided by the Ministry of Interior and through the following operations: - External tables creation and population - Dimension tables update - Data insert on fact tables - Creation of materialized views and related indexes for performance tuning through data pre-aggregation and query rewriting - Ad hoc queries creation for verifying the results of data loading
1 Jahr und 4 Monate, Okt. 2008 - Jan. 2010
Consultant - Oracle database expert
HP
Shell and SQL*Plus scripting (SQL and PL/SQL) for --Providing reports about -Data migration among different systems -State changes history of entities related to an application dedicated to communication services providers for retaining and protecting customer traffic data --Migrating customers' data of a communication services provider to the new monitoring, retention and protection system --Exporting/importing encrypted dump files via openssl tool and named-pipes
2 Monate, Juni 2008 - Juli 2008
Consultant - Oracle database expert
Eni
Development of an ETL PL/SQL package for a data warehouse system - SQL*Plus scripting
Database objects maintenance via SQL*Plus, SQL Developer and Enterprise Manager -Collection and updating of optimizer and system statistics, histograms creation -Detection of disk space allocated and actually used -Quantification of the benefits tied to the "table compression" feature (reduction of disk space required and query response time) -Massive data extraction and loading (direct-path insert, export/import [transportable tablespace], SQL*Loader, external tables) -Elements of Oracle Advanced Security
5 Monate, Juli 2006 - Nov. 2006
Consultant - Oracle database expert
Oracle Italia
Scheduled optimizer statistics collection (DBMS_STATS) -Database performance statistics collection and analysis (Statspack) -Monitoring of databases using tools as Enterprise Manager and SQL Developer -Creation and usage of SQL, PL/SQL and SQL*Plus scripts aimed to maintain and enhance application schemas (rebuilding of “skewed” indexes and “fragmented” segments, elimination of non-selective indexes, “moving” of tables affected by row chaining/migration, storage structures optimization) -SQL tuning
6 Monate, Okt. 2005 - März 2006
Consultant - Oracle database expert
Sirti
Creation and maintenance of: - Microsoft Windows batch files - Unix shell scripts - SQL and PL/SQL scripts and code units for administering an Oracle Advanced Queuing context, providing both message queuing functionality and asynchronous communication in an integrated application environment
2 Jahre, Okt. 2003 - Sep. 2005
Consultant - Oracle database expert
Anritsu (former Nettest)
Shell and sqlplus (SQL and PL/SQL languages) scripting -Performance tuning using materialized views -Data access control using Virtual Private Database security -Software versions management through CVS -Software packaging through Ant -Software installation, support and demos at customer site (South Africa, November 2004) -From December 2004 to September 2005: Project Leadership related to a data warehouse application aimed to monitor a GSM network (Oracle Discoverer reports as performance indicators)
9 Monate, Nov. 2002 - Juli 2003
Consultant - Oracle database expert
Telecom Italia (former Tim)
Publication, in production environment, of prepaid phone card data, for market monitoring and statistics collection purposes (MDDBMS Oracle Express Server 6.3.2, OLAP application "Oracle Sales Analyzer 11i")
6 Monate, Sep. 2001 - Feb. 2002
Consultant - Oracle Database Administrator
Blu (former fourth Italian mobile telephone operator)
Database administration
1 Jahr und 8 Monate, Jan. 2000 - Aug. 2001
Consultant - Oracle Database Administrator
INPDAP
Database administration
11 Monate, Feb. 1999 - Dez. 1999
Consultant - Oracle Database Administrator Junior
General Staff of the Italian Navy
Database administration
Sprachen
Italienisch
-