Luis Martinez

Experience

• 

  Grupo Iusacell

  Mar 1991 - Apr 1996

  Mainframe Technical Support

  Technical Support in DB2 for HPUX, HPUX, MVS, OS400, Oracle, RACF, SMS.• Coordinating Cobol/DB2 and Oracle/C application Replication/ Testing.• Coordinating Upgrades of SW and HW. • Developing Automation tools in Cobol, REXX, ISPF, C, PL/SQL and shell programming.• Training operators in several platforms and implementing automation procedures.• Site Management with 6 coordinators and 12 operators under supervision. In charge of IBM9021, AS400, Uix servers, Printer area, Tape room, Networking and Communications equipments: Multiplexers, CISCO routers, 2074 Show less

• 

  Bancrecer (Banorte)

  Apr 1996 - Mar 1998

  IT Specialist

  Technical Support in DB2 4 for MVS, Oracle 7.1.6, OS390, Cobol,CICS,DB2, Solaris, AIX and HPUX. • Cobol, CICS, VSAM, DB2 environment generation and replication.• Coordinating Cobol/DB2 Application Testing.• Analyzing and suggesting products and tools.• Developing Automation tools in Cobol, REXX, ISPF, C, PL/SQL, SQLplus and shell programming.• Technical Support in OS390 Cobol, CICS, applications.• Training: Shell programming to 16 analysts.• Change Control Management Coordinator. 8 peoples in charge: IBM Mainframe, AS400, AIX, SUN, HP, NCR, DB2, Oracle, Networking, Site equipment. Show less

• 

  Trigger S.C:

  Mar 1998 - Mar 2000

  DBA

  Planning the Cobol/VSAM/DB2 applications and data replication from DB2 5.1 for MVS to SUN E10K with DB2 LUW 5.1. • System programmer activities as trainee: Analysis, installing, customizing and maintenance of IBM SW in MVS equipments: PTFs and APARs, SMP.• Developing Automation tools in Cobol, REXX, ISPF, C and shell programming for DBA activities and DB2 utilities.• Replication of the DB2 MVS to DB2 Solaris environment: Cobol/VSAM Applications, Structures and Data.• DB2 MVS and LUW administration: 4 subsystems, 6 instances, 10 databases, 2000 objects and 6 Tb. Solaris: Logical and physical DB design support, Daily Requirements, Spaces Maintenance, Data replication, Disk space administration, Advisory.• Solaris and DB2 Monitoring and tuning: CPU, Memory, Swap, Paging, Workloads, Virtual storage, Bufferpools and I/O, Locking, SQL, Access Paths, Explain: : Commands, snapshots, monitors• Technical support post-migration in Solaris and DB2 LUW to DBA's Staff• Training in Solaris fundamentals, administration and shell programming to system's personnel.• DB2-RACF-Solaris security scheme implementation.Analyzing and Planning the implementation of Data Warehouse on DB2 for OS390 platform.• Developing DB2 Automation tools in REXX, ISPF, C and shell programming for extracting information and create Decision Support reports.• Analyzing, Testing & advising DB2 IBM and Third Party Products and tools. Show less

• 

  Costa Rica Government

  Nov 2001 - Jan 2002

  DB2 DBA

  IBM • Planning, installing, implementing DB2 7.1 for OS390.• Planning, installing, implementing DB2 Connect 7.1 for OS390.• Implementation of TCPIP/SNA communications for DB2 subsystems. Connectivity problem determination among DB2 390, DB2 VSE and DB2 AIX 4.3.• System programmer activities: Analysis, installing, customizing and maintenance of IBM SW in 390 equipments: PTFs and APARs, SMP/E. PMR’s and maintenance procedure with IBM Support.• Technical Support: OS390 2.10 DB2 VSE & DB2 OS390 V7 Cobol CICS applications and data migration from VSE to OS390. AIX customization for data migration.• DB2-RACF customization: Implementing DB2 security through RACF definitions and accesses.• Monitoring Performance and Tuning DB2 VSE and OS390 Subsystem and Cobol/CICS/ VSAM/DB2 applications: Mainview, RMF, SMF, DB2 Performance Monitor, traces, VSE Tools.• Teaching "DB2 for OS390 Concepts".• Teaching "DB2 for Os390 System Administration" .• Teaching "DB2 for Os390 Application Programming".• Teaching "DB2 for Os390 Application Design". • Teaching "DB2 for Os390 Application Tuning". Nov 01 – Jan 02IBM Teaching "DB2 for OS390 Concepts".• Teaching "REXX programming".• Teaching "DB2 for OS390 Application Programming". • Teaching "Linux for OS390 Overview". • Technical support in Linux OS390 installation.• Teaching "Linux for OS390 Concepts".• Teaching "DB2 for OS390 Concepts". Jul,01 – Oct,02 Show less

