SUMMARY

• Over 9 years of Experience in Oracle Database Administration, Oracle Applications, tuning, development, analysis, design, installation, patches, upgrades, migrations, configuration, database security, capacity planning, space management, backup and recovery, cloning, auditing, SQL, PL/SQL, troubleshooting and documentation.
• Hands on experience in installing and upgrading to 12.2.3 ERP instances.
• Experience in installing, configuring and maintaining 11.5.10.2 applications and 4 node 11.2.0.3 RAC databases.
• Responsible for identifying solution to run Oracle Applications Apache server on 443 port as Oracle/Applmgr user
• Experience in installing and maintaining Weblogic, SOA suite, Webcenter portal, ADF etc.
• Experience in migrating a 30TB database from HP - UX to UCS by using transportable tablespace.
• Experience in Upgrading “10.2.0.5” database to “11.2.0.2” database and then converting to a 12 Node RAC database with ASM
• Experience in Installation, Configuration and Maintenance of Oracle 11g/10g RAC with ASM and single instance database.
• Experience in cloning and patching E-Business environments utilizing tools such as rapid clone, adadmin, adctrl and adpatch.
• Experience in Configuring Secure Socket Layer (SSL) in an Oracle E-Business environment.
• Oracle Database Administration in a variety of environments including Linux, HP-UX, IBM-AIX, Sun Solaris.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).
• Experience in installing, maintaining, upgrading and patching Oracle Database versions 11g/10g/9i/8i.
• RMAN procedure for backup and recovery.
• Managed Oracle and SQL server in High Availability environments using Failover, Clustering, Mirroring, Data Guard and Cloning technologies.
• Preparing cluster, configuration and Installation of Clusterware and Oracle RAC on RHEL.
• Experience in database full Backup (hot and cold), Incomplete Backup, Data Pump Export/Import and Restore procedures.
• Experience in Space Management, Rollback segments, Undo segments and Capacity Planning.
• Setting up RAC services to balance Load on a RAC database.
• Installed 10g Grid agent on servers and configure OEM Grid control.
• Experience in maintenance of Production, Testing, Development, RAC, Standby databases/ Dataguard.
• Job scheduling using cron utility and Shell Scripting for automating DBA tasks.
• Experience with new features like Flash-Back Recovery, ASSM, AMM, ASMM, Recycle Bin.
• Good experience in Database Creation, Partitions, Setting-up parameters, Tablespaces, Indexes, User Setup, Roles, Security, Storage and hands on experience in network management.
• Experienced in Oracle Support processes for technical requests through MOS (Metalink) and other support procedures.
• Documented all Oracle database installations and database operations

TECHNICAL SKILLS

Database: Oracle 11g/10g/9i/8i, RAC 11g/10g, SQL Server

Ebusiness Suite Apps: Oracle Ebusiness suite versions (12.1.1, 12.1.3, 11.5.10, 12.2)

Operating System: Linux, HP-UX 11/11i, Sun Solaris, AIX and Windows NT/2000/2003

Languages: SQL, UNIX Shell Scripting

Tools: /Utilities: SQL*Loader, DataPump (Export/Import), OEM, RAC, TOP RMAN, TOADAWR, ADDM, STATSPACK, TKPROF, Crystal Reports, Oracle Grid Control.

PROFESSIONAL EXPERIENCE

Confidential, Red Wood City, CA

Sr. Oracle Apps DBA consultant

Responsibilities:

• Planned and upgraded Oracle applications from 11.5.10.2 to 12.2.3 applications successfully.
• Hands on working experience on Oracle fusion applications i.e HCMDomain,CRMDomain, Financial Domain etc.
• Proficient in 10G/11G/12c RAC Installation/Maintenance and Troubleshooting CRS/Grid Infrastructure and ASM issues
• Replication using Goldengate, Zero-downtime migrations.
• Refresh/Cloning of 12.2 Instances for development and testing purpose.
• Hands on experience in upgrading oracle applications to 12.2.3 and setting up multi node configuration.
• Responsible in applying post upgrade patches using adop (online patching method introduced in 12.2) and help in reducing downtime during production cutover.
• Helped in improving performance of upgrade by trying various mount options on AIX server.
• Worked extensively with oracle on fixing online patching issues and performance related bugs on 12.2 environment.
• Worked closely with Developers helping them identify and fix issues in 12.2.3 environment. Helped them in finding performance bottlenecks using EXPLAINPLAN, SQLTRACE, TKPROF, AWR reports.
• Hands on experience in setting up SSL on 12.2.3 environment.
• Helped in Configuring Data Guard setup for Oracle 11g database to ensure high availability, data protection and disaster recovery.
• Worked on tickets/requests raised by users helping them in code migrations, applying patches, providing trace files in case of issues, assigning responsibilities etc.

Confidential, Mountain View CA

Oracle Apps DBA consultant

Responsibilities:

• Played a crucial role in installing and configuring a 4 node 11.2.0.3 RAC database with 11.5.10.2 Oracle Application Services. (Project: BOA)
• Implementation of High Availability solutions with Oracle 11g RAC,Standby Database (Active Data Guard), Replication.
• Managing environments which include Oracle Applications such as Oracle ERP 11i, R12 and Fusion MiddleWare Products like SOA, BPEL installed on Weblogic Server(WLS)
• Implemented Oracle streams for replication and configured tablespaces for streams administration at database and table level.
• Experience in implementing RMAN backups and recovering databases using those RMAN backups.
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Written Shell scripts to monitor activities like availability of database & listeners, space utilization.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using EXPLAINPLAN, SQLTRACE, TKPROF, AWR.
• Applying Quarterly patches and Version change patch bundles.
• Refresh/Cloning of Database and applications for development and testing purpose
• Responsible for identifying gaps with and automating end-to-end Production to non-Production Refresh process: Renaming ASM disks with Instance Name, Automating process of resetting Application user passwords
• Responsible for testing various methods to reduce downtime for patching an E-Business environment (eg.’s Rolling fashion of applying patches for each RAC instance, Applying patches for duplicate binaries and flipping during down time)
• Installing and configuring 11g Grid with ASM storage on a single node and then converting it to a cluster infrastructure without a data loss.
• Worked closely with Developers helping them identify and fix issues. (eg.’s SSL connectivity, Correcting a PL/SQL procedure to receive emails after completion of their program)
• Responsible for identifying solution to run Oracle Applications Apache server on 443 port as Oracle/Applmgr user. Oracle was unable to provide a solution and no solutions were found in the Internet community
• Identifying, troubleshooting, designing, and implementing solutions for critical issues. (eg. Automate changing DB user passwords after reaching PASSWORD LIMIT TIME, Registering services in Scan Listener)
• Provide technical assistance and backup for all team members during system problems and implementation both during business hours and off hours.

Confidential, San Jose CA

Oracle Apps DBA

Responsibilities:

• Upgraded from 11i/12.1.3 to 12.2.3 oracle ERP.
• Analyzed major features of 12.2 oracle ebusiness applications (File system Sizing, online patching,cloning procedure etc)
• Cloning 12.2.3 instances for Development and Test teams.
• Configured GoldenGate for 10g and 11g databases for data replication and setting up Capture, Datapump and Replicat processes.
• Supporting OBIEE admin tasks and Oracle DBA activities
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Installed Fusion Middleware components (SOA Suite, Weblogic, Webcenter portal, ADF applications etc).
• Created and modified Database objects like Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures and Packages.
• Worked on Oracle installations, upgrades, migrations, designing logical/physical architecture, SQL*Net, Tuning, Capacity planning, database access and Security and auditing.
• Integrated Fusion Middleware with Oracle Ebusiness Suite (12.1.3 version).
• Enabled supplemental logging for GoldenGate at database level and also table level.
• Managing Capture, datapumps, replicat processes for data replication in Golden gate.
• Installed and managed 10g and 11g databases
• Upgraded 10205 Database to 11203 version.
• Upgraded 11201 database to 11203 database and then converted to a 6 Node RAC database with ASM
• Configured Services on different nodes to load balance and Failover. Tested those services after configurations.
• Works with management, peers and vendors to design and implement hardware/software configurations, logical models, operational management models and business continuity plans for systems under management.
• Clone instances from production environment.
• Responsible for cloning and patching the E-Business environment utilizing tools such as rapid clone, adadmin, adctrl and adpatch.

Environment: Unix/Linux, HP/UX Oracle 10g&11g RAC and ASM, 11i and R12 applications

Confidential, San Jose CA

Oracle Apps DBA

Responsibilities:

• Installed and managed 10g Database R2 10.2.0.4
• Upgraded 10204 Database to 10205
• Migrated a 30TB database from HP-UX to Unix OS by using transportable tablespace.
• Upgraded 10205 database to 11202 database and then converted to a 12 Node RAC database with ASM
• Configured Secure Socket Layer (SSL) on Oracle R12 applications environments
• Configured Services on different nodes to load balance and Failover. Tested those services after configurations.
• Plan, develop and Schedule of the production refreshing, dependency checking and setting up the initialization parameters for standby database as well as tuned SPFILE parameters.
• Clone instances from production environment.
• Installation, configuration and administration of the followings clustered H/A environments in Development, Test, QA and Production:
• Oracle Application Server and WebLogic Server 10g/11g on Linux and Windows platforms
• Oracle SOA Suite 10g/11g (BPEL, ESB, B2B, OWSM, Rules, Workflows)
• Oracle HTTP Server, Tomcat, Apache web server Plug-ins
• Oracle Grid Control 11g and OEM agents on all QA and Production servers.
• Responsible for cloning and patching the E-Business environment utilizing tools such as rapid clone, adadmin, adctrl and adpatch.
• Configured ASM and handled issues and suggested possible workarounds for ASM Metadata corruption.
• Involved in Oracle Real Application Testing (RAT) for testing purposes. RAT is new feature in 11g
• Documented all Oracle database installations and database operations

Environment: Unix/Linux, HP/UX Oracle 10g&11g RAC and ASM, 11i and R12 applications

