SUMMARY

• DB2 z/OS V10 DBA, DB2 LUW V10 DBA and IMS V8 DBA with experience in manufacture, telecommunications, finance, insurance, banking, oil and government IT work environments.
• Demonstrated ability to design, develop, implement, administer, maintain, monitor, and tune Database systems; install, test, evaluate, customize, implement, and maintain software products; administer and monitor disk space for containers, file systems, database volumes and datasets; develop and implement applications.
• Well versed in Mainframe and Distributed architectures. Team leadership skills. Project supervision experience. Enjoy learning new skills and tutoring colleagues. Bilingual Spanish - English.TECHNICAL SKILLS

TECHNICAL SKILLS

Operating Systems: AIX, LINUX, Solaris, z/OS (PARALLEL/SYSPLEX), OS/390, MVS, WINDOWS XP/Vista/7/8

Control Languages: SCRIPT, KORNSHELL, JCL, CA7/CA11, SMP/E, SIPO/E, RACF, ACF II

Data Base Systems: DB2 LUW V7/V8/V9.7/V10, DB2 Connect, DB2 Stored Procedures, BMC Catalog Manager/Change Manager, BMC MAINVIEW, Visual EXPLAIN, Power Designer, DB2 Z/OS V8/V9/V10, IMS DB/DC V8, VSAM, BMC DB2/IMS UTILITIES, OMEGAMON/DB2/IMS, TOTAL, DMS II

Editors: VI, TSO, ISPF, ROSCOE, XEDIT, OWL, CANDE

Programming Languages: COBOL, EASYTRIEVE, ALGOL, PL/me, MANTIS, FORTRAN

Monitors: NMON, Data Studio, DB2Top, DB Artisan, Optim, TOAD DB2, DB2PD, QUEST DB2:Central, Spotlight, Agent & Optimizer, BMC Patrol, TMON, OMEGAVIEW, SAMS DISK, ASTEX

Development tools: FILEAID, XPEDITER, VISIO, SYNCSORT, CA ENDEVOR, CHANGEMAN, JOBTRAC, PDSMAN, EZYEDIT

Transactions/Networks: IMS DC, CICS, WEBSPHERE, NDL

Other tools: Datastage, Cognos, CommVault, TSM, Infosphere Change Data Capture (ICDC V6.5), Jira, Confluence, LOTUS/NOTES V8.5, Clarity, Kronos, BMC Remedy, ITIL, Crontab, MicroSoft OFFICE, PROFS, SAP

PROFESSIONAL EXPERIENCE

Confidential

Consulting Database Specialist

Responsibilities:

• Advise and assistance to companies Confidential and PDVSA on revision of database design, setting up database utilities, upgrading and patching DB2 versions, performance tuning, disaster recovery strategies and tests, fail over clustering, HADR, et cetera. Review plans to set DB2 LUW database warehouse creation from DB2 z/OS databases. Assistance on script revision. Review plans on upgrade for DB2 z/OS software.
• Work on DB2 ESE 9.x & 10.x versions, doing installation, upgrade, Fix Pack application, deployments, migrations and performance tuning. Regularly work on DBA maintenance activities like setting up and schedule: reorgs, runstats, back-up, recovery, restore, etc. Collaboration on database physical design. Regularly doing application optimization, taking care of query performance issues on production environments. Ability to understand and fix production issues on the fly and conduct root cause analysis. Exposure on DR test & strategies like Fail-over Clustering/HADR. Knowledge of IBM standard tool for performance monitoring. Good communication skills. Knowledge on ITIL methodologies, and software for Change, Incident, Problem, and Service Management. Interaction with Websphere MQ.

Confidential, Nebraska, USA

Senior Database Administrator

Responsibilities:

• Working with UDB ESE V9/V10 on Linux and AIX environments. Work on physical design, implementation and support for Databases in Test, Development and Production environments.
• Work on procedure and scripts to upgrade databases to DB2 version 10. Tuning of SQL statements using EXPLAIN. Check on daily backup, reorg, runstats utility processes, correcting any problems. Set up recovery and restore procedures.
• Provide support for availability, performance and data integrity for application systems. Implement physical models using ERWIN for database elements creation and changes. Also worked on mainframe DB2 V10 on creation and maintenance of database elements like tables, columns, indexes and grants. Tuning SQL and rebinding packages. Interfaces with Websphere MQ

Confidential, Missouri, USA

Senior Database Administrator

Responsibilities:

• Under DB2 ESE on Linux, Unix (AIX/Solaris) and Windows environments worked on physical design, implementation and support for Data Bases on 8 Mutual Fund systems for more TEMPthan 60 different Financial Institutions, which utilize Test, Development, Beta and Production environments: on 11 servers, 36 DB2 instances, 120 databases and around 100 Terabytes in disk space. Also work on installation/update, migration and Fix Pack application on DB2 for LUW, and same on software related. Constantly keeping software versions and releases up to date.
• Query Performance optimization using EXPLAIN. Request for ports, telecommunication nodes, user codes and disk space for new servers and DB2 instances. Take part in the physical design, capacity planning, and database maintenance planning. Assistance to application's user interface design and prototypes.
• Provided support for availability, performance and data integrity for application systems. Control activities related to database administration, development and maintenance. Implement scripts and crontab schedules for periodic reorganizations, runstats, rebinds, also other periodical maintenance and control tasks. Provide database/tablespace restore or recovery on needed cases. Implemented table partitioning and database Federation for several databases. Interaction with Websphere MQ.

Confidential, Michigan, USA

Database Administrator

Responsibilities:

• Supported over 30 databases in mainframe and distributed systems on 18 manufacturing and assembly plants.
• Physical designed, administered, tuned and maintained DB2 ESE/WSE and IMS Databases on AIX, Linux and z/OS environments for the company's applications. Instalation, upgrade, Fix Pack application, and Database migration when software changes needed for DB2 LUW ESE/WSE environments. Day to day support includes IMS databases, DB2 (on AIX, Linux and z/OS) Tables and Indexes creation, testing support, SQL performance optimization, conversion and production implementation, query performance optimization, Explain SQL, set up Backup/Recovery/Reorg/Restore/Runstat utilities.
• Using PARALLEL/SYSPLEX mainframe environments. Worked under SARBAINE - OAXLEY audit procedures. Designed and implemented 24X7 “Kanban/Just In Time” mission critical application dat supported 28 plants, with outstanding performance and reliability

Confidential

Database Audit Assistant

Responsibilities:

• Project assessment on Customer Claims and Repairs Help Desk system. Audit interviews to project leaders and user representatives involved on the system. Analyze artifacts needed to verify good project management practices. Translations from Spanish done when needed.
• Work on re-design on an application and make several modifications to COBOL DB2 program. Create 750 jobs for the new Spool Database System using JSCAN . Changeman as change control software, JOBTRAC to schedule and run jobs, JHS (Job History System) and PDSMAN - EZYEDIT to edit programs and JCL’s.

Confidential

Systems Programmer

Responsibilities:

• Coordinate and led the activities of 3 analyst doing administration of IMS/ESA environment. Planned and executed activities like installation, test, evaluation, customization, implementation and maintenance of a variety of software. Provided support to Trouble Administration System (TAS) and Billing & Voucher Treatment (BVT) which were GTE applications. Designed, customized and tuned IMS environments to meet service level agreements within required time frame. Installed IMS 5.1. Developed IMS procedure manuals. Day to day support includes PSB, DBD, and ACB gens, testing support, conversion and production implementation. Walk in support for application programmers in COBOL, IMS DB, IMS DC.
• Directed a 12 system analyst team in charge of technical support to software products and disk storage administration in a MVS/XA environment. Provided operating support to 50 offices around the country. Managed and Supervised installation, test, evaluation customization and maintenance of software products.
• Administration and maintenance of IMS Databases and systems environment for the bank's applications. Design, modify and implement logical/physical database models. Work on IMS to DB2 application conversion project. DB2 installation.