PROFESSIONAL SUMMARY:

• Overall 11+ years of industry experience primarily in Oracle Databases (9i/10g/11g/12c), ERP applications (11i/R12.1.3/R12.2.5), SSO (OIM/OAM), SOA weblogic & OBIEE including installation, configuration, cloning, upgradation, and implementation across various platforms. on a variety of UNIX flavors (Red hat Linux, Solaris, AIX & HP - Unix).
• Expert in Installing the Oracle Application 11i, R12(single node, multimode and enabling shared Appltop) and database creation.
• Expertise in Application cloning (rapid clone, Autoconfig) and database refresh, Schema refresh (using export and import) and to apply the application patches and database patches.
• Upgraded EBz Applications from 11i to 12.1.3 then to 12.2.5 end to end.
• Good knowledge in AD utilities & creating the users and Assign the responsibilities.
• Very efficient in working in tickets based environments making priorities.
• Good knowledge in Forms, login issues, Oacore, report & Apache and Concurrent managers.
• Performed Patching on 11i, R12.1.3 & 12.2.5 instances as per functional and development requirement and applied CPU patches for security purpose.
• Installed printer on OS level and registered on Application level for all instances.
• Installed standalone Discoverer server and configured to all instances.
• Helping to functional and development team on perform action plan regarding SR(tar), provided file version and migrated file from dev/test to Prod.
• Good at administering OIM (Oracle Identity Management), OAM, OID & Access gate.
• Worked on SOA 11g and 12c environments with 8 server architectures.
• Administering OBIEE & informatica application 11g and 12c environment.
• Highly experienced (8 Yrs) in Oracle Data Guard (Both Physical & Logical) for setup, maintenance and gap resolution using rman.
• Successfully completed scheduled disaster recovery with failover and switchover methodologies.
• 5 years of experience in Installing and maintaining Oracle GoldenGate (11gR2) Replication processes.
• Experience in installing Oracle 11g Grid Infrastructure with ASM disk both for RAC and Standalone database.
• Extensively worked on Oracle Database Patching and Upgrade (From 10.2.0.4 to 11.2.0.4)
• Good experience in upgrading 10g & 11gR2 database to 12c Pluggable database using Oracle DBUA and/or expdp/impdp method.
• Extensive experience in ASM Storage management such as create ASM diskgroups from SAN disks, add/remove ASM disks to existing ASM diskgroup, drop diskgroup.
• RAC experience includes working experience in - planning, designing, developing, deploying, maintenance and supporting RAC on RHEL and Oracle Linux.
• Configured the Load Balancing on RAC database through service names using SRVCTL utility and using SCAN - Single Client Access Name (in 11g).
• Experience on Partitioning table for better performance and ease in data archival process.
• Highly experienced on various database performance improvement activities such as analyzing AWR reports, partitioning tables, purging old data, reducing various wait events, using ADDM report and tuning advisor.
• Involved in capacity planning: developed strategies and maintenance plans and implemented the same for monitoring, security, disaster recovery & load balancing.
• Experience with database backup, restore, and disaster recovery procedures such as creating catalog database, Virtual Private Catalog, Hot Backup, RMAN (9i/10g, 11g) full & incremental backup, 10g Data pump (expdp, impdp).
• Experience in recovering corrupted data files using “recover corruption list” command.
• Experience in cloning 11g RAC database (RMAN DB Duplicate)from RMAN backups.
• Installed GoldenGate 11gR2/12c software in Test and production (RAC DB) environment.
• Prepare GoldenGate parameter files for Extraction (Both classic and Integrated Capture mode) and Replication to implement data filter and column mapping.
• Implemented GoldenGate setup to achieve Uni-directional replication both for DDL and DML operation.
• Improved performance of GoldenGate replication process by implementing parallel Extract & Replicat processes.
• Performed initial Data Load option of GoldenGate during environment build.
• Developed Shell Scripts to monitor different GoldenGate processes.
• Experience on managing Oracle Grid Control servers & Database Control to monitor performances and schedule alerts for all the db servers.
• Good experience in implementing different performance strategies including generating explain plan, creating normal & reverse-key indices, gathering stats, modifying db parameters etc.
• Experience in using export/import and expdp/impdp utility to make copy of databases or to backup databases for testing purposes.
• Strong experience OEM 12c and implementation of OEM13c.
• Strong experience in all database object operation, including creating & Altering Tables/ Constraints/ Index/ Synonyms/ Sequence/ View/ Table Partitions.
• Always worked with the business analyst (Line-of-business), testing team and the front-end developers to provide the necessary support from the database side.
• Knowledge in Installing and configuration of mongo Db.
• Extensive hands-on experience working in Unix (Linux, CentOS, RedHat, HP-Unix, IBM-AIX ) environment and with UNIX Shell Scripting.
• Using the Crontab in UNIX and Scheduler for Automatic Tasks.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently.

