Oracle Database Administrator
Resume:
Grace Chen
(US Citizen)
San Jose, CA 95133
*****.****.***@*****.***
OBJECTIVE Oracle Database Administrator
EDUCATION
Member of Northern California Oracle User Group 2015 - present
Linux & Unix System Administration, Foothill College, Los Alto, CA 2016
Oracle 12c Database Administration on Linux I and II, University of California Ext., Santa Cruz, CA 2016
Introduction to SQL, Introduction to PL/SQL, De Anza College, Cupertino CA 2015
O.C.P. Oracle 10g, 11g Administrator Certified Professional 2012
Certificate in Database Systems, University of California Extension, Santa Cruz, CA 2009
M.S. in Computer Science, California State University at Northridge, Northridge, CA
B.A. in Law, National Taiwan University, Taipei, Taiwan
EXTRACURRICULAR ACTIVITIES
Installed and configured Oracle 12.1.0.2 databases with Grid Infrastructure and Automatic Storage Management on CentOS 7 using VMware Player 12.1.1 on Microsoft Windows 10 server.
Installed and configured Oracle 12.1.0.2 databases with Grid Infrastructure and Automatic Storage Management ASMLib on Oracle Linux 6.8 using Virtual Box 5.1.4 on Microsoft Windows 10 server.
Installed and configured two nodes Oracle 12.1.0.2 Real Application Cluster databases with Grid Infrastructure and Automatic Storage Management ASMLib, Bind DNS server on Oracle Linux 6.8 using Virtual Box 5.1.4 on Microsoft Windows 10 server.
Installed and configured Oracle 12.1.0.2 databases with Grid Infrastructure and Automatic Storage Management on CentOS 7 using Amazon Elastic Compute Cloud EC2 on Amazon Web Services AWS.
Upgraded Oracle databases from 11.2.0.4 to 12.1.0.2 on Oracle Linux 5.4 using Virtual Box 5.1.4 on Microsoft Windows 10 server.
Migrated Oracle databases from 11.2.0.4 to 12.1.0.2 via Full Transportable Export/Import Data Pump on Oracle Linux 5.4 using Virtual Box 5.1.4 on Microsoft Windows 10 server.
Created and upgraded Oracle databases from 12.1.0.1 to 12.1.0.2 on Oracle Linux 5.4 using Virtual Box 5.1.4 on Microsoft Windows 10 server.
EXPERIENCE
Database Administrator, UniversalEC, Taipei, Taiwan 2010 - 2011
Administered 23 databases including Oracle 8.1.7.4, Oracle 9.2.0.4, Oracle 10.2.0.5, Oracle 11.2.0.2, MySQL and DB2 databases on HP-UX B.11.00, HP-UX B.11.31, Red Hat Linux 2.6.9-5, Microsoft Window Server 2003 SP2 and Microsoft Window Server 2008 in a 24*7 production environment.
Migrated Custom Clearance database systems from Oracle 8.1.7.4 on HP-UX B.11.00 to Oracle 10.2.0.5 on HP-UX B.11.31 using HP Service Guard Clusters to achieve hardware high availability and utilized Oracle 10g Data Guard standby databases on HP-UX B.11.31 for remote backup and disaster recovery.
Used Oracle Export/Import utilities to migrate data from Oracle 8.1.7.4 database on HP-UX B.11.00 to Oracle 10.2.0.5 database on HP-UX B.11.31; Used RMAN backup/restore scripts to load data from the primary database on HP-UX B.11.31 into the remote standby database on HP-UX B.11.31.
Developed data synchronization scripts using Oracle 10.2.0.5 SQL, PL/SQL on HP-UX B.11.31 thru database links to synchronize data between old and new primary databases during database migration.
Designed and implemented Custom Clearance Billing systems using database cloning: created Oracle 10.2.0.5 Billing database; cloned Oracle 10.2.0.5 Data Guard standby database on HP-UX B.11.31; renamed and opened the cloned database in read-write mode for Custom Clearance Billing processing.
Created Oracle 9i, 10g, 11g databases using Oracle Universal Installer and database creation scripts on HP-UX B.11.31, Microsoft Window Server 2003 SP2 and Microsoft Window Server 2008.
Designed and developed Shell Scripts and SQL Scripts to monitor database systems performance including cpu, disk, memory, network, Oracle database connections, SGA, PGA, UGA usages.
Installed HP-UX kmeminfo memory information tool to monitor memory usages on HP-UX B.11.31.
Created and maintained Oracle 9.2.0.4 Data Guard standby databases for Electronic Invoice systems and Sports Lottery systems on Red Hat Linux.
Upgraded Sports Lottery database systems from Oracle 9.2.0.4 to 9.2.0.8 on Red Hat Linux.
Created Oracle 9.2.0.4 database in Traditional Chinese Taiwan ZHT16MSWIN950 character set and loaded data from Oracle 10.2 Simplified Chinese China ZHS16GBK character set export dump files.
Performed routine DBA tasks: created and reviewed AWR(Statspack) reports; performed database systems and SQL tuning; purged data; rebuilt indexes; gathered database object statistics; trouble-shooted database system problems including finding out the root cause of deadlock problems of Custom Clearance database systems and the memory leak problems
from application programs of Sports Lottery systems.
Database Engineer, NetDeposit, San Mateo, CA 2006 - 2007
Maintained and enhanced electronic check processing systems using Oracle 9i, Oracle 10.2.0 SQL, PL/SQL, on Linux and Sun Solaris 10.
Maintained and enhanced database utilities including Partitioning, Import/Export utilities using Shell Scripts, Oracle 10.2.0 SQL, PL/SQL on Linux and Sun Solaris 10.
Designed and developed automatic database patch installer using Shell Scripts, Oracle 10.2.0 SQL, PL/SQL on Linux and Sun Solaris 10.
Software Engineer, Commerce One, Cupertino, CA 2001 - 2002
Installed, configured, debugged and administered Market Site Builder systems using JRE 1.3.1, JRun 3.1, Netscape LDAP Server 5.0, SiteMinder Policy Server 4.6.1, Web agent, Oracle 8.1.7, IDS Server 3.5.4, Apache Web Server 1.3.14 with SSL or iPlanet Web Server 4.1 with SSL on Sun Solaris 2.8.
IT Technical Staff, Hewlett Packard, Palo Alto, CA 2000
Maintained and enhanced financial systems using Shell Scripts, Oracle 8.0.2 SQL, PL/SQL and Hyperion Essbase Data Warehouse on HP-UX 11.00 and Windows NT 4.0.
Designed and implemented billing systems using Java Servlet, JDBC, Oracle 8.1.6, JavaScript and Dynamic HTML through Sun iPlanet Web Server on HP-UX 11.00.
Installed and configured iPlanet Web Server, Oracle JDBC driver and SQL*Net on HP-UX 11.00.
Sr. Programmer Analyst, JCIC, Taipei, Taiwan 1999
Designed and implemented credit information systems using Java Servlet, JDBC, DB2, C, JavaScript, HTML thru MQSeries Message Queue utility and WebSphere Web Application Server on IBM AIX.
Sr. Software Engineer, Buypass Corp., Pleasanton, CA 1997 - 1998
Designed and implemented electronic payment processing systems on internet using Java, RMI, JDBC, Oracle 7.3 SQL and HTML through Microsoft IIS Server on Windows NT 4.0.
Sr. Programmer Analyst, Citation Insurance Co., San Jose, CA 1995 - 1996
Maintained and enhanced property & casualty and workers' compensation insurance processing systems using Sybase 10.0.2 Transact-SQL and SQR Report Writer on Sun Solaris 2.4.
Technical Consultant, Analysts International Corp., San Jose, CA 1994 - 1995
Contract Assignment with IBM/ISSC, Palo Alto, CA
Developed IBMLink news bulletin board service software on internet through Mosaic Browser using C and HTML on IBM RS6000/AIX.
Contract Assignment with First Image Corp., San Jose, CA
Converted print image processing systems from IBM MVS to Sun Solaris using C and Shell Scripts.
Contact this candidate