It looks like you are in United States. Would you like to go to https://onsiter.com/us/ instead?
Könnte verfügbar sein
(Aktualisiert 2020-10-12)DBA e Sviluppatore Oracle
Genova
Einheimische Italian, Spanish, Mittelstufe English
- Camstar Designer, Portal Studio, WMWare, Java Script/JSON/XML
- Oracle Database, PL/SQL, SQL Server
- Scrum methodology, Microsoft Visual Studio C#
Fähigkeiten (37)
XML
SQL
MATERIAL HANDLING
SVILUPPARE
PL/SQL
Oracle
DATABASE
SQL SERVER 2008
MICROSOFT SQL SERVER 2012
DB2
PERFORMANCE TUNING
Test
DATABASE ADMINISTRATOR
DATABASE MANAGEMENT
Oracle 12c
ANSI C++
Visual Basic
PDB
AMMINISTRATORE DI DATABASE
SQL SERVER 2012
C#/.NET
SQL Server
INTEGRAZIONE
ORACLE 10G
Microsoft SQL Server
OPTIMIZATION
DATA EXTRACTION
SICUREZZA
ACQUISIZIONE DATI
INTERFACCIA UTENTE
PIANIFICAZIONE
PROCESSO DI SVILUPPO
MICROSOFT SQL SERVER 2008
RELATIONAL DATABASE
INTEGRATION
MS SQL Server
FRONT END
Berufserfahrung
ORACLE PL/SQL Developer CONSULTANT
Sinelc Spa Tortona
2020-03 - Jetzt
In smart-working mode, I deal with software development in a PL/SQL environment on behalf of Akronos Technologies S.r.l of Turin.
• I deal with PL/SQL development activities on Oracle 19c databases in an Application containers environment, on an application
for the development of the Road Tolling System interface in Portugal to install EFC (Electronic Fee Collection) solutions for
managing the toll of a Portuguese motorway network.
- Oracle Database 19c version 1
• I deal with PL/SQL development activities on Oracle 19c databases in an Application containers environment, on an application
for the development of the Road Tolling System interface in Portugal to install EFC (Electronic Fee Collection) solutions for
managing the toll of a Portuguese motorway network.
- Oracle Database 19c version 1
ORACLE PL/SQL Developer CONSULTANT
Di. Tech Spa. Bologna
2019-10 - 2020-03
• Software development in PL / SQL environment on behalf of Esis S.r.l. of Bologna.
I have involved with the development and testing in PL / SQL environment of the export and data storage modules, as well as the price variation acceptance form, of the More application suite, designed to manage the distribution company in the management
phase of contracts with suppliers to the crate barrier. In this context, I am carrying out of several Oracle database migration activity
on Multi-tenant 12c architecture, from Oracle database Server version 11g (11.2.0.3.0) to version 12c (12.1.0), in a test/development environment.
-Agile Methodologies -Jira -SQL and PL/SQL Oracle DB Server 11g / 12c.
I have involved with the development and testing in PL / SQL environment of the export and data storage modules, as well as the price variation acceptance form, of the More application suite, designed to manage the distribution company in the management
phase of contracts with suppliers to the crate barrier. In this context, I am carrying out of several Oracle database migration activity
on Multi-tenant 12c architecture, from Oracle database Server version 11g (11.2.0.3.0) to version 12c (12.1.0), in a test/development environment.
-Agile Methodologies -Jira -SQL and PL/SQL Oracle DB Server 11g / 12c.
DATABASE Developer CONSULTANT
LBA Consulting S.r.l
2019-02 - 2019-10
Main Projects managed:
• Software development in Microsoft SQL Server environment - Transact SQL. In a team of 4 people where I dealt with the corrective and evolutionary maintenance of medium-large databases for a cruise booking system.
• I also dealt with installation activities, cloning the database server in the production environment.
-T-SQL SQL Server 2016
• Software development in Microsoft SQL Server environment - Transact SQL. In a team of 4 people where I dealt with the corrective and evolutionary maintenance of medium-large databases for a cruise booking system.
• I also dealt with installation activities, cloning the database server in the production environment.
-T-SQL SQL Server 2016
SOFTWARE Developer and DBA
headquarters US Siemens PLM Software (ex UGS)-, Genoa
2006-08 - 2019-02
Main Projects managed:
2017 - 2019: As a software developer accountable for developing in a Siemens US Charlotte-located Research & Development
department, inside an Agile product development team for the Camstar Industry Solution extension, I was involved with mainly:
• software development in proprietary environment Camstar Designer and Portal Studio, Oracle database 12c and Microsoft SQL
Server for MES.
• development of new requirements for the MES system and for automatic tests based on Spec-Flow for .Net
• development of new features of the OEE system requirements for the extension of Camstar Platform Enterprise V7 mainly
developing on Oracle database server 12c in PL/SQL environment.
-Scrum methodology -Oracle Database 12c Release 2 -WM Ware -TFS
2017 - 2019: As a software developer accountable for developing in a Siemens US Charlotte-located Research & Development
department, inside an Agile product development team for the Camstar Industry Solution extension, I was involved with mainly:
• software development in proprietary environment Camstar Designer and Portal Studio, Oracle database 12c and Microsoft SQL
Server for MES.
• development of new requirements for the MES system and for automatic tests based on Spec-Flow for .Net
• development of new features of the OEE system requirements for the extension of Camstar Platform Enterprise V7 mainly
developing on Oracle database server 12c in PL/SQL environment.
-Scrum methodology -Oracle Database 12c Release 2 -WM Ware -TFS
member of the Quality Tools R&D
2015-01 - 2017-01
team I dealt with the implementation of tools to automate activities to support
the development process and business activities:
• development in Microsoft Visual Studio IDE environment (API library, .Net class library, Web Services library, etc.), Reporting
Services, as well as Oracle Database Server 12c.
• design and development of a report server based on SQL Reporting Services and MS SQL Server Database for the consultation of the Code Analysis results of the builds on the source codes.
• Technical support, to the Test Quality Assurance team: Oracle Grid Infrastructure, Oracle ASM, Oracle Real Application Clusters
(RAC) One Node 12c, Transparent Data Encryption Tablespace, etc.
the development process and business activities:
• development in Microsoft Visual Studio IDE environment (API library, .Net class library, Web Services library, etc.), Reporting
Services, as well as Oracle Database Server 12c.
• design and development of a report server based on SQL Reporting Services and MS SQL Server Database for the consultation of the Code Analysis results of the builds on the source codes.
• Technical support, to the Test Quality Assurance team: Oracle Grid Infrastructure, Oracle ASM, Oracle Real Application Clusters
(RAC) One Node 12c, Transparent Data Encryption Tablespace, etc.
developer I participated
2011-01 - 2015-01
in the maintenance and development of the SIMATIC IT OEE component.
• Implementation on MSSQL Server Database, development of T-SQL procedures and functions, as well as SQL scripts for automatic
tests.
• development of the functionalities of executable components of the server-side project in the Visual Studio C ++ environment.
Finally, I dealt with a client GUI part of the OEE configuration system by developing functionality and user interface in Microsoft's C
++ / MFC environment.
• Implementation on MSSQL Server Database, development of T-SQL procedures and functions, as well as SQL scripts for automatic
tests.
• development of the functionalities of executable components of the server-side project in the Visual Studio C ++ environment.
Finally, I dealt with a client GUI part of the OEE configuration system by developing functionality and user interface in Microsoft's C
++ / MFC environment.
member
2006-01 - 2010-01
of the development team on Oracle Database 9i R2, 10g R1, 11g R1 I was in charge of the software
development of the PL / SQL packages residing on the database server of the specification management system, of the SIMATIC IT
Interspec product, " Product Specification Management System ", preceded by a short 3-month on-site experience at the Siemens
headquarters in Belgium for product knowledge transfer.
• definition of the technical specifications of the requirements and development of the business logic software of the database.
• development of the software packages of the system connecting the local and central databases with multi-tier architecture for
the management of geographically distributed multi-plant scenarios.
• LDAP integration with OID and Oracle Identity Management for the security of GLOBAL USER entities with the Siemens PLM Team
Canter solution.
development of the PL / SQL packages residing on the database server of the specification management system, of the SIMATIC IT
Interspec product, " Product Specification Management System ", preceded by a short 3-month on-site experience at the Siemens
headquarters in Belgium for product knowledge transfer.
• definition of the technical specifications of the requirements and development of the business logic software of the database.
• development of the software packages of the system connecting the local and central databases with multi-tier architecture for
the management of geographically distributed multi-plant scenarios.
• LDAP integration with OID and Oracle Identity Management for the security of GLOBAL USER entities with the Siemens PLM Team
Canter solution.
database developer and expert
2010-01 - 2010-01
I participated with the Enterprise Test team in the development of a benchmark tool to perform automatic measurements of the SIMATIC IT Intelligence Suite MDM level database performance.
• T-SQL development on procedures, functions, triggers, and Jobs in Microsoft SQL Server environment.
• T-SQL development on procedures, functions, triggers, and Jobs in Microsoft SQL Server environment.
consultant
Software design
2006-01 - 2006-01
I have developed PL/SQL - XML DB ORACLE 10g packages on Red Hat Enterprise Linux for the realization of a project for the management and integration of data in a distributed environment.
• Software design for the application APIs used for the calls of the Mass Printing system services. In this project I also dealt with the tuning of the SQL and PL/SQL statements and with the partitioning of some tables and indexes of the database schema on which
this system operated.
• Software design for the application APIs used for the calls of the Mass Printing system services. In this project I also dealt with the tuning of the SQL and PL/SQL statements and with the partitioning of some tables and indexes of the database schema on which
this system operated.
ORACLE PL/SQL XML Developer
POSTEL
2006-01 - 2006-01
Main Managed project:
As consultant
2005-01 - 2006-01
I developed the software in PL / SQL environment of ORACLE and Korn Shell of Unix HP-UX of a System
Position project (Positioning system based on the conversion of geographic coordinates. • Activities concerning the definition and
the development of a PL / SQL package containing functionality for the conversion of the coordinates of the reference systems from ROMA40 to IGM, based on approximate calculations.
Position project (Positioning system based on the conversion of geographic coordinates. • Activities concerning the definition and
the development of a PL / SQL package containing functionality for the conversion of the coordinates of the reference systems from ROMA40 to IGM, based on approximate calculations.
SOFTWARE Developer and DBA Oracle
Line System Spa
2000-01 - 2005-01
Main Projects managed:
2004-01 - 2005-01
Analysis and support for the management of the specifications of the requirements for the Acquisition and Management System of the Case Files of the Criminal Sector Court of Rome (in UML). 2003-2004: Development on the database
and desktop client side of a computerized protocol system in a distributed environment, and of the advanced features of Digital
Signature, Time Stamp and Application Interoperability, compliant with A.I.P.A (now CNIPA) standards.
and desktop client side of a computerized protocol system in a distributed environment, and of the advanced features of Digital
Signature, Time Stamp and Application Interoperability, compliant with A.I.P.A (now CNIPA) standards.
ORACLE PL/SQL Developer
TIM
2005-01 - 2005-01
Main Projects managed:
SOFTWARE C-Shell Developer / DBA Oracle
ENEL Spa
2004-01 - 2004-01
Main Projects managed:
As consultant as Oracle 9i / 10g database administrator I was in charge of providing technical support in the activity of restoring
application data backups, based on ORACLE 9iR2 systems in the AIX Unix environment.
• software development of the file system creation procedure on Unix physical machines in a C-shell environment to support the automatic database installation procedures based on the information of the inventory file in the clone machines in Disaster
Recovery situations.
As consultant as Oracle 9i / 10g database administrator I was in charge of providing technical support in the activity of restoring
application data backups, based on ORACLE 9iR2 systems in the AIX Unix environment.
• software development of the file system creation procedure on Unix physical machines in a C-shell environment to support the automatic database installation procedures based on the information of the inventory file in the clone machines in Disaster
Recovery situations.
database administrator
2003-01 - 2003-01
in ORACLE database 8.05 / 9i. and technical support to the systems group in the management of the applications for the management of the Civil, Criminal process and the Review of the court of Naples.
SOFTWARE Developer
OPEN DATA S.r.l. Bologna
1999-01 - 2000-01
Main Project managed:
Brief experience in the development of some software modules, commissioning, and start-up of the systems of a data acquisition
system developed in the Borland Delphi 4 and Oracle 8i environment on OS Windows and based on industrial terminals.
Brief experience in the development of some software modules, commissioning, and start-up of the systems of a data acquisition
system developed in the Borland Delphi 4 and Oracle 8i environment on OS Windows and based on industrial terminals.
SOFTWARE Developer
SELCOM Elettronica Spa
1994-01 - 1999-01
Main Project managed:
-As a developer, based on very detailed technical specifications, I dealt with the development of the local automation software of
the prototype plant of the Autonomous body for the Apulian Aqueduct, EAAP project of the Alberobello department of six out of
about forty remote water stations, in RMX / 86 (TM) iAPX, PLM86 Intel and ANSI C environments. - Support for the development of the ISO900 quality management system for the production of electronic boards, repair management. Delphi Borland 2 environment,
Oracle 8 on OS Windows. - I carried out system engineering activities on the Windows Server NT 4.0 / Novel network and
management of the Oracle 8.0 production database. As DB administrator I took care of the installation and configuration, Backup / Recovery, data migration and upgrade of the Oracle Server DB.
-As a developer, based on very detailed technical specifications, I dealt with the development of the local automation software of
the prototype plant of the Autonomous body for the Apulian Aqueduct, EAAP project of the Alberobello department of six out of
about forty remote water stations, in RMX / 86 (TM) iAPX, PLM86 Intel and ANSI C environments. - Support for the development of the ISO900 quality management system for the production of electronic boards, repair management. Delphi Borland 2 environment,
Oracle 8 on OS Windows. - I carried out system engineering activities on the Windows Server NT 4.0 / Novel network and
management of the Oracle 8.0 production database. As DB administrator I took care of the installation and configuration, Backup / Recovery, data migration and upgrade of the Oracle Server DB.
Software Automation Developer
HS Elettronica Progetti
1990-01 - 1994-01
for material handling and warehouse automation system.
Software / firmware development, system configuration and commissioning of automatic handling systems of automation level 2, in particular the supervision part of the systems. Movement of stacker cranes with DC motors and transhipment bridges with on-
board firmware, PID control and parameterization, In RS432 / 232 communication network based on the master / slave
communication protocol on the conveyed wave electrical network. Interface to the field, handling management software and basic
firmware on the input and output stations of the materials of the automatic warehouse. Made in Intel iAPX environment, Borland 3 on OS RMX / 86 (TM). Involved in the development of the self-propelled line control software for Fiat engine production systems.
Made in Intel PLM86 environment.
Software / firmware development, system configuration and commissioning of automatic handling systems of automation level 2, in particular the supervision part of the systems. Movement of stacker cranes with DC motors and transhipment bridges with on-
board firmware, PID control and parameterization, In RS432 / 232 communication network based on the master / slave
communication protocol on the conveyed wave electrical network. Interface to the field, handling management software and basic
firmware on the input and output stations of the materials of the automatic warehouse. Made in Intel iAPX environment, Borland 3 on OS RMX / 86 (TM). Involved in the development of the self-propelled line control software for Fiat engine production systems.
Made in Intel PLM86 environment.
Electro-pneumatic maintenance technician
VETROSILEX Spa
1989-01 - 1990-01
Short experience as electro-pneumatic maintenance technician of the production lines for glass bottles. Mechanical and electrical
maintenance of machines
maintenance of machines
Akademischer Hintergrund
High School Diploma
Liceo Scientifico International school di Maracay
2020-10 - 1979-01
Zertifikate
Certified Associate