SUMMARY

• Sr. Oracle Applications DBA/ Oracle DBA/ GoldenGate with 12+ years of IT experience as an Oracle Apps DBA and Good experience in Oracle E - Business Patching / DB Patching, upgrading, Migration and Load Balancing.
• Worked on upgrade of oracle databases from 12c (12.1.0.2) to 19C (12.2.0.3).
• Extensive knowledge in Oracle EBS R12.2 Technology, Architecture, Deployment and Infrastructure having multi node, load balanced, clustering and DMZ setup
• Extensive knowledge in installation, configuration, deploying technology stack of in EBS R12 and its Oracle database installation, configuration and upgrade
• Expertise in Oracle Database administration in clustered (RAC) and Non-clustered architecture, Oracle Applications DBA (EBS), Implementation, upgrade and support of Oracle EBS v11i to R12.2.9
• Expertise in Installation of Oracle EBS 11i, 12.1.3, 12.2.9 Version
• Specialist in Upgrading the EBS from 11i to 12.1.3 and from 12.1.3 from EBS 12.2.9
• Extensive knowledge of ADOP cycle (Apply, cutover, finalize, fsclone, cleanup)
• Implemented different version of AD and TXK Delta upgrade. From version Delta 5 to Delta 8 and to Delta 11
• Good experience in applying PSU and Critical Patch Update (CPU Patches) using Opatch Utility on Databases 11g, 12c(12.1.0.2, 12.2.0.1, 12.2.0.3(19c)), Oracle E-Business Suite (R12, R12.2), Weblogic (10.3.6, 12.1.3, 12.2.1.4)
• Expertise in Platform migration for Application 12.1.3 and database 11.2.0.4 to Cloud ExaData
• System wide Performance Tuning including memory, SQL, Database tuning, monitoring locks & processes using OEM, AWR, ADDM tools
• Upgraded database from 11.2.0.4 to 12.1.0.2.
• Performed U2L Migration of Databases and Applications using swing server and Goldengate to reduce downtime for the Applications.
• Involved in various Golden gate installation, instantiation, upgrades, performance tuning.
• Setup Uni-Directional table and schema replication using Golden gate and Wrote scripts for Error Detection using Exception table.
• Working on Standby Databases, which are out of sync from primary by roll forward using incremental backups.
• Working on a daily basis on various reports related to tablespaces management, Goldengate, Data guard etc.
• Expert in install and maintain WebLogic servers and related applications like SOA, ADF, OBIEE
• Experience integrating Oracle Application sign-on to Microsoft AD
• Expertise in OAM, OIM, OID and SSO Configuration
• Involved in the areas of installation and support of oracle Applications 11i (11.5.10.2), R12 (12.1.3) and 12.2.4 on single and multi-node systems and databases 11g/12c.
• Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Stats pack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzed SQL trace dumps for 11g/12c.
• Experience in OID, OAM, SSO, SOA, ADF and GRC middleware applications
• Expertise in Single sign on implementation with better understanding of Oracle internet Directory and Oracle Access Manager.
• Experience in installation of Oracle Discoverer (11.1.1.7) Oracle Access Manager (11g-11.1.2.3), Oracle Identity Manager (OID - 11.1.1.9), Oracle HTTP server, WebLogic server (10.3.6) and having experience in managing the servers.
• Integrated SSO implementation and integrated with R12.2.4 EBS Application and discoverer
• Daily health check like monitoring tablespace, mount points etc.
• Analyze DB performance using AWR Report, ADDM Report, Oswathcher logs and fix the performance glitch
• Scheduling jobs through Oracle Job Scheduler, Cronjobs (UNIX), Autosys jobs

TECHNICAL SKILLS

Operating System: Exadata, Exalogic, Linux x86, x86-64, Windows 98/XP/2000

Programming Languages: Forms/reports 10g/11g, PL/SQL,SQL, Oracle OBIEE

Applications Tools: OAM, OID, Rapid install, AD Utilities, FNDLOAD, Oracle ADI / Web ADI and ad utilities. Toad, Putty, PL/SQL developer, WinSCP, DataLoad, Workflow builder, OEM and Shareplex

