OBJECTIVE:

Oracle Database Administrator

SUMMARY:

• 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.22 on Microsoft Windows 10 server.
• Upgraded Oracle databases from 11.2.0.4 to 12.2.0.1 on Oracle Linux 6.8 using Virtual Box 5.1.22 on Microsoft Windows 10 server.
• Migrated Oracle databases from 11.2.0.4 to 12.2.0.1 via Full Transportable Export/Import Data Pump on Oracle Linux 6.8 using Virtual Box 5.1.22 on Microsoft Windows 10 server.
• Created and upgraded Oracle databases from 12.1.0.2 to 12.2.0.1 on Oracle Linux 6.8 using Virtual Box 5.1.22 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.
• Created and upgraded Oracle databases from 11.2.0.4 to 12.1.0.2 on Red Hat Linux using Amazon Relational Database Service RDS on Amazon Web Services AWS.

EXPERIENCE:

Database Administrator

Confidential

Responsibilities:

• 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; 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

Confidential, San Mateo, CA

Responsibilities:

• 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.

Software Engineer

Confidential, Cupertino, CA

Responsibilities:

• 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

Confidential, Palo Alto, CA

Responsibilities:

• 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

Confidential

Responsibilities:

• 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

Confidential, Pleasanton, CA

Responsibilities:

• 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

Confidential, San Jose, CA

Responsibilities:

• 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.