Professional

My focus is the Database Administration for DB2 in Linux, UNIX and Windows, where I have been working for more than four years assuming the risks and difficulties that appear. In addition, thanks to these experiences I have passed several certifications. In the same way, I actively participate is forums and seminars to be up to date in the new features that this application incorporates.

In parallel, I have not forgotten the Software Engineer and the programming, because in my professional career I have been part of several projects mainly developed in Java, based on open source technologies.

Most of my job positions have been in production environments, this is the reason I have been interested in informatics service quality, and I have passed the basic ITIL certification.

Certifications

Currently, I hold these certifications:

And I have passed these mastery exams:

N18: IBM Information Management DB2 10 Technical Mastery Test v3 ( June 8th, 2012. 29/35 82.86% )
M80: IBM ISW-9.7 & Smart Analytics Technical Mastery Test v1 ( March 10th, 2011. 32/45 71.11% )
M45: IBM Information Management DB2 Technical Mastery v2 ( December 8th, 2010. 30/32 93.75% )
M121: DB2 Information Management Sales Mastery - Retired ( November 18th, 2005. 29/35 82.86% )

Professional experience

CC IN2P3 / CNRS

The CNRS is the National Center of Scientific Research in France, and it is the largest governmental research organization in France.
The IN2P3 is the National Institute of Nuclear Physics and Particle Physics , and it works together with many other high energy institutes such as the CERN .
CC is the Computing Center of the IN2P3, and it is a Tier1-Tier2 of the CERN.
DB2
- Storage: IBM DS8300 .
- Server's processor: IBM Power 6 (P550) .
- Server: IBM AIX .
- Version: DB2 ESE, OLTP, embedded.
- Size: Medium databases ~ 50 GB.
- Clients: IBM HPSS, scripts in Perl , Python y Batch.
- Activities:
  - DB2 migration from version 8.2 to 9.1 and from version 9.1 to 9.5.
  - Creation of tools/scripts to monitor the databases.
  - Definition of the strategy of disaster recovery.
  - Automated creation of the test environment from the production data.
Others
- HPSS
  - It is HSM that currently (end 2010) stores 9 PB between tapes and discs.
  - Migration from version 5.1 to 6.2 and from version 6.2 to 7.3.
  - Scripts migration (Perl and Python).
  - Data migration from old tapes (9840 and 9940) to new tapes (T10K and T10K Sport) including the tape movement from the IBM 9310 robot to the StorageTek 8500 one.
  - Definition of new quality standards (tickets for operations, project management to control internal projects.)
- TReqS .
  - TReqS and jTReqS
  - MySQL .
  - C++ and Java.
  - Linux.
  - Several presentations and paper submission for CHEP 2010 - Poster .
  - Frameworks: SLF4J, Logback, Maven, Apache Commons CLI, Apache Commons Collections, Apache Commons Configuration, Apache Commons Lang, Apache Commons Logging, MySQL, JNI, Maven.
From 20081201 to 20110415 (29 months.)
Lyon, France.

Internship: LIG - Adele

The LIG is the Grenoble Informatics Laboratory , and they do researches in many fields about computer science.
RFID / NFC .
- RFID suite. Aspire RFID
- Paper submission. ( NFC Museum .)
- J2ME, Bluetooth, Nokia NFC 6131 , OSGi for the NFC Museum.
From 20080115 to 20080915 (8 months.)
Grenoble, France.

IT Consultings - Computec

IT Consultings is an IBM business partner.
Computec is a company that provides computational services.
DB2
- Storage: SAN.
- Server's processor: Sun Sparc.
- Server: Sun Solaris.
- Version: DB2 ESE, OLTP, HADR.
- Size: Small databases ~ 10 GB.
- Clients: PHP , Java, ODBC.
- Activities:
  - Database definition and implementation (table per tablespaces, security schema, monitoring, physical storage distribution, memory usage, disaster recovery strategy, HADR)
  - Definition of the database administration politics (database creation, configuration and administration, procedures, data migration policy, data access privileges.)
  - Process definition on the database as part of the quality (how to make a change in production, different environments - test, preprod, prod.)
  - Design of the strategy to migrate the databases, and the migration itself from Interbase .
  - Automation of certain process of the database maintenance.
Others
- Tool for data migration from Interbase to DB2 in Java, using JDBC access generically.
From 20060801 to 20061031, and from 20070501 to 20070831 (7 months.)
Bogota, Colombia.

IT Consultings - Liberty Seguros SA.

IT Consultings is an IBM business partner.
Liberty is an assurance company part of Liberty Mutual.
DB2
- Storage: HP EVA .
- Server's processor: Itanium 2.
- OS server: Windows 2003 Server.
- Description: DB2 ESE, data warehouse, OLAP.
- Size: 1.5 TB.
- Clients: BusinessObject , ODBC.
- Activities:
  - Administration and tuning of the Data Warehouse.
  - Increase the database availability and reduce the downtimes.
  - Data migration from old servers to new servers.
  - Creation of a security plan (users, permissions, etc.)
  - New physical storage hierarchy (data migration from disk without RAID to mirrored disks.)
  - Maintenance plan (runstats, reorg, backups) and design of the disaster recovery strategy.
  - Process automation (maintenance, data migration.)
  - Table inventory (delete of old data.)
  - Documentation of the process already established in the database (user creation, export data.)
    - Fixpacks installation.
Others
- Database administration of Microsoft SQL Server databases.
- Tool for data migration from Oracle to DB2 in Java .
From 20051101 to 20060731 (9 months.)
Bogota, Colombia.

IT Consultings - Carulla

IT Consultings is an IBM business parter.
Carulla is a department store.
Design of the application for the call center of Domicilios Carulla, a big-box store. The application was developed in WebSphere Studio v5.0 using WebSphere Application Server.
Design and conception of the whole process of home-deliverance service (creation of the list of groceries by phone (client) and web (call center), product picking in the closest store, billing, and deliverance) monitoring each step.
Focus on performance because of the variety of products.
J2EE .
Others:
- Jasper Reports .
- Oracle database .
From 20050601 to 20051031 (5 months.)
Bogota, Colombia.
Domicilios Carulla .

Teacher assistant

Databases

4 times.
5 h/week, 600 hours.
Creation of guides, and assist the students in their work.
3rd year engineers.
2003 - 2005.

Object Oriented Programming 1.

1 time.
5 h/week, 120 hours.
Solve questions about the assignments.
3rd year engineers.
2003.

Computing Programming 2.

1 time.
5 h/week, 120 hours.
Solve questions about the assignments.
2rd year engineers.
2002.

Colombian School of Engineering "Julio Garavito" .

Blogs

I usually write about technical stuff in a blog, where I put the ideas that came into my head. Also, I write about DB2 stuff in my other blog.

Forums

I am member of different forums to solve problems to other users, and I also put some questions in order to know what the community thinks. Some of these forums are:

Online communities

All the professional information about AngocA.

[ es , fr ]

AngocA

Other languages