SUMMARY:

• More than eleven years IT experience in the Information Technology, Healthcare service, Pharmaceutical and Telecommunication industries.
• Database/System Analysis. Very strong Analytical and diagnostic skills. Project management, excellent communicator.
• Oracle, SQL Server, MySQL, Access database management, design, implementation and programming. Data Warehouse management. Data analyze.
• Documentation in compliance with FDA 21 CFR Part 11. Training in HIPAA compliance.
• Hands - on experience in SQL, PL/SQL, Shell/Batch scripting, Visual Basic programming. PC & MS Office proficient.

TECHNICAL SKILLS:

Database: Database design and implement, migration, upgrade, refreshing, patching, database clone, backup/recovery, disaster recovery, DB security… Oracle 8i/9i/10g/11g/12c DBA, RMAN, OEM9i/Grid Control10g/12c/13c, RAC, ASM, Standby/Data Guard, Data Pump, Export/Import, SQL Loader, ADDM, AWR, ASH, StatsPack, TKPROF, Log Miner, opatch, Oradim, OLTP/OLAP, SQL* Plus, PL/SQL, Materialized View, MySQL 5.5/5.6/5.7, MySQL Replication, MySQL Enterprise Backup, MySQL Enterprise Monitor, SQL Server 7.0/2000/2005/2008/2012

Operating Systems: UNIX (AIX 4.X/5L/6/7, Solaris8/9/10/11, HP-UX 11i), Linux 6/7 (Red Hat), Windows 2000/2003/2008/2012/2016, Cluster (Windows Cluster, Fail Safe, VCS, IBM HACMP)

Other: Project management, Technical documentation, MicroSoft Office, Data Warehouse, VLDB, Big Data, DB on Cloud, Shell scripting, batch file scripting, ExaData DBA, Health Care System (Medical Record, Clinical, Integration…) DBA, PeopleSoft HR V7.5/V8.8 DBA, ARISg Drug Safety Validation system V3.4.1 DBA, Envision Government Price System V2.2.7/V3.1 DBA

PROFESSIONAL EXPERIENCE:

Confidential, Ridgefield Park, NJ

Senior Database Administrator

• Primary Oracle DBA for DataWarehouse/BI system on ExaData DB machine (with RAC, ASM, DB size is more than 30 TB), samsung.com system, Samsung Smart TV system, ERP interface portal system, Samsung Global HR system…Support multiple large Global systems.
• For multiple projects, collect the requirements from clients, communicate with vendors and app groups, arrange testing environment, dry run, UAT, go-live plan…
• Mentor the junior members in the DBA team and Data center.
• Team leader of database upgrade project: upgrade more than 80 databases from Oracle 9i/10g to 11g with minimum service down time. Project management, design upgrade plan, arrange test environment, testing, documentation,…
• Setup Oracle EM 12c/13c (DB monitoring tool) and MySQL Enterprise Monitor for Data Center
• SRA(Samsung Research America) Website re-design project: Set up DB servers with MySQL 5.6 replication on RedHat Linux 6.4 servers, setup MySQL Enterprise Backup
• DB migration from UNIX to Linux project: migrate Oracle DBs from Solaris/Windows platform to RedHat 6 platform
• DB migration to private cloud project: migrate Oracle, MySQL DBs from physical servers to company private cloud (around 300 servers’ private cloud).
• ExaData machine migration project: evaluate different technologies to migrate BI/Datawarehouse system to big data solution
• DB upgrade from Oracle 11gR2 to Oracle 12c project.

Senior Application Specialist

• CHP System Backup/Tape Management Project: Test and Setup RMAN environment for TSM Tape Library backup. Upgrade the RMAN repository from Oracle 9.2.0.7 to Oracle 11.2.0.1 on AIX 6.1 server. Migrate RMAN backup from TSM to NetBackup.
• META Medical Record Chart system Project: Design, configure and setup Production, Development, and Test Databases for META system of three hospitals -- including upgrade from Oracle 8.1.7 to Oracle 9.2.0.7 on AIX 5.3 for one hospital. Implement backup/restore strategies for these databases by using RMAN and TSM.
• IPATH Operation Room Scheduling system Project: Setup Production, Development Databases for IPATH system on Oracle 10.2.0.1, help vendor to migrate the system from Informix to Oracle. Design the whole set of maintenance plan. Upgrade the system from 10.2.0.1 to 10.2.0.4 accessANYware Medical Document Imaging system project: Design, configure and setup Production, Test Databases for accessANYware system. Upgrade Oracle database from 8.1.7.4 to 11.2.0.1, and migrate from AIX 5.3 to Windows 2008 R2 Cluster. Used Oracle Fail Safe 3.4.2 to ensure the high availability of database.
• Echo Access Physician Referral system project: Setup Production, Test Databases for Echo Access system on SQL Server 2008 which platform is WINDOWS 2008 R2 cluster.

Database Administrator Consultant

• PeopleSoft HR DBA for HR department: Upgrade DB from Oracle V8.0.4 to V9.2.0.5, server from Windows NT to Windows 2003, PeopleSoft HR from V7.5 to V8.8. Design backup/recovery strategy and Disaster Recovery Plan.
• ARISg drug safety Validation system DBA for medical service department: Global support production environment.
• Envision Government Price System DBA for contract management department: Design/Document/Implement migration plan for Application upgrade from V2.2.7 to V3.1 project.
• Data Mart system for sales department: 24x7 support for this 5TB datawarehousing system.

Senior Software Engineer Consultant

• Developed the Network Hardware Management System: monitor/optimize the usage of network equipment and the responsibility of vendor and CSC for these equipments.
• Developed the Facility Transferring Management System: Three facilities were transferred from AT&T to CSC, including peoples, equipments and etc., which still need to be connected to the AT&T’s intranet. To manage the location of people or equipment, the security, data flow and the timeline of transfer… etc.