SUMMARY

• Over 18 years of consulting experience wif Oracle as a Database Administrator and Technical Architect on UNIX/Linux platform wif 10 years in Federal Space
• Over 16 years of experience working wif Oracle E - Business Suite 10.7, R11, R11i and R12 suite, Application Server 10g, OBIEE+, Oracle RAC and SOA infrastructure Architecture.
• Expertise includes Oracle Applications and Databases on UNIX platforms in ensuring Quality, Integrity and Availability of the Company’s data wifin Oracle Server.
• Experience wif many Installations, Configurations, Upgradations, Migrations, Administration and Patching of Oracle Applications and Oracle databases.
• Upgraded many large scale Oracle Applications from 11i to R12 and also 11.0.3 to 11i wif full set of application modules: Finance, Manufacturing, Order Management, Advance Supply Chain, Configurator, HR. Many Maintenance pack release upgrades wifin Oracle Applications 11i.
• Experience wif many OBIEE installations and configurations which include
• Informatica and DAC tools.
• Have an excellent understanding of OLAP, BI Architecture, Business Intelligence and Data Warehousing Concepts
• Extensive experience wif OBIEE Admin tools including Informatica tools and DAC.
• Experience working wif Weblogic Servers, WebCenter and GRC applications.
• Designed and Implemented SSL, load balancing solution for Oracle Applications11i. RAC setup, configuration, JDBC load balancing and PCP configurations for Oracle Applications.
• Routine Oracle Application Maintenance and configuration: autoconfig, clone, patching, technology stack upgrade, configuration management, and statistics for CBO.
• Upgraded databases to 11g from prior releases. Implemented HA solutions including RAC, Dataguard.
• Experience in Installations, configurations, Administration and patching of 10gAS, 9iAS and Oracle Web Application Servers.
• Proficiency includes Engineering and Architecture of Oracle, Resource and Security management, Tuning, Clustering, Backup and Recovery, RMAN scripts. Good Exposure to Oracle Database Architecture, Optimal Flexible Architecture (OFA).
• Developing standard DBA procedures and practices.
• Troubleshooting critical production issues in a complex application environment.
• Work in conjunction wif other IT, application development, and business groups to understand functionality, scalability, performance, security, and integration requirements from the database perspective.
• Design and Implemented Oracle Application Patching using PPM (HP Mercury Product). Experience wif Deployment using PPM Kintana.
• Knowledge in administration, management of Operating Systems like Sun Solaris 2.X, HP-Unix, IBM AIX and Windows NT 4.0

TECHINICAL SKILLS:

Hardware/OS: SunFire 15K, SunFire v880, EMC Symmetrix (8830, 8730) storage array, Sun E6800, Sun 6500, Sun Solaris (2.5.1, 2.6, 2.8), IBM AIX, WindowsNT, Windows XP

RDBMS: Oracle 11g, Oracle10g, Oracle 9i2, Oracle 8i, Oracle 8.0.x, Oracle 7.x

Application: Oracle Applications R12, 11i, OBIEE 10.1.3.4.1, 11.0.3, 10.7 NCA. Oracle Application Servers 10gAS, 9iAS, Oracle Web Application Server 3.x

Tools: Informatica 7.6.1, DAC 10.1.3.4.1, Kintana (Now Mercury ITG for patching), Precise In-depth for Oracle, TOAD, OEM, Manage Now, Remedy.

Exposure to: Oracle Portal, Oracle Internet Directory, SSO, OC4J, Wireless, Oracle 9iDS, Discoverer, GRC, CCG, AACG, Gelco, Appworx, Markview, Linux OS, Oracle Jdeveloper, Oracle Developer 2000 suite, OAM, Vertex, Noetix.

PROFESSIONAL EXPERIENCE

Confidential, MD

Responsibilities:

• As a Senior Apps DBA for dis R12 Design project upgraded E-Business suite test environment from 11.5.10.2 to 12.1.3.
• Documented upgrade steps and provided input on the Infrastructure road map document.
• Resolved and documented issues during the upgrade. Worked closely wif functional and other team members in troubleshooting and resolving issues.
• Cloned test instance and upgraded database from 10gR2 to 11gR2 (11.2.0.3) as part of support on existing 11i environment.
• Provided recommendations on upgrade process, architecture, reduction in downtime requirement for R12 Upgrade.
• As Senior Apps DBA under O&M support, provided day to day support including oncall support to R11i production and non production environments including third party tools like Sunflower, Prism, GRC, HP PPM and Markview.
• Project:HIGLAS (Healthcare Integrated General Ledger Accounting

Consultant

Environment: Oracle Databases 11g, 10g and 9i, Oracle R12 EBusiness Suite, Oracle 11i E-Business Suite, OBIEE 10.1.3.4.1, IBM AIX Servers.

Confidential

Responsibilities:

• Documented all upgrade steps on upgrade process.
• Worked closely wif functional resources developers and Unix SA’s on the upgrade.
• Upgraded many RAC databases to 11g wif ADG at CMS HIGLAS
• Performed many 11.5.10.2 application and 10g Upgrades on test instances and on production instance at HIGLAS.
• Documented the upgrade process and mentored junior DBA’s.
• Responsible for configuring PCP, JDBC, and server load balancing at HIGLAS.
• Actively involved in configuring and setup of 10g RAC and Dataguard at HIGLAS, upgraded to 11g RAC wif ADG.
• As a lead OBIEE DBA at HIGLAS performed many installations of OBIEE, Informatica and DAC on Windows and AIX 5.3. Configured Informatica and DAC for ETL, Installed and configured Mapviewer etc. Documented all the steps necessary for installation, configuration, pre and post ETL configurations. Worked closely wif performance team on reducing ETL load timings.
• Created and configured DAC and Informatica repositories.
• Integrated OBIEE wif E-Business Suite.
• Responsible for running ETL data loads.
• Worked on many performance related issues during ETL.
• Responsible for DAC configurations including creating Containers, Subject areas, scheduling ETL’s etc.
• Responsible for creating roles, responsibilities in Dashboards, RPD’s.
• Worked wif developers on designing and customization of rpd’s, customization/creation of new folders and mappings in Informatica. Creation of new custom subject areas and tasks in DAC.
• Responsible for promoting OBIEE code from dev to production environments. OBIEE code includes DB objects, export and import of Informatica and DAC repositories, web catalogs, Export and import of custom mappings etc.
• Worked on table partitioning, compression and tuning Datawarehouse databases.
• Designed and implemented automated scripts for weekly cloning production environment.
• Responsible for automating generation of reports for Dataguard status, Backup status, Alert log errors, Invalid objects,
• Responsible for installation of Oracle software products, database creations and upgrades.
• Regular activities include Administration, Configuration, Cloning, Analysis, and Patching of Oracle Applications 11i.
• Developed shell scripts to proactively monitor Oracle databases and application components.
• Participated in planning and implementation of off-site Disaster Recovery planning and testing.
• Monitor databases for performance and tune accordingly.
• Analyze and Apply critical database and application security patches (CPU) as recommended by Oracle Support.
• Open Service Requests (TAR’s) as required and work wif Oracle support for workarounds and resolutions.
• Clone Application and database to create new environments as required.
• Deploy builds/drops once created and approved. Build types include Common components, Performance monitoring, Extensions, Reports, Conversions, Inbound/Outbound Interfaces, Letters, Seebeyond components.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances.
• Created custom Statspack scripts.
• Created scripts for automatic periodic statistics gathering and reporting.
• Ensure databases adhere to corporate standards and policies.
• Implemented database auditing, data security and Remediate high risk violation in production environment.
• Work wif developers and change management team to ensure smooth life cycle progress from development through testing and production implementation.
• Responsible for Implementing Mercury ITG software for Oracle Application patching and change management.

Confidential

Consultant

Environment: Oracle Applications

Responsibilities:

• Database upgrade from 8.1.7.4 to 9.2.0.5. Used Maintenance Wizard tool for the upgrade.
• Captured steps and timings for dis first iteration which can be used as baseline for subsequent iterations.
• Evaluated upgrade steps and addressed issues during each category of the upgrade.
• Installed and configured Maintenance Wizard.
• Upgraded database from 8.1.7.4 32 bit to 9.2.0.6 64 bit. Applied critical security RDBMS and 9iAS patches.
• Upgraded JDK (1.4.2), Jinitiator (1.3.2). Applied Developer6i patchset 16.
• Cloned Environments to create Patch test, Dev, QA, VT.
• Implemented Load balancing, SSL

Confidential

Development QA

Responsibilities:

• Implemented Secured Socket Layer (SSL) in the 11i E-business applications suite to enable data encryption between the client and the middle-tier layer. dis was first implemented and tested in the lab and then promoted to production
• Configured the Apache server of the Oracle 11i E-business suite to take advantage of multiple Java Virtual Machines (JVM) to avoid overloading of fewer JVMs
• Upgraded the 11i Oracle RDBMS instance to 64-bit on Solaris 2.8. dis was done so dat the System Global Area (SGA) could be scaled up beyond the 3.2 GB boundary limit imposed by the 32-bit RDBMS. dis was also implemented as a pre-requisite task to implementing Quick me/O, ODM (Oracle Disk Manager) or RAW devices to allow these technologies to take advantage of the larger Oracle cache while providing efficient me/O. dis was first implemented and tested in the lab and then promoted to production
• Implemented character set conversion from USASCII7 to UTF8 (Unicode) in the Oracle 11i E-business applications suite. dis was done as a prerequisite to support “Multiple Language Support” (MLS) in the applications, as their were business requirements to support multiple foreign languages, including French, Spanish, Portuguese, etc. dis was first implemented and tested in the lab and then promoted to production.
• Configured Oracle 11i E-business applications suite wif AutoConfig
• Cloned environments to create patch test, development and QA environments
• Configured and enabled wireless feature of the E-business suite. Due to an inherent deficiency in the 9iAS release 1.0.2.2.2, a separate instance of 9iAS had to be installed and configured to enable the wireless functionality.
• Upgraded Oracle’s 11i E-business suite from 11.5.3 to 11.5.6. Followed the promote-to-production methodology where all supporting environments were first successfully upgraded prior to production.
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades.
• Designed, tested and documented a process to clone 11.5.x environments. dis process was designed at a time when no other supported cloning process was available from Oracle.
• Monitored and effectively tuned the 11i database instances by utilizing own scripts, Precise In-depth for Oracle and the StatsPack utilities.
• Installed Oracle applications 11i E-business suite using multi-node architecture.
• Upgraded Oracle’s 11i E-business suite from 11.5.6 to 11.5.9. Followed the promote-to-production methodology where all supporting environments were first successfully upgraded prior to production
• Upgraded production database to 9i2.
• Upgraded production database from 9204 to 9206.
• Implemented database auditing, data security and Remediate high risk violation in production environment, calculators as per SARBOX policy requirements.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Leveraged SSO and Portal in lab environment.
• Provided DBA support in many implementations including customer and item loads.
• Other activities like applying RDBMS patches, security patches, proactive monitoring of databases.
• Configured Discoverer.
• Involved in POC Implementation of Verities Clusters and Oracle RAC on SUN Sparc Solaris (64bit) Platform.
• Converted the existing single-tier 11.0.3 NCA installations to multi-tier.
• Implemented load-balancing in Oracle applications 11.0.3 by leveraging the “Cisco Local Director” switch technology.
• Upgraded Oracle applications 10.7 SC to 11.0.3 using the multi-tier architecture. Followed the promote-to-production methodology where all supporting environments were first successfully upgraded prior to production.
• Cloned environments to create patch test, development and QA environments
• Conducted multiple dry runs/test runs to gather timings for production upgrade.
• Installed Oracle applications 10.7 NCA
• Installed and configured Oracle web application server 4.x, 3.x
• Installed Oracle self service web applications 2.0.x

Confidential

Consultant

Environment:Oracle Applications 10.7, 11i

Responsibilities:

• Installed and deployed Oracle Application Release 11i.
• Upgrading GEMMS 4.10.6 to 4.10.10
• Upgrade GEMMS 4.10.10 to OPM11i
• Database Upgrade tasks and migrating Oracle 7.3.2 to 8i
• Run Autoupgrade
• Applied Mini Packs
• Applied High priority patches downloaded from Metalink
• Run SQL scripts for AP, OE update and PO import from the interface tables to Financials
• Applied OM patches downloaded from Metalink
• Data Migration from 4.10 database tables to new 11i database tables.
• Applied Maintenance Packs 11.5.1
• Installed and Configured Developer Server for Oracle Application 11i.
• Upgraded the Applications from 11.5.1 to 11.5.2.
• Installed and integrated Confidential (OPM) wif Oracle Applications 11i.
• Daily activities include administration, performance tuning and proactive monitoring of Oracle databases.
• Creation of scripts which register forms, functions, menus, responsibilities value sets, descriptive flex fields and concurrent programs.
• Scripts to generate forms and plls.
• Scripts to create interface tables.

Environment: Oracle APPLICATIONS 11.0/10.7,ORACLE 7.3.x/8.x, OAS

DEVELOPER SERVER

Confidential

Responsibilities:

• Installed and Configured Oracle Web Application Server for Oracle Application 11.0.
• Installed and Configured Developer Server for Oracle Application 11.0.
• Installed and deployed Oracle Application Release 11.0.
• Installed and integrated Confidential (OPM) wif Oracle Applications 11.0.
• Installed India Localization patches.
• Responsible for maintaining Oracle Applications Databases on both UNIX and NT platforms.
• Creating Oracle Apps localization release patches, dis involves UNIX and NT scripting.
• Responsible for maintaining sales demo databases at Oracle offices across India.
• Installation and configuration of Oracle Apps rel. 10.7 & 11.0.
• Creating replicas of client databases at localization support center.
• Installation of latest adds on products like CRM, OPM.
• Providing Support for various clients on installation and configuration issues of Oracle Applications and Localization Software.
• Installation, Configuration and Upgradation of 11i.
• Installation of Web Customer 3i, OPM, CRM at different Oracle offices in India.
• Creation of several UNIX and NT scripts/Patches for OPM and Apps Localization.
• Creation, Configuration and maintaining database for IMN, Peterson Publishing.
• Developed scripts for creating databases, tablespaces, rollback segments and users as per the specifications given by customers.
• Performed cold & hot (Physical) backups, logical backups of the database.
• Created and managed users, roles and database access. Creating primary database objects (tables, views, indexes) once application developers have designed an application.
• Developed Database triggers and Stored Procedures for populating and updating data into different tables on ORACLE 7.3/8.0 Database Management Systems. Developed scripts for exporting and importing database.
• Installation of ORACLE Web Application Server on Sun Solaris 2.5, Windows NT 4.0.
• Deployed forms on web application server for Peterson project.
• Developed scripts for exporting and importing database.