OBJECTIVE:

DB2 Systems Programmer or DB2 Performance Engineer on z/OS and z/Linux

SUMMARY:

• Over 25 years of DB2 systems programming and database administration experience with special expertise in DB2 installation, migration, monitoring and tuning, Confidential good knowledge of Buffer pool tuning and I/O management in various operating system platform.
• Also experienced in software evaluation, benchmark competitive product, advice and recommendation for SQL process, plan and implementation of disaster recovery exercise.
• Strong expertise in product installation, migration and customization of DB2 up to V11 for z/OS.
• Significant experience in system level performance tuning such as Buffer Pool, EDM pool, RID pool, Sort pool, system checkpoint and I/O management.
• Knowledge of z/OS internal, Coupling Facility structure and significant experience in performance analysis in Data Sharing environment.
• Proficient in using tools such as DB2 performance Expert, CA insight, BMC mainview.
• Strong expertise in DB2 performance traces and IFCID analysis.
• Strong familiarity with vendor contact for software problem symptom and diagnosis.
• Proficient in coding SQL, Clist, Rexx and assembler
• Conversant with DB2 LUW maintenance procedure using Fix Pack, PTFs and APARs.
• Strong knowledge in software maintenance procedure using SMP/E process.
• Proficient in using 3 rd vendor db2 tools such as CA DB2tools, Detector, subsystem analyzer, BMC utilities, change manager, catalog manager.
• Strong performance analysis experience in 3 - tier system environment including isolating, identifying and resolving bottle-neck in end-to-end network.

SKILLS:

• DB2 on ZOS
• DB2 LUW zLinux
• IMS on ZOS
• DB2

SOFTWARE:

Technology: DB2 LUW v10.5, DB2/ZOS v11.1, DB2 connect, DB2 Omegamon performance ExpertSMP/E, CICS, SPUFI, MQ series, DB2 Data Sharing, TSO, QMF, IMS DB up to v11, OPCWebSphere, DB2 data propagator, Infosphere Replication Server, DB2 encryption tools, Confidential

DB2 Analytics: Accelerator, DB2 tools, Tivoli Decision Support, Capacity Management Analytics

BMC: Patrol, Catalog Manager, Change Manager, DB2+utilities, Mainview, Smart DBA, Delta IMS

CA - Platinum: Detector, RC/Migrator, RC/Update, Subsystem Analyzer, Database Analyzer, Insight

Others: File-Aid, Omegamon, TMON, Quest central DB2/Oracle, PeopleSoft HRMS/Financial/CRMSAP, Informatica Power Exchange replication, PL/1, COBOL, Oracle Transparent Gateway for DB2

PROESSIONAL EXPERIENCE:

Confidential

Sr. DB2 systems programmer

Responsibilities:

• Currently working as Confidential systems programmer for DB2 data sharing subsystem planning, migration, configuration and troubleshooting performance bottlenecks in SQLs, DB2 10 sub system on DB2 for z/OS.
• Strong Experience in DB2 migration procedures on data sharing environment. maintain up-to-date DB2 for z/OS and 3rd party products
• Plan, lead and implement DB2 z/OS v10 to v11 migration in CM, ENFM and NFM
• Participate mainframe system capacity planning and guide performance tuning strategy and guide DBA team members for technical update and new function of DB2

DB2 consultant

Confidential

Responsibilities:

• Planned and wrote DB2 migration procedure document on data sharing environment.
• Participated client system capacity planning and guide DB2 performance tuning strategy guide DBA team members for DB2 compatibility issue report fix as part of migration project

Confidential

Sr. DB2 systems programmer

Responsibilities:

• Troubleshoot client’s DB2 system problem and recommend, guide performance tuning
• Monitor and tuning DB2 configuration using DB2 tools
• Plan and implement DB2 z/OS v8, v9, v10 migration in compatibility mode, ENFM and NFM
• Participate client system capacity planning and guide performance tuning strategy and guide team member for technical update and new function of DB2/IMS

