PROFESSIONAL SUMMARY:

• A competitive professional having total around 8+years of experience in Oracle Apps DBA and as well as core DBA
• Worked on 12.2.3,12.2.4,12.2.6 with latest Cloning step Dual in 12.2
• Worked on 10g, 11g, and 12c database.
• I lead Projects going through ALL phases of Product Life Cycle and playing key roles such as Apps DBA, and Team Lead.
• Proficient in Applications 11i/R12 HTTP load balancer (DMZ), upgrade, cross platform migration, JVM Tuning and production support in 24X7 environments. managers and processes, Patching, User management issues and space management issues related to Oracle Applications
• Good knowledge in AD utilities and handling different kind of activities in Oracle Applications
• Experience with managing Oracle systems on UNIX platform a plus (Sun Solaris)
• Excellent remote systems support and troubleshooting capabilities
• Worked 12.2 patching adop utlity and 12.2 Cloning.
• Hands - on operational expertise as an Oracle DBA, with technology including RAC, SSO, DataGuard, High Availability and Backup/Recovery
• Participated in the DR and JRE upgrade.
• Proficiency in high availability solutions using RAC, stand by databases and fail over servers.
• Proficiency in application upgrade from R11 to R12.2 with multi node configuration.
• SOA/BPEL/ODI/AIA/PIP installation and integration with Oracle EBS R12 and Peoplesoft 8.51 application. proficient in NAS and SAN storage solution.
• Have troubleshooted and fixed the Concurren issues.
• Analyzed and applied various CPU patches, PSU patches etc.
• Experience in performance tuning including database, applications, JVMs and o/s recommendations..
• Proficiency with several AD admin tools like Rapid clone, ADpatch, ADadmin, ADsplicer etc.
• Expertise in application clone, patch and code migration with change management Dev, Tst, Prod.
• Implement reliable backup strategies and recovery procedures for large database (3.5TB).
• Proficiency in 11g R2 and 10g database, Data Guard, ASM, flask recovery, OEM and RMAN, AWR, ADDM and SQL tuning adviser.
• Proficient in capacity planning and architect design of data center migration project with 200+ instances.
• Extensive use of OEM 10g grid control and application monitoring and alert setup.

TECHNICAL SKILLS:

Oracle Apps: Release 12.2 /R12/ 11i with database 10g/11g/12c on RAC.

Tools: RMAN, OEM, NETAPPS, SAN and NAS storage, Sql Developer, Toad. Solaris, Linux, UNIX, HP-UX, Linux, Windows NT, VNC server.

TECHNICAL SKILLS:

E-Business: Oracle Applications Release R 12.2/12.1 / 11.5.10

Database: Oracle 12c/ 11.2/11.1/10.2.0.4 with RAC

O/S: Solaris(5.10,5.9,5.8), HP-UX 11, Linux Redhat 5.2, Windows NT, Motif, X - windows

Tools: RMAN, OEM, Sql*Loader, Mig, Data Pump, TKPROF, Export/Import, Various Oracle Supplied packages, RAC related utilities.

Technology: J2EE, ADI, Java, Apache,9iAS, 10gAS, Discoverer 4i, Discoverer 10g, OEM,Data Guard,Grid control

Storage/Cluster: EMC,SAN,NAS,ASM,RAW

PROFESSIONAL EXPERIENCE:

Confidential, New York

Lead Oracle Apps DBA

Responsibilities:

• Primary DBA in capacity planning and architect design for all the EBS client and point of contact for escalation.
• Primary responsible for Administrating multiple clients Oracle Applications R12 instances, High availability, migration, upgrade and cloning of Oracle Applications, Installations, Monitoring and Performance Oracle Applications Instance
• Responsible for upgrade, performance, Data Guard, ASM, RMAN, AWR, and SQL tuning.
• Upgraded EBS version from 12.2.3 to 12.2.6 using ADOP
• Applied all the CPU patches using ADOP online patching tool
• Design high availability solutions using RAC, stand by databases and fail over servers in SAN Storage and oracle cluster.
• Tune Oracle RAC 11gR and Oracle Application server for better performance and handle 4000+ users.
• Application server (Weblogic, 10gAS) tune for JVM usage for best performance.
• Implement high availability and fail over server with Oracle 11gR2 Active data guard in RAC.
• Responsible for application administration, upgrade, backup recovery, application cloning, patching and application optimization and customer communication.
• Convert EBS non shared Appltop to shared application top with PCP configuration.