TECHNICAL SKILLS:

Database: Oracle 12c/11g/10g/9i/8i,, Oracle GoldenGate, Dataguard.

Database Tools: Toad, expdp/impdp, RMAN, ERWIN, Designer, SQL Navigator, Designer 2000, SqlPlus, SQL*Plus, SQL*Loader, SQL* Navigator, SQLDeveloper, Oracle Grid Agent, Oracle GoldenGate, OEM & VMWare.

Operating System: UNIX, Linux, HP-UX, AIX, Windows NT, Windows 2000, Windows XP.

Hardware: Sun Sparc E5000, HP9000, RS6000, Compaq, EMC

Languages: Perl script, UNIX Shell Scripting, SQL, PL/SQL, HTML.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA, USA

Lead Oracle Application DBA

RESPONSIBILITIES:

• Installed Oracle 11g Grid Infrastructure with ASM disk both for RAC and Standalone database (Both in silent and GUI mode).
• Created and configured 12c CDB and PDB.
• Migrated 11g databases to 12c PDB using expdp and impdp procedure.
• Extensively used srvctl & crsctl commands to perform RAC database related activities.
• Worked on various database performance improvement activities such as analyzing AWR reports, Partitioning tables, purging old data, reducing various wait events, using ADDM report and tuning advisor.
• Writing Unix Shell script to track and monitor database alerts and scheduled the scripts through crontab.
• Executing Database script for scheduled releases on all the database environments (non-Prod & Prod).
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Worked on optimizing various SQL queries by creating index, reverse-key index, gathering table stats in fixed intervals, archiving old/unused data from larger tables and using hint, changing DB parameters.
• Experience in installation, upgrade and support of Pendo Analytics tool.
• Planned installed executed the Oracle dataguard with 5 standby DBs.
• Done scheduled disaster recovery with failover and switchover methodology.
• Upgraded Applications from 11i to 12.1.3 also from 11i to 12.2.4.
• Good knowledge in AD utilities & creating the users and Assign the responsibilities.
• Very efficient in working in tickets based environments making priorities.
• Good knowledge in Forms, login issues, Oacore, report & Apache and Concurrent managers.
• Performed Patching on 11i and R12.1.3 instance as per functional and development requirement and applied CPU patches for security purpose.
• Installed printer on OS level and registered on Application level for all instances.
• Installed standalone Discoverer server and configured to all instances.
• Helping to functional and development team on perform action plan regarding SR(tar),provided file version and migrated file from dev/test to Prod,
• Supported ON-DEMAND instances(DEV,TEST,UAT,CRP1) which are cloned from ORACLE supported CRP instance.
• Handling administration of 24*7 Production and Dev/test environment
• Expertise in handling the tickets raised by the clients through support wizard site.
• Upgraded from 11i to R12.2.5 and also taken backup after installing(Cold Backup) for internal instances,
• Performing Patch analysis for all the patches before going to apply and applying.

Environment: Oracle 10g/11g, Linux (RHEL), Sun Solaris, SQL, PL/SQL, UNIX (Korn Shell), Windows XP, TOAD, SQL Navigator, SQL* Loader, RMAN, expdp/impdp, Oracle GoldenGate 11gR2

Confidential, Houston, Texas, USA.

Lead Oracle APPS DBA (Support)

RESPONSIBILITIES:

• Installed Oracle 12c and 11g Grid Infrastructure with ASM disk both for RAC and StandAlone database (Both in silent and GUI mode).
• Created and configured 12c CDB and PDB.
• Extensively worked on Oracle Database Patching and Upgrade (From 11.2.0.3 to 11.2.0.4)
• Upgraded database from 11gR2 to 12c using DBUA and expdp/impdp method.
• Cloned non-CDB 12c Database to 12c PDB (Pluggable DB).
• Experience in Installaing and Supporting Oracle database in AWS.
• Extensively used srvctl & crsctl commands to perform RAC database related activities.
• Worked on various database performance improvement activities such as analyzing AWR reports, partitioning tables, purging old data, reducing various wait events, using ADDM report and tuning advisor.
• Installed GoldenGate 11gR2/12c software in Test and production environment.
• Prepare GoldenGate parameter files for Extraction (both for Classic and Integrated Capture) and Replication to implement data filter and column mapping.
• Performed initial Data Load option of GoldenGate during environment build.
• Created RMAN scripts for DB duplicate (to a different host) and DB Restore from existing backups.
• Created physical Data Guard (Stand-By DB) for 11g RAC Production database.
• Experience in oracle Data Guard maintenance such as fixing log gap, transitioning from recovery mode to read-only mode.
• Created and monitored the concurrent managers.
• Allocating system storage and planning future storage requirements.
• Cloning of Database and Applications as per functional requirements.
• Oracle Applications upgrades, patches using various AD utilities
• Troubleshooting and on-call support (7x24)
• Resolving system errors, disk space problems, huge file sizes errors
• Applying quarterly PSU's and CPU's to databases and application.
• Worked with End Users and Functional Analysts on issue resolution (concurrent manager problems, one off patches etc.)
• Developing UNIX and sql scripts for the smooth functioning of database and applications related issues
• Tuned the database and applications using EXPLAIN PLAN, Auto Trace, SQL Trace, TKPROF STATSPACK (advanced version of UTLBSTAT and UTLESTAT)
• Gathered database/Objects statistics using DBMS UTILITY, DBMS STATS, and FND STATS packages and ANALYZE command.
• Monitored the Applications and database using OAM.
• Rebuild the indexes and dropped unused indexes.
• Setting up the printers in Application environment.
• Upgraded JDK 1.1 to 1.3.1, also implemented 1.6 Java for application.
• Troubleshooting throughout the project phases and TAR Management
• Effective use of Oracle Web cache with multiple applications.
• Capacity Planning/Management (space/machine load/network)
• Moved the objects from one instance to other using FNDLOAD.
• Performed Application admin tasks using ADADMIN utility
• Cloning of Database and Applications
• Prepare and implement system management and maintenance procedures
• Analyzing the requirements and creating the database as per the requirements and the connectivity of clients to the server
• Cloning of Oracle APPS 11.5.10 Instance on HP-UX 11.0 platform
• Upgraded Oracle Applications 11.5.10 to Oracle Applications 11.5.10.1 on HP-UX 11.0 platform
• To tune and configure Oracle 9i Database for optimum performance.
• Provided production support.
• System Administration of 11i
• Applied the patches using ADPATCH & ADOP for 12.2 and above.
• Setting up of printers
• Developed backup scripts for EBS Applications 11.5.10 and 12.1.3.

Environment:Oracle9i/11gOracleApplications 11i (11.5.10.2) & 12.1.3, Oracle9i, HP UNIX TRU 64, Precise, OEM, SQL*plus, SQL Loader, Toad,OracleDiscoverer, JDK 1.2/1.3.1

Confidential

Lead Oracle Application DBA

Database Responsibilities:

• Install, configure and support of Oracle RAC Database 10g & 11g on Linux environment.
• Extensively used srvctl & crsctl commands to perform RAC database related activities.
• Monitored the database performances using OEM Grid Control utility.
• Implemented Oracle 11g RAC load balancing using SCAN (Single Client Access Name) feature.
• Installed GoldenGate 11gR2 software in Test and production environment.
• Prepare GoldenGate parameter files for Extraction and Replication to implement data filter and column mapping.
• Implemented High availability using GoldenGate Replication from Oracle-to-Oracle and Oracle-to-SQL Server environment.
• Implemented GoldenGate setup to achieve Uni-directional replication both for DDL and DML operation in Oracle RAC database.
• Improved performance of GoldenGate replication process by implementing parallel Extract & Replicat processes.
• Performed initial Data Load option of GoldenGate during environment build.
• Developed Shell Scripts to monitor different GoldenGate processes.
• Created RMAN scripts for DB duplicate (to a different host) and DB Restore from existing backups.
• Good knowledge in Forms, login issues, Oacore, report & Apache and Concurrent managers.
• Performed Patching on 11i and R12.1.3 instance as per functional and development requirement and applied CPU patches for security purpose.
• Installed printer on OS level and registered on Application level for all instances.
• Installed standalone Discoverer server and configured to all instances.
• Helping to functional and development team on perform action plan regarding SR(tar),provided file version and migrated file from dev/test to Prod,
• Supported ON-DEMAND instances(DEV,TEST,UAT,CRP1) which are cloned from ORACLE supported CRP instance.
• Handling administration of 24*7 Production and Dev/test environment
• Expertise in handling the tickets raised by the clients through support wizard site.
• Installed 11i,R12 and R12.1.3 and also taken backup after installing(Cold Backup) for internal instances,
• Performing Patch analysis for all the patches before going to apply.
• Monitoring and Installing oracle Application EBS R12.2.4, EBS R12.2.5, EBS R12.2.6 and 12c Database
• Cloning Oracle application R12.2.6 on QA/DEV/Test instance
• Creation of application users.
• Upgradation oracle database from 11g to 12c
• Upgradation oracle Application ERP from R12.2.0 to R12.2.4.
• Handling ERP login page problems
• Troubleshooting the daily production instance problems
• Production support for database and Application activities
• Apply patches on Fusion middleware, WebLogic serv.
• Upgraded Applications from 11i to 12.1.3, 11i to 12.2.4 and using ADOP for patching.
• Good knowledge in AD utilities & creating the users and Assign the responsibilities.
• Very efficient in working in tickets based environments making priorities.

Environment: Oracle 10g/11g, Linux (RHEL), Sun Solaris, SQL, PL/SQL, UNIX (Korn Shell), Windows XP, TOAD, SQL Navigator, SQL* Loader, RMAN, expdp/impdp, Oracle GoldenGate 11gR2

Confidential

Sr. Oracle DBA/Apps DBA.

RESPONSIBILITIES:

• Install, configure and support of Oracle RAC Database 11g on Linux environment.
• Installed Oracle Grid Infrastructure 11g as part of the RAC installation in staging and Production environment.
• Used oracleasm utility to create ASM disks from SAN disks, add new ASM disks to existing diskgroup and add disk space to the existing disk.
• Monitoring all the databases for tablespaces and OS disk space usage and add space as necessary.
• Monitored the database performances using Database Control utility.
• Installed Oracle Wallet for standalone & RAC databases to encrypt the biometric information (Both for normal & BLOB columns)
• Extensively used srvctl & crsctl commands to perform RAC database related activities.
• Implemented Oracle 11g RAC load balancing using SCAN (Single Client Access Name) feature.
• Executing Database script for scheduled releases on all the database environments.
• Identifying the long running queries from Database control monitoring and working with Development team to get the explain plan for such long-running queries and suggest a preferred query hint or any other query changes to make the query faster.
• Writing Unix Shell script to track and monitor database alerts and scheduled the scripts through crontab.
• Extensively Used Explain Plan, SQL Trace, AWR, ADDM reports to Monitor Performance Tuning.
• Implemented object auditing to track tables DMLs & DDLs for production database.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Created catalog database to implement RMAN incremental backup strategy in all the production databases.
• Created automated scripts to make hot RMAN backup (both Full & Incremental) for the Oracle databases.
• Executed the backup/recovery drill by recovering a copy of the database from the RMAN incremental backup and documenting the steps.
• Created and maintained read-only users for non-dev databases and scheduled jobs to set read-only access for new tables.
• Worked on optimizing various SQL queries by creating index, reverse-key index, gathering table stats in fixed intervals, archiving old/unused data from larger tables and using hint, changing DB parameters.
• Worked as a Team Lead for one junior DBA and one technical support team member on their everyday activities.
• Installed GoldenGate 11gR2 software in Test and production environment.
• Prepare GoldenGate parameter files for Extraction and Replication to implement data filter and column mapping.
• Implemented GoldenGate setup to achieve Uni-directional replication.
• Performed initial Data Load option of GoldenGate during environment build.
• Upgrade from Oracle E-business Suit from 11.5.10.2 to 12.1.3.
• Cloning the Development, TEST and UAT database and applications.
• Setup of complete disaster recovery done for database and application.
• Working on dataguard database for any failures.
• Running test executions for scheduled switchover and failover activities.
• Resolving concurrent manager issues in the application.
• Working closely with development team for best plan of action on issues.
• Resolving forms and login issues for users and internal teams.
• Working closely with functional team on specific issues.
• Installed Oracle applications 11.5.10.2(CRP Instance) single node on IBM AIX server with module of HRMS, PAYROLL and FINANCE (PO,INV,ICX,POR,POS,OM,WSH,AR,AP,GL,FA,CE).
• Performing the patching for HRMS and Payroll - including Family Packs, Rollup patches etc plus installing Quantum 2.9.x and all year end patching requirements.
• Performed Patching on 11i and R12.1.3 instance as per functional and development requirement and applied CPU patches for security purpose.
• Performed cloning form CRP instance to CRP2, DEV, CRP3 instances, and CRP3 to CONV, PROD instance.
• Applied NLS patches on 11i /R12.1.3 instances in UAT instances.
• Used FNDCPASS to change APPS, SYSADMIN, and other user passwords.
• Configured Workflow mailer on Production instances.

