Db2 DBA and System Programmer
Resume:
Curriculum Vitae – Sergio Alcalá
Personal Details
Johna Baildona 24A/7
Katowice, Poland
******.******@*****.***
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