EXPERIENCE SUMMARY:

• Profile Demonstrate strong teamwork by supporting off - shift work, being flexible, and taking on problems outside of one's assigned area.
• Drive quality improvements.
• Provide feedback to the development team to improve product quality. With over 30 years experience and In-depth professional knowledge of DB2 for z/OS, Datasharing environment, mainframe operating systems z/OS 2.10 and later releases, ORACLE, SQL Servers, SAP, IMS, CICS subsystems.
• Provide recommendations for capacity and performance planning, installation of performance tools, monitoring, tuning and analyzing performance data using WLM, RMF, SMF, SAS, MXG PDB, DB2, CA Tools, BMC Tools and other 3rd party software.
• Apply this knowledge to solve complex software problems within the business unit. Advise other professional on complex issues.
• Demonstrate analytical ability, creativity, and judgment in analyzing, developing and implementing solutions to complex problems.
• Be sensitive to customers' requirements, and translate these into product function.
• Perform upgrades and new installations of DB2 and related 3rd party software
• Perform routine and release maintenance of DB2 and related 3rd party software.
• Perform upgrade and new installations of z/?OS and related 3rd party software.
• Develop/?Execute implementation and test plans for software installations and upgrades.
• Provide system level support for application developers.
• Participate in an off-hours support rotation
• Monitor and support multiple DB2 subsystems.
• Modify and understand the effect of system parameters on the operating environment.
• Participate on projects providing technical assistance.
• Meet with customers as needed to address technical issues.
• Meet with customers as needed to address technical issues.
• Independently set direction and lead team in driving technology decisions, devising solutions to complex database problems and in overall technology planning.
• Strong leadership skills with ability to provide expertise, guidance and constructive feedback to team members.
• Analytical, problem-solving, decision-making and time management skills.

KEY SKILLS:

• Certified DB2 Internals and Externals Skills, Database Administrator
• Experience with mainframe COBOL, JCL, SMPE, IMS, CICS, SQL, ISPF, Platinum, QMF and DB2. Experience with UNIX, ORACLE, WINDOWS, VM, AIX and other platforms.
• Debugging skills including dump and trace reading, complex problem recreations.
• Demonstrated successful problem solving skills, excellent oral and written communication skills. Conducted Performance Tuning on SQL and DB2 subsystems.
• Supported and assisted development and testing teams. Provided preventive maintenance, troubleshooting and quickly resolve problems to ensure infrastructure and application stability.
• Expertise in DB2 UDB, LUW database design with extensive experience with database design and tuning with all DB2 Versions including Data Partitioning Features used in Warehousing, data mining, OLTP and Very Large
• Databases.
• Proven ability to work effectively with all levels within an organization.
• Ability to install, upgrade, migrate, refresh Mainframe DB2 subsystems.
• Expertise in the Installation or migration of DB2 for z/OS V7, V8, V9, V11 and V12
• Expertise in CCSID, UNICODE, SYSSTRINGS conversion, migration, correct errors in CCSID / CODEPAGE discrepancies.
• Skills in DB2 System Services, DBM1 storage tuning, ERLY code, and subsystem settings.
• Skills in DB2 Utilities and DB2 Tools
• Skills in ISV products, such as, CA Tools, BMC Tools, Platinum, Quick Select and other 3 rd party software.
• Skills in DB2 RDS (Relational Database System and Management) components, DDL, Parser, Precompilers, Optimizer, Executives, Task Manager, DDF, RLF, Authorizations, Parallelism, Semantics, BIND, and other components.
• Mainframe DB2 Disaster Recovery skills. High level skill in DB2 system problem determination
• Mainframe z architecture skills. Strong JCL skills and overall Mainframe skills

WORK EXPERIENCE:

DB2 / IMS Systems Support

Confidential, Troy, MI

Responsibilities:

• Demonstrated advanced, in-depth professional knowledge of DB2 for z/OS, z/OS System parameters,
• Distributed, LUW, DRDA, UDB, Websphere Server, Replication, DB2 Connect
• Applied this knowledge to solve complex problems within the business unit.
• Demonstrated advanced, in-depth professional knowledge of IMS 13 and later releases
• Provide technical guidance and support in preparation and migration of several DB2 subsystems to V8, V9, V10 V11, V12 and collecting artifacts before and after an upgrade or major changes.
• Provide technical guidance, planning and support in porting, moving DB2 databases to an ORACLE platform.
• Provide technical guidance, planning and support of ENDEVOR packages
• Provide technical guidance and support in application and DB2 subsystem parameters to obtain optimum performance as well as in IMS 13
• Provide technical direction and system architecture for individual Initiatives. Served as a fully seasoned/proficient technical resource.
• Provide technical guidance and support in application performance testing, problem recreation and troubleshooting

Senior DB2 Advisor,Consultant/Architect,Support,Programmer

Confidential, Jersey City, NJ

Responsibilities:

• Demonstrated advanced, in-depth professional knowledge of DB2 for z/OS, z/OS System parameters,
• Distributed, LUW, DRDA, UDB, Websphere Server, Replication, DB2 Connect
• Applied this knowledge to solve complex problems within the business unit.
• Provide technical guidance and support in preparation and migration of several DB2 subsystems to V8, V9, V10 V11, V12 and collecting artifacts before and after an upgrade or major changes.
• Provide terhnical guidance, technical guidance, planning and support in porting, moving DB2 databases to an ORACLE platform.
• Provide technical guidance and support in application and DB2 subsystem parameters to obtain optimum performance.
• Provide technical direction and system architecture for individual Initiatives. Served as a fully seasoned/proficient technical resource.
• Provide technical guidance and support in application performance testing, problem recreation and troubleshooting
• Provide technical guidance and support in the use of DB2 Tools and Utilities and other 3 rd party softwares.