Oracle Applications: Oracle E-Business Suite 11i, R12, R12.2.4, Oracle Application Server 10gAS, Oracle Access Manager (OAM) 10g/11g, Oracle Internet Directory (OID), Discoverer 11g

Databases: Oracle 9i/10g/11g/12c, Shareplex, ASM, RAC, Dataguard

Other Utilities: Oracle Data Integrator, Oracle Forms & Reports 10G / 11G, Data Modeling, EBS, IPcenter V3 and Remedy Server for ticketing, 10g Enterprise Manager, Export/Import, Recovery Manager (RMAN), Toad

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Responsibilities:

• Good Experience on oracle Application 12.1.3, 12.2.9 and WebLogic Administration
• Specialist in Upgrading the EBS from 11i to 12.1.3 and from 12.1.3 from EBS 12.2.9
• Advanced configurations - Load Balancer, PCP with RAC
• Patching using Adop and Adpatch
• Good experience in applying PSU and Critical Patch Update (CPU Patches) using Opatch Utility on Databases 11g, 12c (12.1.0.2, 12.2.0.1, 12.2.0.3(19c)), Oracle E-Business Suite (R12, R12.2), WebLogic (10.3.6, 12.1.3, 12.2.1.4).
• Recently upgrade database from 12c(12.1.0.2) to 19C (12.2.0.3)
• Upgraded database from 11.2.0.4 to 12.1.0.2.
• Installation & configuration Apache Tomcat/8.5.51 & Sabrix Tools
• Monitor and maintain Oracle databases health using Grid control (OEM)
• Coordinate, manage and conduct network vulnerability tests and remediation with end users; and participate in dynamic/static application code scans/assessments.
• Fixing All Infra Linux Server Applications Security Vulnerabilities.
• Upgraded JDK versions from 1.6 to 1.7 and JRE to 1.8
• Applied EBS 12.1.3+RPC5 patch set, which includes the latest recommended patches and their dependencies for all Oracle E-business Suite products and product families like ATG, FIN, SCM, HRMS, and PRC etc.
• Applied Fusion Middleware Technology stack patches (OHS, WebLogic, FMW) for EBS R12.2 environment.

Confidential

Sr. Oracle Applications DBA/ Oracle DBA

Responsibilities:

• Good Experience on oracle Application 12.1.3, 12.2 and WebLogic Administration
• Expertise in Installation of Oracle EBS 11i, 12.1.3, 12.2 Version
• Specialist in Upgrading the EBS from 11i to 12.1.3 and from 12.1.3 from EBS 12.2.6
• Implemented different version of AD and TXK Delta upgrade. From version Delta 5 to Delta 8 and to Delta 10
• Extensive knowledge of adop cycle ( Apply, cutover, finalize, fsclone, cleanup)
• Perform application tuning
• Cloning on multi node of EBS application in different version of EBS (11i, 12.1.3, 12.2.4 )
• Expertise in OAM, OIM, OID and SSO Configuration
• Worked on Platform migration for Application and database to Cloud Exadata.
• Experience on Refresh multiple table from one instance to another
• Experience on re-org partition and non-partition tables - memory issues, stats are up to date schemas, Table fragmentation.
• Experience on Bulk Migration from one instance to another
• Installation and Upgrade of Oracle Database of different version 10g, 11g and 12c
• Upgraded database from 10g to 11g, 11.2.0.3 to 11.2.0.4 and from 11.2.0.4 to 12.1.0.2
• Expertise in RAC database, Cluster Services and Grid
• Database Patches ( Critical Patch Update, Patch Set Updates and regular database patches)
• RMAN backup strategy in Database (Arch or Full backup)
• Analyze DB performance using AWR Report, ADDM Report, Oswathcher logs and fix the performance glitch
• Implemented the Integration of Oracle Internet Directory with E-Business Suite
• Successful implementation of Single sign on (using OID, OAM and Web Gate/Access Gate) with Windows Authentication (Kerberos).
• Installation and integration of Oracle Data Integrator (ODI), R12.1.3 EBS.

Confidential, Jersey City, NJ

Sr. Oracle Applications DBA/ Oracle DBA