• 

  IBM Business Partner

  Jan 2002 - Sept 2004

  Technical support in DB2-Peoplesoft Development, Volume and Production environments: Peoplesoft 8.40-80, DB2 7.x-8.x, AIX 5.2 and HACMP, Solaris 5.8, Sun Cluster, Websphere 5, Weblogic 5 : SW installation and maintenance, Clustering, NFS, Networking, Application Server, DB2 LUW and Solaris problem determination and troubleshooting. Tools: IBM and Quest, commands, shell scripting, HP OpenView, DB2 health monitors, event monitors, DB2DART, Inspect, db2diag, db2greg, db2_call_stack, db2pd, db2support, db2xprt, db2trc. • DB2 LUW administration: 14 instances, 38 databases, 10,000 objects and 10 Tb. Solaris/NT: Support for daily requirements, Spaces Management, Data replication, Disk/File System configuration, Advisory.• Capacity Planning for Applications and Data migrations from SUN15K to SUN20K.• Logical and physical design DB2 LUW data bases.• Technical support for migrating Peoplesoft 8.40 to 8.80 applications. Solaris 8.0 and DB2 LUW 8.1.• DRP. Planning and Implementing Solaris and DB2. DB2 backup-restore, disks, filesystems, containers.• AIX/Solaris and DB2 Monitoring and tuning: CPU, Memory, Swap, Paging, I/O Buffering, Priority tables, Workloads, Virtual storage, Bufferpools and I/O, Locking, SQL, Access Paths, Explain: Commands, snapshots, monitors.• Planning and designing automation tools for DB2 and Solaris/AIX administration, monitoring and maintenance (utilities) . C, shell, Java, XML, HTML.• Development of DB2 procedures and documentation for maintenance utilities.• Developing Data Cleaning Utility in SQL & shell.DB2 LUW 8.1, Solaris 5.8 and Windows NT technical support.• Analysis and data replication between Redbrick DMart and DB2 LUW 8.1. with Assential Data Stage.• OS390 Application/Data replication to WINDOWS/ Solaris. Show less Technical support in DB2-Siebel Development, Testing and Production environments: Solaris 5.7-8, DB2 LUW 7.x, OS390 2.10, Websphere 5 Vignette: Diagnosis and problem determination, Troubleshooting. Performance monitoring, system & applications tuning. Tools: IBM, Quest, Embarcadero.RMF, SMF, shell scripting, Siebel Support Web, DIAGNOSE, DSN1SDMP, DSNJU*, DSN1LOGP, DSN1COPY, Traces, DSNJLOGF, DSN1CHKR, DUMP.• Capacity Planning for Structures,Applications and Data migration in SUN10K and SUN15K.• Planning, installing and implementing Siebel 7.5.2, 7.5.3 on Solaris.• DB2 LUW, Siebel and Solaris administration: 8 instances, 17 databases, 4000 objects and 2 Tb. Solaris/NT: Logical and physical DB design support, Daily Requirements, Spaces Maintenance, Data replication, Disk space administration, Advisory.• Siebel, Solaris, websphere and DB2 Monitoring and tuning: CPU, Memory, Swap, Paging, I/O Buffering, Priority tables, Workloads, Virtual storage, Bufferpools and I/O, Locking, SQL, Access Paths, Explain. Websphere transactions, HTTP sessions, TCPIP, Connection Pooling, Threads, Garbagge collector. Siebel components, Siebel Memory usage. Consoles, commands, snapshots, monitors.• Backup and restore. Planning and Implementing Solaris and DB2 : disks, filesystems, containers.• Data migration between DB2 OS390 and DB2 LUW.Process automation for DB2 under Solaris and OS390: REXX, JCL, shell, java. • Development of DB2 procedures and documentation for maintenance utilities Show less

  • DBA

    Apr 2003 - Sept 2004

  • DBA

    Jan 2002 - Apr 2003
