SUMMARY:

• Over 20 years IT experience (including development and system engineer) with 18 years plus core/Apps DBA experience, capable to design the reliable, scaleable architecture and build the manageable enterprise technology for a company in the industry.
• Expert level experience in Oracle 9i/10g/11gR2 RAC, Data Guard, EBS11i/R12, OEM Grid Control, RMAN backup/recovery, and Networker.
• Expert level experience in Oracle installation, upgrade, large system architecture designing, capacity planning, consulting, backup/recovery.
• Expert level experience in performance tunings on SQL statements, indexes, network, OS and DB parameters using various tools such as tkprof, Statspack, SQL trace, AWR, ASH, ADDM, RACCheck, etc.
• Knowledge of the best practice in SQL and PL/SQL coding for the performance.
• Experience as a Principal Consultant for Confidential .
• Experience as an Oracle DBA instructor in one of Confidential .
• Experience in mentoring other DBAs.
• Experience in OBIEE, Hyperion, ASCP, Streams, GoldenGate, AS10g/FM11g, Linux, Solaris, AIX, HP - UX, Shell Script, NetBackup, MySQL and SQL Server.
• Strong ability in identifying problems, developing new ideas, and finding the best solutions.
• Experience on 24 by 7 on call for production database support or maintenance.
• Highly self-motivated and detail-oriented individual with excellent communication and personal skills.
• Broad knowledge in related areas such as Linux, Unix, Solaris, AIX, HP-UX, Suse Linux, Network, TCP/IP, Storage LUNs, Partitioning, Interconnect, Load balancer, Python, HTML, PHP, and CSS.

TECHNICAL SKILLS:

• HP9000, Sun E4500/6500, SP/2, IBM RS6000, disk arrays, tape library, IBM mainframe, Bridge, Routers, EMC Symetrix, EMC Clariion CS450, MS Windows, etc.
• Oracle7/8/8i/9i/10g/11g, RAC, Data Guard, OEM Grid Control, OBIEE, Streams replication, Shareplex, Advanced Replication, Oracle Applications 10.7/11/11i, Oracle Application Server 10g, SQL, PL/SQL, SQL*Loader, RMAN, exp/imp, MS SQL Server, HP-UX, AIX, Solaris 2.6, Linux, VCS, Veritas Netbackup, SQL*Net, Korn shell, Apache, etc.

PROFESSIONAL EXPERIENCE:

Sr. Database Engineer

Confidential, Tempe, AZ

Responsibilities:

• Performed many Oracle 11g and 12c installations on Linux and created/set up many single, RAC, and ADG databases for the Data Center migration with minimum downtime.
• Wrote python program to automatically check all Oracle databases on remote servers for compliance requirements.

Sr. Database Administrator

Confidential, Phoenix, AZ

Responsibilities:

• Created Oracle/PostgreSQL/MySQL databases on AWS RDS/EC2 for Oracle Access Manager upgrade. Created Chef scripts to automate the Oracle installation and database creation on EC2 servers. Also installed and configured MySQL Cluster on Google Cloud.
• Performed Oracle 11g RAC and Dataguard installation and configuration for Informatica repository databases on Linux multiple times including RQA and production environments. Performed hardening on Oracle databases based on the PCI compliance requirements.
• Uesed the dbms redefintion tool to redefine column data types on multiple very large tables in the data warehouse with almost no outage.
• Used partition exchange to moved old data from very large tables to archive tables with almost no downtime.
• Performed upgrade from 11.2.0.3 to 11.2.0.4 on multiple cluster environments.
• Provided the DBA supports for the Data Warehouse migration to Teradata 14.10 database. Set up the DEV/QA/Production database environments the project team. Worked with Teradata consultants and off-shore consultants to resolve various issues during migration.
• Implemented the backup strategy using RMAN and Networker. Scheduled the backup to tape and monitored the daily backup jobs including incremental and archivelog backups.
• Provided the DBA supports for the Reservation System migration/upgrade. Worked with the vendor on various issues during and after migration. Resynchronized the standby database in production using the Rman backup when the standby was out of sync with the primary due to lost of archivelogs caused by the server reboot.
• After the QA database was corrupted, with RMAN, rebuilt the entire QA RAC and Data Guard environment with two nodes on the primary site and two nodes on the standby site.
• Applied PSU in rolling fashion in the RAC and Data Guard environments. Created the document for operation and maintenance. Performed the standby switchover test.
• Configured the Goldengate extracts/datapumps/replcats for oneway replication.
• Installed/Upgraded OEM repository/OMS/agents to 12.1.0.5 and configured OEM to monitor hundreds of production databases and send alerts to DBA team, Operation personnels and business owners. Also installed Goldengate plugin and configured the new OEM to monitor the Goldengate processes using jagent. Investigated and troubleshot various issues and performed the root cause analysis and provided solutions to fix various issues. Performed various tunings for performanance issues.
• Provided the database security related reports to the Compliance department and remediated various security concerns based on the compliance requirements.
• Cloned production database from RAC to single instance on the AIX stage server, then the single instance was cloned to the QA in RAC configuration.
• As a DBA SME, reviewed and approved various database change requests/tasks including the design details documentations, database modifications, and database access, etc.

