Over 19 years experience of database administration including Oracle software installation/upgrade/building/configuration, database security, database backup/recovery, database support and database monitoring by using OEM and database performance tuning.
*Over 19 years experience in data modeling, data mining, database design, database architecture, database conversion, and data migration.
*Over 19 years of PL/SQL programming and report development including 5 years lead experience.
*Over 19 years experience in Unix/Linux and Windows environment.
*Over 4 years experience in MYSQL software installation, database creation and database architecture implementation.
*Over 4 years experience in Cluster. Failsafe, oracle real application clusters, Oracle Automatic Storage Management (ASM), oracle replication management, RAID, Change management pack and enterprise management.
*Over 2 years experience in SQL server software installation, database creation and database architecture implementation.
*In-depth knowledge on data warehousing, networking, security, Oracle Form, ETL process, No SQL database, Toad DBA suit for Oracle.
*Familiar with FDA software compliance process.
*Over 14 years experience in programming to develop applications and utilities. The applications include health care projects, data exchange, certificates system and financial management.
*Object-oriented design methodology (RUP vs. Extreme Programming).
*Extensive experience in full life cycle software analysis, design, development, testing (including unit testing, system testing, user acceptance testing of functional requirements and regression testing) and system integration of large or small-scale software projects.
*Significant Agile experience. Familiar with Scrum Framework.
*Strong inter-personal skills and problem solving skills.
Oracle (v.7x, v.8.x, v.8i, v.9i, v.10g, v.11g, v12c), Informix-OnLine Dynamic Server (version 7.23, 7.3x), MS SQL Server (v.6,v.7,v.8, 2012), Sybase, DB2, MySQL database (5.6, 5.7), PL/SQL, trigger, stored procedure, Oracle package, Unix Shell Scripts, Erwin, Windows NT/2000/XP/2003,UNIX. EzGov, C/C++, Oracle Pro
DBA and PL/SQL developer
Database administration, database application developer and SQL developer for USPS (United Stated Postal Service) Web-based and Mobile device project.
The project includes Identity Verification Services (IVS).
Primary Response in working on database analysis, database design, data encryption, data modeling by using ERWin.
Response in database monitor, database performance tuning, database upgrade and IVS database supports.
Generated IVS reports for audit, debug and troubleshooting purposes.
Involved in designing application and database deployment processes.
Supported Database requests for CA Identity Minder and CA SiteMinder products.
Implemented functions by using Oracle PL/SQL and SQL to create triggers, stored procedures, oracle jobs and functions in Oracle 11g and Oracle 12c UNIX environment.
Created MYSQL IVS database for developers.
Installed MYSQL IVS database in HPE cloud environment.
Performed analysis on SQL server for IVS application.
Coordinated Oracle 12c upgrade in USPS projects.
Used JAVA MVC frameworks to create report tools.
10/2005 to 09/2014
DBAHP – Herndon, VA.
DBA and SQL developer
Database administration, database application developer and SQL developer for USDA (United Stated Department of Agriculture) Web-based projects.
The projects include Phytosanitary Certificate Issuance & Tracking (PCIT) system, Veterinary Export Health Certificate System (VEHCS), Phytosanitary Export Database (PEXD), Electronic exchange of the Phytosanitary Certificates (E-Cert), Lacey Act Web Governance System (LAWGS), PCITLite and CARPOL systems.
Primary Response in database administration including backup/recovery more than 10 databases, installation/configuration, maintenance, migrations/upgrades, patching, performance tuning, partition tables in databases, system architecture and security setting based on USDA requirement.
Use OEM (Oracle Enterprise Manager) to maintain database tasks and monitor databases performance.
Also working on database analysis, cloning, database design, data modeling by using ERWin and Codd's Rule.
Involved in designing application and database deployment processes.
Implementing functions by using Oracle PL/SQL and SQL to create triggers, stored procedures, oracle jobs and functions.
Provide various reports including financial reports, research reports and statistic reports for the customers by using oracle aggregate functions, analytic functions, SQL and PL/SQL in Oracle report and Cognos report.
Developing small databases by using MySQL for laptop application.
Help desk level II supports.
Using JDeveloper 11g to develop the applications.
11/2003 to 09/2005
developerHP/EDS – Herndon, VA.
Database administration and Web application developer for two USDA (United Stated Department of Agriculture) Web-based projects.
One is called Electronic Commodity Ordering System (ECOS), which supports USDA objects for distributing quality, cost-effective nutrition products.
The ECOS application is designed and constructed on the ATG Dynamo 6 software platform.
The ECOS application database is managed by IBM DB2 8.1.
The Primary responsibilities For ECOS
11/2000 to 10/2003
DBAEDS – Falls Church, VA.
Led a team of 3 DBAs
Technical lead on database administration/migration field for project called the Defense Blood Standard System (DBSS), which is a Food and Drug Administration (FDA) approved medical device that is used in the manufacture, management, tracking and reporting of blood products.
The DBSS systems involve Oracle (v.8.x, v.9I), Oracle FailSafe, Informix (v7.30), WinNT, Win2K, Win2K advance server, Terminal server, Oracle/Veritas products and Microsoft Cluster Server (MSCS).
The PVCS version manager and PVCS track software are used for document tracking purpose.
The Primary responsibilities.
Lead to response for database administration, analysis, cloning, design, installation/configuration, maintenance, migrations/upgrades, patching, performance tuning, system architecture, security setting based on DISA (Defense Information System Agency) requirement, replicated/standby environment setup and backup/recovery involving Oracle Advanced Security, Oracle/Veritas products for DBSS production databases.
Lead to design, develop, implement and document database conversion procedures to convert data from 88 client site databases to central globalize database using ETL process.
Develop utilities, batch jobs and programming to perform database maintenance tasks such as detecting data block corruption, update statistic data, backup database, database auditing and database monitoring by using Visual C/C++, PL/SQL program, Oracle packages and Oracle jobs.
Support DBSS software developers to design and implement database architecture, tuning SQL statement and write trigger and stored procedures.
Support DBSS software testing engineer team to perform testing tasks.
Technically support customer service activities including configuring databases, database performance tuning and fixing any database related issue.
Lead to design, develop, implement and document database conversion procedures to migrate data from Informix platform to Oracle platform.
Maintain and create the informix databases and oracle databases based on the requests from DBSS team members.
Maintained the BusinessObjects databases in the informix databases and oracle databases.
Work closely with the development team to help them about any database design issue, translate OO models into data models and ultimately into a database schema by using Rational rose and Erwin.
Work with customer support team members to troubleshooting, maintain and fix site database issues such as bad performance, recovering databases, typing incorrect data and so on.
Support the Release 3.04 development effort.
Support all software product builds.
Create standard of procedures (SOP) for database related activities.
Document database related activities for delivery orders and FDA inspection.
Coordinate and communicate with other team members to complete delivery orders from customers.
01/2000 to 11/2000
Database AdministratorTowerSoftware. Reston, VA – DBA
Database Administrator for TRIM Captura , which is an Electronic Recordkeeping system designed to provide a complete and seamless management solution for physical and electronic documents.
TRIM products are produced by TowerSoftware and can be run on the NT plate form and Unix box.
The database can be Oracle 7, 8i, Informix 7, Microsoft SQL Server, SQL anywhere, Sybase or DB2.
The Primary responsibilities
06/1997 to 12/1999
EngineerLitton/PRC – Reston, VA
Oracle Database Administrator for Performance Evaluation System (PES) and Informix Database Administrator for Optical Digital Imaging Records Management System (ODI-RMS) Board Room Application in the Personal Records Management Branch (MMSB) for marine Corps.
PowerBuilder and C++ programmer for PES and Digital Boardroom Applications.
The primary responsibilities include
10/1996 to 05/1997
Associate EngineerLitton/PRC – Reston, VA
Designed and implemented the Joint Engineering Data Management Information and Control System (JEDMICS) version 3.0 using UNIX, ProC, C, C++, PL/SQL, Window NT 4.0, VISUAL C++4.1, ORACLE7/UNIX, COTS, CASE TOOL (Teamwork, from Cadre Inc.) and requirements and tractability Management Tool (RTM) from Marconi Systems Technology (GEC Marconi Limited).
01/1996 to 09/1996
Senior ProgrammerNational Data Corp – Rockville, MD
Designed and developed the DataStat Pharmacy Management System using MAGIC and C, which provides advancements in the management of pharmacy information.
I also developed the printing modules using Magic, C, and PCL to print the labels with prescription information and bar-codes, and the reports with the statistic data in the forms of bar graphs and pie charts.
I developed the client/server communication modules between the hospital computer system and the DataStat using the industry standard protocols such TCP/IP, Xmordem, and Health Level Seven (HL7) version 2.2.
06/1994 to 12/1995
Technical lead/Senior ProgrammerNational Data Corp – Rockville, MD
As the subcontract and technical leader in EDS corporation, I was responsible for the following tasks
M.S: Computer Science Southwest Texas State University -
M.S: Plant Pathology & Entomology National Taiwan University - Plant Pathology & Entomology
Ph.D: Zoology University of Texas - Austin Zoology