Download PDF

Summary

Senior MySQL Database Administrator with around seven years of Database knowledge. Extensive experience in implementation and management of internet services to ensure highest levels of system availability and performance globally. Demonstrated ability to adapt to changing technologies and methodologies.
Excellent interpersonal skills, confident and poised in interactions with individuals at all levels
Dedicated individual with reputation for consistently going beyond what is required.

HIGHLIGHTS

    • Relationship management
    • Solution architecture
    • Documentation & reporting
    • Enterprise architecture
    • Mentoring
    • Troubleshooting

Skills

INFRASTRUCTURE TECHNOLOGIES 

  • Database: MySQL
  • Virtualization: VMware vSphere
  • Storage: EMC VNX
  • Reporting & Monitoring: Zabbix,Nagios, Cacti,Grafana,OpManager
  • Backup: Veeam Backup and Replication, Simpana Commvault,Networker, Bacula

DEVOPS TECHNOLOGIES 

  • Configuration Management: RH Kickstart, Ansible, Rundeck,Capistrano,Spacewalk
  • Monitoring: Zabbix,Munin, Nagios, Cacti,Grafana
  • Coding: Bash, Python
  • Logging: Syslog, ELK (Elasticsearch, Logstash and Kibana)

Work experience

2017Present

Database and Automation team leader

ContactLab

In Contactlab I'm part of the Platform Operations team, which has the responsability of maintaining the production environment.
Me and my team are in charge to manage and tuning around 70 MySQL instances, distributed over 50 Freebsd and RHEL7 server, with about 20TB of data.
With my colleagues we plan, deploy and maintain a medium-sized but extremely vary ecosystem of servers: physical, virtual or container, linux, freebsd, java, ruby or php.
The main tasks we manage are:
-  All things monitoring: maintain and operate a customized Zabbix installation, from the creation of SNMP/JMX/ZBX templates to the definition of custom dashboards (Life Pro Tip: execs love Grafana!)
-  Providing support for a mid-sized Kerberized Hadoop cluster (Hortonworks)
-  Maintain an ever-growing Elasticsearch cluster, supervising the ingestion flow and helping other teams exposing meaningful metrics with Kibana
-  Automation: I'm obsessed with automation and I try to bring it everywhere it's needed - be it Rundeck/Ansible for operations, or Capistrano for deployments. Spacewalk makes my life easier too.

20112016

IT Databases Team Leader

Lumata Italia srl

From the November 2011, I am working at Lumata Ltd., where I am the leader of the Database and Backup Team.
In Lumata I built my team, doing a lot of interviews and selecting three people.
In addition to the team in Italy, I was a consultant for the selection of two MySQL DBA in favour of the Indian office of Lumata.

In Lumata I designed and implemented the entire architecture of the Database, all the infrastructure is in High Availability, using proprietary technologies and methods of replication suggested by MySQL.

Currently I and my team of three people, we are managing a lot of MySQL instances, ensuring availability, in the last 3 months of 99.99%.
For some internal projects, aimed at collecting data for the reversal of costs to customers, I have used, even if not so thorough, some NoSQL databases, and in particular I used Riak and MongoDB.

I am in charge, also, to set up and ensure the proper functioning of the enterprise backup, performed with the Enterprise Backup Tool EMC Legato Networker.

In addition to the management and implementation of new services, I was responsible, during the separation from Buongiorno, for the migration of data from Buongiorno to Lumata, migrating instances of MySQL to version 5.6 with UTF8 characters.

20102011

Backup Manager and Senior Database Administrator

Buongiorno

From the April 2010 to the November 2011 I added to my task, also the management of the Backup Team.
I made the migration of the enterprise backup (MySQL, File System, SQL Server, Oracle) from an Open Source tool (Bacula) to an Enterprice Backup Tool (EMC Legato Networker) and I got to work with the DataDomain Storage.
During this experience I have followed the course

  • EMC Networker Administration for UNIX and Microsoft Windows

In addition, I am certified in:

  • Networker Backup and Recovery Specialist Exam for Storage Administrator
20092010

Senior Database Administrator

Buongiorno

From the February 2009 to the April 2010, I worked on the installation, configuration and performance tuning of about 150 MySQL instances, distributed over about 50 RHEL5 server, with about 7TB of data and processing an average of 3.500 queries per second.

I have migrated about 80 MySQL instances from the version 4.0 to the version 4.1, 5.0 and 5.1.
I assisted application developers with the test works correctly with the updated versions.

20062009

Junior Database Administrator

Buongiorno

From the March 2006 to the February 2009 I worked as database administrator in the technology division.
My Task was the configuration and the management of the MySQL databases. I was also responsible for the proper functioning of the script for fail-over, the MySQL replications, and the backups.

20052006

PHP Developer 

Buongiorno

From the October 2005 to the March 2006 I worked at Buongiorno Spa with as PHP developer. Involved in developing a web application for managing technology assets.

Education

20002005

Degree in Computer Science

University of Insubria in Varese
19952000

Diploma di Maturità Scientifica

Scientific Liceo Galileo Ferraris, Varese

Certifications

2015

MySQL Performance and Tuning

Pres srl
2011

Networker Backup and Recovery Specialist Exam for Storage Administrator

Magirus Italia 
2010

Oracle Database 11g:Administration Workshop I

Oracle University

Language

  1. English: Professional working proficiency
  2. Italian: Native or bilingual proficiency

Privacy

I give the authorization for the treatment of my personal data according to Italian Law D. Lgs. 196/2003