Oracle Apps DBA, Oracle DBA
Resume:
Raj Shekhar
********@*****.***
Oracle Apps DBA/ Oracle DBA
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).
Oracle Applications Ebz:-
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.
Oracle Database:-
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 in changing the public, private, virtual and SCAN IP for 11g RAC database.
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.
Extensive experience on working with onsite-offshore model which involves coordinating with offshore or onshore team.
Education:
B.Sc (Computers & Electronics), Osmania University, India
Year of Passing: 2006
Certifications & Trainings
Oracle Certified Associate (OCA) in Oracle.
Oracle Certified Professional (OCP) in Oracle.
Oracle E-Business Suite R12 – Applications Database Administrator Certified Professional (OCP).
Oracle WebLogic Server 12c: Administration I
Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Administration Workshop II
Oracle Database 10g OCA Exception to SQL Requirement.
Oracle WebLogic Server 12c: Administration.
Attended 11g RAC Administration Training From Oracle University.
Attended Oracle Performance Tuning Training from Oracle University.
Attended SOA/Weblogic Training from Oracle University.
Attended Exadata Machine Administration Training from Oracle University.
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.
Project Details:
Client: VIAVI Solutions Jan 2017 to till date
Location: San Jose, CA, USA
Role: Lead Oracle Application DBA
Project : R12 upgrade/ Support
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.
Application Tasks:-
Upgraded Applications from 11i to 12.1.3 then 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
Client: HP Global Support Nov 2015 to Dec 2016
Location: Houston, Texas, USA.
Role: Lead Oracle APPS DBA (Support)
Project : Oracle Database support (Global Shift basis).
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 Installing 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.
Application Responsibilities:
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: Oracle 9i/11g Oracle Applications 11i (11.5.10.2) & 12.1.3, Oracle 9i, HP UNIX TRU 64, Precise, OEM, SQL*plus, SQL Loader, Toad, Oracle Discoverer, JDK 1.2/1.3.1
Client: AXA Insurance Dec 2014 to Oct 2015
Location: Edison, New Jersey, USA
Role: Sr. Oracle Application DBA
Project: AXA Insurance DBA Support
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.
Application Responsibilities:
Monitoring and Installing oracle Application EBS R12.2.4, EBS R12.2.5, EBS R12.2.6 and 12c Database
Patching and Cloning
Apply patches using ADOP utility in R12.2.6
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, R12.2.6
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.
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
MSP HiTech Sdn Bhd Mar 2012 to Nov 2014
Location: Kuala Lumpur.
Role: Lead Oracle Application DBA
Client: HP Global Support (Global Shift basis)
Responsibilities:-
Upgraded Applications from 11i to 12.1.3 then 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.
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.
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
Primainfo Technologies Sdn Bhd Apr 2009 to Mar 2012
Location: Kuala Lumpur.
Role: Sr. Oracle DBA/Apps DBA.
Project: Tabung Haji FMS and EPS Implementation.
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.
Performed Database maintenance to change the public, Private & SCAN IP of the existing RAC installation.
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.
Application duties:-
Upgrade from Oracle E-business Suit from 11.5.10.2 to 12.1.3.
Upgraded from 12.1.3 to 12.2.4 in test, dev & prod environments.
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
Client: KPIT Cummins Infosystems Ltd. Dec-06 to Mar-09
Location: Hyderabad.
Role: Oracle DBA
Project: CPA application
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
Contact this candidate