Dr. Marco Mazzocchi

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

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

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

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

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

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

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

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

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)

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")

Database administration

Database administration

Database administration