| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Email: EMAIL AVAILABLELinkedIn: https://LINKEDIN LINK AVAILABLEPhone: PHONE NUMBER AVAILABLELocation: Princeton, NJStatus: U.S. CitizenSummary: Passion for perfection. Lifelong learning. Innovative solutions. Process improvement to sustain the goal.Over 20 years of global IT supporting over 5000 databases, with innovative one-click solution to answer real time questions. If you can't explain it simply, you don't understand it well enough. --Albert EinsteinOracle database administrator in performance tuning, IT environment reporting, monitoring, and M&A.C/C++/PL/SQL/Shell development, data modeling, ERP application support, data warehouse, automation, incident management, change management, problem investigation and document compliance.ExperienceDatabase AdministratorJohnson & Johnson headquarter, Raritan, NJ10/19/1998-10/16/2020Created, coordinated, and reviewed database compliance documents, including SOP, WI and TMP.Oracle Enterprise Manager application owner from 2010 to 2020.Deployed Oracle 12.2: including NetBackup, Oracle Internet Directory, new functionality, backup/recovery, Oracle Enterprise Manager monitoring, automate cloning on Red Hat Linux, SUSE, and HP-UX.Oracle auto data refresh: refreshing data with different setting, including standby, read only, character sets, database service account privileges, NAS storage design, Novell Identity Manager, ServiceNow Change Management and VMware VRO automation.Oracle Central Server: designed and implemented ad hoc reporting tool for over 2500 Oracle databases from 9i to 19c.ServiceNow platform upgrade to Geneva version: performed quality assurance for all the database support related components.Ortho-Clinical Diagnostics divesture from Johnson & Johnson: led the effort from the database team.Change Management template creation: automated change record by using templates in ServiceNow.SharePoint Administrator: migrated three SharePoint 2017 sites to SharePoint 365 and created sites to provide real time reporting.Oracle Enterprise Manager Administrator: deployed Oracle database monitoring with Oracle Enterprise Manager and integrated with ServiceNow and other tools.HP-UX clustering environment database administrator: led the effort from the global database team.Corporate database service coordinator: improved database services.Lawson HR/Payroll application database administrator: supported as application database administrator for OLTP and reporting.AT&T, Piscataway, NJ09/01/1997 - 09/30/1998Data warehouse DBA for project Falcon using star schemaData modeling and production support for project Falcon which used Oracle parallel server.Sony and Xilinx, San Diego and San Jose, CA1/01/1996 - 08/31/1997DBA to setup security of Oracle financial at Sony.DBA for Manufacturing applications at Xilinx.Oracle headquarter, Redwood Shore, CA11/02/1995 - 10/31/1996Production DBA to support Oracle global Financial.C/C++ Developer on Unix/WindowsIBM, Santa Teresa Lab, San Jose, CA09/01/1990 - 11/01/1995Tool Developer for the following tools:TIRS: expert system shell, a knowledge base system.C++ interpreter to link compiled code with interpreted C++ code.Data Hub: console to integrate multi-vendor RDBMS for user to drag and drop a table from one vendor database to another one.AchievementsI/T Strategy Award: Improve PVSIR Upgrade and Aris Migration.Crown of Excellence Award: Significant contributions by implementing an innovative and cost-effective solution that focused on consolidating a global view of employee data via Project STEP, HR reporting application.Global Standards of Leadership Award: Achieving exceptional business results by demonstrating outstanding leadership behaviors embodied the Global Standards of Leadership for Project JJEMS Mini-Dome Migration.SkillsCoding: Unix shell script using SSH, C/C++/PL/SQL/Python programmingOracle Enterprise Manager: including OEM deployment, AWR, ASH, ADDM, target database data collection using emcli, report generation, database performance tuning, in-memory column store, SQL tuning with recommended index creation, SQL profile, application connection pooling, database connection retrial setting, OS performance monitoring, F5, multiple OMS servers with standby database and VMWare VM failover, and network monitoring.Oracle database: Active Data Guard, Data Guard Broker.OS platform: RHEL, SUSE, HP-UX, Windows, and AIX.DR: VMWare Disaster & Recovery.ServiceNow: incident management, change management, problem investigation, knowledge articles, automation.EducationU. of California at Riverside, CaliforniaMS in Computer ScienceNational Chung Hsing University, TaiwanBA in AccountingLanguagesEnglishMandarinPassionsAnswering my own questions.Learning from YouTube: including home repair, technologies, psychology, history, book summary and politics.Challenging myself how to get things done with free or minimum cost of daily challenges.Learning social inequality and solutions. |
