DBA e Sviluppatore Oracle Genova

Podría estar disponible

(Actualizado 2020-10-12.)

DBA e Sviluppatore Oracle

Genova

Nativo Italian, Spanish, Intermedio English

  • Camstar Designer, Portal Studio, WMWare, Java Script/JSON/XML
  • Scrum methodology, Microsoft Visual Studio C#
  • Oracle Database, PL/SQL, SQL Server

Habilidades (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

Experiencia profesional

ORACLE PL/SQL Developer CONSULTANT
Sinelc Spa Tortona

2020-03 - Presente

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
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.
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 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
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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

Formación académica

High School Diploma
Liceo Scientifico International school di Maracay

2020-10 - 1979-01

Certificaciones

Certified Associate

Contacta con el consultor

/