Confidential, San Jose CA

Oracle Apps Production DBA

Responsibilities:

• Managed nearly 40 marketing production databases of CISCO. There are various 9i, 10g, 11g databases with 11i and R12 oracle applications
• Upgrade of database from 10.2.0.4 to 11.1.0.6 by applying patches using Opatch utility.
• Utilized RMAN for backup and Recovery strategy and even performed cloning of database.
• Monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM, Grid Monitoring.
• Performed performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack, ASH.
• Cloned database for test environment.
• Administering Real Application Cluster (RAC) databases running on Cluster File system.
• Responsible for applying CPU patches on most of the production databases in CISCO.
• Migrated database objects from database to other server by using Export/Import, Datapump.
• Rebuilding indexes when needed to avoid fragmentation and improve performance, monitoring index usage and removing unused indexes.
• Responsible for scheduling and holding design reviews as needed to support the development processes.
• Good at managing and monitoring grants, roles, privileges to users, analyze tables to generate and gather stats including verify daily backup’s logs and alert logs
• Configured user logon load balancing and failover on RAC database
• Configured services for load balancing and failover
• Database Capacity Planning & configuration (redo and stream sizes), design staging schema and use of DBMS STREAM ADM packages.
• Regular DBA activities like Undo segments, Rollback segments, database auditing, space management, database issues, locking, managing user groups and tuning.
• Applied patches and database reorganization using oracle enterprise manager (OEM).
• Plan, develop and Schedule of the production refreshing, dependency checking and setting up the initialization parameters for standby database as well as tuned SPFILE parameters.
• Experience with Oracle Streams which enable the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another.
• Maintained Very Large Multi Terabyte (VLDB) around 14TB+ in Data Warehouse Environment for DSS.
• DBA activities which include Creating Users, Roles and Profiles, Privilege management with role-based security of databases, tablespaces, indexing, data maintenance, roles, user management, and maintenance.
• Load data from OLTP systems into data warehouse databases.
• Documentation of Oracle database operations and training of backup personnel.

Environment: ORACLE 9i/10g/11g, Oracle 10g/11g RAC, ASM, RHEL 4.x, SUN SOLARIS 10, HP-UX 11, Toad, SQL, Dataguard, DataPump, OEM, RMAN, SQL*Loader, OLTP, Oracle Applications 11i and R12.

Confidential, San Jose CA

Responsibilities:

• Configured Disaster Recovery Environment with 10g Database with R12 applications using DATAGUARD BROKER
• Installed and managed 10g Database R2 10.2.0.4
• Responsible for implementing Veritas cluster file system on LINUX OS and 11gR2 database in the environment.
• Oracle Applications Upgrade from Oracle Applications(E-Business Suite) 11i (11.5.10) to R12/12i(12.0.4)
• Installed and Configured 10gRAC with DG setup
• Responsible for applying patches on database using opatch on GOLD environment.
• Set and document standards for use of databases to use Data guard in Maximum availability mode.
• Responsible for testing the behavior of 10gR2 RAC database using Veritas cluster file system.
• Building Clone instances for Development and Test teams.
• Installing and maintaining a 4 node RAC 10gR2 database.
• Configured, created and Managed Oracle Data Guard in a real Applications Clusters (RAC) Environment.
• Provide technical assistance to all internal/ external customers and team members during system problems and implementation.

Environment: Unix/Linux, HP/UX Oracle 9i&10g, Oracle Applications 11i and R12

Confidential, San Jose, CA

Oracle DBA

Responsibilities:

• Responsible for maintaining databases of Confidential which includes data of Warehouse, bookstore, dining info etc. of San Jose State University students
• Responsible for managing production, development & test databases and applications.
• Pre-patch analysis for the patches and document preparation with pre and post patch installation steps.
• Worked extensively on tuning the database for better performance.
• Tuning the databases for optimal performance.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Partitioning tables by determining the suitable methodology to improve performance and manageability
• Wrote custom PL/SQL packages for DBA related jobs such as purging custom tables, loading data into custom tables etc.
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Experience in implementing Hot, cold and RMAN backups and performance tuning of SQL statements

Environment: Unix/Linux, Oracle database 10g

Confidential

Oracle Apps DBA Administrator

Responsibilities:

• Responsible for managing production, development & test databases and applications.
• Maintaining the Oracle Applications Systems including Oracle databases, Middle tier IAS Applications.
• Involved in Upgrading of Oracle Version 8.1.7.4 & Oracle Applications 11.5.2 and supporting the production environment.
• Involved in database migrations, cloning Oracle Applications (11.5.2) production system, for test instances.
• Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers and monitoring of the concurrent managers.
• Tuning the databases for optimal performance.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Partitioning tables by determining the suitable methodology to improve performance and manageability
• Enabled Auditing feature for tables such as FND USER etc.
• Experience in implementing Hot, cold and RMAN backups and performance tuning of SQL statements

Environment: Unix/Linux, Solaris, Oracle database 8i&9i, Oracle Applications 11i