Sr. Oracle Apps DBA/DBA Lead

Confidential, El Segundo, CA

Responsibilities:

• Installed and configured the Oracle 11gR2 database in the RAC environment. Configured kernel parameters, NTP, and hangcheck-timer kernel module; installed required rpms and ASMlib 2.0 on Redhat Linux 5.3. Configured SSH and enabled SSH user equivalency. Worked with the System Administrator to configure the private, public, and virtual IP addresses for RAC. Installed the Cluster Verify Utility, Oracle Grid Infrastructure (clusterware) 11.2.0 and the Oracle Database 11.2.0. Created LUN partitions and ASM diskgroups on EMC CX3-40. Also installed the patchset update PSU 11.2.0.1.2 on the top of 11gR2 Grid Infrastracture (clusterware) and RAC installation on all nodes. Installed Cluster Health Monitor (IPD/OS).
• Deconfigured, deinstalled, cleaned up and rebuilt the clusterware on the crashed node and added the node back to the cluster.
• Designed and implemented the backup/recovery strategy and configured RMAN with EMC Networker and tested backup/recovery scenarios by restoring or duplicating from hotbackup without target and catalog connection or duplicating from active database. Performed logic backup using Data Pump.
• Configured the Data Guard and created the standby database using RMAN duplicate from active instance. Tested switchover and failover procedures in both SQL*Plus and the Data Guard Broker command line. Reinstated the failed primary database using the flashback database feature.
• Installed, setup, monitored, and troubleshot the GoldenGate for the bi-directional (active-to-active) replication. From primary to secondary, on primary, created extract/traillog group, datapump (extact, extsrc), extrail, rmttrail; on seconday site, create replicat group. From secondary to primary, on primary, created EXTRACT group, datapump, remote trail; on primary, created the replicat group. Used Conflict Detect and Resolution (CDR) to resolved uniqueness conflicts occurred during insert and update replication, update conflicts and delete conflicts such as no data found. Also configured the parameter files including getbeforecols, comparecols, resolvecols, reperror, etc, for conflicts resolution and various errors hundlings. Troubleshot and resolved various errors.
• Installed and configured OEM Grid Control master agent using Oracle 11g repository and client agents on multiple nodes.
• Upgraded the RDBMS from 10.2.0.2 to 11.2.0.1 and applied patchset 11.2.0.1.2 and other required or recommended patches. Migrated and converted the database characterset from US7ASCII to AL32UTF8.
• As required by the PCI compliance, created the wallet and configured the Transparent Data Encryption (TDE). Also configured Database vault and enabled the audit option.
• Monitored the performance and generated AWR, ADDM and ASH (Top Cluster events and Top remote instance waits) reports for perfomance tunings. Reviewd RACCheck report and configured hugepage. Monitored the interconnection bandwidth utilization such as RX, TX and packets errors, dropped, overrun, collisions, interrupts and worked with SA to fix various interconnect issues. Reviewed AWR report for high Global Cache Block Access Latency and tuned UDP.
• Tuned various SQL statements to reduce the high I/O waits by creating missed indexes or function based indexes; increased initrans on few tables and indexes to reduce the block contention for ITL (Interested Transaction List); tuned SGA size to minimize the number of connection timeout occurance; increased log simultaneous copies value to lower redo copy latch waits.
• Provided DBA support on both Oracle Applications 11i/R12 production (multi TB) and development environments running on Red Hat Linux, including cloning, patching, backup, tuning, troubleshoot, etc.
• Installed/configured Fusion Middleware/Weblogic/OBIEE11g/SOA/IDM, Hyperion, OBI Apps, DAC server repository, Informatica server/client.
• Installed/configured Oracle NoSQL database, MySQL 5.5, MySQL Cluseter 7.2, MySQL Workbench, MySQL Enterprise Backup/Monitor
• Provided support on the whole life cycle of Oracle E-Business R12 implementaion. Installed Oracle Appplications EBS Release 12.1.1. Applied HRMS HRglobal patches and performed other post installation configuration. Analyzed the requirements for RUP2 and Oracle Financial Critical Patch Collections (CPC). Upgraded R12.1.1 to R12.1.2 by applying RUP2 patchset then to 12.1.3 laterly. Also upgraded the database from 11.1.0.7 to 11.2.0.1. Cloned R12 instances from development to test then to production and vice verse using RapidClone utility (adpreclone.pl, adcfgclone.pl).
• Configured R12 Workflow notification mailer. Defined printer styles, types, and Pasta definition various profiles. Configured the mobile WMS (Warehouse Management System) and various printers using the PASTA.

