Oracle Database administration in Windows and Unix environment
Database and application security Annual Review and ATO Support
Secure database access with two-factor and CAC-PKI solutions
Client-server and web-based applications production and development support
System life cycle integration, deployment and support of commercial-off-the-shelf (COTS) product suites
Software development using Visual Basic, Oracle PL/SQL, C in Windows and/or Unix environment
Security Plus certification in 2017
M.S., Computer Science, University of Maryland at College Park, 1996
B.S., Physics, University of Science and Technology of China, 1986
October 2014 – present: Universal Consulting Services Inc., Senior Computer Specialist/Oracle Database Administrator
June 2013 – September 2014: HP Enterprise Services, Senior System Engineer/Oracle Database Administrator
Support DHA Special Needs Program Management Information System (SNPMIS).
Support SNPMIS Oracle 11g and 12c database running in 10 production sites and 8 test servers in development environment. Perform maintenance tasks such install and test Oracle Critical Patch Updates (CPU), monitor database performance, backup and version upgrade.
Support and interface with IA and Cyber security teams for SNPMIS technical Self-Assessment, security Annual Review and Authority to Operate (ATO).
Configure SecurityCenter to perform Assured Compliance Assessment Solution (ACAS) and The Security Content Automation Protocol (SCAP) to scan SNPMIS production and development server and mitigate security vulnerability findings in database and Windows 2008 R2 server.
Support creation of Plan of Action & Milestones (POA&Ms) and Acceptance of Risk (AOR) and mitigation vulnerability findings according the DoD database and Operating System Security Technical Implementation Guide (STIG).
Implement Oracle Advanced Security Option Kerberos Authentication with MS 2008 Activity Directory for two-factor authentication.
Implement CAC-PKI solution for SNPMIS using Oracle SSL/TLS authentication with DoD Certificates.
Implement Transparent Data Encryption (TDE) SNPMIS database tablespaces and tables.
Configure PowerBuilder development server to support SNPMIS development and deployment of SNPMIS version 6 upgrade to remove password authentication, SSN, add new reports. Develop Oracle scripts to upgrade SNPMIS database structures and document deployment procedures.
Provide Tier 3 support for SNPMIS client application running in Application Virtualization Hosting Environment (AVHE).
Support DHA Nutrition Management Information System (NMIS) for user account management in a dozen of NMIS sites.
Support SNMIS BOXI database server, Apache Web server and Tomcat Application server in development environment. Install JAVA patches and Apache Tomcat patches.
October 1997 – June 2013: HP Enterprise Services, Senior System Engineer/Oracle Database Administrator
Supported the legacy financial system Project Management Control System running on Informix database in UNIX environment.
As technical lead, in System Life Cycle, implemented and deployed Financial Control System (FCS), an integration of the following commercial-off-the-shelf (COTS) product suites: Micro-Frame Program Manager, Primavera Project Planner, Cost Schedule Integration Tool (CSIT), and three-tier web-based online timecard TimeWizard (TW) to support Military Health Program (MHP) DoD contracts.
To further customize for our supported DoD contracts, designed and implemented and deployed FCS support (FCSS) system database and software including modules such as TW labor extraction, other direct cost processing, monthly progress reports, interfaces with FCS and financial reports using Visual Basic, Oracle PL/SQL functions, procedures, triggers, packages and Crystal Report. Two of the modules in FCSS replaced two COTS products.
As the lead FCS application administrator, developer and the sole Oracle database administrator, responsible for end-user support, and continued FCSS software enhancement and system support for all applications. Tasks involved include installing, configuring, patching, upgrading, migrating and troubleshooting COTS, FCSS and Oracle software, building production, test/development system in Windows environment, performing application data, database backup and recovery, performing Oracle database maintenance, performance tuning, and contacting Oracle and other vendors for technical support.
Supported MHP DoD project Expense Assignment System IV (EAS IV), a centralized web-based application with Oracle RDBMS as database layer, Oracle WebLogic and Business Objects as application middleware layer, and JAVA web application as data layer.
As a part time DBA in administrator team, supported EAS IV database and repository database designed using Oracle 11g in an Oracle RAC running in Sun Solaris 10 environment with database files managed by ASM. Tasks performed included Oracle quarterly CPU installation in test, development and production environment, synchronization of test and development data with production data, upgraded Oracle database from 10g to 11g, maintained and updated database ER-diagram with Erwin Data Modeler, other routine database maintenance, database security management, database backup and recovery, archive log backup and recovery, performance monitoring using shell scripts and tools such as OEM, AWR, RMAN.
Additional application administration tasks performed included EAS application server migration from Oracle application server to WebLogic server, WebLogic server installation, configuration, upgrade and patch installation and administration.
October 1996 – October 1997: Virtual Technologies Consulting Inc., Software Engineer
Developed and enhanced advanced, secure relational database management software called Trusted RUBIX in UNIC environment.
Designed and implemented test suites in C/ESQL to test mandatory access controls (MAC) kernel, MAC interface and SQL engine using UNIX tools such as RCS, debug, imake, and shell script.
Reengineered and implemented in C RUBIX archive system containing backup modular, transaction logging modular and recovery modular.
February 1996 – September 1996: Ellsworth Associates Inc., Senior Program Analyst
Worked for Department of Labor contract to develop GUIs for the project Unemployment Insurance Required Reports running on INFORMIX database in UNIX environment.
Designed, implemented and tested GUI JAM screens with JAM program language and C-embedded SQL.
Designed and implemented Batch Load module with C-embedded SQL, which downloaded Unemployment Insurance reports as ASCII flat files into database on a daily basis.
Oracle Database 11g Release 2: Administration Workshop – Database Creation and Instance Management, Storage Structures and User Security, Managing Database Maintenance and Performance, Oracle Database 11g: Database Architecture and ASM, Using RMAN for Recovery, Oracle Database Security Hands-on Workshop, Oracle Advanced Security Option Workshop over the Web, Oracle Data Masking Workshop Over the Web.
CompTIA Security+, 2017.
DISA ACAS 4.8 Assured Compliance Assessment Solution
DoD’s Cyber / Information Assurance Awareness
Privacy Act and HIPAA Operations.
Oracle 8 Certified DBA from Oracle Corp, 2001. Oracle 7.3 Certified DBA from Oracle Corp, 1999.
Current Security Clearance Held:
Operating Systems: UNIX - Solaris, and Windows NT/2000/2003/2008R2
Databases: Oracle, V7, V8, V8i, V9i, 10g, 11g, 12c, Informix, MS SQL Server
Middleware: Oracle Application Server, WebLogic10.3.4
Program Languages: FORTRAN, C, SQL, Oracle PL/SQL, MS Visual Basic, JAVA, PowerBuilder
Tools: Oracle SQL*Plus, Oracle SQL developer, Oracle SQL Loader, Oracle Enterprise Manager, Oracle Recovery Manager, Oracle Data Pump, ERwin Data Modeler, Shell Scripting, Crystal Reports, BusinessObjects Enterprise, PVCS, ARCserveIT