Sr DBA

JONATHAN Y CHEN

**** ***** ***.

Sunnyvale, CA **089

Home: 408-***-****

Cell: 650-***-****

Email: ********@*****.***

********@*******.***

CAREER SUMMARY:

Designed, planned, converted, Modeled (reverse engineering), and implemented database projects via multiple platforms (UNIX-AIX, Solaris, Linux, Mainframe and PC) as Senior Developer, As DBA Technical Team Lead and hands on DBA, worked on DB2 UDB ESE Version 9.1 fixed pack 6a migrating to UDB DB2 9.7 fp3a on power 770 machine. Ensure High Availability Disaster Recovery in a 24X7 X365 environment. Experienced in SQL Server 2008, Erwin r8, Tivoli system management Admin, Tivoli Data Warehouse Admin, Shell script Developer, C/C++ programming and Unix Admin. Routine tasks include the 24X7X365 database high availability, fine tuning database to assure high through-put and performance, Database redesign and Query editing, SQL query optimizations, System I/O efficiency, and memory allocation.

Assignments include setup high availability disaster recovery connection among databases. Be responsible for the development of Reporting Mechanisms. The older one is to use Crystal Report to report ETL data. The new one is to ETL the data using Informatica and reports with an Oracle BI interface.

Formerly, developed telecomm software in Lucent Technologies, converted DB2 to Oracle databases in Novus Inc, migrated IBM mainframe applications (COBOL TO MICROFOCUS COBOL) to UDB-DB in Blue Cross and Blue Shields, Chicago Illinois. Initiated and migrated IBM Mainframe financial packages to AIX/Solaris/UDB-DB in Deutsche Bank Baltimore, redesign UDB-DB system for APWUHP Silver Spring Maryland, redesign and plan Tivoli Data Warehouse. Redesign and configure IBM content manager UDB DB2 8.2.1 databases. Upgrade UDB-DB2 from 7.2.8 to 8.2.0, ITM 4.2.1 to 4.2.3 in Lockheed Martin (Center for Medicare and Medicaid Service) and installed Inventory, CCM, and IBM Tivoli Monitoring software. Installed Tivoli Data warehouse 1.3. Establish Physical partitioned database on clustered network nodes (db2nodes.cfg – distributed databases). Installed and configured IBM Q-Replication (WII) on UDB DB2 8.2.6 on Solaris version 9 and 10, DB2 Federated system – Integration between all types of databases. Install IBM content manager Server and resource manager databases. Install ITCAM version 6.1 on AIX 5.2 machine. Designed dimensions on fact tables and data mart star schema, managed subject area (ETL: store procedures), warehouse sources, warehouse targets, warehouse schemas, administration. Be responsible for all monitoring, fine tuning, maintenance of all above databases and all disaster recovery procedures including standby and mirror image.

Upgrade all UDB DB2 from version 8.2.7 to version 9.1 for CMS. Maintain data movement between Mainframe and Oracle data server via Federated system. Installed Oracle 10g database on both Window and Solaris systems. Worked in

AMERICA POST WORKER UNION HEALTH INSURANCE on DB2 AS400/zOS system.

Experienced in KORN Shell, NAWK, C++, C, Studio.net, Visual Basics, JAVA Script, Job Control language, COBOLII, CICS-DB2, VSAM indexed file handling, Relational Database management systems, SQL and database API developments, DB configuration/High Availability Clustering on AIX/Solaris, Access, and SQL2000.

Familiar with JAVA, Perl 5.0, Experiences in trigger (In Oracle, COBOL and others), P/L Stored Procedures (In Oracle, COBOL and PL/SQL), User Defined Function trigger (In Oracle, COBOL and PL/SQL), integrated IBM WebSphere and Web Server Applications, Setup and maintain IBM Tivoli Date Warehouse. Proven leadership and peer relationship. Seek DBA, Data Architect positions.

TECHNICAL SKILLS:

1. Strong UNIX (Solaris, HP, and AIX, 15 years) background and language such as vi, ex, sed, ed, C/Korn Shell(> 15 years), SCCS, CVS, NAWK, C( 8 years ), C++( 5years), PERL/PERL-OO( 3 years). Extensively applied skills include Regular Expression match and Pattern with PERL, C builder, NAWK and UNIX Shell Scripts, Built JDBC-ODBC, DBI and DBD for UDB-DB2 and many GNU software on UNIX boxes.

