SUMMARY:

Extensive relational database technology experience as a database specialist focusing on DB2 and UDB. Database administrator and data modeler with excellent leadership, technical, coordination, communication and presentation skills.

TECHNICAL PROFICIENCIES:

Platforms: Confidential Mainframe zSeries, 30xx, 43xx, xSeries, iSeries, PC, Intel, Linux/UNIX

DBMSs: DB2 for z/OS (v2 thru v10), UDB, IDMS DB/DC - UCF

Tools: SQL, QMF, DB2I/SPUFI, Confidential DB2 Utilities, Tivoli Omegamon for DB2, DB2PM, Query Monitor, BMC MainView, Change Manager, Catalog Manager, Log MasterInfoSphere Data Replication for DB2 (Data Propagator), ERwin Data Modeler, Confidential Intelligent Miner for Data, File-Aid, TSO/ISPF, JES2/3, JCL and Utilities, CICS, VSAM, COBOL, INSTALL/1, DESIGN/1, METHOD/1, INTELLECT, INTERTESTCayenne/Bachman, CoolDBA, Sybase IWS, IDD, ADS/O, OLMTMON for DB2/MVS, Insight, Platinum, DB ProEdit, Librarian, Panvalet, ADW, FDR, Clarity PPM, Primavera, Windows, Win/NT, OS/2, MS LAN Manager, ChangeMan

EXPERIENCE:

Confidential, NY

Lead DB2 DBA

Responsibilities:

• Logical & physical database design and implementation.
• Performance analysis and tuning using Query Monitor, EXPLAIN, SMF data via MainView and DB2PM.
• 24x7 on - call support for DB2 application, utility, and/or subsystem problems.
• Business continuity planning and exercises.
• Day-to-day database-related support including design and schema enhancementsDBMS and tool usage, ad hoc query and change requests, DB2/CICS RCT maintenance, and change management for application releases.
• Oversight, coordination, and review of third party DBA support activities.
• Definition and maintenance of multi-platform DB2/UDB data replication.
• Automated RUNSTATS and REORG processes for production environments.

Confidential, NY

Hands-On Manager, Database Administration (DB2/UDB)

Responsibilities:

• Managed staff of senior - level DBAs responsible for multiple DBMSs (DB2 for z/OSIMS, UDB) across mainframe and distributed platforms in development/test and production environments.
• Resource planning, recruiting and third-party support management.
• Business continuity planning and exercises.
• Provided timely resolution for day-to-day database-related service requests.
• Extensive user, stakeholder and vendor interaction and negotiations.
• Documented and ensured DBA and application adherence to best practicesprocedures, standards and guidelines.
• Provided support on DB2 for z/OS test/dev/production.
• Initiated and managed project to isolate IMS onto single, smaller LPAR which resulted in a savings of more than $30k/month in licensing costs.
• Employee performance planning, counseling, and evaluation.

Confidential, NJ

Data Modeler & DBA

Responsibilities:

• Logical and physical data modeling support for international customs brokerage system.
• Ensured accurate representation of logical/physical designs within
• ERwin models and corporate repository. Supported enhancements and new business requirements.
• Primary liaison between business & development community and DBA group.
• Recommended and substantiated benefits of physical database design changes.
• Application SQL performance analysis and coding recommendations.

Confidential, NJ

DB2 UDB Database Specialist

Responsibilities:

• Logical & physical database design in a Linux environment. Developed databases for data mining functions using Confidential s Intelligent Data Miner.
• Formulated/documented DBMS standards, procedures and guidelines.
• Performed installation and maintenance of all Confidential software including DB2/UDB and Confidential s data mining products, operating system software (Windows and Unix - based), and network configurations.
• Windows and Linux workstation and server systems and network administration including backup/recovery, security, and shell scripts where appropriate.

Confidential, NY

DB2 DBA and DBA Manager

Responsibilities:

• Logical & physical database design, implementation, performance tuning in a data - sharing environment.
• Definition and maintenance of multi-platform DB2/UDB data replication.
• 24x7 on-call support for DB2 application and DB2 subsystem problems.
• Managed staff of ten DBAs responsible for multiple DBMSs across mainframe and distributed platforms.
• DBMSs include DB2 for OS/390, UDB, OracleSQL Server, and Sybase.
• Business continuity planning and exercises.
• Employee performance planning, counseling, and evaluation.
• Extensive user and stakeholder interaction and negotiation skills.
• Timely resolution of to day-to-day database-related challenges.
• Formulated/documented DBMS and modeling standards, procedures and guidelines.
• Project planning and management for intra-group endeavors using Primavera

Confidential, NJ

DB2 DBA and Data Modeler

Responsibilities:

• Logical & physical database design, performance tuning, standards & procedures.
• 24x7 on - call emergency support for DB2/DBA problems.

Confidential, NY

DB2 DBA and Data Modeler

Responsibilities:

• Logical & physical database design using CoolDBA including: definition and forward engineering of new logical models into physical DB2 design; DB2 implementation of physical models; reverse engineering of existing DB2 databases into logical models.
• Database design, development and support for client/server application executing under Windows/NT accessing data on the mainframe in DB2 via DDCS.
• Technical support provided to managers and developers in DB2 (and non - DB2) applications including remote DB2 application preparation and execution.
• Contingency planning and exercises.
• Performance tuning of existing applications - application SQL & coding, physical database design, etc.
• DB2 subsystem maintenance, performance monitoring and tuning. Tools used include TMON for DB2/MVS/CICS and OMEGAMON.
• 24x7 on-call emergency support for DB2 subsystem and DBA utility problems.
• Initiated/implemented conversion of existing DB2 PLANs to PACKAGEs.
• Creation and maintenance of batch DBA utility job streams.
• Implemented standard procedure to perform archiving of rows in large "active" transaction tables to "historical" tables on optical devices.

Confidential, CT

DB2 DBA & Data Modeler

Responsibilities:

• Provided DB2/DBA development support for International Customer Financing
• System designed to run at multiple sites and/or single - site/multi-country.
• Logical/physical database design; SQL/application performance analysis; DB2 object/data maintenance at multiple test levels; application design walk-thrus.