Extensive experience on server reviews, workload tracing and SQL rewriting and tuning.
Scripting/development: Python, Perl , PL/pgsql and bash. In reverse order.
Aedgency - MySQL/Oracle DBA
Barcelona, Spain November 2010 - March 2012
MySQL/Oracle database administration.
Query tuning and performance.
ETL integration between databases.
Sphinx basic configuration, fixing and monitoring.
SIU - DBA & Database Production Consulting
Buenos Aires, Argentina July 2009 - July 2010
Provided trainings and support to the national universities (as UNLP, UNC, UNNE, UNNOBA, UNCU, UNPA, UNR, etc) , support developers in DB modeling, administration of Postgresql-Informix-Mysql databases.
Data Architect tasks and server revisions. Planing migrations and future strategies to board new releases.
Coordinated teams for database support to enhance the compliant between apps of SIU.
Developing the production and pre-prod following plan for all the SIU apps. Server metrics and other stuff for high performance servers.
Globant - SysAdmin Linux - EA
Buenos Aires, Argentina February 2009 - July 2009
SysAdmin Unix at EA (Electronic Arts) Hydra - GOP project.
Maintained platform consisted in Oracle database 10, Apaches and Tomcats (VAP, VCM) Clustered, with several stages of deploy.
Main tasks were relate to deploys, environment configuration, VMWare Infraestructure Client maintenance and monitoring.
I did Mysql DBA tasks on Prod, Pre-Production and Development Servers for a Forums project. Fixing some character set problems and DDL, backups, restores, check, performance and others.
Basic knowledge on deployment / process with Maven - Ant - Hudson.
Assigned 50% to another project to provide Engineering Support at EA over Python scripting.
Correo Argentino - SysAdmin senior Linux and PostgreSQL
Monte Grande, Argentina August 2008 - February 2009
I managed production platform at Correo Argentino (over 400 terms with local databases and Linux enviroment).
Some machines was enlaced with a AD throw WinBind.
Created an improved deploy tool for scripts, database recovery, control and monitoring, etc.
Also managed servers over Centos 5 for the support area’s knowledge-base application (7 DB MySQL 5.1)
Siemens - PHP developer
Monte Grande, Argentina January - August 2008
Huenei - Application Support
Monte Grande , Argentina October 2007 - January 2008
Terminal administration in W/NT and 2K remote servers. Configuration, control, monitoring. Attend Remedy tickets for fix problems and others.
The application was in Paradox and Oracle databases, in which my tasks consisted in repair tables, fix some wrong data and others.
Bug reporting and detection.
MOSAIC debugging and support.
Customer Correo Argentino / Siemens.
As a consultant, I provided independent database consulting services for the following companies (in non-particular order):