• 

  IBM Bussiness Partner

  Sept 2004 - Dec 2006

  DBA

  IBM Local and remote Technical support for customizing DB2 ZOS V8.1 Cobol applications over ZOS 1.5.Instructor of DB2 for ZOS 8.1 training:DB2 iseries , DB2 LUW, SUSE Linux 9.0 ZOS native and under VM, DB2 LUW over AIX 5L support: analysis of DB and V5.3 operating system configuration: kernel parameters, workloads, memory pools, CPU, I/O, SQL processed, access paths, data organization and recommendations for improvement of performance for Cobol/CICS/ DB2 and Java applications.• Websphere transactions, HTTP sessions, Connection Pooling, Threads, Memory statistics. Consoles, commands, snapshots, monitors. Mexico Government:• Technical support in DB2-SAP Development, Quality and Production environments: SAP 6.20-6.40, ZOS 1.5-1.6, DB2/ZOS 7.1, Websphere 3.5-5.1, SUSE Linux 9.0 , TCPIP, SMS, USS, WLM: Diagnosis and problem determination, Troubleshooting. Performance monitoring, system & applications tuning. Tools: IBM, Omegamon, RMF, RMF Spread sheet, SMF.• DB2 System programmer activities: Analysis, installing, customizing and maintenance IBM SW in ZOS.• DB2 Administration: 3 subsystems, 1000 DB, 40,000 Objects and 6 TB. Logical and physical DB design support, Daily Requirements, Spaces Maintenance, Data replication, Disk space administration, Advisory, RACF Security.• Planning and Implementing SAP/DB2 DRP: System, Application, Data, Disks recovery: SMS, HSM DUMP-RESTORE & DB2 backup-recover. • DB2 Monitoring and tuning: Subsystem activity, Workloads, CPU, Virtual storage, Bufferpools and I/O, EDM, DSC, RID/Sort pools, Logging, Locking, SQL, Access Paths. • Planning migration of SAP applications to DB2 V8. • Planning and designing automation tools for SAP & DB2/ZOS administration, monitoring and maintenance. REXX, ISPF, shell, Java, HTML, XML.• Health checking participant: DB2 & SAP applied by Germany/USA SAP/IBM equipments. Sep, 04 – Dec 06 Show less

• 

  EVERTEC Puerto Rico

  Nov 2006 - Jan 2008

  DBA / IT Specialist

  • ZOS 1.4, 1.7 implementation over 2 Parallel Sysplex: Helping in activities for implementing, customizing, monitoring and cloning ZOS images on 12 LPARS: LPARs weight, capping, memory and logical/physical dedicated/shared CPU assignments. Workload distribution, CF structures sizing, SFM, ARM, MAS, WLM configuration, IRD, VSAM RLS, ZOS libraries, parameters and procedures customization. • DB2 ZOS Data Sharing advisory: GBP / Lock structures, ZPARM / Bind parameters, workload distribution over members of several groups, backup and recovery procedures. Tuning DB2 components: Logging, Locking, Bufferpools, RID pool, Sort pool, SQL, tablespaces and index design. • IBM and ISV SW installation on ZOS/USS over 9 LPARs on Parallel Sysplex: Analysis, planning, installing, customizing and maintaining: ZOS, HTTP server, VPS Web, CA Vantage, TMON monitors suite. Libraries and components cloning, SMPE, PTFs, APARs, HOLDDATA, RACF, TSS implementation.• ZOS/DB2 Performance Monitoring local / remote over Parallel Sysplex and Data Sharing groups. ZOS 1.4/1.7, DB2/ZOS V7 / V8 and USS, Cobol/VSAM/ DB2 applications: Diagnosis and problem determination. Performance Tuning, Subsystem and applications tuning. TMON monitors suite, RMF, SMF, CA tools, DB2 traces, DB2 explain.• DB2 SW evaluation: Evaluating and recommending about DB2 tools: IBM and CA•ZOS Web and USS support: Websphere AS , TTP Server customization and administration, VPS/VMCF web, Web page design with HTML and JavaScript• DB2 ZOS V8 Applications Health Check: Collaborating in analysis and recommendations with IBM DB2 Labs (Silicon Valley) specialist for DB2 applications tuning. Show less

