Data Engineer Barcelona, Spain

Might be available

(Updated 2023-10-16)

Data Engineer

Barcelona, Spain

Native Italian, Fluent Spanish, Intermediate English

  • 10+ years of experience in Databases
  • 10+ years of experience in IT (general)
  • 2+ years of experience in C#
Contact

Skills (39)

JSON

Data Migration

Oracle

LOGGING

DDL

DATABASE

DEBUG

SQL

MAINTENANCE

CUSTOMER RELATIONSHIP MANAGEMENT

PostgreSQL

OBJECT-ORIENTED

Bash

DRAFTING

OBJECT-ORIENTED PROGRAMMING

C#

Postgres

XML

MySQL

SHELL SCRIPTING

Linux

JavaScript

Git

Data Center

Apache

Marketing

MongoDB

SVN

Subversion

Java

HDFS

CRM

WINDOWS SERVER 2012

WINDOWS SERVER 2008

Python

JQuery

PHP

VBA

MariaDB

Summary

Technologies are my interest since when i was 7 years old.
I've started study develpment with Basic for after move to C and C++ (studied at school
also). A
t the university/college i've passed with high scors all informatics, mathematics and
physics exams (but i haven't finish college so i am not graduate).
Now, i'm working as developer (backend & db) since 2012. My speciality is work with data
on ralational DB but i'm skilled also on non relational db.

DBs:
• DDL and DML (insert, update, delete, merge, upsert)
• query optimization (index, clustered index, function index, execution plan analysis,
dynamic sql, ecc).
• virtual and temorary table
• transaction (and autonomous transactions)
• session analysis
• PL-SQL / PL-PGSQL / T-SQL
• Data warehousing (Oracle exadata, Amazon Redshift, Azure SQL, Postgres)
• CI/CD (in particular SqlServerDataTools for Microsoft DBs)

• Apache suite (hadoop, hive, hdfs)
• MongoDB

Backend:
• .net C#: good knowledge (some personal project shared on github)
• Java (basic, no frameworks)
• Python: study in progress

Versioning:
• Git (gitlab, github, devops)
• SVN
• CVS
Work Tracking:
• Azure DevOps
• Jira
• Redmine

Professional Experience

Data Engineer
Vitria s.l

2023-02 - Present

Country: Spain Vitria sold its product that sells worldwide, to manage data center problems My role is to implement (linux, scala, c#) the features required by customers.
Data Engineer / Technical Analyst
HP inc

2022-05 - 2023-02

Country: Spain • Technical analyst for collect data over the world (EMEA, LATAM, APJ) and merge its into one structure for expose it on CRM.
• PostgreSql Developer (in AWS) using also Amazon CloudWatch (for logging) and Jira (for tracking)
Data Engineer / Technical Analyst
Banca Sella / Hype Bank

2019-09 - 2022-05

City: Biella / Milano Country: Italy Management of Oracle procedures relating to the calculation of interest and rules against usury. Calculation and management of interest on deposit and savings products Analysis of customer data for marketing campaigns. Oracle development for maintance and evolutions (DBA and Software) Data migration from Oracle SQL to Azure SQL and Azure Data Lake using Azure DevOps, Azure DataFactory. Azure SQL CI/CD using SqlServerDataTools integrated on DevOps Pipelines
Technical Analyst
NTT DATA

2019-03 - 2019-09

City: Milano Country: Italy The final customer (energy sector) has developed a cad for internal use (using Bentley / Oracle 12c Spatial) and a management tool (Win32 application) connected to the same database. In my role, I mainly deal with Analysis / Development of the Oracle component.
I also deal with the pre-insertion evaluation of new Oracle resources. Used technologies: Oracle 12c Spatial C # (.NET 2) Talend (ETL) Versioning systems: SVN / GIT Bug tracker:
Technical Analyst / TeamLeader
Lynx s.p.a

2014-01 - 2019-01

Country: Italy First half: • Client requirements analysis, drafting of technical documents, implementation, support for tests and releases in production.
• Oracle 11g (mostly), Beadata WebLogicServer 10.3.6, Java 6 (Struts 1.1), JSP, HTML, Javascript, JQuery, Prototype, HTML, CVS (versioning), ClearQuest (bugTracking).
IDE used: PlSql Developer / Toad / Eclipse • The use of the database, which included most of the software, provided for: Procedural and object-oriented programming Package development Stored procedures / functions Debug DML / DDL modification (creation and use of Indexes and Related Keys, partitions, sub-partitions) Session analysis Query Optimization Creation of CSV / XML files for exporting data in an ASYNCHRONOUS.
Second half: • Migration from Oracle OnPremise to AWS • Creation of new datawarehouse: Amazon Redshift, Amazon S3, Amazon CLI, Postgres, Wildfly / JBoss, Cloudera (BigData), Hadoop.
The control version has also moved to GIT and Atlassian (Jira, Confluence, Bamboo, FishEye).
Also, having to adapt and transfer between the two systems, I have seen and used Talend for BigData.
Also covering roles as TeamLeader, I also dealt with the technical and functional training of the Junior resources and the sharing of functional KnowHow to the new senior resources
FreeLance
REDMINE

2012-06 - 2014-06

City: Padova Country: Italy Collaboration with local companies for the creation and maintenance of the IT department. Consulting, design and installation of the infrastructure and initial basic configuration of the Server-Clients. Server: Linux Debian / Windows Server 2008 / Windows Server 2012 Client: Windows / Unix (Linux Fedora/RedHat and Debian) Predisposition for FTP, SFTP, SSH, SMB (Unix) servers and basic management of ActiveDirectory and related policies (Windows).
After the possible commissioning of the hardware part, if there was a request for ad-hoc software, I proceeded with the analysis of the requirements and the development. Used technologies: Shell scripting (bash), PHP 4.x, PHP 5.x, Javascript, Jquery, CSS, HTML, OpenOffice BASIC, Excel VBA Database: MySql Home sector: basic computer lessons for individuals (Windows, Office) repetitions (programming) to high school computer science students computer maintenance

Academic Background

Technical in Electronic & Telecomunications
ITIS A. Meucci

2000-01 - 2005-01

Contact contractor

/