SUMMARY

• Having 14 Years of IT experience in Oracle Applications Database Administration and Oracle Database Administration.
• Have several years of experience in Oracle Database technologies and Strong skills in using Oracle Relational Database Management System (Databases) and Business Analysis Query Optimization Techniques (RQO).
• Sound knowledge of software development life cycle methodology with strong analytical, and problem - solving skills to troubleshoot complex issues while adhering to process standards and procedures for software development.
• Lead and execute with a cloud-first mindset, helping customers realize the benefits of an Oracle cloud-based architecture Provide assessment of current state architecture and recommendation of future state architecture.
• Experience in Enterprise Security Domain, in-depth knowledge of LDAP and Identity and Access management products - Oracle Identity Manager (10g and 11gR2), Oracle Access Manager, Oracle Internet Directory, Oracle Virtual Directory, Oracle Business Intelligence, Oracle Web Center, Oracle Apps DBA, WebLogic Server, SOA Suite, Oracle forms, reports and Discoverer 11g, Application Express, Patching, Cloning, Upgrade.
• Experience in installation and maintenance of various EBS modules.
• Applying latest releases of the patches from Oracle to the instance to resolve few application issues.
• Cloning the instances from production to Test, Development instance to test & simulate few technical challenges, coordinate with testing and development teams.
• Performed EBS R12 DB Upgrade 11.2.0.4 to 12.1.0.2, 12.2.0.x and .2.0.4. Oracle DB 12c/11g/10g Installation, Upgrade, Administration on HP UX Itanium 11:31.
• Extensive experience in Graphical User Interface (GUI) Development using JSP, HTML and XML.
• Experience with implementing out-of-box and customized connectors for MSAD, OID, EBS and GTC connectors.
• Experience designing enterprise LDAP & Active Directory.
• Experience in defining strategy and approach for AD group clean-up and group management by IDM (RSA VIA) including Access .
• Extensive knowledge of PAM (Privileged Account Management).
• Extensive experience working with implementing or designing implementations of Oracle Identity Manager (OIM), Single Sign-on (SSO), Oracle Internet Directory (OID), Oracle Access Manager (OAM) and analyzing complex access requirements against highly-sensitive data and designing and/or implementing reliable and secure solutions to accomplish them.
• Experience in troubleshooting the complicated issues, defects during deployment and post deployment of IAM solutions
• Experience in deploying enterprise topologies for the Oracle Identity Management Infrastructure components
• Excellent knowledge of applying Oracle Identity Manager (OIM), Oracle Access Manager (OAM), Oracle Identity Federation (OIF) and WebLogic application server patches
• Solid experience in theoretical and practical aspect of relational databases with focus on Oracle PL/SQL, Stored Procedures and SQL Plus.

TECHNICAL SKILLS:

Operating Systems: Windows, Red hat Linux, SolarisDatabasesOracle 19c,12c/11g/10g/9i/ MS Access, MySql, MS SQL Server

Security Management Tools: Oracle Identity Manager, Oracle Access Manager, Oracle Unified Directory, Oracle Internet Directory, Oracle Virtual Directory, MS Active Directory, Oracle Identity Federation, Sun Enterprise Directory Server/iPlanet.

Web Technologies: SOAP, WS-Trust, WS-Policy, WS-Security, WS-Addressing, WS-Secure Conversation, WS-Federation, SAML.

Languages: Java, XML, HTML, PL/SQL, C++, C.

Markup Languages: HTML, XML

Scripting: JavaScript / WebLogic Scripts

Tools: Jdeveloper, Eclipse, NetBeams

PROFESSIONAL EXPERIENCE

Oracle Apps DBA & Oracle FMW Administrator

Confidential - NJ

Responsibilities:

• Cloned and Patched Oracle Applications 11i/R12 Monitored and Managed Oracle Applications 11i/R12 through SOPs
• Installation and Configuration of Oracle Applications(E-Business Suite) R12.2 and Upgrade of E-Business Suite(EBS) Database from 11g, 12c to multitenant 19c.
• Upgrade and Migration of Oracle Databases from 11g to 19c with both Real Application Clusters (RAC) and Non-RAC architecture.
• Implementation and Configuration of Oracle Fusion Middleware(FMW), Webcenter Portal, Content, Imaging, Oracle SOA, Oracle BPM, Oracle Business.
• Refreshed Cloning of Database and Oracle Applications R12 for development and testing Performance Tuning of the database.
• Intelligence Applications with High Availability and Load Balancer configurations.
• Integration of Oracle FMW, EBS with Single Sign-On (OID and OAM), Secure Socket Layer(SSL) and Load balancer.
• Cloning (RAC, Non RAC), patching( opatch, adpatch, adop) of EBS R12.1.3, R12.2.x on Linux, Solaris and AIX platforms .
• Implementation and Administration of IBM Websphere Application Server, IBM Webserver 8.5.5.x, 9.0.x with High Availability architecture.
• Implementation of High availability architectures for Oracle Database - Real Application Clusters(RAC) and Data guard.
• Configuration and Administration of Concurrent Managers, Workflow, SSL, SSO, Load Balancer, Parallel Concurrent Processing(PCP), DMZ and Shared ApplTop
• Performance tuning of Oracle Database, EBS Applications and FMW.