Responsibilities:

• Good Experience on oracle Application 12.2 and WebLogic Administration
• Installed, configured, and maintained Oracle 11gR2 and 12C.
• Upgraded databases from Oracle 11g to 12C.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Upgrade experience of Oracle Applications from 12.1.3 to 12.2.4
• Cloning of 12.2.4 oracle applications
• Oracle Applications R12.2.4 Clone and Support on RHEL Linux environment.
• R12.2.4 installations and Online Patching Activates
• Successful implementation of Single sign on (using OID, OAM and Web Gate/Access Gate) with Windows Authentication (Kerberos).
• Installation of Oracle Access Manager, Oracle Identity Manager (OID), Oracle HTTP server and WebLogic server
• SSO implementation, Discoverer with SSO
• Implemented the Integration of Oracle Internet Directory with E-Business Suite
• Successful implementation of Single sign on (using OID, OAM and Web Gate/Access Gate) with Windows Authentication (Kerberos).
• Installation and integration of Oracle Access Manager 11g (OAM/OID), R12.2.4 EBS and discoverer 11g
• Managing the OAM, OID, OHS servers and also All Web Logic domains
• Expertise in Single sign on implementation with better understanding of Oracle internet Directory and /
• Integrated SSO implémentation and integrated with R12.2.4 EBS Application and discoverer 11g
• Patching CPU for databases and Oracle Applications
• Troubleshoot Oracle Applications and Oracle database issues
• Daily health check like monitoring tablespace, mount points etc.
• Involved in SYSADMIN activités
• Starting, stopping managed servers, admin servers as per the monitoring status.
• Plan DBA schedules and activities, prioritize the work to ensure work is progressed and aligned with project delivery dates
• Identify and escalation plan for each critical situation

Confidential

Sr. Oracle Applications DBA/ Oracle DBA

Responsibilities:

• Handling administration of 24*7 Production and UAT/Dev/Test environment.
• Part of team maintains 120 DB/Apps instances - all version of Oracle Applications starting from 11.5.10.2 to R12 in all flavors of UNIX, versions of databases- 11g, size of prod is 2 Terabyte.
• Configured & supported Shareplex for replication.
• Expertise in handling the tickets raised by the clients through IPcenter v3 Tool.
• Handling Outage Engagement Process
• Day to day troubleshooting of the environments which includes fixing all the issues coming in them and supporting the various components of Oracle Applications - Forms, Apache, Concurrent Manager, SOA services, SSO services, Stat Agent services, GRC services, WF Mailer and apps login etc.
• Installed and Configure Oracle 10gAS R3 with SSO, OID and LDAP.
• Gathered requirement for installation of OAM products including OHS, Web Logic server and OID.
• Installation of Oracle Access Manager, Oracle Identity Manager (OID), Oracle HTTP server and WebLogic server.
• Installation of SOA 12C environment and ADF 12c installation
• Involved in maintain and administrative activities of SOA 11g environment
• Experience in deployment of applications in SOA and ADF.
• Implemented the Integration of Oracle Internet Directory with E-Business Suite
• Successful implementation of Single sign on (using OID, OAM and Web Gate/Access Gate) with Windows Authentication (Kerberos).
• Single Sign-on implementation using Oracle Access Manager 11g(11.1.2) and integrated with Active Directory
• Managing the OAM, OID, OHS servers and also All Web Logic domains.
• Daily review of RMAN backups and error logs, ASM disk usage, OS Disk utilization.
• Configured Physical Standby Database with Maximum Performance Protection mode.
• Install OS Watcher and RACCheck to address and troubleshooting issues on a RAC Database.
• Added more raw disk to ASM disk group, create and maintain ASM database instances.
• Experienced with SRVCTL, CRSCTL, OCR and Voting Disk of 10g/11g RAC.
• Performance troubleshooting using tools such OEM Grid control, Oracle SQLT
• Resolving locks, compile invalid objects, resolving blocking objects and killing inactive sessions if necessary.
• Monitoring space related alerts and adding space or deleting old files.
• Performing (Database/Applications) refresh from production to other instances on user requests.
• Done database refreshes from RMAN weekly, monthly and daily as per the business requirements.
• Interacting with Oracle support for technical assistance requests
• Patch Analysis for the patches including CPU patches, RUP, minipacks, one-off and RDBMS patches.
• Monitoring Cold, Hot and RMAN backup scripts of the databases supporting different applications
• Taking Oracle traces and providing the output of tkprof and explain plan utilities to the development team
• Taking care of table space related issues like increasing the storage parameter values, resizing the data files, adding new data files etc
• Applied India Localization, RDBMS, Applications patches, using Opatch/adpatch utility.
• Performed database and application cloning of Production database on TEST environment to provide users the live data for testing purpose.
• Performed clone from Prod backup to Test and DEV environment instances for all clients. Cloning includes from multinode-multinode, muti-single, RAC to Non-Rac and RAC to RAC environments.
• Designed and implemented Expenses role based security
• Configured Workflow Mailer on different instances.
• Setting Profile Options (site level, User level).
• Bouncing of SSO, SOA services as requested by clients.
• Upgrading JDK versions from 1.4.2 to 1.5 and 1.6 and JRE to 1.5, 1.6 and 1.7

