Alberto Serra

Angestellt, Senior SQL engineer, Dentsu Aegis Network Germany

Wiesbaden, Deutschland

Fähigkeiten und Kenntnisse

Big Data
Solution Architecture
Apache Hadoop
AWS Redshift
Actian Paraccel (MPP)
Python-Programmierung
Agile Software Development
RDBMS
NoSQL
Datarush/Dataflow
PostgreSQL
Replication
Postgres
MySQL
MySQL Workbench
MariaDB
Oracle 10g
Oracle 11g
Stored Procedure
Database Trigger
Data Migration
Data Warehouse
Reverse Engineering
Backup/Restore
XML
JSON
MongoDB
Apache Cassandra
Cloudera
AWS S3
AWS EC2
AWS RDS
IAM
AWS cloudformation
UML Modeling
PHP-Programmierung
Smalltalk
Bash (Unix shell)
C++
LINUX server
Red Hat LINUX
Linux
Debian GNU/Linux
Debian-Pakete
Gentoo Linux
Ubuntu
Puppet
Docker
Apache
Nginx
Lighttpd
Mercurial
SVN
Git
Zabbix
Nagios
Confluence
Jira
elasticsearch
Pentaho
Code Reviews
Maintenance
Disaster Recovery
Business Intelligence
Continuous Integration
Solution Design
Architektur
PostGIS

Werdegang

Berufserfahrung von Alberto Serra

  • Bis heute 6 Jahre und 10 Monate, seit Aug. 2017

    Senior SQL engineer

    Dentsu Aegis Network Germany

  • 2 Jahre und 6 Monate, Feb. 2015 - Juli 2017

    Senior SQL engineer/DBA

    Dentsuaegis Ltd

    In the last year I have basically been working as a mix of Solution Architect, Developer and Sysadmin, as the Big Data growth often exposes situations in which individual tools are difficult to assemble into a properly working set with manageable levels of administration (in particular when most of the team has little previous exposition to Linux). So I have become the guy who assembles the system and maintains the glue that keeps all bits and bobs together.

  • 1 Jahr und 11 Monate, Apr. 2013 - Feb. 2015

    DBA, Lead developer & Data Architect

    Truphone Limited

    Responsible for  Cassandra and MongoDB based HA billing systems (python development)  System consistency and data integrity  General system revision and future development strategy

  • 1 Jahr und 4 Monate, Jan. 2012 - Apr. 2013

    Senior Technical Architect

    Sirius Corporation Ltd

    Team co-ordination and management, Design, administration and implementation of the internal postgreSQL replication server, Design and implementation of the postgreSQL replication clusters for high availability, Disaster recovery, Migrations to different hardware with optimization (and minimal downtime constraint), Migrations on non interruptible services (~zero downtime), Creation of monitoring systems and ad-hoc tests (load and structure of service use in time)

  • 7 Jahre, Jan. 2005 - Dez. 2011

    Data Architect/DBA Consultant

    Vox Humanitatis

    Data Architect for an Open Source distributed textual repository

  • 4 Jahre, Jan. 2001 - Dez. 2004

    Data Architect/DBA and Outsorcing Manager

    Smileline srl

    The company aimed to be a totally on-line business, including: 1. E-commerce public interface (with all the usual gear: carts, payment, delivery tracking); 2. Private administrative interface for stock management, invoicing, statistics, etc.; 3. Online tools for retailers and sub-distributors; 4. Database on MySQL (innoDB); 5. LAMP environment with OO-PHP

  • 3 Jahre und 9 Monate, Apr. 1998 - Dez. 2001

    Oracle Consultant

    Techne srl

    Support of third parties, including SIPRA (biggest advertising industry in Italy at the time )

  • 2 Jahre und 10 Monate, Juni 1995 - März 1998

    IT Director

    MAT srl

    Robotic warehouses. A system capable of dramatic reduction of storage space for metal bars, coils and sheets.

  • 3 Jahre und 2 Monate, Apr. 1992 - Mai 1995

    Consultant

    ELEA spa

    Technology teacher for the Olivetti spa sales structure. Travelled through all Italy to ensure the sales network was ready to use/sell internet and windows based technology.

  • 11 Jahre und 3 Monate, Jan. 1981 - März 1992

    Partner

    BA.SE. snc

    The industry was young, and so were we. We did anything that could produce some cash. Fron Vic-20 and C-64 games to automation for commercial Radio Stations (sort of auto-DJ) and the book-keeping of the planet-wide Ermenegildo Zegna franchising line. Which is how I started to think of databases.

Ausbildung von Alberto Serra

  • 3 Jahre und 5 Monate, Okt. 1979 - Feb. 1983

    Economia e Commercio

    Università degli Studi di Torino

    Some College Coursework Completed. I interrupted the process because I had already started my own software house (see BA.SE) and I was working 14 hours a day x 7 days a week. In the last year I was only paying taxes and never showing up at all.

Sprachen

  • Englisch

    Fließend

  • Italienisch

    Fließend

  • Russisch

    Fließend

  • Deutsch

    Grundlagen

  • Französisch

    Grundlagen

  • Spanisch

    Grundlagen

Interessen

Domotics (arduino - raspberry pi)
1960s music and fashion
Mountain hiking
Drawing
Reading
Cooking

21 Mio. XING Mitglieder, von A bis Z