2. Database Experiences - Recently, converted from file system to DB2 database 9.7.2 on IBM AIX 6.1. Previously, worked on SQL SEVER 2008 2R, Oracle 10g, IMS-DB and -DC, CICS, DB2 on IBM, VSAM indexed file handling, Relational Database management systems, and converted DB2 to Oracle Database for Novus. A SQL-PL developer using Visual Basics 6, C++, PERL, Developed Access DB applications with VB6, C++. Highly skilled in JAVA /Shell scripts (including import, load, stored procedures, UDF and triggers), skills converging in UNIX System (> 10 years), DB2-UDB database administrations (10 years) and Tivoli Storage Server administrations. Built DBI and database driver JDBC4-ODBC for PERL, and UDB databases. Experienced in Design tools such as Erwin r8, CASE and automatic SQL generating third party tools. Partition database, set up High Availability Cluster Multi-processing. Installed IBM content manager – library server and resource manager databases. Create and deployment of stored procedure, User defined Functions. Experienced in Q-Replication of data from Mainframe DB2 database to Oracle databases. Experience in installing Oracle database 10g on window and Solaris.

3. Data Warehouse – Building Tivoli Data Warehouse 1.3 in Lockheed Martin. Install Crystal report V10 and configurations. Modify store procedures for ETL performance efficiency.

4. Legacy system – Developments, Conversion and maintenance, experience includes IBM Mainframe, IMS-DC, IMS-DB, CICS, COBOLII (10 years), and COBOL390 (2 year). Developed skills in AIX environments (> 5 years) using DB2 (>5 years), IMS, SQL, MF-COBOL to handle crisis and enhance general performance. Data migrating between all systems (Mainframe, PC and UNIX). Converted JCL to Korn Shell scripts to run on UNIX systems.

Visual studio .net – Developed software and application using enterprise and professional versions of Microsoft Visual Studio .net including C++, C# and Visual Basics 6. Commendable skills in active-directory (Window 2003 Server) for web security and privacy implementation, hands on Cisco rotor – TCPIP, HTTP.

Operations of Red Hat Linux Operating System (version 9), MEPIS and SUSE 9.0 from installment to support. Install UDBDB2 8.2.2 on PC/Linux. Incorporate IBM WebSphere-applications to UDB-DB2 on Linux operating system. Created TCL, KORN Shell, and PERL on Linux kernel 2.6.

Database Programming Experiences – Embedded CICS/DB2 programming, Batch DB2 programming. PL/SQL, Access programming using Visual Basic 6.

PROFESIONAL EXPERIENCE:

DB2 - Independent Consultant:

Feb 11, 2011 – March 3, 2011

Temporary Assignment: Sprint, Inc. Feb 11 , 2011

Focused on DB2 stored procedure and function coding, debugging db2expn, MDC table load and refresh.

Performance Tuning.

Installed DB2 V9.5 and DB29.7 database on AIX OS system.

Set up high availability disaster recovery among 12 databases in different locations and servers.

Setup db2 database maintenance procedures’

Initialize db2fmc and automatic db2start during reboot process.

Set up raid 10 on IBM X machine.

Install and configure Websphere replication server on Linux.

Configure Q replication into DB2 server with active high availability

disaster recovery (active hadr).

Transportation Security Agent

(CONVERGENZ)

132 National Business Parkway

Annapolis Junction, MD 20701

December 2008 – Feb 2011

UDB DB2 team lead/Senior DBA – Subcontractor of CONVERGENZ (TSA Operation and Maintenance)

Responsibilities: Development and implement of databases from Logical Models on Window and UNIX servers. This is a 24X7X365 service which is a challenge for maintenance. Routine tasks is to monitor CPU/ memory usages, query optimization using db2expln utility, fine tuning of indexes, tablespaces, buffferpools, and all database functions.

Support at top level to resolve urgent and chronicle production problems.

Maintenance includes database backups, table reorg/runstats. High Availability Disaster Recovery, Version upgrade and security patches.

Created Store Procedures, User defined Functions to facilitate DB2 table purge and other functions.

Maintain Cooperate SQL Server version 2005 and 2008. Trained DBA.

Morgan Stanley Smith Barney

901 South bond Street, #6/

(New York City – Plaza 1)

Baltimore, MD 21231

November 2007 – December 2008

Senior DB2 DBA Associate – Employee

Responsibilities: Communicate with New York headquarter and offshore

