Profileimage by David Tomaselli Oracle Developer and DBA from

David Tomaselli

available

Last update: 19.09.2017

Oracle Developer and DBA

Graduation: not provided
Hourly-/Daily rates: show
Languages: German (Limited professional) | English (Full Professional) | Spanish (Native or Bilingual)

Attachments

201707_cv_david_tomaselli.docx

Skills

Programming Languages:
  • SQL and PL/SQL           
  • T-SQL                  
  • Unix Shell  
  • Visual Basic
  • HTML          
  • JavaScript   
  • PHP             
  • Java            
Databases:
  • Oracle (9i, 10g, 11g)              
  • Microsoft SQL Server               
  • MySQL                                  
  • MS Access                             
  • DB2                          
Back End Tools:
  • Oracle Warehouse Builder 10g, 11g (ETL)   
  • Informatica Powercenter 7.4, 8.6 (ETL)
  • SQL Developer, PL SQL Developer, TOAD 
  • SQL Plus      
  • SQL*Loader
  • XML/BI Publisher  
  • Autoconfig and AD Utilities (adpatch, adctrl, adadmin, adrelink)    
  • Oracle Jdeveloper
  • Oracle Data Integrator (ODI) 10g, 11g (ETL)    
  • Oracle Golden Gate       
Front End Tools:
  • Oracle Developer (Forms and Reports) 
  • OBIEE 10g, 11g    
  • Essbase              

Project history

  • 10/10/2016 – Ongoing
Database Administrator (DBA)
RM IT Professional Resources AG. Förrlibuckstrasse 10, 8031 Zürich (Switzerland).
Customer: Credit-Suisse.
  • Database Administration for various internal and external business critical applications.
  • Backup and restore (DR) policy implementation.
  • Enterprise Manager Grid control setup to monitor large number of database infrastructure.
  • Automated scripts writing for database backup, recovery and monitoring using PL/SQL, Unix/Linux Shell.
  • Migration and upgrade of Oracle databases. Patch validation and implementation.
  • DBaaS provisioning
  • Work occasional off hours as well as part of a 24x7 on-call rotation
  • 14/09/2015 – 29/07/2016
Technical Team Lead
Stamford Consultants. Limmatquai 2, 8001 Zürich (Switzerland)
Customer: Credit-Suisse.
On charge to analysis the problems, gather the requirements and involved in the development (particularly those related with the databases).
  • Creation of Interface between several applications
  • Requirement engineer role
  • 3rd Level Production Support
  • Optimization and increase the performance of the DB process
  • Virtualization of several standalone GUI to Citrix
  • Batch scheduling jobs design and implementation in Control-M
  • Database migrations and machine migration from Unix to Linux
  • Technology used: Oracle RAC, Oracle 11g, Applications servers Linux, Unix and Windows.
  • 01/10/2014 – 11/09/2015
Oracle ETL Senior Developer and BA
Partners K2 AG. Neuhofstrasse SA 6340 Baar (Switzerland)
Customer: PostFinance. DWH Department.
  • Developer and Business Analyst role
  • Creation of Documentation LLD (Low Level Design)
  • Close collaboration with the developer team in Bern
  • Design and modeling of Datamarts
  • 3rd Level Production Support
  • Enterprise Manager Grid control setup to monitor large number of database infrastructure.
  • Creation, updating and maintenance of ETL Mappings using Oracle Warehouse Builder (OWH) and Oracle Data Integrator (ODI)
  • 10/06/2013 – 31/08/2014
Application Developer (DWH department)
Cognizant Technology Solutions. Hohlstrasse 560, 8048 Zürich (Switzerland)
Customer: Credit Suisse. FA (Financial accounting) department.
  • Developing and supporting Oracle databases (SQL and PL/SQL).
  • Working with Unix and SQL (Sybase, Oracle)
  • Design and modeling of business processes.
  • Desing and analysys reports in BI tool (Oracle OBIEE).
  • Responsible for Batch job monitoring and troubleshooting (Control-M).
  • Design of ETL processes in Informatica PowerCenter.
  • Design and modeling of datamarts.
  • DBA support.
  • 3rd level Production support.
  • 09/07/2012 – 30/04/2013 (10 months)
Oracle Senior Developer DWH
Stamford Consultants. Limmatquai 2, 8001 Zürich
Customer: Credit-Suisse. Hagenholzstrasse 20-22, Zürich (Switzerland)
Oracle senior developer on charge of a migration of a Swiss Datawarehouse:
  • Migration of the SWISS database and staging part of an application from a legacy environment to the Credit Suisse Datawarehouse (DWH) platform including:
  • Migration of Informatica 7.14 Workflows to a standardized DWH platform operating on Informatica 8.6
  • Migration of batch scheduling jobs running on a internally developed scheduling program to Control-M
  • Migration of Database objects on Oracle 10G to a standardized DWH platform operating on Oracle 11G
  • Migration of Feed transfers (Connect Direct / ftp) to the new platform (FTPS)
  • Deployment of the application parts using common change management (SWAN XP) and version control tools (Subversion)
  • Close collaboration with the application and platform responsible based in Switzerland and Singapore
  • 12/01/2009 - 06/07/2012 (3 years and 7 months)
Oracle and MS SQL-Server DWH developer:
Oracle MICC (Oracle Málaga International Consulting Center). c/Severo Ochoa, 30. Parque Tecnológico de Andalucía - 29590 Campanillas (Spain)
  • Developing of Oracle, MS Sql-Server databases.
  • Master Data Management (MDM)
  • Creation/Modeling of Data Marts/Data Warehouse
  • Reporting in OBIEE 10g or 11g, Apex
  • Transferring of a large amount of data between heterogeneous databases.
  • Design of a graphic data model of all databases joined with the business processes modeled on Sybase Power Designer.
  • Creation of interfaces ETL (Extract, transform, and load) processes with Oracle Warehouse Builder (OWH) and Oracle Data Integrator (ODI)
  • User support
  • Solving issues at the helpdesk
  • 29/06/2006 – 11/01/2009 (2 years and 8 months)
Oracle Database Administration (DBA):
Oracle Ibérica S.R.L. c/. José Echegaray, 6, Edificio B, Madrid - Las Rozas (Spain)
  • Expert developer in Oracle Forms and Reports and customization (Analysis, Design and Development).
  • Experience in Database Development activities like Installation, applying patches and hot fixes, designing, Database Security, Data Transformation Services, and Query Optimization.
  • Provide Oracle Application Server and Oracle APEX implementation and support.
  • Expert in PL/SQL database programming.
  • Database migration from Oracle to SQL server or MySQL, and vice versa.
  • Experience in Data Modeling, Database Design, Database Programming and ETL Development.
  • Provide 3rd level support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN/DataProtector, trace analysis, service creation, cluster, and system management.

Local Availability

Only available in these countries: Switzerland
I'm available for traveling
Profileimage by David Tomaselli Oracle Developer and DBA from Oracle Developer and DBA
Register