SUMMARY:

• Strong background in Oracle E - Business Suite v11.5.x and Rel12 and Oracle Database 8i, 9i,10g,11g administration. Specialized in implementation, support, maintenance, upgradations and migrations of high availability databases.
• Customer-focused, highly organized and self motivated with proven ability to manage technical aspects, relationships and communicate solution strategies to teams and management.
• Platforms migration from HP-UX to IBM AIX, LINUX to WINDOWN, SOLARIS TO LINUX
• Experience working on Oracle fusion middleware and Oracle Application Server architecture. Worked worldwide. Experience
• Installed Collaboration SOA Suite 10iAS 10g. Setup Oracle Web conferencing, Email, SSO, 10g Rac database.
• Multiple installed of oracle R12, upgrade of E-business R12 from 11i.5.4, 11i.5.8,11i.5.9 and 11i.5.10
• Installed OID and ldap 10g database integrated oracle portal with R12 E-Business suite.
• Installed setup configured and provision Oracle OIF,OVD OIM OAM OAAM OUD OEG, OWSM, OSB OES
• Over Nine years of Oracle 7/8/8i and 10x/11/11i Application DBA, experience both as Apps DBA and Oracle Financial Oracle architecture and administration.
• Experience as an Application DBA for 10x/11x/11i e-business suite activities such as installation and configuration of Oracle9i Application server, and ORACLE Portal.
• Installing, upgrading, migrating, maintaining and implementing 10 x/11 x/11i e-business suites. working with Quest STATs tool for Oracle
• Installed and configured multi-tier Oracle Collaboration Suite 10g, 3 nodes install on Linux and Aix. Installed and setup Oracle Files, Web Conferencing, SSO.
• Installed, configure multiple RAC in various OS, migrate from multiple to single and from single to multiple
• Multiple upgrade from oracle 8i to 9i and 9i to 10g, migrate from single to multiple 9i. Installing, upgrading, migrating, maintaining and implementing 10 x/11 x/11i e-business suites.
• Expertise in Performance Tuning, Migrations, Scripting, Disaster Recovery techniques, Backup & Recovery for Oracle 11g RAC,10g RAC,9i,8i Databases, SQL Server 2005, 2005 databases, Oracle Fusion Middleware and Oracle Application Server 10g.
• Hands on experience with Oracle 11g, 10g Real Application Clusters (RAC) installation, maintenance & as a production support
• DBA.Strong experience as an Oracle 11g, 10g, 9i, 8i Database administrator. Provided 7X24 production DBA support along working with the engineering & development teams for test and production Experience work Databases on Unix, Linux, Solaris & Windows Server.
• Hands on experience with Installation, Configuration and maintenance of Data Guard and RAC.
• Good Knowledge of Installation, Configuration, Monitoring and Maintenance of Oracle Databases, ASM, CRS/Clustware & SQL Server Databases. Expertise in Database Installations, Configuration, Monitoring, Maintenance, Patches, Data Migration, Database upgrade, Database Security and supporting 6+ Terabyte Databases and DB Applications. Excellent Knowledge Oracle RMAN, Conventional Backups, Recoveries, with RMAN and implementation

TECHNICAL/FUNCTIONAL SKILLS:

• Oracle Application Manager (OAM), OATM, Data Guard, Oracle Enterprise Manager (OEM), Replication Manager, 9i and 10g RAC (Real Application Cluster), Backup and Recovery Manager RMAN, Security Manager, Tablespace Manager, Net8 Assistant, Oracle Tools, SQL Worksheet, Oracle Enterprise Edition 9.x/8.x, Oracle Application Management Pack,Omniback oracle OVD oracle access manager and configured SOA suite, OID,Ldap collaborated directly with business units to assess the technical impact of business requirements and to reach consensus on alternative solutions when necessary in an effort to maintain a consistent yet flexible architecture Oracle Product Lifecycle Management, which includes Oracle Collaboration Suite, Oracle Configuration, Oracle Discrete Manufacturing, Oracle Project Management, Oracle Project Collaboration and Oracle Sourcing, helps companies collaboratively manage all product-related activities across the enterprise and accelerate the new product development and introduction process. Many customers are currently using 11.5.10-E release to increase value-chain efficiency.
• Provided analysis, design, installation, and rollout of Oracle 11i General Ledger, Accounts Payable, and Purchasing .
• Setups included Multi Language, Multi Reporting Currency, Multi Organization Maintained proactive interaction with the client to understand business practices to aid in system configuration Implemented a fully integrated solution utilizing Oracle Financials from release 11.03 to R12 for Financial Reporting, General Ledger, Accounts Payable and Project Prepared budgets, reports and financial statements Maintained account reports, and tracking spending and cost variances for reporting
• Experience with Oracle apps through 11i including Project Costing, Project Billing, Payables, General Ledger (GL), Accounts Receivable (AR), Fixed Assets (FA), Purchasing, Inventory and iProcurements Oracle Receivable, Cash Management, Purchasing - Releases: 11i (through 11.5.10.2 patchset M), 11, 10.7 Conducted stakeholder interviews to deliver a project gap analysis. Documented the functional requirements and coordinated with Development and QA/QC to ensure proper implementation
• Provided expertise to customers in developing WebLogic High Availability architecture (Clustering, Cloning, Multidatasourcing etc Expertise in implementing Oracle SOA suite, Good experience working on Oracle - Agile PLM suite
• Guided customers to stabilize and attain Scalable architecture, performance tuning. Guided/Supported customers during Production deployments, new releases. Guided customers to attain their business/technical goals by Performance tuning &diagnostics(tweaking Jvm parameters, using various java profiler tools, third party tools, heap dumps, GC logs etc.) Troubleshooting: memory issues, deployment issues, performance issues, SSL issues, Jvm crashes etc. Guided customers during Upgrades post upgrade Monitoring and Maintenances.

PROFESSIONAL EXPERIENCE:

Confidential

Environment: High available cluster Oracle SOA Suite, weblogic on two node PIP AIA ODI OSR OEPE OSB BPM BAM BPEL, ESB, BAM, OWSM, Jrockit Java 1.5, J2EE, JSP, EJB1.2, DB2, Eclipse, JDeveloper, WSAD, HTML

Responsibilities:

• Design and installed extending domain creation for SOA server, BAM ODI AIA, OSR OER . design OEM 12c architecture and deployment plan
• Install and configuration of base monitoring for SOA components web center portal and enterprise content, install and configuration of OEM SOA/WLS Management pack
• Oracle Provisioning and Patch Automation Pack Oracle Configuration Management Pack
• Responsible for administering Oracle EBS including upgrades and migrations, OEM, Cloning, Discoverer,Concurrent Manager, Multiplatform support including Linux. Performed complex EBS administration tasks
• Responsible for responding appropriately to event tickets with expediency required to meet service level agreements.
• Involved in providing monitoring solutions for customers ‘ Oracle EBS environments using.
• Involved in establishing and documenting best practices for the supported RDBMS and EBS environments.
• Provided expert level trouble shooting skill for the supported RDBMS and Oracle EBS environments.
• Responsible for general database administration tasks and
• Provided expert solution and architecture design for Oracle Entitlement Server (OES)
• Solved customers issues related to web servers Web server and Plug - in to WebLogic server
• Performed Web Logic Server administration tasks such as Installation, Configuration, Monitoring and Performance Tuning..
• Deployed various WAR, JAR and EAR applications in Production and non-production Environments
• Configured and administered JDBC Connection Pools/Multi Pools/Data Sources on WebLogic Server 11g
• Created Managed Servers and Node Manager in Production Servers and test servers.
• Developed Scripts for deploying applications in different environments using webLogic. Deployer utility.
• Performance tuning of JVM heap size, garbage collections, java stack and Native thread & production performance of WebLogic
• Installation of F5 load balancers and configuring then to available IPs, switching over traffic, activating and deactivating traffic over the pools, installing of SSL certs, applied various load balancing concepts.
• Created WLST scripts for deployment activities like deploy, undeploy, redeploy start and stop the applications
• Created Work Managers for the specific applications based on their priority.
• Configuration of Clearcase, Work with bug track system.
• Troubleshooting Web Logic Application Server connection pools and manager
• Implemented Exception Handling for the Confidential Process models to handle System, Business exceptions and used Compensation handlers to handle the transaction if an exception occurs
• Analyzed the business needs for the processes and modules that needed migration
• Design and Implement Adapters for backward compatibility with old modules
• Implement old processes into new modules and make sure all the business needs are addressed. Design, development and deployment of Web Services was done using Oracle BPEL, JAVA, and XML ( Confidential )
• Assisted in training others on Confidential and determining how to integrate Confidential into the Common Services projects.
• Extensively used Confidential to determine dynamic partner link calls, updating databases via BPEL, generating proxy stub classes to call Confidential process from a web application, etc
• Assisting in the coding and testing of the Shared Security Common Service which is intended to be a building block for the rapid development of applications. By providing a configurable, stable, standardized set of security-related services, designers and developers will not have to worry about the implementation of a security system and will just need to invoke the web service.

Confidential

Applications Architect and DBA

Responsibilities:

• Installation, Upgrade, Patching, application integrate the portal 11i with R12, 24x7 Support
• R12 upgrade and platform migration from HP-UX (PA-RISC) to Linux. Six eight server
• Oracle 10g Application Server, Installation, Upgrade. Performance Tuning, PL/SQL Tuning, Indexes.
• Applications Architect and DBA - Performed multiple upgrade iterations
• Release 11 System Architecture and Infrastructure Planning
• Release 11 Patch Planning and Release Management
• Release 11 Conversion, Extension, Workflow, Interfaces and Reports QA
• Provided strategic and tactical guidance for hardware and software Presenting with Client at Collaborate 09
• Database Backups, Export/Imports, and Disaster Recovery
• 11i upgrade and Oracle Applications 11i shared APPL TOP migration from HP-UX to Linux
• Configuration assessments and performance assessments to optimize E-Business environments for 11i and R12 for VLDB
• Mentor and assist Oracle ATG and Functional team members on ATG technical issues
• Rectified for issues upgrade such as BI Publisher, Output Post Processor, Discoverer, SSL, cloning, Forms, Apache, Workflow
• Register Concurrent Managers, Web nodes, load balancing, F5 Big IP configuration
• Enhance and implement the new requirements of the Business.
• Mapping 11.5.10 reports to R12 XML templates, writing Extent and Validation rules, plugging Validation and extends to Payment Process.
• Worked Close to Product Dev. Team of Oracle APPS for modifying functionality for R12 Payments Module.
• Developed Registration Scripts for Moving Objects from one environment to another.
• The client E-business consist of federal fianancial, PO, AR GL IN HRMS
• Clone/refresh production to development environment once a week
• Integrate the E-business with Markview, Sunflower Approwork Oracle Discover.
• Maintains development instance in congestion with production upgrade
• Refresh development instance from production periodically
• Setup markview to caputre invoices and automated oracle payable process
• For Accounts Payable automates financial processes for the purpose of ensuring the consistent, efficient,
• Timely processing of invoices from receipt through payment.
• Use MarkView will capture invoices in Progressive's ERP system from arrive day
• Setup and suppliers, consumes thereby accelerating approval and payment cycles and improving cash management as each invoice is closely managed from receipt through payment and automated business rules are applied to make appropriate tradeoffs between payment timing, potential discounts and late payment penalties
• Create user in Oracle EBS and sync with Markview as purchaser

Confidential

Sr Oracle Appsdba Consultant

Responsibilities:

• Fresh Oracle R12 implementation modules including HRMS, Treasure Inventory project GL, Time and labour
• Upgrade the client current oracle 11i.510 to oracle R12.1.1 on hp-ux itanium 11iv31 with nine database sharing APPLS environments Load balanced the application tier to two nodes and converted it to a shared APPL TOP.
• I mplementation of HRMS suite, which included Payroll and Advanced Benefits.
• Provide production support for which included the Financials Suite on HP UX 11i using 11.5.10.2 CU2 on 10gR2. Implemented RAC for test environment
• Planning and making recommendation regarding patch to applied in the E-business suite application to or to all application environments
• Provide weekly clones of production for development and test instances
• Created post clone procedures that include modifying sensitive production data.
• Conduct three month dba/apps workshop to train the dba the proper procedure to maintains both the database and the application including security setup such as Hrms security profile, node, site concurrent manger profiles how to change user password either through fndcpass or using scripts update user profile
• Provided a health check of production EBS to address many instability and performance issues and documented findings and implement recommendations
• Provided strategic direction for instance creations and recommendations for data center disaster recovery This included strategic plans for system growth and future capacity requirements
• Configured and implemented OEM to manage all instances
• Implemented RMAN for production and test environments
• Created and implemented change management procedures for all environments.
• Worked in conjunction with Developers to resolve performance issues with custom code (reports, forms, concurrent reports, mviews etc)

Confidential

Sr Oracle Appsdba Consultant

Responsibilities:

• Federal finanacial implemention - full life cycle implementation, support functional teams,
• Setup concurrent job, monthlu batch job
• Patch the application as needed by functional teams Designed and implemented Oracle Real Application Clusters (RAC) on Solaris for an OLTP application with Transaction Application Failover and high transaction volume.
• Deployed Disaster Recovery (DR) solution for Oracle 10g using falcon store and database mirroring for SQL Server 2005.
• Implemented Oracle 10g Dataguard for High Availability. (HA) and maintained stand by database for reporting purposes.
• Implemented strategy for partitioning and management of historical data tables in RAC.
• Install, maintain & support Oracle Warehouse Builder (OWB) for datawarehouse.
• Carried out a strategy to direct OLTP transactions and ad-hoc queries to separate RAC nodes using database service name. This helped system to manage workload effectively.
• Maintain the Oracle 10g RAC environment and troubleshoot performance problems.
• Install & Manage Oracle Application server 10g cluster for Oracle forms & reports for high volume reporting applications.
• Troubleshooting & Tune Oracle Application Server 10g report performance.
• Configure active-active HA solution for Oracle App Server 10g.
• Upgrading Oracle Databases from 9i to 10g and from 10g to 11g.
• Configuring SSO for oracle application server, OID & LDAP.
• Performance tuning, troubleshooting & monitoring using ADDM and Automatic Workload Repository Advisor in Oracle and SQL Profiler in SQL Server for very large OLTP databases (VLDB'S).
• Drawing software & hardware requirements for the new applications. Implemented partitioning and materialized views for Oracle 10g Databases. Building test strategies, backup & recovery models for Oracle & SQL servers. Refreshing test databases.
• Managing backup & Recovery for Oracle on Linux using RMAN and MSSQL Server on Windows.
• Providing 24/7 production DBA support for Oracle, MSSQL Server databases and Oracle Application Server.
• Going through the day-to-day user requests and troubleshooting the database related problems.
• Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
• Handle and perform clients Service Request for Incident Management, Problem Management and Change Management.
• Design, develop and deploy logical and physical test and production database solutions for Oracle 11g, 10g database and SQL Server 2005 DB's.
• Identity Management Architect and Implementation Engineer
• Architect for and the implementation of Oracle Identity Manager, Oracle Access Manager, Oracle Role Manager, Novell Identity Manager, and Novell Access manager for proof of concept evaluation.
• Integrated all systems with Active Directory, SunONE LDAP, IIS and Apache web servers
• Implementation was done on multiple virtual servers through VMWare running Oracle Enterprise Linux, Windows 2003,
• Analyze current network layout, services and resources to determine required access.
• Determine user roles and responsibilities, classifying like users into groups to ease maintenance and rule implementations controlling access to resources appropriate to user and group classifications.
• Analyze and document (both existing and potential) solutions for the following: User account provisioning/de-provisioning, Enterprise Directory Services, Single Sign-On (web and desktop), Password Management, Role-Based access control, Strong Authentication
• Provide documentation and recommendations detailing best practices for user and access control as determined by independent research and current like institution implementations. · SOA administration, maintain day to day operation of SOA Systems(development, production, QA)
• Web Service (WSDL, SOAP, and UDDI) definition and architecture and orchestration.
• Installation and configuration of Oracle SOA systems up to version 11g with OAS or Web Logic servers (oc4j and jrocket).
• Defining BPEL, ESB and BAM application development requirements
• Admin and support Business Activity Monitoring
• Implement BI Publisher and Discoverer for Enterprise report - Use BAM for Real time reporting
• SOA- Aqualogic Integration Patterns, AIA implementation and configuration
• SOA Dehydration store administration and planning
• SOA Dehydration store purge programming, scheduling and maintenance
• Back Up and Restore Oracle Application Server which is hosting SOA components
• Adapters: administration JMS, File, FTP, Database, etc
• Manage clustering of SOA components, installation and configuration of SOA HA Upgrade SOA systems
• BAM server installation and configuration, enterprise link configuration, BAM metadata administration
• Experience with Web Service Manager, Service Registry Knowledge of AIA(Application Integration Architecture)
• Weblogic and SOA 11g instillation and configuration on Sand alone and High availability AIA(Application Integration Architecture) based definition of SOA implementation and architecture
• Upgrade SOA 10g to 11g on HA environment, and deployment of service to 11g from 10g Portal Administration and Portlet Development

Confidential

Sr Oracle Appsdba consultant

Responsibilities:

• Migrated MDR from a Legacy based financial package that ran on VAX/VMS to Oracle 11.5.2 ERP and CRM. Installed and configured QA.
• Development and Production instances on Windows 2003 Servers, Linux and AIX servers. Provide all tuning, cloning, 24 X 7 support for production environment.
• Installed Oracle Collaboration suite on Linux AS 3.0. Configured Email, Web conferencing, Files, Voice Conferencing. Integrated with SSO and Oracle applications
• Strong experience in functional and technical knowledge of oracle SOA
• Well experienced in communicating with end users, Application, Application specialist, Superior Management levels of hierarchy.
• Responsible for day to day Production issues.
• Installed and configured Oracle e-business suite 11i
• Troubleshooting and resolved any r FA module.
• Setup and Handle Confidential Gateway setup and involved in inbound and outbound.
• Setup Oracle Fusion ADF and OBIEE, development like menus, toolbars and creating Template
• Setup and installed SOA suit which involved toplinks, oc4j contains
• Setup and Handle weblogic administration task and configure security.
• Setup and Handle ESB design and define the services.
• Setup and validation in ESB and BPM. process
• Handled the Oracle portal setup and installation and development
• Installed Oracle portal and integrate oracle portal with oracle EBS R12
• Integrated Oracle portal SOA suite component, register portal with Oracle OID IM'
• Handled the oracle portal development including portalet pages.
• Setup and configured the orace internet directory setup and oracle portal development.
• Though knowledge and understanding of Oracle Identity Management:
• Understanding about various components of Identity Management.
• Installed Configure & Maintain Oracle Application Server 10g Infrastructure and Middle Tier components.
• Configured the Oracle Identity Management Products. Oracle Internet Directory and its usage.
• Through of Knowledge about Reconciliation and provisioning, Oracle Identity Manager connectors. Customizing the Design Console, Administrative and User Console.Oracle Access Manager 10.1.4
• Installed & Configured Oracle Access Manager and its components like Identity Server, Webpass, etc.
• Integration of AS Infrastructure with Oracle E-Business applications 11i, R12 for Single Sign-On Functionality, maintaining the User’s, through DAS.
• Usage of ldap utilities like ldapsearch, bulkload, etc to manager day-to-day OID functions
• Integrated OID with third party LDAP Directory like Active Directory, etc.
• Bootstrap the AD users to the Oracle OID using dipassistant Configure External Authentication using dipassistant.
• Handled the oracle application manager task for integration.
• Clone 10giAS with four Node cluster, Apply patches on 10g Application servers as part of any bugfixes.
• Upgrade of 10g Application Servers Assume responsibility of all trouble tickets assigned to the DBA via the ticket tracking system and track all progress on the issue and details regarding the resolution in the system
• Configured and Testing of oracle fusion and BPEL
• Involved in BAM integration. And Confidential Designing, fusion intelligence
• Handled the OBIEE Development in Fusion intelligence.
• Involved in Business intelligence development.
• Manager the Confidential Process Management and Validation of ADF Form
• Handled setup in WSM and involved in report development of WSM
• Handled the discoverer administration task installation and export and import of EUL
• Designed and developed complete applications using Oracle Forms; design GUI and implement interfaces with production database and other Forms using Forms 6/6i/9i; familiar with all aspects of designing complete data-driven interfaces in Oracle Forms.
• Designed application interfaces, installation, migration and custom scripts using PL/SQL Developer and SQL*Plus; create and modify existing stored packages, procedures and functions.
• Developed PL/SQL web interfaces using both Oracle HTP methods and Web Forms to display and interact with live production data.
• Maintained and improved existing applications, repair and enhance customer defects
• Created new applications from the ground-up based on customer and business requirements and objectives.
• Unit and release testing performed on all modified modules.
• Combined use of PL/SQL with HTML & JavaScript to create dynamic and crisp web application against Oracle database
• Migrated forms 6i/9i to new oracle meta-fusion FMW111g
• Migrated all application and database servers to AIX 5.1 and RedHat AS 3.0 Linux running Oracle 10gRAC and 10g Application servers. Linux servers running OCFS 2.1 and Redhat Advanced server 4.1 and 5.0.
• Installed a split-architecture configuration of Oracle Applications 11i using HP PA-RISC as the application server tier and HP-Itanium for the database tier.
• Utilized Veritas DBAC software to manage raw partitions and clustering on database tuning of eBusiness suite using Quest spotlight and working with Quest STATs tool for Oracle statspack.
• Setup standby database and RMan backup database on AIX platforms. Several Installations of Oracle RAC on Linux using SAN and EMC disk arrays. Also setup demo's using firewire shared cluster.
• Ported several Sybase AS12.5 database servers to Oracle 9i RAC, ported stored procedures, java stored procedures, XML code.

Confidential

Sr Oracle Appsdba Consultant

Responsibilities:

• Upgrade Major Oracle 11.5.10 multi-tier application to R12CU4. Migrated database to Oracle 10.2.3, upgraded all custom code and configure for 10G ASM RAC with dataguard and TAF.
• Provided mentoring, schedules and performance monitoring.
• Installed Oracle 11.5.10.2 and R12 on Linux, AIX, Windows 2003 Server, HP-UX and Solaris - Multi-tier split 10GR2 RAC clustered environment using GPFS, OCFS2, Sun Cluster 3.0 ASM, utilizing PCP and FAL.
• Setup San, installed and configured ASM disk array layout. Designed cloning strategies for 10 different tier environments. Provide Grid monitoring for Environment.
• Migrated existing Rac databases from Veritas cluster server to ASM.
• Migrated multiple Clients from AIX, Solaris, Windows, HP-UX, Linux to different platforms with Oracle 11i, R12, 10g, 9i, 11g.
• Performed several re-implementations of fresh install of E-Business Suite.
• Oracle 10g and Oracle 11g 4 node Windows 2003 Rac. Install and setup san, ASM disks, used Mercury load runner to test performance.
• Oracle 11g Rac installation on Linux - 10 node to test new features. Upgraded several 10g Rac clustered databases to 11g Implemented Sox and Oracle.
• Migrated over 150 Oracle 8i, 9i databases from Aix, Solaris, Hp-UX to Oracle 10g on Linux, Aix, Solaris, HP-UX and Windows.
• Migrated Split architecture of HP-PA Risc and HP-Titanium to Linux 32 and 64 bit with RAC and ASM on 64 BIT Tier.
• Configured Service Guard on HP and Veritas Cluster server on AIX.
• Workflow and Confidential configuration of legacy database feeds utilizing SOA technologies.
• Workflow Mailer configuration and automation.
• Installed and Configured Oracle RAC on Windows 2003 Server - 4 node cluster with ocfs2 and ASM. Upgraded 9i on Windows 2003 to 10g RAC.
• Install & Configure Oracle Access Manager and its components like Identity Server, Webpass, etc.
• Integration of Oracle E-Business Applications with Oracle Access Manager.
• Integrated Oracle Access Manager with Oracle Single Sign On Server
• Configured the Logout URL Oracle Role Manager:
• Installed, Configured, and Launched Oracle Role Manager
• Created an Approver Role in Oracle Role Manager
• Created and Edited a Business Role in Oracle Role Manager
• Created a Location-Based Policy for a Business Role
• Integrated Oracle Role Manager and Oracle Identity Manage Oracle Virtual Directory 10.1.4
• Installation of various components of Virtual Directory & Maintenance.
• Installed and configured Discoverer 10g with SSO. Upgraded existing EUL from Discoverer 4i.
• Set up Oracle R12 across VMWare environment. Configured Operating System, provided tuning and load balancing techniques for VMWare.
• Configured High Availability with Dataguard and setup RMAN for backups.
• Provided Client with Security Best practices for Oracle 10g. This included securing access to default accounts, securing the network using encryption, using Single Sign On (SSO), enabling database auditing, enable FGA for user access to the database.
• Document all security practices and create daily management reports.
• Installed and configured multi-tier Oracle Collaboration Suite 10g, 3 nodes install on Linux and Aix. Setup Oracle Files, Web Conferencing, SSO, integration with e-Business.
• Automatic startup and shutdown with RMAN backup - RAC backend on Store and mid tier.

Confidential

Sr. Oracle Appsdba Consultant

Responsibilities:

• Installed R12 in multi -tier environment, with 32 bit Linux OS.
• Oracle R12 experience Oracle Database and Fusion Middleware Fusion
• Installed OID and LDap 10g database integrated oracle portal with R12 E-Business suite.
• Installed Oracle 11.5.10.2 and R12 on Linux, in Multi-tier split 10GR2 RAC clustered environment using GPFS, OCFS2, S, utilizing PCP and FAL.
• Installed 10gAS infrastructure on two node RAC with 10gR2 metadata database for High Availability and Local Failover
• Multi Master Replication with Application/ Data guard for Disaster Recovery.
• High Availability and Disaster Recovery Design for 10gAS Single Sign on solution for E-Biz and 3rd Party Applications.
• Overall system Architect to integrate RAC Database with SSO and E-Business suite Applications. Using tools like Quest STATs tool for Oracle
• Oracle Cluster ware or OCFS2, RAC Software and ASM software.
• Configured SSH, AS M or Raw Device, setup OCR and Voting Disk.
• If ASM Configuration setup ASMLIB ASM Management.
• If Raw Device, configure OCR, Voting Disk and Spfile.
• Setup San, installed and configured ASM disk array layout.
• Designed cloning strategies for 6 different tier environments.
• Provided Grid monitoring for Environment. Linux 32 and 64 bit with RAC and ASM on 64 BIT Tier. Configured Service Guard.
• Installed Oracle R12 on Linux 32 and 64 bit for testing purposes.
• Installed and Configured Oracle RAC on Linux Server with 6 node cluster with ocfs2 and ASM.
• Installed and configured Discoverer 10g with SSO. Upgraded existing EUL from Discoverer 4i.
• Installed Collaboration Suite 10g. Setup Oracle Web conferencing, Email, SSO, 10g Rac database.
• Configured High Availability with Dataguard and setup RMAN for backups.
• Upgrade Collaboration Suite 9 to Collaboration Suite 10g. Setup ldap integrator between OID and Oracle e-business.
• Installed Configured & Maintain Oracle Application Server 10g Infrastructure and Middle Tier components.
• Configured the Oracle Identity Management Products. Start and Stop of OIM Components in AS Infrastructure.
• Integration of AS Infrastructure with Oracle E-Business Applications 11i, R12 for Single Sign-On Functionality.
• Maintained the User’s, through DAS. Usage of ldap utilities like ldapsearch, bulkload, etc.
• Integrated OID with third party LDAP Directory like Active Directory, etc.
• Provided Client with Security Best practices for Oracle 10g. This included securing access to default accounts, securing the network using encryption, using Single Sign On (SSO), enabling database auditing, enable FGA for user access to the database.
• Documented all security practices and create daily management’s reports.
• Installed and configured multi-tier Oracle Collaboration Suite 10g, 3 nodes install on Linux Setup Oracle Files, Web Conferencing, SSO, integration with E-Business. Automatic startup and shutdown with RMAN backup
• Configured and setup Confidential for third party database on test environment

Confidential

Oracle Applications / DBA

Responsibilities:

• Oracle Apps 11.5.10.2 (CU2) Upgrade from Apps 11.5.9 to 11.5.10.2 using 10g RAC on Solaris (64-bit). 98 servers and 400 sub server Affiliated project.
• Responsible for Day to Day operations, analysis of current architecture/Procedures and making recommendations for a system that hosts a Database larger than 2Terabytes in size, and provides Data access to various agencies using various middleware including See Beyond/ Autosys / Load Balancer and XML, BC4J, J2EE OC4J BI Forms and OC4J Portal
• Configured and maintained 30 custom containers with Load Balancer and web cache SL (http/https/socket) ldap directing traffic to the 11i applications.
• Maintained and monitored the HHTPS Apache, OPMN, Discoverer and Documentum in each of the containers.
• Configured two Node RAC to support the 2T size database and run concurrent queues in a distributed environment. RMAN is the main tool for backups.
• Responsibilities also include Cloning and Patching and Security analysis. Mercury Kintana is used to simplify the Patching process and Save time. Applying builds / CR are day to day activities.
• Analysis of CPU updates effects of RUP3 and RUP4 are also part of duties. Data guard/ Stand by database were implemented as a High availability Solution.
• Responsibilities also include CPU analysis and monitoring the Batch processing and tuning the Entire system in general and performing Health checks. Day-to-day provisioning of end user accounts per Confidential procedures and policies.
• Assured the Oracle E-Business application operates effectively during the course of the business day, especially during critical windows such as security update
• Maintained and managed daily processing schedules through the Oracle Concurrent Manager.
• Migrated source code through Confidential Application, maintaining Oracle 11i Change Control processes established by Confidential compliance.
• Migration of responsibilities, value sets, menus, report groups, etc via established policy or automated tools.
• Execution of scripts within the Oracle Applications operating environments.
• Performed E-Business module setups for new business Operating Units.
• Coordinated database environment refreshes from productions instance.
• Provided support in the daily administration for tester, monitoring tools deployed within the Oracle Applications environment.
• Provided support in the daily administration of the Oracle Discoverer reporting application.
• Designed and configured application development systems, including the applications change management processes
• Responsible for administration of Oracle applications, including base definition, structures, documentation, upgrades, long-range requirements, operational guidelines, and protection.
• Establishes and maintains security integrity controls. Formulates and monitors policies, procedures, and standards.
• Responsibilities include troubleshooting, recovery, software installation, resolving Oracle errors and failures, auditing activities, and resource utilization.
• Set up and Installed Oracle Web Application Server Setting and Installing Oracle Enterprise Manager 10.1 and Enterprise Backup Utility.
• Configuration of Oracle OEM (Oracle Enterprise Manager) to monitor database and report on events as defined by the DBA group.
• Created custom Statspack scripts and implementation documentation for corporate wide roll out to all databases for Confidential and Confidential project.

Confidential

Contract Consultant

Responsibilities:

• Designed and installed HTMLDB 6.0 with integrated with oracle 10gAS.
• Upgraded the 9i database to 10g Rel2 database.
• Daily production and QA maintained, architecture, performance tuning.
• Installed Maximo application and database.
• Supported an implementation of Oracle Applications 11i through GO-LIVE and production support.
• 11i modules, (AD) Application Developer, (APS) Advanced Planning and Scheduling, OPA, Concurrent.
• Worked independently providing hardware, software, application, and limited network support for production and non-production Linux servers. This includes, but is not limited to, acting as technical lead on a project.
• Performed investigation and analysis to solve problems; server configuration; designing server topology.
• Recommend policies on system use and services.
• Performed analysis to tune systems; and providing training and guidance to junior technical staff.
• Designed and implementation of large scale UNIX and Linux deployments.
• Managed, maintained and supported a large number of medium to enterprise class systems according to existing procedures by utilizing in-house and standard UNIX tools.
• Oracle E-Business suite 11.5.10 Installed in AIX 5.3TL platform using RapidWiz installer; Shared File system/Application Architecture; Application Teckstack components and 10g Database RAC clusterware installed in Multi-(3)node .
• Automatic Storage Management configured to work with RAC.
• Post implementation support such as Tuning and troubleshooting RAC database and cluster ware issues
• Closely worked with Storage/Network and System administrator during Design/Install and troubleshooting
• Installed and configured for Multi-Language support; there are 13 Languages enabled for various part of the Globe
• HW Loadbalancer F5 configured with 2 Apps Nodes internal and 2 Apps Nodes External Access
• Lessee Self-service External Application Configured with DMZ for Internet user for Customer self-service Access
• Interface with several Third party Applications such as Employee Background Test (HireRight) and ResumeMirror-Resume parsing external web application.
• Single sign-on integration with 10gAS and enabled bi-directional synch.
• Other DBA activities such as Patching, Cloning and Backup-Restore, troubleshoot developer and users day to day issues including Jinitiator, performance, security and login;
• Monitored database growth; collect data to identify database & system level performance issues; performance tuning; Scheduled concurrent program to purge audit and requests related tables and files; Automated shell/Perl scripts to backup, startup & shutdown, purge archive logs and alert DBA about space related issues
• Server level and Database level Tuning also assisted developers to tune their program code

Confidential

Oracle Contract Consultant

Responsibilities:

• Implementations oracle Applications 11i, 11.5.9/ 11.5.10 Architecture
• Installed and Upgrades EBS 11.5.9 to 11.5.10, with MRP Module.
• Integrated the EBS with SSL and SSO Single sign-on integration with 10gAS and enabled bi-directional synch.)
• Setup and enable oracle workflow and discover and the upgrade
• Supported an implementation of Oracle Applications 11i through GO-LIVE and production support.
• 11i modules, (AD) Application Developer, (APS) Advanced Planning and Scheduling, MRP, Concurrent Manager, Work Flow, Discoverer.
• Implementations of Oracle 9i application server 9i Forms Reports, Apache Web servers - configuring and tuning cache web servers.
• Upgrade 8i(8.1.7.4) to 9i(9.2.0.5 and 9.2.0.7) 9iAS with grid control, oracle application manager in Oracle 9i AS, 10g, and RAC, Apache/Java environment and oracle enterprise manager, configure oracle repository with web Agent.
• Plans and coordinates application/tools changes, installation of upgrades, patches and new versions, interacting with Systems DBA and Infrastructure teams.
• Implementations new Java and Oracle Application Framework 5.9, and OC4J, J2EE.
• Multi-node implementation experience; applying patches, cloning, trouble-shooting concurrent managers, and trouble-shooting forms/reports issues, configuring load-balancing.
• Identified and resolved performance issues with Oracle Applications technology stack.
• Supported the development team for functional enhancements, trouble shooting and resolution.
• Assisted the Test and Infrastructure team to resolve any cross functional issues.
• Testing plans, in coordination with the development team and end users.
• Experienced with 3rd party s/w tools TOAD, Clear Case, Kantian.
• Determined system data management requirements, implements supporting databases and monitors performance.
• An expert on all the typical Oracle Apps DBA related functions performance tuning, experience in a 24x7 environment.
• Oracle 11.5.4 to 11.5.8/9iAS production level experience in a scalable and fault tolerant environment.
• Configured and implemented 9RAC Real application Cluster Guard.
• Installed RAC 10g real application cluster.
• Set up the configuration files.

Confidential

Oracle Consultant

Responsibilities:

• Migrated Oracle Federal HRMS Applications 11i from 10.7 to 11.5.4
• Installed and integrated 9ias (1.0.1.2) with 11.5.4 in IBM rs600 system upgrade the form-server to 6.1.0.8 with oracle report.
• Upgrade 11.5.4 to 11.5.9 and setup all environments to auto configure.
• Upgrade 8.1.7 to 8.1.7.4. Configure and install all oracle rdbms.
• Daily maintenance of the database and applications.
• Helped functional analysts resolve major issue, setup print server.