SUMMARY:

• More than 10 years' experience in Information Technology as Unix - like platform system administrator, Oracle Database Administrator (9i, 10g, 11g) and PL/SQL developer.
• 12+ years experiences in Unix-like system administration (including IBM AIX / HP-UX / Linux). Proficient in developing management / monitoring scripts by using Korn/Bash Shell and Perl.
• Six years in-depth knowledge and solid hands-on experiences of installation, configuration, trouble-shooting and performance tuning in Oracle 10g/11g R2 RAC (Real Application Cluster), ASM (Automatic Storage Management ), Data Guard (physical standby database), Oracle Golden Gate middleware, Oracle Enterprise Manager.
• Deep understanding about Exadata specified features such as Smart Scan, HCC (Hybrid Columnar Compression), Flash Cache, etc.
• First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.
• Provided and implemented performance tuning recommendations of all components in Exadata database machine. Advised, provided guidance and develop Disaster Recovery strategies for the Exadata Database machine.
• Analyze and determine the feasibility of leverage the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.
• Develop and record certified processes/procedures for all potential IT downstream support groups to maintain and upgrade the Exadata database machine.
• Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
• More than six years experiences and solid hands-on experiences in Installation / Configuration / Performance Tuning / Trouble shooting Oracle Goldengate (OGG) in both homogeneous and heterogeneous environments (including Oracle to Oracle and MS SQL Server to Oracle).
• Extensive skills to configure and build one-way, tow-way, active-to-active Oracle Goldengate Extract/Replicat for multiple databases.
• Strong experiences in configuration and building heartbeat monitoring in Oracle Goldengate. Develop flexible home-cooked Korn scripts to monitor the Goldengate lags.
• Configure error handling for Oracle Goldengate restart, logging, production support and status reporting.
• Hands-on experiences in trouble shooting and performance tuning Oracle Goldengate replications. Working with Oracle on SRs for critical issues.
• Primary technical resources to upgrade Oracle Goldengate from 11g to 12c in Exadata machine environment; design Goldengate HA solutions by using Oracle 11.2.0.4 Clusterware functionality.
• Proficient in Oracle database backup & recovery strategies plan and implementation such as RMAN backup with/without catalog, cold and hot backup, full/incremental backup. Hands on experience in disaster recovery.
• Highly skilled in SQL and PL/SQL Tuning, TKProf, Explain Plan. Expertise in monitoring and performance tuning of Oracle database through tuning application, memory and disk by using Statspack/AWR/ADDM/SQL Advisor.
• Solid hands-on experiences in developing complex database objects like Stored Procedures, Functions, Package and Triggers using SQL and PL/SQL.
• Diverse experience utilizing Java tools in business, Web, and client-server environments including Java Platform, Enterprise Edition (Java EE), Enterprise Java Bean (EJB), JavaServer Pages (JSP), Struts, and Java database Connectivity (JDBC) technologies.
• Excellent English writing, verbal and communication skills. Strong team player and be able to work alone. Highly self-motivated and able to adapt and learn new technologies quickly.

TECHNICAL SKILLS:

Languages: Java, C/C++, Perl, Korn/Bash shell script

Operation System: Oracle Exadata, Redhat Linux, IBM AIX, HP-UX, Solaris

Database: Oracle 10g/11g R2/12c (RAC, ASM), MS SQL, MySQL

Application Server: BEA/Oracle Weblogic Server, Tomcat

Data Replication: Oracle GoldenGate

WORK EXPERIENCE:

Confidential, Agoura Hills, CA

Sr. Oracle Exadata DBA, Consultant

Responsibilities:

• Working as the primary DBA in the DB support team, get involved in the daily On-Call to support the mission critical OLTP and OLAP production databases. Working as one key member of the technical resources pool to support the Front Line Support on-call team according to emergence requirements and issues.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Duplicate all the non-production databases on Exadata server according the Data Warehouse development project's requirement. Help to compress large volume partition table by using Oracle HCC (Hybrid Columnar Compression) techniques.
• Primary technical resources in SQL tuning in Exadata Production and Performance Testing environments by using statistics, hints, SQL tuning set etc.
• Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.
• Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.
• Application DBA lead for a large number of tuning projects. Working with application developers on SQL code review and quality control. Performance load testing and tuning application, SQL code, and database instance by using a wide range of technologies including ADDM, AWR, Statspack, OEM Performance Manager, Spotlight and home-cooked scripts by using Korn shell/Perl.
• Setting Up High Availability Oracle GoldenGate (OGG) systems on Oracle Clusterware 11g Release 2 and Oracle 11gR2 RAC environments. Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc. Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments (from Oracle to MS SQL Server).
• Established database backup/recovery strategy for different databases. Utilized RMAN for backup and recovery strategy. Completed export and import of different databases using Oracle datapump utilities and SQL*Loader. Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
• Participating in the data modeling sessions to understand the data model and providing them inputs based on the existing data to make sure designed model is technically feasible.
• Installation and Maintenance of Oracle 11gR2 on Oracle Linux and IBM-AIX Platforms.
• Worked on DBMS Datapump packages at schema, table and partition level for moving data using database link.
• Upgrade/Migration of Databases from Oracle 10g to 11g, Cross platform migration from different platforms.
• Administered (11g RAC) environments adding and removing nodes to the cluster and handled performance tuning using AWR.
• Involved in a team migrating 12TB & 40TB production database using Goldengate Zero-down time migration.
• Troubleshooting errors and using the Expdp/Impdp utility on a very regular basis for copying data across schemas.
• Daily Oracle DBA tasks such as Oracle network trouble shooting, tablespace usage monitoring, rebuild index / tables etc.

Sr. Oracle DBA, Consultant

Responsibilities:

• Part of the Data Architecture team which supports development, test and production databases.
• Implementing High Availability Oracle Golden Gate (OGG) from front-end OLTP environments to back-end Data Warehouse (ODS) systems on Oracle 11gR2 RAC environments.
• Performed Database migration from Oracle 10g to Oracle 11.2.0.3 using Golden Gate.
• Worked on RMAN duplication, Cross-platform Transportable Tablespace.
• Implementation and support of 10g and 11g migrations and upgrades from Oracle 10g to Oracle 11g databases, including RAC (Real Application Clusters) databases on IBM AIX and Linux.
• Implemented 10g Data Guard Physical and Logical standby using DG Broker, and experienced with 11gR2 Data Guard new features Active Data Guard and Snapshot Standby.
• Performed oracle Software’s Installations, Creation of new standalone and clustered databases.
• Administering and setting up of 11g RAC and 10g RAC clusterware and instances.
• Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
• Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• Database Services creation for distributing the applications across multiple nodes, Extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD.
• Redefinition of tables using DBMS REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespaces
• Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
• Implemented 11g Interval Partitioning for monthly partitioning of large tables..
• Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.
• Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER and Crontab.
• Handled Chained Rows and Row migration, and solved the database performance issues.
• Experienced with ASM, adding, deleting disks to the disk group.
• Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.
• Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries
• Supported development teams for moving changes to different development, test levels and prepared documentations to move changes to the live production environment.
• 24/7 on-call support for the production environment.

Oracle DBA, Consultant

Responsibilities:

• Supporting more than 20 Oracle 10g/11g development/testing environments on IBM AIX and Linux/X64 boxes. Help the developers and QAs to do trouble shooting about database issues.
• Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM/ASH, statspack/tkprof tools
• Daily development / testing environment baseline backup and restore, develop and maintain administration scripts by using Perl/Korn shell.
• Established database backup/recovery strategy for different databases. Utilized RMAN for backup and recovery strategy. Completed export and import of different databases using Oracle Data Pump utilities and SQL*Loader. Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
• Installed, configured and maintained Oracle 11g Real Application Cluster (RAC) / ASM on Redhat Enterprise Linux 5.x boxes.
• Implemented 11g DataGuard Physical using DG Broker, and experienced with 11gR2 Data Guard new features Active Data Guard and Snapshot Standby.
• Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
• Modified database structures including tablespace, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• General DBA daily jobs such as disk usage monitoring, table/index rebuild and reorganization as needed.

Oracle PL/SQL and Java Developer

Responsibilities:

• Studied and analyzed the business requirements, designed entity relationship diagram using Erwin.
• Review the data model and designed database tables as per technical specifications
• In writing PL/SQL code and debugging for triggers, functions, and procedures and packages in the Oracle 9i/10g Database on HP-UX platform.
• Developing the Java module on the Weblogic/J2EE server side. Involved in review the code, preparation of Unit Test Plans (required test scenarios).
• Trouble shooting for the end users requirement and Optimizing the Oracle database.
• Tuning application using tools like Explain plan, SQL*Trace and TKPROF for high efficiency.
• Loading data using SQL*Loader (both conventional and direct path loading) and stored procedures.
• Coordinating and scheduling changes to database based on requirements.
• Responsible for all version control of code and technical documentation.
• Providing support to team member on daily basis.