Customer Support Database Administrator

Chiali TSAI

SUMMARY

Administrator

MANAGEMENT: Project planning, management and control; Management of Applications programmer/analysts; Customer support.

APPLICATIONS: Financial Reserve System, Telecommunication provisioning, compensation, Health insurance systems, Education financial, Reservation system

TECHNICAL SKILLS

Programming Languages: SQL, COBOL II

Windows Applications: Word, Excel, PowerPoint, Access

Software: DB2 z/OS, SQL Server, Datacom, SYBASE, CICS, IMS

Hardware: IBM z/OS, HP UX, Linux, MS Windows

EXPERIENCE

Federal Reserve system August 2014 – Feb 2020

Senior DBA

-Database automation through scripting and stored procedures

-Support clients finding solutions for projects and operational issues for databases

-Administrate database related functions, DB2 Connect, Web connectivity, physical structure, overall architecture

-Planning, installation, and maintenance of DBMS software

Merck August 2013 – July 2014

Senior DB2 DBA Consultant of HCL

-Provide database administration for mission-critical software applications

-Administration of DB2 Distributed implementations, including database definition, structure, documentation, and long-range requirements

- support client on routine query, issues and maintenance request

-Regularly scheduled verification procedures and error correction

-Software: DB2, TSO, ISPF, File Manager, BMC tools on z/OS 390.

Mythics Inc Nov 2012 – July 2013

Senior DB2 DBA

- Perform conversion from Datacom, DB2 tables from Mainframe z/OS to Oracle Linux

- Administration of DB2 Distributed implementations, including database definition, structure, documentation, and long-range requirements

- manage project under ITIL

- Software: DB2, TSO, ISPF, File manager, DataCom on Z/OS 390.

Marriott Sep 2005 – Oct 2012

Senior DB2 DBA

Evaluate and implement jobs that monitor and manage reliability, availability, recoverability and performance.

Coordinate DB2 upgrade,

Implement the jobs to REORG DB2 objects intelligently.

Write programs to monitor the space availability.

Communicate Operational metrics and issues to appropriate levels of management.

Generate report of space usage,

Report utility IDs left in the system to avoid production job abend.

Establish and engage the disaster recovery plan when required.

Apply existing and emerging technology to transform business processes.

Coordinated DB2 upgrade

Support developers – Solve programming issues

Software: DB2, IMS, TSO, ISPF, File Manager, BMC tools on z/OS 390. UDB/Linux.

GEICO Feb 2005 – Sep 2005

Database performance tuning analyst

Perform database performance tuning tasks - Production support, performance tuning.

Perform database design tasks – design new objects, create physical objects, migrate software from development to production.

Software: DB2, TSO, ISPF, File Manager, on z/OS 390.

Accenture Corp. May 2004 - Feb 2005

Dept of Education, Database administrator

Perform database routine maintenance tasks – Production support, performance tuning, disaster recovery.

Perform database design tasks – design new objects, create physical objects

Support developers – Solve programming issues

Software: DB2, IMS, TSO, ISPF, File Manager, BMC tools, Omegamon on z/OS 390

Verizon, Silver Spring, MD May 1999 – Nov 2003

Sales & Business System, Senior Consultant, GBS Compensation Team Lead, DB2 DBA

Designed logical database, create, maintain DB2 database with 10+ giga byte tables

Install physical database, monitor space usage

Led a team of 6, developed, maintained telecom Service Order Tracking Information System(OTIS)

Managed the full life cycle of a sales compensation system

Implemented Compensation business rules in DB2 tables for processing order sales compensation

Created COBOLII programs parsing service orders from 7 Order Processing systems, applied business rules, formatted/distribute data to SQL server, for WEB front-end applications

Programmed in COBOL II, DB2 using JCL, TSO, Fileaid, REXX on IBM OS/390

Sales & Business System, Senior Consultant, GBS Compensation Sybase DBA

Supported SYBASE database

Maintained database

Support CICS system and application

Solve client issues, application usage

Support production environments

EDUCATION

MS Industrial Planning, Chinese Culture University, Taipei, Taiwan

BS Horticulture, Chinese Culture University, Taipei, Taiwan

CERTIFICATIONS & TRAINING

Certifications

Computer programmer certificate, issued Oct. 1980

Training

SQL Live 360 conference, Nov. 2018

IBM On Demand conference, Oct, 2011

DB2 z/OS system performance tuning, Jack Morton, July, 2009

Introduction to Oracle, Verizon in house training, June, 2003

Web design, Verizon in house training, May, 2003

SECURITY CLEARANCE

DHS CIS

VOLUNTEER

Tzu Chi Foundation, Charity group lead

Montgomery county Language Bank

IRS Volunteer Income Tax Assistance

Served Montgomery County, MD

Fairfax County, VA

Volunteer

Contact this candidate