• 

  IBM

  Nov 2007 - Feb 2015

  •SME (Subject Matter Expert) : Oracle, DB2, SQLServer technical leadership , technical support levels 1 – 2 :- Capacity Planning- Application Life-cycle management, Logical and Fìsical Data Base design-Day to day requirements (operations)- Problem and Incident Management- Data Base Administration and Maintenance.- Backup & Recovery, DRP: DB2 & TSM, Oracle RMAN.- Technical Support , Diagnosis and Troubleshooting- IBM, Oracle and vendors SW upgrade- Storage Management- Security Management and Audit- Health Checking and Performance Tuning Infrastructure, databases and applications.- High Availability: DB2 ZOS Data Sharing & DB2 LUW HADR/PureScale, Oracle GRID/RAC.- Data Replication and DRP: Oracle Data Guard / Oracle Golden Gate, IIRS- HW, Operating System and DB upgrade- Application and Transaction Server troubleshooting: Websphere, CICS, Tuxedo.- Automation: C, C++, shellscripting, SQL, PL/SQL. - Technical and operational advisory, Skill Transfer.- Data Warehouse, Data Mart and Informàtica PC technical support, application Development, design and maintenance: Application Life Cycle-Management, data flow, data enrichment, data consolidation, change data capture, transformation, star schemas and so on. - DB2 Versions 9.x,10.x, Oracle 11g,12c Show less Clients: GF Santander, Bancomext, Banamex, Bancomer BBVA, Telcel, Scotiabank•Project Technical Leadership and Implementation:- Content Manager on Demand report migration from DB2 z/OS to DB2 AIX.- DB2 Automation and Health Checking- Implementation of Z/OS Cryptographie for XFB- Implementation of High Availability for XFB on z/OS- Technical Advisory on several platforms for Sovereign project- Z/OS Academy •Advisory and Technical Support for DB2 ZOS V9, IBM DB2 utilities, Mainview, BMC DB2 Utilities, DB2 LUW 8.x, 9.x, CICS TS, Peoplesoft / SAP / On-demand, MQSeries and WAS applications over ZOS 1.9, 1.11, AIX 5.3 and 6.1 for one of the biggest banks in Mexico.• Developing database ETL (Informàtica PC 7 / 8.0) environments with business intelligence applications (Using Designer, Workflow Manager, Workflow Monitor, Metadata Manager). Strong knowledge for transformations and data base concepts: Source Qualifier, Expression Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedures, Sequence Generator, Joiner, Union. Analyze Legacy source systems to identify business rules around data profiling, data flows, data transformations, and data cleansing. Working with data stewards to resolve data variances and exceptions. Design and develop of workflows, mappings, mapplets and transformations, as well as SQL and PL SQL functions, stored procedures and DDL scripts to create database objects.• Technical Support for implementation of Axway products on ZOS, Unix and OS400: •RACF automation for key activities of System Programmers and security administrators.•Planning and supporting upgrades to ZOS 1.8, 1.9 and migration / re-hosting among DB2 ZOS V8-V9 DB2 LUW V8-V9, Oracle 10g-11g.•Supporting strategies and planning for performance tuning and health check projects in several platforms: Operating Systems, Data Bases, Web Servers, Networking and SOA Applications. Show less

  • IT Specialist (SME)

    Mar 2014 - Feb 2015

  • Sr IT Specialist

    Nov 2007 - Mar 2014
• 

  Tata CS

  Jul 2015 - May 2016

  SME Oracle, DB2

  Oracle / DB2 SME- Data Base Administrator- Technical Support L2, L3.- Attending USA client requirements as part of Nearshore Team in GDL- Interacting with India Offshore and USA onsite teams.- Diagnosis / Troubleshooting- High Availability- Replication- Performance Tuning - Cloning/Duplication- Disaster Recovery- Automation- Exadata / Oracle 12c- RMAN- GRID / RAC / ASM- Streams, Golden Gate - DataGuard - Solaris, Linux, AIX over VMs- DB2 z/OS 11 & 12- DB2 LUW 9.x,10.x,- DB2 Data Sharing/HADR/Purescale- z/OS 1.13,2.1 over Parallel Sysplex Show less

• 

  IBM Bussiness Partner

  Aug 2016 - now

  DB2 / Oracle SME

  Remote Technical Support Level-3 (On- Demand) for DB2 z/OS V12 and z/OS 2.2 version´s migration and conversion of 2 Banking Applications from Oracle/SUN to DB2 z/OS:Assessment.AdvisoryDevelopment of migration strategy.Elaboration of migration plan.Technical Support L-3Review of compatibility of 3rd. partySW.Review of new functionality and features.Mapping Oracle Data Structures to DB2.Improvement of logical and physical DB design for better performanceImprovement of SQL coding techniques for better performanceExplotation of DB2 z/OS V12 new optimization and performance features. Planning for performance testings and benchmark Show less