Post Job Free
Sign in

Db2 DBA and System Programmer

Location:
Magdalena Contreras, Mexico City, Mexico
Posted:
February 25, 2020

Contact this candidate

Resume:

Curriculum Vitae – Sergio Alcalá

Personal Details

Johna Baildona 24A/7

Katowice, Poland

**-***

******.******@*****.***

+48-502***-***

Date of Birth: 10 October 1983

Nationality: Mexican

Visa status: Blue Card, Work Permitted in Poland

Education Languages

Universidad del Valle de Mexico 2001-2005 Spanish – Native

Degree in Systems Engineering English - Advanced

Career History

IBM Poland – DB2 System Programmer for z/OS

September 2018 – October 2019

•Maintenance (RSU and PTF) implementation for DB2 and IBM products.

•Upgrade IBM Administration Tool from v11.1 to v12.1.

•Upgrade InfoSphere OptimTDM Solution for DB2 for z/OS from v7.2 to v11.7

•Upgrade IBM Log Analysis tool for z/OS from v3.4 to 3.5

•Prepare and test migration to DB2 v12, fallback and re-migration.

Lloyds Banking Group – DB2 Database Administrator for z/OS

April 2016 – May 2018

•Support the design and implementation of new applications from development to production.

•Testing and implementation of new features, like XML tablespaces and UDFs.

•Generation of processes to extract TSB data in order to assist the migration to Sabadell.

•DB2 object maintenance (execution of DDL, verification of objects and parameters, problem resolution) using BMC’s Change Manager tool (e.g. worklists, baselines, migration profiles).

•Design and implement Stored Procedures.

•Review access paths and provide recommendations for indexes and changes to SQL statements, making use of BMC SQL Explorer and Apptune.

•Design, implement and maintain Automated REORGs using BMC DASD Manager.

Experian UK - DB2 Database Administrator for z/OS

January 2016 – April 2016

•DB2 object maintenance (execution of DDL, verification of objects and parameters, problem resolution).

•Design Stored Procedures.

•Support the design and implementation of new applications.

•Review and improve SQL statements for batch and online programs.

Banorte - DB2 Database Administrator and System Programmer for z/OS

June 2013 – September 2015

•Prepare, co-ordinate and implement migration to DB2 10.

•Migration activities to BMC v11.

•Maintenance and PTF implementation for DB2, BMC and CA products and utilities.

•Implement monitoring and alerting (using REXX), respond to and resolve any issues.

•Performance analysis and tuning of queries, batch processes and transactions using BMC Mainview and CA Detector.

•Analyse costs vs benefits of decompressing datasets to reduce CPU and elapsed time in batch processes.

•Test and implement ongoing improvements to DB2 housekeeping with the use of utilities, in-house written REXX programs, utilising Real Time Statistics.

•Test and exploit new features and options of DB2 and utilities.

•Provide 24x7 support to bank users and software developers.

Santander S.A. de V- DB2 Database Administrator and System Programmer for z/OS

October 2011 – June 2013

•Prepare, co-ordinate and implement migration to DB2 10 in non-datasharing and datasharing environments, including base-lining performance prior to the migrations and measuring performance after the migrations to provide accurate figures for any improvements/regression and CPU savings.

•Maintenance and PTF implementation for DB2 and BMC products and utilities.

•Migration activities for BMC to v10.

•Migration activities for Admin Tool to v10.

•Ensure that the highest level of protection, security and audit is achieved in DB2 by utilising RLF, Audit Traces, RACF and alerting.

•Use log-mining tools to provide effective means of investigation, undo, redo and migration of changes following a data problem.

•Migrate security from DB2 to RACF.

•Provide 24x7 support to bank users and software developers.

BBVA Bancomer S.A. (Infomedia) - DB2 Database Administrator for z/OS

September 2006 – October 2011

•Preparing maintenance (Backups, Reorgs, Stats, Rebinds) process for the American bank, Compass.

•Analysis and implementation of data models.

•Access Path analysis and recommendations.

•Support and assist users with problems and enquiries, 24x7 support.

•Object maintenance (DDL execution, verification of objects, resolution of problems).

Praxis - Benchmark Analyst for BMC

May 2011 – August 2011

•Installation of BMC Products v10 for Benchmark in Banorte Bank

•Benchmark test executions for BMC v10 Utilities and Solutions.

Praxis - Quality Assurance Analyst for BMC

October 2009 – January 2010

•Execution of jobs in order to test and validate the functionality of the latest versions and features of utilities and products.

•Execution of jobs from different versions of the utilities and products in order to analyse and compare results, defects and functionality.

•Regression test environment preparation to facilitate the recreation of errors and defects reported for a utility.

•Installation and migration of BMC utilities and products.

Grupo Nacional Provincial (GNP) - DB2 Database Administrator for z/OS, Data Modeller

October 2005 – September 2006

•Access Path analysis and recommendations.

•Support and assist users with problems and inquiries, 24x7 support.

•Object maintenance (DDL execution, verification of objects, resolution of problems).

•Catalog and Directory Maintenance.

•Use of Erwin All Fusion Data Modeller tool.

•Analysis and implementation of data models.

Technical Experience

DB2 for z/OS v7-11 (11 years) JCL

IBM DB2 Utilities SQL, PL/SQL

IBM Tivoli Decision Support TSO, ISPF

IBM InfoSphere Replication Server SDSF

IBM DB2 Connect ISMF

IBM DB2 QMF IDCAMS

IBM Data Studio DFDS

IBM DB2 Performance Expert VSAM

IBM TWS/OPC REXX

BMC Classic and NGT Utilities Quikref

BMC MainView CA Detector

BMC Change Manager CA Endevor

BMC Catalog Manager CA RC/Migrator

BMC LogMaster CA RC/Query and Update

BMC SQL Performance for DB2 CA Log Analyzer

BMC DASD Manager CA Erwin Data Modeler

BMC Control-M IBM Tool Customizer

BMC Remedy

Key Courses and Training

IDUG 2017

Database Administration for DB2 z/OS - 2008

TSO-ISPF – 2007

JCL and utilities – 2007

COBOL II

Index Design – 2007

Database Design - 2005

Data Modelling – 2005

REXX - 2017

Unix Fundamentals – 2008

Oracle 11g R2 Database Administration - 2011



Contact this candidate