developers to develop Store Procedures, Views for IBM Informatica and DB2 applications. Created Institutional invest group databases form logical models. Localized and estimated the physical database table containers to fit the current and future partitioned database capacity needs, these containers distributed on a Global scale. Responsible for the migration of database objects through Dev/Staging/Production environments. Perform basic tuning and monitoring for

database performance. Optimize queries by studying Indexes usages with DB2 explain tools.

Often time on this job, tasks were performed at home base.

Lockheed Martin

3106 Lord Baltimore Drive

Baltimore, MD 21244

May 2005 – November 2007

Senior DB2 DBA Engineer:

Responsibilities: 24X7 disaster recoveries and trouble shooting of 300-400 UDB DB2 and Mainframe DB2 data servers.

Responsible for all UDB DB2 databases monitoring, maintenance, update, fix pack upgrade, and installations. Trained and managed new DBA. Report all the status of new development, testing and production maintenance For CMS (Center of Medicare and Medicaid).

Improvement in Web Performance, User interface, Automate Data Archiving, Server Scalability and numerous enhanced Application Development Features. Improvements include hardware with additional backup, Failover, scalability and performance capability. The function is needed to drive end-user productivity and provides a single consolidated platform for automating and managing Business processes and intelligence analysis. Edit and create ETL SQL stored procedures to suit LM environments.

Introduction of New Technologies - GUI interaction between Data Warehouse and UNIX/Window report systems. Installed Websphere applications such as web analyzer to Tivoli Data Warehouse, Korn shell scripts, Perl 5, Java scripts, C are the tools used daily.

Researched DB2 monitoring tools and consolidate the enterprise information gathering among LM and US government mid-tier database management.

Upgrade all DB2 versions from 8.2.7 to 9.1 from TEST/VALIDATION TO PRODUCTIONS.

Establish Physical database from logical model and raw server file system and devices.

Accomplishment:

Customize (design to implement) LM TDW dimensional and facts tables, data mart star schema.

Push data to ITM and pull it from central data warehouse to data mart daily.

Maintain DB2 and Oracle data Warehouse pack. Develop new scripting center. Update Tivoli Data Warehouse, Upgrade UDB/DB2 enterprise edition from 7.2.10 to 8.2.1 on Tivoli data warehouse control center, Central Data Warehouse Database, Data Mart. (AIX/Window).

Set up Warehouse enable packs, data warehouse packs – CCM, rim objects, inv_db.

Configure Crystal Enterprise Server for Crystal Report.

Data backup, Reorg, RUNSTATS, database pruning daily, fine-tune database to improve performance. Redirect restore database to increase space for table containers. Finish database replications, performance optimization, data move, and database migrations.

Install IBM content manager – library server, resource manager databases. Installed and configured Oracle database 10g.

Perform database design and plan, both logical and physical. Create database and database connection using TCP/IP protocol. Facilitate DB2 database applications between Tier1, tier2 and tier 3. Maintain and fine tune CMS DB2 databases for optimized performance.

AMERICA POST WORKER UNION HEALTH INSURANCE. Nov 2004 – May2005

12345 New Columbia Pike, Silver Spring, MD 20904

UDB-DB2 DBA, TSM ADMIN

System and Database Operations for UDB-DB2 Project development –

Create database, Set up and tested SQL Stored-procedures and triggers. Maintain production and test database configuration and data integrity. Responsible to backup and restore for DB2-Databases and logs from Tivoli Storage Server. Fine-tuned and maintained DB2 for back end applications, and configured WebSphere applications’ or IDMS connection to DB2 servers.

Set up Tivoli Storage Manager Server – Installed TSM on AIX and Window NT. Configure Servers and Clients – Partition database, featuring High Available Cluster Multi-Processing. Automate backup, restore, archive, Replication, and retrieve files / Databases. Schedule all automatic file system backup to TSM. Set up disaster recovery and fail-over database-system environment.

Built DBI and DB2 Driver for PERL and Java for UDB-DB2 - Write db2 Korn Shell, NAWK, C/C++, and PERL scripts for data extraction, establish stored procedures, UDF, and triggers, and perform table manipulations – import, export, load, alter, and query.

Deutsche Bank July 2004 - November 2004

One South Street

Baltimore, MD 21202

Consultant