Confidential, Charlotte, N.C

Sr. Oracle Applications DBA/ Oracle DBA

Responsibilities:

• Daily monitoring of production systems through OEM 12c and Cron scripts.
• Troubleshooting various database and application issues faced by development and functional Team.
• Configured & supported Shareplex for replication.
• Performed server maintenance activity for databases running ASM, RAC, Shareplex & Data Guard.
• Expertise in maintaining Database Security using auditing.
• Implementation of full life cycle and upgrade of Oracle GRC product Suites (AACG, TCG, CCG and PCG).
• Highly skilled in providing audit and recommendations for all PeopleSoft modules to redesign security in a role-based approach, utilizing industry best practices to support Sarbanes-Oxley and Segregation of Duty standards.
• Remedy Ticket Resolution, identifying customers’ problem and providing solutions in time.
• Identifying probable performance issues in production and solving them, Raising and monitoring SR(s) with Oracle.
• Performance Tuning for R12 applications and 11g Databases in Exadata X3/X4 machines.
• Migrating 11g Databases and R12 applications into new X4 Exadata machines from X3 machines.
• Performing regular clones for applications and databases to build new systems from important applications.
• Analyzing and Applying patch as per request from functional and technical team.
• Preparing backup and recovery solutions for newly built systems.
• Performing audit compliance for database and application systems.
• Oracle R12 experience includes, installing and upgrading to 12.1.3 version
• Successful implementation of Single sign on with Windows Authentication.
• Single Sign-on implementation using Oracle Access Manager 11g(11.1.2) and integrated with Active Directory
• Identifying and creating new problem task which are existing in the system and providing timely resolution for those.
• Mentoring and ensuring delivery for the offshore Team.
• OTM implementation focusing on the initial installation and implementation of OTM( Oracle Transportation Management ) version 6.3.3
• Defining Custom Concurrent Programs.
• Using my analytical ability for analyzing the existing business requirements and proposing new solutions for the problem.
• Involving in team meetings and co-ordinate with the review team.
• Day to day troubleshooting of the environments which includes fixing all the issues coming in them and supporting the various components of Oracle Applications - Forms, Apache, Concurrent Manager, SOA services, SSO services, Stat Agent services, GRC services, WF Mailer and apps login etc.
• Interacting with offshore and onsite teams to ensure proper coordination within the team and with other teams, Provide timely reports to concerned managers about details of project activities, SLA / CSI reports and work status, Determining the resource requirements, allocating resources, planning of knowledge transfer and transition into the environment.
• Taking necessary action for the respective alerts.
• Resolving locks, compile invalid objects, resolving blocking objects and killing inactive sessions if necessary.
• Keeping track of long running Concurrent Requests.
• Monitoring space related alerts and adding space or deleting old files.
• Performing (Database/Applications) refresh from production to other instances on user requests.
• Done database refreshes from RMAN weekly, monthly and daily as per the business requirements.
• Attending meetings with client and offshore managers to discuss about future road maps of the project.