Environment: Oracle 10g/11g, Linux (RHEL), Sun Solaris, SQL, PL/SQL, UNIX (Korn Shell), Windows XP, TOAD, SQL Navigator, SQL* Loader, RMAN, expdp/impdp

Confidential

Oracle DBA

RESPONSIBILITIES:

• Install, configure and support Oracle Database (Release 10g & 11g) for Dev, QA, Staging, UAT and Production environments.
• Monitoring all the databases for tablespaces and OS disk space usage and add space as necessary.
• Installed the Grid Control agents on all the DB servers to better monitor the performance and gather a lot other metrics for the target databases.
• Executing Database script for scheduled releases on all the database environments.
• Refresh the data from Prod to UAT/Staging/QA databases on need basis using expdp/impdp utility.
• Identifying the long running queries from Grid control monitoring and working with Development team to get the explain plan for such long-running queries and suggest a preferred query hint or any other query changes to make the query faster.
• Writing Unix Shell script to track and monitor database alerts and scheduled the scripts through grid control servers using UDM.
• Configured, implemented, 10g RAC with ASM disk on Linux servers.
• Capacity Planning for all the Stage Servers (Performance Analysis, Storage Growth and Grid Controlling and monitoring user access to the database.
• Extensively Used Explain Plan, SQL Trace, AWR, ADDM and ASH reports to Monitor Performance Tuning.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Scheduled scripts to monitor each of the RAC nodes and to detect any RAC hang check.
• Gathered OS statistics using Oracle OS Watcher tool.
• Used export and import commands for database back-up and refresh activities.
• Created automated scripts to make hot snapshot backup and RMAN backup (both Full & Incremental) for the Oracle database.
• Created physical Data Guard for Production database (11g RAC)
• Executed the backup/recovery drill by recovering a copy of the database from the hot backup and documenting the steps.
• Created database monitoring jobs through UNIX shell scripts and scheduled the scripts through either cron job or Grid control UDM.
• Writing Technical Specification Document (TSD) and oracle stored procedure for new client’s Migration project.
• Extensively worked on Oracle SQL, PL/SQL stored procedure, function, package, trigger and other oracle objects for Canvas projects (such as, new client migration and data archival job).
• Developed scripts to create table with storage clause, view, materialized views, external table, index, sequence, synonyms, grant privileges.
• Extensively worked on many database development tools such as TOAD, SQL Navigator, and PL/SQL developer.
• Worked on optimizing new and existing SQL queries by creating index and Materialized views.

Environment: Oracle 10g/11g, Linux (RHEL), Sun Solaris, SQL, PL/SQL, UNIX (Korn Shell), Windows XP, TOAD, SQL Navigator, SQL* Loader, RMAN, expdp/impdp