Sr. Oracle DBA/DBA Lead

Confidential, Fullerton, CA

Responsibilities:

• Designed the highly available and scalable the architecture with the Oracle Real Application Cluster, Data Guard, Grid Control, and Streams technologies included. The architecture will support 24 by 7 availability with maximum 59 minutes down time per year and one thousand DMLs per second and 42 TB data on EMC CX-380. Researched, evaluated, and recommened the hardware, software, and storage technologies, performance, and capacity required to support the architecture. Also performed the benchmark test on Emc CX-380 and Sun Storage 6540.
• Installed and configured the RAC environment on Sun Solaris. Installed Oracle 10.2.0.1, the patchset 10.2.0.3, the Cluster Verify Utility, Oracle Clusterware 10.2.0.1 and the patchset 10.2.0.3. Created the ASM and cluster database instances using DBCA and created TNS listener using NETCA. Configured the Transparent Application Failover (TAF) and both client-side and server-side Connection Load Balance (CLB) in tnsnames.ora. Using the DBMS-SERVICE package, configured the RAC to use the Load Balancing Advisory (LBA) to determine how to balance new connections based on information in the SERVICE METRIC’s event (SME) and other FAN events.
• Installed and configured the Oracle Enterprise Manager Grid Control and its agents on multiple nodes.
• Configured the Data Guard in Maximum Availability mode, enabled Flashback feature on both the production and the target standby databases, enabled the Data Guard Broker configuration, configured Redo Transport Services in LGWR SYNC mode, and configured the Fast-start Failover Observer and enabled the Fast-start Failover.
• Configured, tested, monitored, and tuned Streams replication in the multiple source and multiple target environment. Turned on the supplemental logging on both db and table levels. Created db links, StreamsAdmin and granted privileges. Created the queue tables, AnyDataQueue, rules and rule sets tapply process, capture process, and propagation process. Manually instantiated objects and started/stopped capture, propagate, and apply process for testing and troubleshooting. Packages used are dbms rule adm, dbms streams adm, dbms adadm, dbms capture adm, dbms propagation adm, and dbms apply adm. Troublshot and fixed various issues related to capture, propagation, apply, network, truncate, DDL, etc. Also configured the replication from Oracle to SQL Server using Microsoft’s Oracle Publisher.

Sr. Oracle DBA

Confidential, Orange, CA

Responsibilities:

• Provided the DBA support on the production and QA databases in the Oracle 10g RAC and Data Guard environment.
• Tuned the SQL statements and tested various tuning options and improved performance 300% better for few reports utilizing AWR (Automatic Workload Repository) snapshots, ASH (Active Session History) report, and ADDM (Automatic Database Diagnostic Monitor).
• Designed and tested backup strategy using the RMAN and Netbackup.
• Providing the DBA support for the application teams throughout the development cycle.
• Troubleshoot various issues such as performance related issues, connectivity issues, space management issues, report job failure issues, etc.
• Refreshed the test and QA databases using data pump utilities.

Sr. Support Engineer

Confidential, Aliso Viejo, CA

Responsibilities:

• Installed Shareplex 5.1.0 and patches on Solaris, HP-UX, and Linux. Set up and tested various replication configurations and features such as one way, multiple targets, peer to peer, horizontal and vertical partitioning, intermediate replication using named queue, multi-thread post, etc.
• Worked with clients to resolve various Shareplex issues related to library errors, slow capture or post performance, log wrap, export or impor idle, core dump, queue corruption, compare hanging, reconcile hanging, out of sync between source and target, configuration, network connection error, and Oracle database related issue such as full table scan, index problem, privilege problem, slow performance such as inittrans contention, etc.

Sr. Oracle DBA

Confidential, Torrance, CA

Responsibilities:

• Providing the database support for five application teams throughout the development cycle and production databases in Oracle9i and Oracle10g environment.
• Installed, configured Oracle10g software and upgraded databases from Oracle9i to Oracle10g.
• Designed and tested backup strategy using the RMAN and Netbackup.
• Designed, created, and maintaining the logic and physical database models using ErWin 4.0.
• Tuning the SQL code and tested various tuning options. Created the bitmap index and partitions by list and improved performance for few major reports from few minutes to few seconds in a large data warehouse database.
• As a team member, worked with the migration team to migrate the databases from one data center to the new data center.

Sr. Oracle DBA

Confidential, New York

Responsibilities:

• Provided DBA support on Oracle Applications 11.5.7 (HR, FIN) production running on Sun Solaris and development support on development and QA databases.
• Installed and configured Oracle 9.2.0.1.0 multiple times on multiple Sun Solaris machines. Created more than fifteen databases and Auto Undo Management for rollback segments. Created locally managed tablespaces with segment space management auto option. Created spfile from pfile. Also installed the Oracle Patchset 9.2.0.4 on top of each Oracle9i binaries and upgraded all Oracle9i databases to 9.2.0.4 release.
• Migrated multiple Oracle8i databases to Oracle9i release. Converted database characterset from US7ASCII to WE8MSWIN1252 then to multiple-byte characterset AT32UTF8. Configured and tested automatical database startup and stop. Created multiple listeners on the development machine.
• Improved performance by tuning session cashed cursors, log buffer, checkpoint, redo logs. Eliminated Checkpoint Not Complete message. Minimized I/O contention on redo log activity.

Sr. Oracle Apps DBA

Confidential, Phoenix, AZ

Responsibilities:

• Analyzed and documented all requirements and impacts for Oracle Apps 11i upgrade from 11.5.1 to 11.5.6 (FIN, HR, INV, Order Management, inventory management, iMarketing, iPayment, iStore; Manufacturing) in a three-tier (multi-node middle-tier) Solaris environment. Before upgrading the production, cloned the production and tested the upgrade procedure three times in the testing environment.
• Recreated the digital certificate files adsign.txt using adjkey. Repackaged Jinitiator using adjbuild.sh.
• Regularly purged Concurrent Request and Manager data, Obsolete Workflow Runtime data and Signon Audit data.

Sr. Oracle DBA/Lead

Confidential, Princeton, NJ

Responsibilities:

• Managed the DBA team to supported on 24 by 7 mission-critical production databases (the largest one is around 1 TB), which provided thousands of internet and IVR users for the online billing services
• Performed the capacity planning and designed the file layouts. Designed the new database architecture that is two-dimensional and modulated by the vertical industry and horizontal services.
• Designed the VLDB data warehouse open architecture and models for one of client companies. The architecture could be scaled up to 131 TB data capacity using the Oracle9i Real Application Cluster (RAC) technology in a four E4500 cluster configuration.
• Designed and implemented the backup/recovery strategy using RMAN and Netbackup tools to improve reliability, manageability, and scalability on the backup/recovery and ensure the business continuity services.