Structure and operation of computer systems - Associate Professor

DB2 DBA performance, design, installation and implementation new releases ( v12 m500 - m509 ), installation db2 tools, design and creation own tools, technical support. and internal DB2 instructor for technical groups.Tools usedQMF onlineQMF batchDB2PMOmegamon for DB2Omegamon batch reportsRexx

Actually I am working in the Client site (ICBC bank ) as DB2 DBA supporting DB2 Z/OS since February 2014. In the ALTAMIRA environment I work in the DB2 objects creation using ENDEVOR tool, customization some new DB2 version tools, I am supporting users in all kind of problem including the recommendation for his/her project. In my job position also support the daily production activity that is very critical for the client.

Create project plan for DB2 migrationDB2 V8 to DB2 V10DB2 V7 to DB2 V8Installation and migrationDB2 V10.1 for z/os customizationDB2 V8.1 for Z/osDB2 V8.1 for Z/os maintenance to the last vesionDB2 Administration Tools V7.2DB2 Object Comparison Tools V7.2DB2 SQL Perf Analyzer V3.2DB2 Table Editor V4.3DB2 UDB for Z/OS V8.1DB2 Utilities Suite V8.1Optim Test Data Management V6.1.1Optim tools for DB2 Z/OS 7.1BMC Catalog Manager for DB2 V10.1BMC Change Manager for DB2 V10.1BMC Copy Plus for DB2 V10.1BMC Load Plus for DB2 V10.1BMC Unload Plus for DB2 V10.1BMC Command Processor V2.4BMC Snapshot upgrade Feature for DB2 V5.6BMC MAT Mainframe Application Turner V10.0CA Report Facility R11.5Oracle Transparent Gateway for DB2 V10.2.0.3Softbase Systems Batch Healthcare V3.1.0Tivoli Decision Support Installation and customizationOmegamon for DB2 XE 5.1.0 with DB2 V10Installation DB2 features forOmegamon for DB2 XE 4 1 0Many DR exercises executedGenerate Project plan for installation or migrationManage ticket tools:Impact toolMaximoManagenowDB2 software and DB2 tools maintenance.Customers where I worked :Gas Company North Carolina U.S. (PNG)Financial Company Canada (Manulife)Electronic Industries U.S. (Freescale)and some SMB industries U.S.

General DBA taskLoad, unload, create environment, general grants, binds, DR exercise, perfomance, support operator and job streamers etcGeneral support and assistance on incident reported by customer, operators etcCustomer : important transportation company from Miami Florida U.S.

I worked in the implementation of GENESIS project sent from Telstra Australia.This implementation included the creation of 50.000 DB2 objects( using automatic jobs created to execute with REXX languaje associated, all jobs and REXX was created in TELECOM).Successfully implementation of the bussiness applications and generated aditional automation jobs to day to day bussiness.General support for programmers analists PM ETC.

I worked in all kind of jobs related to DBA and System programmer.

Operations monitoring, backups , printing load cartridge etc.