DB2 Consultant

Confidential

Responsibilities:

• Installed and customized DB2/zOS V8 and initial performance tuning
• Installed and customized DB2 PE and Query analyzer configuration setup
• Planned and implemented DB2 V8 performance assessment and tuning

Confidential

Senior Systems DBA

Responsibilities:

• Installed, customized and tuned DB2 v8 on ZOS using SMP/E in CBPDO
• Captured and analyzed SQL activity for performance tuning
• Planned and implemented DB2 disaster recovery procedure
• Monitored and analyzed through Web, App and DB servers for performance tuning

Environment: DB2/ZOS v8.1, DB2/UDB v8.1, DB2 Connect, PeopleSoft CRM v8.9, DB2 PM, Oracle 9i

Confidential

Database Administrator

Responsibilities:

• Troubleshot 2/3 tier problem diagnosis and resolution among Web/Application/DB2 server
• Performed SQL tuning and advice subsystem tuning for Dynamic SQL
• Initiated, planned and implemented DB management using DB2 V7 utilities

Environment: DB2/ZOS v7.1, Platinum, DB2 Connect, PeopleSoft CRM, DB2 data sharing, Omegamon

Confidential

IMS/DB2 Systems DBA

Responsibilities:

• Performed DB2 production maintenance support and performance monitor/tuning
• Installed and customized DB2/UDB and DB2 Connect
• Fixed application problems and performed SQL tuning

Environment: DB2/ZOS v7.1, DB2/UDB v8, BMC Change Mgr, DB2 Connect, IMS, AIX

Confidential

DB2 Systems Programmer

Responsibilities:

• Planned, installed and customized People Tools for DB2 ZOS/AIX
• Provided DB2 production maintenance control and subsystem performance monitor/tuning
• Analyzed and solved PeopleSoft Dynamic SQL performance tuning
• Backup support for CICS maintenance

Environment: DB2 v6.1/v7.1, PeopleSoft, WebSphere, BP tools, Platinum, TMON, DB2 Connect

Confidential

DB2 systems DBA

Responsibilities:

• Performed DB2 production/development support and Oracle Production with Data warehouse
• Performed Data modeling, physical/logical design with Erwin
• Initiated and implemented DB2/UDB EEE cluster on new infrastructure

Environment: DB2 v6.1/v7.1, Oracle 8/8i, PeopleSoft, DB2 connect, WebLogic, Solaris, AIX

Confidential

Responsibilities:

• Provided DB2 and IMS production control and preventive service
• Performed Application problem determination and SQL tuning
• Implemented DB2 data from/to Oracle DB through MQ series to synchronize data

Environment: IMS, DB2/OS390 v5.1/v6.1, UDB v6.1, Oracle v7/8, HP-UX, BMC, IMF, File-Aid, MQ

Confidential

Integration Specialist

Responsibilities:

• Planned and implemented benchmark distributed DB2/Oracle DB
• Performed analysis for DB products on end-to-end IP/SNA data network
• Did Benchmark setup to measure data traffic performance with complex Query

Environment: DB2/MVS, DB2/6000, Oracle, SQL server, MVS, Solaris, HP-UX, TCP/IP, SNA

Confidential

Systems Programmer

Responsibilities:

• Monitored production and maintenance on CICS, VTAM and MVS
• Assisted in application problem determination
• Configured and monitored DB2/6000 on AIX

Environment: MVS/ESA, CICS, AIX, DB2/6000, VTAM, TCP/IP

Confidential

Systems Engineer

Responsibilities:

• Performed MVS, IMS/DB and DB2 troubleshooting and system performance tuning
• Consulted in the migration of IMS/DB into DB2
• Planned and advised Clients’ capacity planning in MVS, CICS and DB2

Environment: MVS/ESA, CICS, DB2, IMS DB/DC, BMC, Platinum, Amdahl UNIX