SUMMARY:

To apply for a position of Epic Cache DBA & Clarity ETL Admin in your company.

TECHNICAL SKILLS:

Database: Epic Cache 2017, Epic Clarity DBA with Oracle Database and MS SQL Server.

Skills: KB SQL, Hyperspace, Clarity Console, Cogito Console, EPIC StudioChronicle Mumps Programming, Crystal Reports used in Epic environmentOracle Database 11gR2/12c, RAC, Grid, ASM, RAC, OEM / Grid Control Dataguard, SQL Loader, Import / Export, datapump, Rman Backup & RecoveryMS SQL 2012/2014 and Cache DB 2014 used in Epic Implementations

Performance Tuning with: Oracle, MS Sql server and Cache 2017 db.

OS: Redhat Enterprise Linux 7, UNIX Solaris ( System Administration, Backup, NFS )

Skills: HPUX 11i, IBM AIX UNIX, VNC, VMWare, Oracle, VM Manager 3.2.4 and 3.3.1

EXPERIENCES:

Epic Cache DBA

Confidential, Bethlehem, PA

Responsibilities:

• Upgraded multiple non - prod environments to Epic 2018 ICC by conventional upgrade.
• Implemented new Epic EPS printing environments for Epic 2018.
• Upgraded multiple low environments to Epic 2017 using conventional upgrade
• Upgraded SUP and PRD environments to Epic 2017 using transparent upgrade
• Applied multiple SU patches into non-prod and prod environments.
• Fixed ESMP communication issues between multiple PROD DR members, and fixed redalert checkdrreadieness issues.
• Per training team's request, adjust training environment envcopy jobs.
• Created a daily script to report training envcopy job status.
• Deal with multiple tickets of user TEXT access in UNIX and Cache user level.

Epic Cache DBA

Confidential, Durham, NC

Responsibilities:

• Prepared multiple Linux servers OS for fresh Epic installations, Kernel parameters, user/groups, skel profile,
• Obtained necessary certificates, including mirroring certficates, weblob certificates, esmp certificates
• Created cache users using epic cusers utility so TEXT users could pass through when they login to linux via putty.
• Installed multiple Epic Cache 2017 Environments, MPI, POC, TST, TSTRPT, RELBLD, PLY.
• Designed a temporary Epic Cache Backup solution for the new nonprod environments.
• Configured the new epic environments redalert and trove to work with System Pulse servers
• Setup new Epic environments to work with DataCourier
• As the only Certified Epic Security Coordinator, roll out initial Security Plan for different Epic teams for their TEXT / Epicmenu access, and their Hyperspace access.

Epic Cache DBA

Confidential, Durham, NC

Responsibilities:

• Upgraded Epic Cache from 2015 Upgrade to 2017 in multiple testing environments.
• Upgraded Epic Cache from 2014 Upgrade to 2015 in multiple environments by conventional upgrade and transparent upgrade.
• Apply Epic monthly SU patches in different environments per change tickets.
• Migrated Shadow replication configuration to Mirror replication configuration with Reporting Mirror and DR mirror.
• Upgraded Cogita Star from V10 to V12.2 then to V13.2 in PROD, TEST and DEV
• Optimized 2 Caboodle slow executions of PatientRegistryValueFact and FlowSheetValueFact tables by doing Oracle profiling and shortened the executions from more than 12 hours to 4 hours.
• Supported a MSSP external data load into Cogito Star database.
• Planned to install Slicer Dicer environments of DEV, TST and Production

Epic Cache DBA Consultant

Confidential, Seattle, WA

Responsibilities:

• Migrated 4.5 TB Epic Cache database from AIX to Linux, by using Mirror Configuration across AIX and Linux to dramatically cut migration down time.
• Supported an Epic Cache 2014 Upgrade project from Epic Cache 2012, for a major hospital in Northwestern Region:
• Used instaServer to upgrade all Epic Server Admin Scripts,Redalert, etc components to 2014 in advance.
• Upgraded System Pulse to 2014 on its web/ms sql server in advance.
• Performed all pre-checks for Epic 2014 Upgrade and fixed all pre-check failures.
• Implemented a disaster and recovery plan for this Epic implementation, by using EMC Avamar software and SAN scripts ( EMC naviseccli fractureclone ) to online backup this 2.5TB Cache DB
• Redesigned a multi TB sized Oracle 11gR2 Data Warehouse database which works with Epic Clarity ETL application, load data from Epic Cache 2014 DB.
• Revised Epic Cache DB refresh procedure by using new backup methods and envcopy
• Served as Oracle Expert for this large Epic implementation including Clarity ETL
• Solved various performance problems in Clarity ETL loading jobs, optimized Oracle Data Warehouse database to complete several critical overnight reports.
• Production support of Epic Cache 2014 database, administrate 2.5 TB Epic Chronicles Cache DB 2014.
• Write customized scripts and crontab jobs to monitor multiple servers of this large Epic implementation.

Oracle DBA Consultant

Confidential, Bellevue, WA

Responsibilities:

• Doing Vertex implementation with EBS R12.1.2, installed Weblogic servers and vertex application servers, configured vertex taxlink in R12.
• Adding 3rd node into existing RAC EBS R12 configuration
• Implementing deduplicate feature of FND LOBS in R12 PROD database, saved 50% SAN disk space.

Oracle DBA Contractor

Confidential, Redmond, WA

Responsibilities:

