PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Database Administrator

Responsibilities:

• Provided remote database administration functions in support of international investment bank processing. Production environment complexity involved multiple LPARs, each with multiple DB2 subsystems to provide worldwide regional support.
• Client - developed tools interfacing with IBM DB2 Solution Packs utilities and DB2 Automation Tool used to manage DB2 in Production and test environments, and manipulation of object, utility, and job profiles performed to adjust and adapt target maintenance activities. Support provided for maintenance schedules; Problem Determination and Resolution. DBA support provided for DB2 upgrade strategy and implementation, staggered across development and production environments.
• Client-developed tools interfacing with IBM DB2 Administration Tool used to facilitate application development changes. Scheduling and coordinating with DBA team members on production (and test) environment deployments of multiple project implementations across multiple LPARs, Data Groups, and DB2 Sub-systems.
• Nominal interaction with IBM DB2 Log Analyzer utilized in support of application-related data recovery. Nominal research and problem determination support provided for z/OS DB2 to Z/OS DB2 Q-Replication.

Confidential, Minneapolis, MN

Data Replication AdministrationConsultant

Responsibilities:

• Provided technical support for the Department of Health and Human Services’ (HHS) Centers for Medicare and Medicaid Services (CMS) data replication architecture. Using IBM’s InfoSphere Information Integration product, Q-Replication, data replication implementation and support is provided for data replication between multiple environments; uni-directional replication for z/OS DB2 (v10.5) to zLinux DB2 LUW, uni-directional replication for z/OS DB2 to z/OS DB2, uni-directional replication for z/OS DB2 (v10.5) to Unix-based Oracle, and Peer-to-Peer between multi-nodes of zLinux DB2 LUW.(v9.7.7).
• Contributed Linux shell script development for diagnostic and configuration automation and validation, and scripts to simplify and consolidate process control for Q-Capture, Q-Apply, and Replication Monitoring Linux/Unix processes. Supported z/OS Rexx exec development for JCL job management and documentation automation for replication subscription management and ETL (Informatica v 9.5) automation.

Confidential, Fredericksburg, VA

Enterprise Metadata RepositoryConsultant

Responsibilities:

• Provided support for Social Security Administration’s initiative to implement an Enterprise Metadata Repository using Computer Associates’ MetaData Repository product. Support provided for implementation methodology and planning, and project documentation, general consulting support as Subject Matter Expert for Repository use in active mode (Data/Data Base Administration), Repository maintenance strategy, and interim solutions for transitioning metadata between tools (ETL development using Rexx).

Confidential, Owings Mills, MD

Data Base Administration

Responsibilities:

• Lead DBA - Data Base Administration activities were performed for multiple Data Base Management Systems (DBMS’s) on multiple hardware platforms.
• Data Base Administration for z/OS operating system included support for the IBM DB2 Data Base Management System (DBMS) and the IBM IMS DBMS.
• Application DBA activities involved DB2 database design and metadata maintenance using CA Metadata Repository and ERWIN, application development support for queries to the operational system and ad hoc reporting from the data warehouse, and IMS control block coding in support of application maintenance. Provided consultation on access path optimization and provided problem determination in support of application performance and abends.
• System DBA activities involved general sub-system performance and maintenance strategy, and disaster recovery strategy. Created database utility JCL for database maintenance and disaster recovery support for the operational system and legacy data warehouse using both IBM and BMC utilities. Monitoring DB2 database performance using ASG TMON toolset (formerly Landmark), Omegamon for DB2, and STROBE. Performed configuration and trouble-shooting support for DB2 communication gateway product for midrange application and Personal Computer interfacing. Created database utility JCL for database maintenance and disaster recovery support using IBM and BMC utilities. Implemented compression technology features in IMS databases. Performed and assisted in program product problem determination for DB2 and IMS for z/OS and application transaction handling program products (CICS).
• Extensive use of MVS utilities, REXX, and CLIST in support of database maintenance, automation efforts and program product management support (Computer Associates AllFusion Repository for MVS maintenance and upgrades, and installation and configuration of BMC Recovery Manager for DB2).
• Data Base Administration for midrange hardware platforms included support for Oracle DBMS in Hewlard Confidential HP-UX Unix, IBM AIX Unix, and Microsoft Windows Server operating systems.
• System DBA functions included Oracle Enterprise Edition program product installation, patching, and upgrading versions (from version 7 to version 11i) across test and production environments in accordance with vendor and industry standards. For individual instances, custom application-based configuration and tuning to optimize performance based on application specifications was performed. Database maintenance and facilities for disaster recoverability were implemented with database utilities from BMC and IBM’s Tivoli products (RMAN compliant) in conjunction with UNIX shell scripting and facilities. Database and program product feature (ASM, RAC) performance monitoring, log monitoring, and problem determination was performed using Oracle Environment Manager (OEM) database monitoring tools in conjunction with SQLPLUS procedures and Unix shell scripting and facilities.
• Oracle designated “Application DBA” functions for this site included installation, patching, upgrading, and configuration of Oracle Financials E-Business Suite (originating version 10.7 with upgrades to 11.5.10.2) and all supporting program products (Apache, Discoverer, etc.) and features (Form server, Report server, Load balancing client/server, etc.) required for operation in a multi-tiered configuration. Application control, log monitoring, and problem determination were performed using Oracle Application Manager (OAM) in conjunction with SQLPLUS procedures and UNIX shell scripting and facilities.
• All major projects across all platforms were planned, developed, documented, and communicated using Microsoft Project. Other duties include recommending and conducting software trials/evaluations for after-market products, documenting comparison benchmarks, and maintaining industry standard DBMS Disaster Recovery procedures documentation.