Oracle DBA and Oracle E-Business Suite DBA

Confidential - CA

Responsibilities:

• Data Centre migration of Oracle EBS environments R12.1.3, R12.2.8
• Cloning, Patching of RAC, Non-RAC DBs and EBS applications R12.x.
• Production and Non-Production support and Deployments.
• Checking pre-requisites for the new servers as part of preparation of datacenter migration.
• Administration of EBS application, Databases and Fusion Middleware
• Third party Integrations.
• Non-Production and Production Support(24*7) for Multi-Terabyte Oracles databases and Business critical EBS and Middleware applications.
• Configuring Oracle Enterprise Manager for monitoring Oracle environments(Database, FMW, Applications) and Linux, AIX Servers.
• Automation of Oracle Database and EBS application cloning using shell scripting
• Creating tickets and following up with Oracle for Service Requests.
• Preparation of server pre-requisites for the above said installations.
• Documentation of steps and procedures for implementations of Oracle DB, EBS, FMW and IBM WAS.
• Performing of Switch Over, Switch Back of Oracle Databases, EBS Applications and FMW from Primary site to Disaster Recovery site and vice versa as part of Business Continuity Planning.
• Created Menus, Functions, Personalizations, Concurrent Programs, Responsibilities and registered Custom Top Applications in 11i/R12 Troubleshooted Long Running Concurrent Requests, Forms, Reports and Blank Page issues.

Oracle apps DBA/Fusion DBA

Confidential, CA

Responsibilities:

• Monitoring of Databases and servers using OEM and Oracle applications using cron jobs.
• Oracle EBS migration and Database Upgrade:
• Worked on Oracle E-Business suite application migration from OEL to RHEL including design and configuration of new RHEL servers
• Upgraded database from 11g to 12c on OEL,RHEL and Windows platforms
• Grid upgrade from 11g to 12c
• Setup Dataguard configuration
• Migrated Oracle EBS Databases from ASM to Non-ASM and Non-ASM to ASM
• Backup, Restore, Recover databases using Recovery Manager(RMAN)
• Conversion of databases from RAC to Non-RAC
• Implemented Fall-Back procedure for downgrading 12c database to 10g on Windows
• Worked on Automation of Database upgrade from 11g to 12c using shell scripting
• Cloning and patching of 12c database,grid and R12 applications.
• Performed System Administration and Security of Oracle e-Business Suite 11i/R12 Used RMAN for backup and recovery.
• Performed backup validations using RMAN.

Confidential, CA

Oracle Apps DBA/OAM

Responsibilities:

• Production support the Oracle Application 11i and R12 instances including the boundary application like Weblogic,OBIEE,Apex Portal aplication with glass Fish server.
• Fusion 11.1.8 installation and configuration upgrade 11.1.7 to 12.1.0.2 and also upgrade R12.1.3 to 12.2.5.
• Web gate configuration and registration with Oracle access manger.
• Setting up Oracle Identity Manage for Single Sign-On with Oracle Access Manager.
• Worked together as a member of a Team to design and develop solutions.
• Design, development, test, and implement Oracle identity management 11gr2 solutions
• Development and enhancements Banner/OIM web services
• Document, test implement and provide ongoing support for Oracle E-Business suite application.Performed Unit Testing
• Developed Custom Scripts to automate the Build and Deployment Process
• Developed and registered Plugins with Oracle Identity Manager
• Developed and registered Event Handlers
• Created Users, Access Policies, Authorization policies and custom attributes
• Configuring & provisioning to Active Directory
• Responsible for documenting the various process flows
• Analyzed and troubleshooted problems in the application.

Confidential

Oracle Apps DBA

Responsibilities:

• Installations, Upgrades, Patching, Administration (AD Utilities), Cloning, Migrations and 24x7 Support.
• Performed System Administration and Security of Oracle e-Business Suite 11i/R12 Used RMAN for backup and recovery.
• Installed and supported OEM 10g on Windows and Linux.
• Perform Oracle database performance analysis and optimization, define bottlenecks and manage testing and production implementation
• Make recommendations for process improvements
• Create and execute scripts
• Perform Root Cause analysis
• Created table spaces, tables, and users for custom applications.
• Performed Schema/Tables/Databases export using Data Pump, Export and Import utilities.
• Created Menus, Functions, Personalization, Concurrent Programs.
• Running Concurrent Requests, Forms, Reports and Blank Page issues.
• Monitored and Managed Oracle Applications 11i/R12 through SOPs.
• Experience with Oracle database High availability (RAC/ASM/Data guard)
• Prepare, Manage, and Own backup and recovery objectives for entire Oracle E-Business suite and other database stack
• Install, configure, patch, and, clone RAC and non-RAC Oracle databases.