• I successfully tuned its PROD system on its all 6 areasthe results were striking, users are very happy with the results.
• Successfully tuned Crane’s EBS PROD system, results are striking: no more complaints from end users, all concurrent requests are completed in a timely manner.
• Provide DBA support for Crane’s Taiwan Implementation, including migrating customized codes, rapid clone new environments for UAT testing.

Oracle DBA Contractor

Confidential

Responsibilities:

• Support Oracle BI application OBIEE and informatica Powercenter ETL tools.
• Support a multiple TB sized Oracle EBS RAC PROD environment.
• Migrated R12.1.2 from HP-UX to HP Itanium, then migrated to 11.0.7 RAC environment
• Worked as a DBA to upgrade EBS 11.5.10.2 to R12.1.2 on HP RISC platform
• Successfully troubleshoot performance issues of Oracle Apps R12.1.2, and this is my third case of successful performance tuning of Oracle E Business Applications.
• Work with offshore DBA team to achieve important milestones.
• Convert a 4 nodes configuration of EBS R12.1.2 to 11gR1 RAC environment
• Use Rapid Clone to refresh test / dev from production in R12.1.2, troubleshooting various situations of missing library, completing cloning with post clone steps.
• Design and implement a rman backup strategy for this client.
• Follow and work with SOX processes defined by this client.
• Work with metalink for various troubleshooting service requests.
• Design and implement a logical dataguard to replace old clone-based data warehouse
• Performance Tuning in our production R12 EBS application after upgrade.
• Plan an Oracle 11.1.0.7 RAC ASM environment for this R12.1.2 EBS Apps on HP-UX.

Senior Cache DBA

Confidential, Madison, WI

Responsibilities:

• Support a multiple TB Cache database Environment used in Epic 2006 and 2008.
• Support Epic Clarity ETL with MS SQL Server 2005 database warehouse
• Build a huge oracle database warehouse to meet various needs from different departments.
• Work with Intersystem vendor support to troubleshoot Cache DB technical issues
• Work with Oracle metalink for various troubleshooting service requests.
• Research ( patch README.txt ), test, apply patches by using adpatch in 11i and R12.
• Performance Turning in our production R12 EBS application after upgrade.
• Building an Oracle 11.1.0.6 RAC ASM environment on Enterprise Linux platform.
• Setup an Oracle 11g Dataguard environment on Enterprise Linux platform.
• Setup rman backup script jobs for 11g RAC ASM environment.
• Work independently to solve a transient performance problem of real time shop floor database Exacta, which outsourced consultants could not solve for months.
• Successfully completed NEXTGEN performance tuning project and speedup database 500%
• Work with consulting team to upgrade Oracle Clinical to 4.5.1
• Work with many other projects, including NIMS, NextGen, Tibco Applications.
• Design and implement new RMAN backup strategy for Covance Madison Site.

Oracle Database Administrator

Confidential, Madison, WI

Responsibilities:

• Upgrade Quest shareplex from 4.X to 5.X version.
• Upgrade several mission critical databases from 8i to 9i.
• Implement new backup standard using rman and catalog
• Research on project path of implement 10G RAC on Linux

Oracle Application DBA

Confidential

Responsibilities:

• I am responsible to manage multiple instances of Oracle 8i / 9i Database running on HPUX Servers and Sun UNIX Servers and Windows platform, also support multiple instances of Oracle Application 11.5.8 ERP Suites of Oracle Financials, Manufacturing, Puchasing, Order Managementwork with Oracle Metalink for TAR and Patches.
• Additionally work with 1 TB of EMC Symmetrix disk storage, HP Omniback.
• Upgrade existing 11.0.3 Oracle Applications to 11.5.8 version.
• Implement WIP tracking project with customized workflow, forms and reports.
• Install several 11i instances on different platforms for testing purposes.
• Use Oracle 2.6 workflow and customized stored procedures to implement Order Fulfillment Project.
• Upgrade Oracle 11.5.8 Applications to 11.5.9.
• Work with Metalink and TAR, find correct patches to fix Oracle Application Problems.
• Apply Oracle Application Patches into Test instance first, then Production instance.
• Consult with end users about maintenance downtime of Oracle ERP PROD instance.
• Work with development team to meet new database needs for our ongoing projects.
• Stop and restart concurrent manager, add different numbers of concurrent managers.
• Submit and reschedule MRP jobs in Oracle ERP Application.
• Revise Oracle Application Responsibilities, profiles, and setup UNIX / ERP printers.
• Check Error Requests in Oracle Applications, and find fixes for these error requests.
• Schedule and monitor weekly purge jobs of request logs and output files.
• Resize Rollback Segment and Temp Tablespace to meet Oracle Applications Need.
• Change Physical Parameters of storage according to the growth of tables and indexes.
• Check Omniback and make sure daily backup jobs are finished properly.
• Run perfstat, utlbstat and utlestat scripts in order to do performance tunning.
• Check tablespace storage growth, disk free space, resize autoextend maxsize.
• Check Alert log and trace files to trouble-shoot possible problems.
• Monthly flush production database into test instance in order to keep test current.
• Use glance, top commands and other scripts to find bad processes and sessions.
• Find and kill old Oracle Form User Sessions which lock certain resources.
• Monitor Active Users sessions, Locked objects and locked sessions.
• Monitor running requests and resource cosumptions.
• Find and cancel wrong print jobs in UNIX system.