Keywords
Java (Programming Language)
Unix
Linux
Unix Shell
Microsoft SQL Servers
MySQL
Oracle Applications
Solaris (Operating System)
SQL Databases
C (Programming Language)
Skills
SQL, PL/SQL, Awk, Unix Shell Scripting, Java, C, Oracle RAC, SQL Tuning, Linux, Database Design, MySQL, Oracle, Performance Tuning, RMAN, SQL*Plus, OBIEE, Solaris, Unix, Microsoft SQL Server, Databases, Shell Scripting, Disaster Recovery, Oracle Enterprise Linux, Exadata, Data Guard, Red Hat Linux, Oracle Enterprise Manager, Database Administration
Project history
Istituto Poligrafico e Zecca dello Stato
Senior Oracle Consultant
11.2013 - today
Development, testing and producion management of Oracle DataBase v. 9i/10g/10g/11g both on standalone and rac even on raw device. Dataguard system (logical and phisical standby db) configuration and management. DataBase Backup and Restore manager. DataBase Performance & tuning manager.
Ada Project Srl
Senior Oracle DBA
09.2009 - 11.2013
Implement Audit for DB users.
Cloning Production Instance.
SGA Tuning. SQL tuning
Write a shell script for massive parallel Export-Import with high performance
Designing tables using partition by list and sub partition by range with blob storage
Write shell scripts in order to automate backoffice processes
Restart RMAN after error ORA-27069
Detecting error ORA-07445 on 10gRac
Installing patch 5036588 on 10gRac
Implementing automatic index analysis and on-line rebuild system
Implementing automatic on-line table shirink system
Install Oracle 10g DataBase Rac archivelog on Sun-Solaris
Install Oracle 11g DataBase SI archivelog on Oracle Linux
Creating a SSL comunication channel between two Oracle v. 10g/11g Database using OWM
Plan and realize statistical basket for Immigration Central Office
Plan and realize data replication system based on Materialized Views
Rewrite RMAN Backup script full + archivelog changing backup policies
Creating 4 Oracle phisical stand by database
Creating 1 Oracle logical stand by database
Performing full restore + recover Oracle 10g rac on raw device on production database due media crash
Apply pacth 4518443 on 10g
Solve error Ora-01192 on standby db
Transform phisical standby db in a production db
Data Base throughput optimization: BCHR index increase from 28% to 92%
Oracle AWR reports generation and reading
Cid Software
Oracle Developer
11.2002 - 09.2009
Oracle PL/Sql Developer for Regione Campania (Public Administration). Naples. Italy.
Oracle Form Builder Developer for Regione Campania (Public Administration). Realize form for General Accounting of Regione Campania.
Oracle DBA for ASL Napoli 2 (Public Administration). Naples. Italy.
Realize new shell for warm backup. Rewrite indexes for data access of major applications. Reproject rbs tablespace.
I realize ordinary and extraordinary activities. Coordinate an Help Desk team.
Project leader for ASL Napoli 1 (Public Administration). Naples. Italy.
Analysis of requirement. E-R model analysis. Physical data model creation. Generation of instance on Oracle 9i data base. Analysis of procedure for massive data loading. Project and realize package for queue control using Oracle Advanced Queuing. Analysys for Ejb objects. Technical docuementation writing.
Oracle DBA for Finsiel Spa. Based at Finsiel SpA. Naples. Italy.
E-R model analysis. Generation of physical model. Generation of instance on Oracle 9i data base.
AP Web srl
Oracle Junior DBA
0.2001 - 0.2002
Administering Oracle 8i db
I.T. Staff Group LLC
Oracle Developer
0.1999 - 0.2000
SQL and PL/SQL Developer
c/shell/awk developer
sql tuning and performace manager
Senior Oracle Consultant
11.2013 - today
Development, testing and producion management of Oracle DataBase v. 9i/10g/10g/11g both on standalone and rac even on raw device. Dataguard system (logical and phisical standby db) configuration and management. DataBase Backup and Restore manager. DataBase Performance & tuning manager.
Ada Project Srl
Senior Oracle DBA
09.2009 - 11.2013
Implement Audit for DB users.
Cloning Production Instance.
SGA Tuning. SQL tuning
Write a shell script for massive parallel Export-Import with high performance
Designing tables using partition by list and sub partition by range with blob storage
Write shell scripts in order to automate backoffice processes
Restart RMAN after error ORA-27069
Detecting error ORA-07445 on 10gRac
Installing patch 5036588 on 10gRac
Implementing automatic index analysis and on-line rebuild system
Implementing automatic on-line table shirink system
Install Oracle 10g DataBase Rac archivelog on Sun-Solaris
Install Oracle 11g DataBase SI archivelog on Oracle Linux
Creating a SSL comunication channel between two Oracle v. 10g/11g Database using OWM
Plan and realize statistical basket for Immigration Central Office
Plan and realize data replication system based on Materialized Views
Rewrite RMAN Backup script full + archivelog changing backup policies
Creating 4 Oracle phisical stand by database
Creating 1 Oracle logical stand by database
Performing full restore + recover Oracle 10g rac on raw device on production database due media crash
Apply pacth 4518443 on 10g
Solve error Ora-01192 on standby db
Transform phisical standby db in a production db
Data Base throughput optimization: BCHR index increase from 28% to 92%
Oracle AWR reports generation and reading
Cid Software
Oracle Developer
11.2002 - 09.2009
Oracle PL/Sql Developer for Regione Campania (Public Administration). Naples. Italy.
Oracle Form Builder Developer for Regione Campania (Public Administration). Realize form for General Accounting of Regione Campania.
Oracle DBA for ASL Napoli 2 (Public Administration). Naples. Italy.
Realize new shell for warm backup. Rewrite indexes for data access of major applications. Reproject rbs tablespace.
I realize ordinary and extraordinary activities. Coordinate an Help Desk team.
Project leader for ASL Napoli 1 (Public Administration). Naples. Italy.
Analysis of requirement. E-R model analysis. Physical data model creation. Generation of instance on Oracle 9i data base. Analysis of procedure for massive data loading. Project and realize package for queue control using Oracle Advanced Queuing. Analysys for Ejb objects. Technical docuementation writing.
Oracle DBA for Finsiel Spa. Based at Finsiel SpA. Naples. Italy.
E-R model analysis. Generation of physical model. Generation of instance on Oracle 9i data base.
AP Web srl
Oracle Junior DBA
0.2001 - 0.2002
Administering Oracle 8i db
I.T. Staff Group LLC
Oracle Developer
0.1999 - 0.2000
SQL and PL/SQL Developer
c/shell/awk developer
sql tuning and performace manager
Local Availability
Only available in these countries:
Italy
I am avaible now
