SUMMARY:

20 years working experiences in information technology Industry, which include 6 years DB2, Tivoli, Lotus Notes technical support on Open System - -Unix/NT in Confidential China, 14 years DB2 DBA on Unix in North America, two years C programmer experience and some Oracle DBA experience.

COMPUTER SKILLS:

• DB2/UDB Lotus Notes/Domino AIX Windows server, Windows 7 OS/2 Warp DB2 Connect Solaris TCP/IP NETBIOS SNMP TIVOLI
• ORACLE ACCESS SYBASE ODBC UNIX (KORN) SHELL
• PERL C/C++ JAVA NETVIEW Websphere SQL
• SSL Foglight LotusScripts MQSeries FTP TELNET
• DNS Linux Autosys SQL Replication Q-Replication

WORKING EXPERIENCE:

Confidential

Senior DB2 DBA

Responsibilities:

• Application DBA as well as provide third line production support for production DBA.
• As application DBA, we provide DBA expertise in project development, contribute DBA expertise on architecture design, perform logical and physical database design, SQL tuning and database configuration performance tuning and mornitoring. ( monitoring whole DB system performance like CPU and I/O memory usage status using vmstat or iostat, monitoring database performance like memory usage, lock status, application transactions through db2 snapshot, db2 admin view and table functions,DB2 utilities like db2pd, db2top).
• I also setup data synchronization using Confidential SQL replication between two applications to performing near real time replication which including replicate CLOB data. I also tested the replication time in DEV environment using production volumn to test the CLOB data replication performance impact.
• I’m responsible for one core banking application--- branch sales and service application, which is used by all the branches. It is a complex system, since it is not only had transaction system function, also had analyse function in the application. So, we had couple databases to provide this function, which involved a lot of stored procedures, some triggers and quite complex SQL tunings.
• Explore and research Puresacle technology in our environment, get onsite training on purescale from Confidential expert, setup Sandbox for proof of concept for the purescale technology.
• I kept on improving DBA work, like using new DB2 features to reduce database maintenance windows(online reorg), improve database response time(auto runstats) and enhance database availability (integration with foglight monitoring tools to prevent database issue).

Confidential

Senior DB2 DBA

Responsibilities:

• Application is 24*7 Online Banking Application. The environment is three tier environments, Application Server is called FFI—java based vendor Software, hosted by Confidential Websphere Server, backend is DB2 UDB database in AIX. I’m responsible for database capacity planning, database maintenance and troubleshooting, database backup using EMC legato server/ NAS device later. The database servers are running on clusters with failed over functionality. We use VERITAS software to replicate data from production side to Disaster Recovery Server side.The data is async replicated.
• Support Enterprise Reporting database warehouse environment, which running on 4 physical nodes, 26 partitions, the database around 3 TB. Provide DSS support for the user.
• Also support other DB2 servers across multiple platforms, (Linux, Solaris, windows) applications including Content Management (CM), CMOD, ITIM, PASSMARK.
• DB2 on windows is cluster environment.
• Support connection to mainframe database through DB2 connect gateway server.
• Use Database federation functionality to transfer data across different DB2 environments.
• Write Perl, shell scripts for daily database admin activity.
• Troubleshooting and performance tuning for the database issue.
• Monitor database using CA DB2 database monitor modules,

Confidential

Senior DB2 DBA

Responsibilities:

• Build new database, design physical database model, and implement physical database objects based on ERWIN model (ER Diagram).
• Performance tuning for the new database, including tuning configuration parameters, tuning query based on the DB2 explain and use MQT, MDC to increase the query performance, using db2pd, db2dart tools to troubleshooting.
• Setup database security policy. .
• Database capacity planning.
• Database backup and recovery design using TSM (Tivoli Storage Manager).
• Database production support and troubleshooting.
• DBA support for ETL developers and support for interface with AB initio ETL tool.
• SQL query tuning through explain and using Query Patroller(DB2 Workload Manager) to investigate and filter out expensive SQL.
• Automate monitor activity by UNIX scripts and Perl scripts, writing triggers and stored procedures to strengthen business rules and optimize applications development.
• Oracle database development and implementation for FRS system.
• Oracle database backup and recovery planning.
• Oracle advanced security implementation. ( SSL over TCP/IP )

Confidential

DB2 DBA

Responsibilities:

• Design physical database layout based on the different function models.
• Design and implemented online and incremental database backup and disaster recovery plan using TSM.
• Database performance tuning and troubleshooting using DB2 tools and utilities such as snapshot monitors, event monitor, DB-GUYS and UNIX system monitor tools—vmstat, iostat and topas. Refining the database configuration parameters.
• Designing the plan to move the data warehouse from old SSA storage to new ESM storage, and redistribute data to the new containers.
• Database migration from Sybase to DB2 data warehouse database, including the data extract, transformation and conversion.
• Daily database administration and maintenance in DB2 UDB EEE environment.
• Complex SQL tuning for the application including rewrite the SQL, create indexes and summary tables based on the SQL explain.
• Write triggers, stored procedures using SQL procedure language: java and C.
• Develop process for the new projects, troubleshooting and optimization of the existing ETL process using informatica.
• Complex queries from data warehouse for the BI team.
• Writing some procedures, functions using TOAD for oracle database.

Confidential

DB2 DBA

Responsibilities:

• Design database physical layout using ERwin, created reports on database model (Entities, attributes) through ERwin tools. Maintain and track different model version.
• Setup database three-tier environment which include backend --DB2 UDB, middleware--Sybase EA Server, Front-end GUI application developed by PowerBuilder. Plan for the DB2 implementation including database sizing, new volume group, logical volume, file system, how data placement on disks.
• Designed and implemented Backup and Disaster Recovery Plan using TSM.
• Designed and implemented security plan.
• Performance tuning and troubleshooting the database server. Developed application and database system update process.
• Wrote stored procedures using SQL and Java, enable debug function for stored procedure builder in development environment.
• Changed Database structure, extracted and loaded data. Automated routing operation using Korn shell, Perl scripts and SQL scripts.
• DB2 SQL coding support for the applications development team.
• Use crontab to automate system operation. Using vmstat, iostat to check the system I/O and CPU using condition.
• Designed and implemented the database file system structure and mirrored some important file system.
• Database capacity planning and monitoring.

Confidential

DB2/UNIX System Administrator

Responsibilities:

• Installation and configuration DB2 UDB EE and EEE on UNIX.
• Built large database (1TB) using different physical layout for best performance.
• Protected database log and data using raid5 and raid0 technology.
• Loaded data into the database, analyze and tuning the performance issues using UNIX and database performance tuning tools and database configuration parameters.
• UNIX system Installation, configuration and update.
• MQseries installation and configuration which include definition of queue, channel and cluster.
• Websphere installation and configuration which include web server configuration, Load balance configuration, security consideration, clustering configuration.

Confidential

Post Sale Technical Support on DB2

Responsibilities:

• Confidential OS/2 helpdesk hotline service
• Confidential internal helpdesk service
• Post-sale technical support on UDB implementation which including database installation and customization on open servers
• Database physical and logical design support according to customer requirement.
• DB2 SQL coding support on application development.
• Technical support through the whole project phases which including application development, Unit Testing, System Testing, UAT and production phase.
• Database system performance tuning and troubleshooting in production environment.
• Database system update and application migration.
• Supporting on database Backup and restore strategy and tuning their performance.
• Recognition Award for Successfully implementation country wide DB2 project in Confidential China.