CHEEHSIEN JEFF WAN

***** ********** **, ******* ** 20854

301-***-**** Email:adbgoo@r.postjobfree.com

Summary of Qualifications

SUMMARY

All of the responsibilities and duties apply to custom applications developed in Operations.

· Strong Oracle Database Performance Tuning skills.

- Active standby for report activity, significant performancd gain can be achived

-Performance tunning by using Partition allows tables, indexes, and index-organized tables to be. Subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of granularity. There is a rich variety of partitioning strategies to address business requirement.

-Performance on SQL tunning and important initialization parameter adjusting memory_target, memory_max_target, db_cache_size,shared_pool_size,sga_target,pga_aggregate_target and optimizer_mode and so on.

- Twenty years of experience with Oracle RDBMS systems..

-Three years of Oracle RAC experience.

· Five years of Oracle Data Guard experience..

· Hands-on experience in Oracle 12c, 19.5 database, OEM13 and ASM.

Job Duties:

-Tune, administer and maintain Oracle instances according to set standards -Patch, upgrade, and maintain Oracle binaries (database, RAC, DataGuard, CRS, and GC agent)

-Develop and document procedures for backup and recovery of databases

-Update and maintain established security policies set forth by the DISA STIG -Implement mitigations of security vulnerabilities

-Work independently and coordinate with various teams in accordance with defined standards and practices

-Monitor and manage legacy backups using command line -Monitor and tune RMAN backups using command line

· Responsible for writing detailed architectural and infrastructure documentation.

Professional Experience

Self Employment :

Vets(Veterans Enterprise Technology Solutions, Inc), Herdon, VA

Dates (October 2017 – Present)

Edge Solutions and Consulting, Inc. Westlake Village, CA Dates (Sep/2019 – Nov/2019) IBM for IRS project

MSI, Arlington, Virginia, Dates (April 2012 – May 2017)

Vets(Veterans Enterprise Technology Solutions, Inc), Herdon, VA Dates (October 2017 – Present)

Senior Oracle DBA

Perform DLAP(Disaster Loan Assistance Portal)/DCMS(Disaster Credit Management System) builds in Test/Training/Staging/Production environments.

Apply Quarterly Patch Set in the Lower/Production environments.

Apply DCMS Production fixes.

Deploy monthly Zip codes following the process in all the environments including Production.

Perform DLAP/DCMS builds in Lower/Production environment.

Edge Solutions and Consulting, Inc. Westlake Village, CA Dates (Sep/2019 – Nov/2019)

Contract at IBM for IRS project

Senior Oracle DBA

Oracle Data Guard for high availability on MeF DB PRD.

Using the GCC zEC12 for Oracle data guard high availability testing.

An IBM DBA supporting HSA MeF.

24+ years experience as an Oracle DBA with experience with Oracle 12C or a higher version

Experience with Linux (Red Hat) operating system

Database administration skills: installation, patching, backup, restore, cloning, etc.

Database performance enhancement and tuning

Database scalability, sizing and capacity

Proficient in SQL and SQL tuning procedures; reading AWR reports and explain plan

Experience with scripting for automating the installation

MSI, Arlington, Virginia, Dates (April 2012 – May 2017)

Senior Production DBA

Create and Maintain 1.3TB JDIS primary database and it’s five standby databases and configured data guard.

Performance tuning: The prisoner/cellblock scheduler sometimes has issue to open, tried to find the root cause and came up with a solution to fix the issue by regathering stats and generating a new sql profile. Define a baseline performance for the JDIS application

Refresh dev/test databases from production by restoring RMAN backups.

Switchover/Failover process: Outlines the steps required to failover/switchover the JDIS production database betweem the DEA (CEF DC) and Pocatello (CEF WEST A) data centers.

Created and maintain two active data guard for reporting.

PL/SQL enhancement: Assited and put effort to enhance removing record process from booking fingerprints. It took less time to remove the records.

Apply Oracle Critical Patches Updates.

OEM Cloud control 13c: install and manage cloud control, agent installation.

Unix scripting: Oracle installation/configuration in Oracle 11g/12c environment and created unix scripts for data loading.

Dataguard Broker: Create the Oracle Dataguard Broker and configured and set up monitoring scripts.

User account management: Create and modify application user account, grant priviledges.

Upgrade oracle database from 11g to 12c on HA.

General Dynamic Information System, Alexandria, Virgina Dates (January 2002 – April 2012)

Production/Development DBA

Experience with Oracle Enterprise Manager, Instance Monitor, Quest Software DBA tools, SQLPLUS and utilizes Metalink.

Oracle installation/configuration in Oracle 11g environment and using unix script for data loading. Database optimization and indexing.

Create and maintain Physical Standby/Dataguard database environment.

Perform environments builds, upgrades, patching, cloning and maintenance.

Perform system monitoring, performance tunning, load balancing and capacity plan.

Execute disaster recovery/high availability activities, backups, restores and flashbacks.

Define operational procedures and create system documentation.

Configuration/Release Management. And information Assurance.

Oracle ASM, Oracle RAC environment.

Winstar Telecommunications Inc, Reston, Virgina Dates (January 1997– January 2002)

Development DBA

Design Process modeling, entity-relationship diagrams, and data diagram for N-Tier concurrrent project on Oracle 9i and Peoplesoft7.

Responsible for the management configuration and maintenance of Oracle Database Management System on the UNIX(Solaris) platform. Contact Oracle Corporation through TAR and Metlink for technical support and troubleshooting. Assist Developers in tuning database applications for better performance.

By using RMAN to handle backup.

Performance tuning by using STATSPACK.

LCI Worldwide Telecommunications, McLean, Virginia Dates (Oct 1995– January 1997)

Oracle Database Administrator

Logical data model design with S-Designer, Physical data model design

Data Analysis. Project planning, Performance tuning, data cleansing skills. Develop Policy Standards Procedures, project planning, requirements gathering, and systems analysis and design data integrity and data migration.

Implementing the database in a distributed environment

Installing Oracle 7.x in HP-UX on HP9000, creating databases, 24 x 7 backup, recovery, data conversion, performance tuning, monitoring the database on disk usage, I/O contentions, etc.. Also working with system administration team to perform HP 9000 system configurations.

General Electric Information System, Rockville, MD Dates (January 1991– Oct 1995)

Oracle Database Administrator

Migrating data from Oracle engine to INFORMIX, experienced with INFORMIX ESQL/C, ISQL, DBACCESS in UNIX environment.

Participating in the design and implementation of distributed software which is implemented in Oracle7 RDBMS. Completed prototyping of software modules of various transactions and reports using ORACLE FORM4.0.

Texas Instrument Inc., Texas Dates (August 1990– January 1991)

Software Engineer

Integrating automatic manufacturing system control system in local system local area network environment by using C, Database Communication(DBC), and TCP/IP communication protocol to remotely control cells, also by using U.S. Data Factory Link protocol to provide the interface for manual station operating under MSDOS.

Name Page Two

Clearrance:

Public Trust (SBA) active

MBI clearance (IRS) active

Secret Clearance with restric data(DOE) in processing

Top Secrect (inactive)

Education

The State University Of New York at Binghamton

B.A. in Mathematics Science, 1987

The Johns Hopkins University

M.S. in Computer Science (Sept, 1990),

Professional Certifications

List any Professional Certifications

OCP9i/11g Certified

Contact this candidate