Database Administrator

Confidential

Responsibilities:

• Demonstrated advanced, in-depth professional knowledge of DB2 for z/OS, z/OS System parameters, Distributed, LUW, DRDA, UDB, Websphere Server, Replication, DB2 Connect
• Applied this knowledge to solve complex problems within the business unit.
• Provide guidance, technical guidance, planning and support in porting, moving DB2 databases to an ORACLE platform.
• Provide guidance and support in application and DB2 subsystem parameters to obtain optimum performance.
• Provide technical direction and system architecture for individual Initiatives. Served as a fully seasoned/proficient technical resource.
• Provide guidance and support in application performance testing, problem troubleshooting and in engaging technical support personnel.
• Provide guidance and support in the use of DB2 Tools and Utilities.
• Manage internal databases, from planning and testing stages through implementation and support.
• In-depth understanding of security and backup procedures to ensure database integrity. Background in developing backup and disaster recovery plans for nationwide offices.
• Superior communication, presentation, analytical and problem solving skill. Work well with all levels of business.
• Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages.
• Over 18 years of experience, including 10 years as DBA in development and production environments.

Senior DB2 Advisor,Consultant/Architect,Support,Programmer

Confidential, Jersey City, NJ

Responsibilities:

• Demonstrated advanced, in-depth professional knowledge of DB2 for z/OS, z/OS System parameters, Distributed, LUW, DRDA, UDB, Websphere Server, Replication, DB2 Connect
• Applied this knowledge to solve complex problems within the business unit.
• Provide guidance and support in preparation and migration of several DB2 subsystems to V8, V9, V10, V11, V12 and collecting artifacts before and after an upgrade or major changes.
• Provide guidance, technical guidance, planning and support in porting, moving DB2 databases to an ORACLE platform.
• Provide guidance and support in application and DB2 subsystem parameters to obtain optimum performance.
• Provide technical direction and system architecture for individual Initiatives. Served as a fully seasoned/proficient technical resource.
• Provide guidance and support in application performance testing, problem troubleshooting and in engaging technical support personnel.
• Provide guidance and support in the use of DB2 Tools and Utilities.

DB2 z/OS Support and System Programmer

Confidential GDF Boulder, CO

Responsibilities:

• Demonstrated advanced, in-depth professional knowledge of DB2 for z/OS, z/OS System parameters, Distributed environments, LUW, DRDA, UDB.
• Applied this knowledge to solve complex problems within the business unit.
• Provide guidance and support in preparation and migration of several DB2 subsystems to V8 compat mode and collecting artifacts before and after an upgrade or major changes.
• Provide guidance, technical guidance, planning and support in porting, moving DB2 databases to an ORACLE platform.
• Provide guidance and support in preparation and CCSID conversion from on several DB2 subsystems.
• Provide guidance and support in application and DB2 subsystem parameters to obtain optimum performance.
• Provide technical direction and system architecture for individual Initiatives. Served as a fully seasoned/proficient technical resource.
• Provide guidance and support in application performance testing, problem troubleshooting and in engaging Confidential, Oracle, Peoplesoft, SAP and other third party technical support personnel.
• Provide guidance and support in the use of DB2 Tools and Utilities.

Advisory Software Engineer

Confidential, San Jose, Ca

Responsibilities:

• Demonstrated advanced, in-depth professional knowledge of DB2 for z/OS. Applied this knowledge to solve complex software problems within the business unit.
• Advised other professional on complex issues. Demonstrated analytical ability, creativity, and judgment in analyzing, developing and implementing solutions to complex DB2 problems.
• Sensitive to customers' requirements, and translated these into product function. Developed, enhanced, debugged, supported, maintained, and tested software applications that supported business units or supporting functions (these application program solutions may involve diverse development platforms, software, hardware, technologies, and tools)
• Maintained ownership of Problem Records (PMR) to resolution by driving to resolution technically or by driving development. Participated in the design, development, and implementation of complex applications, often using new technologies
• Acted as a Team Leader to provide, manage, mentoring to associate engineers and assisting in performance reviews, individual development plans.
• Provide technical direction and system architecture for individual Initiatives. Served as a fully seasoned/proficient technical resource
• Worked under minimal supervision

Sr. Systems Programmer Mainframe,

Confidential, Dublin City, CA

Responsibilities:

• System generation
• Operating System upgrades and migrations. Operating System performance monitoring and tuning
• System resource utilization collection and reporting
• System Maintenance (PTFs, APARS, PUTs, etc.)
• System/user software package installation
• Develop system utilities using user exits, or vendor packages
• Special purpose command list (CLIST), REXX procedures and script development for Operators/customers
• Data communications/networking systems analysis and support
• S ystem problem analysis, resolution, and documentation
• Develop customer CLISTS, REXX procedures, scripts and JCL PROCS
• Document all system procedures, scripts, JCL, CLIST’s and EXEC’s.
• Assist in establishing recovery procedures needed by customers (i.e. checkpoint/restart indepth knowledge of dasd management, SMS, HSM