Responsible for Korn Shell, PERL, NAWK, C scripting. Convert COBOL programs from IBM Mainframe to UNIX Clone and JCL from IBM mainframe to UNIX. Recompiled Stored Procedures and Triggers in the UDBDB2 Environments, either AIX or Solaris, from legacy databases modified the invoking syntax in calling programs. Setup functions of Tivoli storage facilities. The UNIX UDB in Deutsche Bank is basically a mirror image of Mainframe DB2. This is usually called Vancouver system. Users do the query as if they are using the mainframe DB2.

Database administration responsibilities include converting IBM JCL load utility DSNUPROC to UDB load tables. Inventing “C” tool which can easily check the validity of input data and code the “^” and “|” constitutions for load-ready files automatically before loading the table. The constitutions speed up the load by the thousands. Write up and tested stored procedures and triggers on UDB DB2. Set up new tables and views including architect and designs

Accomplishments: In three months, use automated tools to convert difficult applications and tested in jobs such as cash splitting, tickler generating by the hundreds. Created and loaded many tables. These projects had been belated for 6-8 months with other approach and by other developers. Consequently, the client was able to deliver in time with the above complex tasks. Test successfully the failover procedures.

Blue Cross and Blue Shields Dec 1999 – June 2004

300 East Randolph Street

Chicago, Illinois

DB2 Consultant

1 Responsible for System Administration, UNIX System Management, and UDB DB2-applications development.

2 Administrate DB2 functions – created triggers and store procedures, optimize performance and fine-tune database. UNIX System Management, and UDB DB2-CICS development

3 Focused on Re-engineering and redesign the Legacy COBRA System to SCO Unix box and later on migrated to IBM AIX 5.1 Unix box.

4 Incorporated and review Business rules to design Logic, Physical models, write specs and testing plans, finishing up regressing test cycle. The main unit test tool is MicroFocus Bench animator. The results are verified with PERL/Shell/NAWK scripts. Average working hours is between 40 – 100 hours / week including maintenance.

5 Write C++, C, and NAWK tools for screen (interface), report templates’ generation and other 800 some tools to monitor and automate the whole system...

6 Set up stored procedures and triggers, fine-tune database, management of threads (deadlocks).

7 The tools used are MicroFocus-COBOL, COBOL 390, CICS, VASM File, ProComm, C++, C, Korn Shell, HTML, PERL, DBI, SQL, ERWIN CASE Tool, FTP from UNIX to mainframe and vise versa, electronic transmission of payment from Bank one to BCBS(EDI).

8 Build a system from 2 customers to more than 15,000 customers, the take home income for Blue Cross and Blue Shields is about half a million dollars per week day.

9 We have made the billing and payment possible for Blue Cross and Blue Shield COBRA benefit system. Recently, we converted the file system to UDB DB2 database.

Lucent Technologies Sep 1997 - Dec 1999

2000 N. Naperville RD.

Naperville, IL 60563

MTS Engineer

1 Developed Administrative and user tools to analyze all 5ESS (Electronic Switch System) files and functions for logical errors and defects for Lucent Software updates and releases using C, C++, NAWK, PERL. Heavily used with Regular Expression and Pattern. Function as Consultant for other tool Developers. Risk management for software development.

2 Reduced defect rate from 88% (1998) to less than 1% (1999) while Lucent Stock went sky-high.

3 Established new database for software risk management.

4 Completed more than 2000 tools (new and old) for migrating to new machines.

5 Completed Y2K conversion for almost all lucent software update (more than 1000).

6 Daily Activities including technical skills with C, C++ tool generations. Languages used are C, C++, PERL (Regular Expression, Pattern), Informix, TCL/TK, NAWK, Office97, and HTML.

7 Meeting with a variety level of engineers to come up with plans and projects.

DePaul University Jun 1997 – Jan 1999

243 South Wabash Avenue, Chicago, Illinois 60106

Instructor School of Computer Science

1 Responsible for teaching C, Shell script, COBOL II, CICS, VSAM FILE, DB2 and JCL

Novus Service Inc June 1997 – Nov 1997

Lake Cook Road, River woods, IL 60015

Programmer/Analyst

1 Responsible for designing, coding and testing a variety COBOL II-DB2 programs that extracted VSAM files that were used to load Oracle databases.

2 Finished discount_fee_tran client server, non_discnt_fee Server, organization_set, Settlement Conversions.

05/1997

M & I Bank Data Process Center - 11000 W. Lake Park Ave. Milwaukee,

Wisconsin

Responsible for Bank fee adjustments for Accounts. Converting IMS program