Environnent: DB 11.2.1 RAC, APPS R12.2.3,& R12.2.6 OAS 10g, Linux RHL 5 On Exa machines

Confidential

Oracle Application DBA

Responsibilities:

• Troubleshooting several worker issues while patching.
• Tune production database and application for optimum performance.
• Reduced the timelines of patching using features like defaults file and merge patch Install and configure Oracle E-
• Installed off-cycled products using adspilce utility.
• Helping users while initial setup of application launch and resolved db Connectivity issues.
• Worked on third party tool Super Trump
• Experienced with RMAN, BACKUP and RECOVERY, POINT-IN-TIME RECOVERY (PITR)of databases
• Monitoring table spaces for space usage and adding required space whenever it reaches threshold
• Used TKPROF, EXPLAIN PLAN, and STATSPACK to improve the performance
• Developed stored procedures, packages and database triggers
• Converted a single instance database to Oracle RAC 10g

Environnent: DB 11.1.0.7, APPS R12.1.3 in Linux RHL 5 and

Confidential, OH

Lead Oracle Application DBA

Responsibilities:

• Primary responsible for Administrating the Oracle Applications instances, High availability, migration, upgrade and cloning of Oracle Applications, Installations, Monitoring and Performance Oracle Applications Instance
• Responsible for upgrade, performance, Data Guard, ASM, flashback recovery, OEM and RMAN, AWR, ADDM and SQL tuning.
• Monitoring Concurrent Managers & its operations like starting, stopping the concurrent managers & Troubleshooting problems, resolved the view log/out files issues of concurrent requests.
• Applying patch on Applications using Adpatch utility on Patch instance.
• Oracle Applications Utilities like AD Administration, AD controller, Autoconfig, AD Relink, Auto Patch, f60gen and managed passwords using FNDCPASS.
• Install Ghost Script, OCR fonts, printer driver and configure PASTA for Barcode and OCR print
• Configure RMAN for backup to Tape library (Commvault) and clone the database.
• Install and configure OEM 10g grid control and application monitoring and alert setup.
• Tune production database and production application server for best performance.
• Validating and creating grants & synonyms on Apps schema, performed Jar file/forms generation as a post patch step, Relinking the Oracle Apps programs
• Performed tracing for various user sessions and for various conc. Programs

Environnent: DB 11.1.0.7, APPS R12.2.4/R12.2.5, in Linux RHL 5 and Solaris10

Confidential

Lead Oracle Apps DBA

Responsibilities:

• Controlling and monitoring the user access to the database.
• Resolving user issues and performance issues due to high CPU usage.
• Developing Hot, cold and logical backup scripts to automate the backup procedures
• Cloning of application from production environment to test environment and application of patches.
• Monitoring the table growth, database growth, current users, and system usage.
• Implementing standby database and database replication to provide high availability of database.
• Design and involve in planning of upgrade with 32bits to 64bits upgrade.
• Instance and configure single instance to 2 node 10g RAC instances in ASM shared disk.
• Design high availability solutions, stand by databases and fail over servers in SAN Storage and oracle cluster.
• SAN storage solution and architect for Oracle R12 RAC with LUNS layout.
• Provide solution with evaluating Hardware and Software requirements and making recommendations.
• Implement reliable backup strategies and recovery procedures for large database (3.5TB).
• Proficiency in 11g R2 and 10g database with cluster, Data Guard, ASM, flask recovery, OEM and RMAN, AWR, ADDM and SQL tuning adviser.
• Hands on experience in Disaster Recovery with FAILOVER from Data guard to Production.
• Implement and execute SWITCH Over from production to data guard and vise versa after Failover happened in our production server.
• Current application Database larger than 3.5 TB in size, with multi tier Load Balancer.
• Resolved major issues and storage setup for large segments with BLOB and BFILE type.
• Setup and configure Active-Active Cluster in shared disk in SUN cluster.
• Implement KINTANA / PVCS for patch application and code migration, to ensure integrity and Control, between development and production environments.
• Extensive use of OEM 10g grid control and application monitoring and alert setup.
• Exclusive GO-LIVE production support and APPS implementation in Netherlands.
• Help Client review the Security Hazards and evaluating the options provided by Oracle Security.
• Resolved multiple production issues in ASCP, WF mailer, configurator, JVM and DB performance.