1)Make sure database archive jobs successful.2)Resolve the problems related database, such as archive failed, deadlock, etc.3)Perform DBspace Reorganization and add dbspaces on required.4)Install FP and upgrade DB2 version on z/Linux.5)Application support (24/7 maintenance), provide trouble shooting and problem reproduction. Communication with India/Netherlands/Wuhan development team and customers.6)develop and maintenance automation tool.7)Applications support and join in project when required.Key skills/Technical Qualification1. Maintenance DB2 servers for z/VM and z/Linux.2. Professional at REXX programming.3. Good at communication and reporting in English.4. Good at documentation for issues, S1 incidents, etc.5. Familiar with program language like shell, C, phython.project in 2016: OPM( IBM Operations Manager for Z/VM 1.5 ) Duration: about 6 months. Purpose: OPM replaces the old tool HMF Maintenance Environment. Description:I mainly lead this project. Phase 1, I prepare the documents in advance, such as HMF configurations translated to OPM, OPM servers build, storage/DASD configuration, creating profile and customization profile. It took about 3 weeks. Phase 2, With the help of my leader and architect from Netherlands, I update the local code, test it and make sure that it works in OPM. It took a long time, about 3 months. The last phase, prepare change and move it to PROD.Project in 2013: DB2 upgrade Duration: about 2 monthsPurpose: meet the security requirementDescription:We work together with TE team. TE is responsible for the installation of the software and I focus on the DB related tasks, such as upgrade the instance and database, testing, etc.Firstly I will upgrade the database on test database. Then I will schedule changes to do it on SIT, UAT, PROD per application. FP installation is about every 3 to 6 months.

12/2010 - 07/2011Oracle DBA and PL/SQL Developer in Bleum Incorporated,Shanghai.1. Problems shooting and tracking, ensure the data integration.2. Offer support for statistics, analysis and regular and temper reports to the provision of customer requirements.3. Provide high quality customer service and technical support to customer, data change should follow work flow and the policy.4. Focus on DI management and DI report. Daily DI tickets allocation, weekly DI reports to Manager Group and check in CVS Server. On team weekly meeting, we’ll discuss the top 3 and give advice and suggestions5. Response for issue resolution documentation, knowledge share in team and new comer training.6. 7*24 service for urgent troubleshooting and bug fixing.

I mainly focus on the SQL programming. Our architect have finished the documents, such as creating main tables and indexes. I extract the data from spreadsheets from provinces. Transform it and load the final “clean” data into the database. The main procedure is about 700 rows and it calls several small functions.

05/2008 - 07/2010 Desktop Business application Engineering1. OA system daily maintenance, including OA database management and security.2. Error message analyze and tracking, make sure accuracy of data.3. Combine system process and business logical during DML. Any change should follow the policy.4. Case management and report. Daily tickets process and monthly case report to the manager. On semimonthly team meeting give feasible advice for top 5.5. Problem shooting and high quality customer service.6. Sensitive to SLA and professional in knowledge documentation for supporting and new comer training.

IT assistantResponsibilities：OA system maintenance, End-user Q&A, Remedy ticket resolution, data change via PL/SQL, such as DML, Cursor usage. Weekly Report to the manager and give available suggestions.1. Database management and maintenance. Regular check and monitor according the list.2. Any DML script should be reviewed by the manager before updated in production. And there must be before/after snapshot.3. End-user support via E-mail and Phone, and new comers training.4. Documentation updated, which should be approved by the manager and then check into Server.5. Weekly Remedy tickets report to the manager, discuss top 3 and give available suggestions.