Eric Ho
Database Administrator, Sr. Staff
San Diego,CA
Summary
IT System Architect professional with extensive experience in Oracle relational database design, implementation, and administration. Successfully performed administration, performance tuning, backup and recovery, networking, and security for databases in complex environments. Provide technical leadership to the database team in a fortune 500 company. Transitioning database technology to NoSQL, distributed databases using MapR, Cassandra, Vertica, and AWS. Involved in all aspect of information technology from hardware, software, OS, storage, network, and security.
Overview
27
27
years of professional experience
Work History
Database Administrator , Sr. Staff
QUALCOMM
San Diego, CA
05.2007 - Current
- Lead the data transition project to migrate on-premise data to the Cloud in AWS
- The project involved moving 2 Petabytes of data across 5 major applications with red-ip data using Snowball, AWSCLI, and datasync
- TLS was implemented to encrypt network traffic using TCPS protocol and Qualcomm generated certificates
- Data at rest was encrypted using a combination of SSE-S3 and KMS
- Lifecycle Management policies were put in place to archive data to Glacier Deep Archive cutting the storage cost by nearly $1 million each year
- Migrated on-premise Exensio application for data analytic from Oracle to AWS using open source Apache Cassandra running on EC2 instances
- The migration allows data to be loaded on time for engineers to analyze and reduce waste on chip manufacturing
- Purchased new SuperMicro servers to replace 28 nodes Cisco UCS servers to refresh the hardware due to instability and out of support issues on the old servers
- The transition to new hardware involves installing RHEL 7.x, Vertica software, and migrating the database over during the cutover process
- Implemented Vertica clusters for our Optimal Plus application during the transitioning from SQL Server
- Backend for parametric data is on MapR Hadoop cluster
- Designed backup, monitoring, and configuration of the Vertica database clusters running on VMs and physical hardware
- Planned and managed the migrations of databases from San Diego and Las Vegas data centers to the Switch, NV Supernap colo for QCT Engineering databases as a part of Project Nevada
- This involves switching to new hardware, virtualizing many of the environments, and coordinating with the project managers, web tier, and application components
- Managed the relabling, scanning, and mounting the 3PAR LUNs for the Data Power Copy-on-Write refresh process in Las Vegas
- A repeatable process has been created to ensure that the monthly clone refreshes are successful on 3PAR as it has been with NetApp
- Migrated QCT Analytic Netezza database from the Skimmer to the TwinFin6 using the NZBACKUP and NZRESTORE utilities
- Provides leadership and guidance to Senior, Intermediate and Offshore DBAs for technical issues and project planning
- Planned and standardized the migration of Oracle data warehouse databases from Oracle to Netezza Appliance on both the Skimmer and TwinFin systems
- The move to postgres database was to improve data warehousing performance as well as cut down on the time to implement new applications
- Configured monitoring for the entire Netezza stack to email and page Netezza DBAs for minor and major alerts respectively.
Database Administrator , Senior
Sony Online Entertainment
San Diego, CA
07.2006 - 05.2007
- Installed Enterprise Manager Grid Control, upgraded to version 10.2.03, and administered the tool to allow the Database Administration group to make use of its capabilities
- This includes sending messages to the SNMP host for Operations monitoring, setting metrics alerts and thresholds, and staging the EM agents for ease of installation for future hosts and reinstall
- Documented the streams configuration process
- Worked with Oracle Development to on a one-off patch for 10.2.0.2 on streams purged process creating orphan segments and quickly consuming the streams tablespace
- Setup reports for streams latency and over spilled messages
- Run and analyzed streams health check reports to trouble-shoot problems with streams capture, propagation, and apply processes
- Implemented metrics and monitoring for Soemon3 prior to the launch of the PS3
- This included numerous hours trouble-shooting and configuring the Net SNMP agent to query the Oracle MIBs and Non-Oracle MIBs trees through the OEM subagent
- Migrated the SCE warehouse from ocfs2 to RAW file system due to ocfs2 memory corruption
- This included laying out a RAW file system mapping, installing Oracle 10g RAC, and recreating the database
- Responsible for the RMAN full and incremental backups using block change tracking for the data warehouse Production and Non-Production environments
- We also use clone splits technology for backup of databases on a daily basis
- I have setup backup on the clone splits site where the daily splits are mounted to reduce performance hits on the main Production warehouse
- Repartitioned large tables in the data warehouse to make use of partition pruning and data management
- The maintenance includes compressing old data partitions and using online table redefinition to move the data to read only tablespaces.
Database Administrator
QUALCOMM
San Diego, CA
03.2005 - 07.2006
- Involved in the successful implementation and monitoring of the Corporate ERP system from the initial phase of development through the support cycle
- Migrated database instances off legacy servers from our San Diego data center to Las Vegas as well as upgrading non-supported Oracle versions to Oracle 9i and 10G
- Setup customized auditing in ERP for SOX compliance
- Trained offshore DBA in the day-to-day maintenance of QUALCOMM database systems and to handover off hours DBA support
- Standardized and setup statistics gathering through statspack for troubleshooting performance related issues
- Installed, configured, and upgraded Oracle server software in a UNIX environment including security and Oracle Application’s interoperability patches
- Performed ERP database refreshes through WAN cloning strategy involving Veritas FlashSnap, ShadowImage, and TrueCopy technologies.
Database Administrator
MedImpact Healthcare Systems, Inc
San Diego, CA
11.1998 - 01.2005
- Revamped the data refresh process resulting in 50% reduction in preparation and runtime
- Implemented an automated statistics gathering process utilizing Oracle and cron jobs resulting in increased performance through the cost base optimizer
- Developed a data warehouse for a client application using star schema configuration
- Lead the database development effort for the throw away claims (TAC) and Sandbox projects
- These tools served as test facilities prior to adjudicating and moving actual claims into the Production databases
- Provided on call support in emergency situation for 24/7 availability; resolving conflicts and restoring databases through RMAN in the event of a disaster recovery.
Data Analyst
The Araz Group
Bloomington, MN
10.1997 - 10.1998
- Developed and standardized clients’ annual reports by creating MS Access database to retrieve information from Oracle DBMS
- The automated process reduced production time from 3 hours to 15 minutes per report for a total saving of 1,100 hours annually
- Interfaced with actuarial consultants and perform actuarial analysis of the Company’s business for bringing in prospective clients
- Created automated reporting tools through MS Access and Oracle
- These reports focus on the primary functions such as Claims, Enrollment, Utilization Management, and Provider Services.
Inventory Reporting Analyst
Fingerhut Companies, Inc
Minnetonka, MN
11.1995 - 10.1997
- Established an automated online program scheduling tool in Microsoft Access allowing timely updates and revisions to critical due dates for key projects in the company
- The online scheduling database has a realized cost saving of over $40,000 per year by eliminating approximately 1,700 hours of labor
- Analyzed data from inventory systems in DB2 and developed summary reporting for buyers and management for purpose of making inventory control decisions.
Education
Bachelor of Science -
University of San Diego
Oracle Certified Professional (OCP) - undefined
Netezza Appliance Training - undefined
Certified Apache Cassandra Administrator - undefined
AWS Certified Solutions Architect Associate - undefined
Skills
TECHNICAL SKILLSOracle 80, 8i, 9i, 10g, 11g, 12c, 19c, 13c Oracle Enterprise Manager, Grid Control, Oracle Streams, ERP, TOAD, Golden32, DB2, Veritas Cluster Server (VCS), Precise i3, Concord, UNIX, Linux, Solaris, CentOS, Oracle 9i, 10g, 11g RAC, Windows NT, RMAN, SQL, PL/SQL, SQLLoader, Erwin, Korn Shell, Microsoft Access, MS Excel, MS Word, RAW, ocfs2, Veritas File Systems, NetApp, ASM, Oracle Advanced Security, Postgres DB, Netezza Appliance, Enterprise Database (EDB), ADDM, AWR/Statspack, APEX, OID, Data Guard, Flex Cloning, Shadow Image, CRM, Flashback Database, Informatica Power Exchange, 3PAR Copy-On-Write, VMware, Solaris LDOM, RAC One, Extended RAC, Oracle SOA, Vertica 93, MapR, Cassandra, Medusa, AWS, SSL/TLS
Database development
Linux operating system
Implementing security measures
Apache Cassandra
Systems administration
Relational Database Management
Additional Information
- ACTIVITIES AND ACHIEVEMENTS , San Diego Oracle Users Group (SDOUG), Oracle Open World, Oracle Apps World, Platinum Qualstar (QUALCOMM), Fingerhut Jackson Awards, Fingerhut Employee Action Committee, Beta Alpha Psi, USD Honors Program, AWS reinvent
Running, hiking, biking
Enjoy road biking as well as mounting biking on the weekend. Ran Spartan races for 3 years receiving 3 trifectas. Occasionally surf down in Encinitas and Del Mar.
Timeline
Database Administrator , Sr. Staff
QUALCOMM
05.2007 - Current
Database Administrator , Senior
Sony Online Entertainment
07.2006 - 05.2007
Database Administrator
QUALCOMM
03.2005 - 07.2006
Database Administrator
MedImpact Healthcare Systems, Inc
11.1998 - 01.2005
Data Analyst
The Araz Group
10.1997 - 10.1998
Inventory Reporting Analyst
Fingerhut Companies, Inc
11.1995 - 10.1997
Bachelor of Science -
University of San Diego