Confidential, Washington, D.C

Data Base AdministrationContractor

Responsibilities:

• As part-time consultant, administration and maintenance on DB2 for z/OS sub-system was performed. Completed and standardized Disaster Recovery documentation to department standards, and built and implemented of suite of DB2 utilities for standard database maintenance. DB2 sub-system parameter analysis performed and developed DSNPARM modifications to address sub-system performance and minimize deadlock issues. Performed program product upgrade strategies for System Programmer and developed and documented plans for “Y2K” compliant OS/390 DB2 upgrade path.

Confidential, Hanover, MD

Database AdministrationContractor

Responsibilities:

• In support of Customer Information System (CIS) development project, system DBA duties performed included; customizing PLATINUM tools product set to expedite DBA functions related to test environment maintenance, migration, and recovery, implementing and testing REXX Automation Feature of CDB SuperUtilities (SuperCopy and SuperReorg), and developing REXX executables to generate user-defined DB2 storage parameters and DSN1COPY JCL for data migration.

Confidential, Valporaiso, IN

Data Base Administration Contractor

Responsibilities:

• The Order Fulfillment System (OFS) project facilitated the migration VSAM-based legacy application to MVS CICS/DB2 and Natural/ADABAS environment. DBA support efforts consisted of; 1) database maintenance and tuning activities for the Data Warehouse team utilizing PLATINUM DB2 utilities and tools and 2) managing a multiple instance environment for application roll-out for over 2300 employees over a two week period. environment duties required the development of an environment refresh regiment to selectively reload each environment containing approximately 700 DB2 tables and 40 ADABAS V5.1 database files, daily.

Confidential, Chicago, IL

Database Administration

Responsibilities:

• Technology Specialist - DB2 Data Base Administrator in support of US marketing, customer, retail sales, product service, and accounting (A/R, A/P, Invoice) applications for nationwide retailer in 24-7 shop.
• System DBA responsibilities consisted of DB2 data base maintenance and disaster recovery support using BMC DB2 utilities and tools for databases with DASD utilization of over 40 Gigabytes. JCL and MVS utilities were extensively utilized in support efforts.
• Application DBA responsibilities included targeted database performance tuning assignments, development application design support and database design using PACBASE CASE tool.

Confidential, Bannockburn, IL

Data Base AdministrationConsultant

Responsibilities:

• In support of a new IT organization for the Prescription Services Division, consultation was provided for functional integration of new DB2 DBA department into development activity. A strategic outline was created for the Data Administration and Data Base Administration groups to enhance productivity by customizing PW System Management Methodology in Data Resource
• Planning and Custom Software disciplines by extending the client’s procedures and guidelines for DB2 logical to physical database design and enhance understanding and involvement in development process. Additional duties included creating conceptual overview for use of the Bachman Tool Set for logical to physical database design for, and developing project management plans for revision of application requirements, application-specific Data Flow Diagrams to support requirements validation, and COBOL data analysis programs in support of ETL efforts.

Confidential, Irving, TX

Data Base Administration - Support

Responsibilities:

• Duties performed supporting application development included business process and data analysis, data modeling, and data base design (DB2). Metadata management and database implementation performed using IBM DC/DB Data Dictionary, and CASE tools (BACHMAN and KNOWLEDGEWARE). Application modeling/profiling efforts were performed using Confidential Crystal and IBM PROTOTYPE II. ETL methodologies for database transition (from ISAM/BSAM file system to DB2) were developed using IBM’s DXT program product. Some development support was also provided using REXX.
• Duties performed for system DB2 DBA included configuring distributed database application architecture to facilitate price announcement process with internally designed DRDA extension, data base performance monitoring and problem determination analysis using IBM DB2PM and Candle OMEGAMON, and extensive use of JCL, MVS utilities, and DB2 and IMS database utilities for database management, maintenance, disaster recovery support in production and test environments, and, additionally, application support for applications using SQL/DS in VM/370 environment.
• Temporary application requirements assignment provided in several project management disciplines including IBM Application Design Methodology (ADM), Integrated System Design Methodology (ISDM) procedures, Joint Analysis and Requirements (JAR), and Joint Application Design (JAD).

Confidential, Bethesda, MD

Function Test / Quality Assurance

Responsibilities:

• Developed test plans from application requirements. Test plans described constraints and goals of the test effort; scheduling, resource configuration, staffing, and . Implemented application test plans to insure system integration, functional accuracy, and data integrity of development projects. All related documentation associated with tests performed using HTML.
• Tasks related to preparing test environments required various data base and general computing tasks. These tasks involved use of CICS DC commands, IMS commands and utilities, DB2 commands and utilities, and MVS utilities. Site citation was ed for graphic design of test environment configuration documentation.

Confidential, Bethesda, MD

Computer Operator

Responsibilities:

• Manual initiation and control of system resources, started tasks, batch job schedules, and transaction processing environments on multiple MVS systems. Expertise developed in MVS commands, JES2 commands, JCL, and MVS utilities. Level one problem determination and IPL support.