to DB2 programs. Apply fees to accounts and update accounts using 19

Accounting criteria. Create and load the new accounts data to DB2 tables.

Daily used skills involve CICS programming, DB2 database handling, and

JCL.

04/1997

Case - 7000 Durand Avenue, Racine, Wisconsin 53406

Responsible for IMS-DB and -DC and CICS programming in collaborate with

teams to set up the European General Parts System.

Accomplishments - Created Screens for Calendar daily Constants and the

daily calendar databases. Programming for the daily calendar constant

module. Moved North America orders from UK to France and established the

relationship between North America Orders and France order quantity

Forecasts. Start and assign newly created purchase orders. Mapping,

creating PSB, creating and loading databases are daily routines. Finished

up to date five major programs.

Updated Austria Tariff from German part system.

02/1997 - 03/1997

WW Grainger - 7300 Melvina, Morton Grove, Illinois.

Responsible for debugging and enhanced current programs that updates and

The on line program has too long a response time due to Cartesian products.

Accomplishment - Rewrite two major programs, corrected the Cartesian

products, reduced the response time from hours to seconds. Installed

restart function at the proper logic unit of work for several CICS and IMS

programs.

10/1996 - 01/1997

Addison-Wesley Publishing Company –

One Jacob Way, Reading,

Massachusetts 01867

Responsible for products dimension establishment for the company new

data Warehouse. This assignment requires Cobol II programming that reads

all DB2 tables related to product inventory, history, copy-right year,

locations, sales restrictions, sales price, packaging and components. With

two months, completed the products dimension that contains eight programs

and four files and three DB2 tables that updates the server daily.

05/1996 - 09/1996

Komatsu American Incorporated - 440 North Fairview, Vernon Hills, IL 60061

Responsible for suppliers purchase order and promise expiration.

Designing, coding, testing and implementation of the subroutine that retires a series of promised quantity those suppliers promised from promise table.

Establish screen for promise table.

Accomplishment - Finished the promise expiration subroutine program and

the map job. Improve the efficiency of program performance from hours to

run a job to minutes to run a job.

Finished more than ten programs in one and half months including the

inventory master writing up.

Routinely used techniques are COBOL II, ISPF, File AID, DB2, SQL, QMF, and IMS database calling, DB2 and CICS on-line interactive programming. Telon

development facility for IMS-DC online programs, expeditor, are used to

facilitate CICS and DB2 program development, testing and implementations.

02/1996 - 04/1996

Allstate Insurance (The Registry) - 2775 Sanders Road, Northbrook, IL

60062-6127

Responsible for Client File Maintenance and Project Development.

Routine maintenance of the DB2 data integrates for tables in Client File using CICS online tools.

Update all the information in Client File tables at the request of

Clients. Developing projects and programs to reduce the errors and

Exception of the Client File system.

09/95 - 01/96

Ameritech (Maxim Group) 475 Martingale Road, Shaumburg, Illinois 60731

Responsible for bill conversion in new generation billing system development. Concentrating on standard transaction process for triggering

daily bill format and service. Validate and update customer files and

calculating simple and complex billing for invoice and promotion item

generations. Daily techniques used on mainframe and Microfocus COBOL

workbench dispersed around COBOL coding, JCL design, process testing, and data validating, SPUFI, and SQL coding, DB2 table manipulation, IMS program maintenance and data base calling, and documentation release.

Accomplishment: Finished the assignment of standard transaction.

1994 - Midway Culture-Tech Co. Mundelein, Illinois

1992 - 1994 Molecular Geriatrics Co. Alzheimer’s Pharmaceutical Division, Lake Bluff, Illinois

1983 - 1992 Abbott Laboratories, Pharmaceutical and Diagnostic Divisions, Neuroscience Division, Abbott Park, Illinois

1979 - 1983 University of Texas, Houston, Texas

1976 - 1979 National Institutes of Health, National Cancer Institute, Bethesda, Maryland

1971 - 1975 University of Nebraska, Lincoln, Nebraska

EDUCATION:

CLC, CISCO Router network II 2000

DePaul University, Computer Career Program 1995

Post Doctoral Fellow, National Cancer Institute, Bethesda, Maryland, 1978

PH.D. Chemistry, University of Nebraska, 1975

M.S. Chemistry, University of Nebraska, 1973

B.S. Agricultural Chemistry, National Taiwan University 1969

Profession Society of Neuroscience

Contact this candidate