EXPERIENCE SUMMARY:

• Over 7 years of experience as Oracle Database Administrator and Apps DBA (11i - 11.5.10., 11.5.10.1.11.5.10.2 and R12.0.4,12.1.1,12.1.3) with diversified experience in N-Tier and Client-Server Architecture using Oracle (9i 10g and 11g) on multiple OS platforms in Production, Development and Data Warehousing Environment.
• Over 7 years of experience with Oracle products as Oracle APPS DBA (R12 /11i) and Oracle DBA (9i/10g/11g).
• Expertise in Installation, Upgrade & Performance tuning of Oracle Applications 11i/R12.
• Experience in full lifecycle implementations of client/server, Database application project analysis, business analysis, development as well as traditional software development methodologies.
• OracleApplication Server 10.1.2 and Oracle applications 10.1.3 Administration
• Expertise in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN.
• Expertise in applying Maintenance packs, Cumulative updates, Interoperability patches & Family packs using adpatch
• Oracle Application upgrade from 11.5.10.2 to 12.1.1 and 12.1.3.
• Oracle applications Database migration from HP-UX to Oracle Linux 6 using Transportable table space
• Experience in Oracle EBS 12.1.3 Family and EOY patching
• Implemented Oracle Golden gate 11g
• Oracle applications maintenance and monitoring using OAM
• Experience with Patch wizard and admrgpch tools
• Worked on Unidirectional and Bi-Directional Replication Topologies
• Troubleshooting Golden Gate issues like Abends And Error 509
• Web Logic Server Code deployments/promotions, performance monitoring and performance tuning
• Hands-on Oracle SOA Suite 11g product knowledge
• WebLogic Administration, Monitoring and Troubleshooting using Admin Console and JMX.
• Cloning Oracle 11i Instance using Rapid clone and manual cloning.
• As an Oracle DBA (11g, 10g, 9i) expertise in Installation, Performance tuning, Backup and Recovery.
• Expertise in SQL query tuning and database tuning using ADDM, AWR and Explain Plan.
• Also worked on SQL tuning advisor using Grid control.
• Experience in integrating oracle apps 12.1.3 with 11g OAM.
• Experience in integrating oracle apps with oracle Internet Directory (OID) and in configuring i-modules.
• Patch wizard and Patch analyzer(PAA)
• Managing Oracle application using Oracle Application Manager (OAM)
• Involved in Configuring & Managing Standby Databases (Data Guard)
• Experience in configuring SSL for oracle apps R12, 11i.
• Hot and cold Backup and recovery of Oracle 10g/11g database using tools like RMAN( Recovery Manager), Flashback
• Install/clone Oracle SOA Suite including cluster and non-cluster configurations
• Monitoring the environments from OAM.
• Cloning of database for development teams, import and export of data.
• Configuration and managing of Oracle 11g RAC (Real Application Cluster) and CRS (Cluster Ready Service).
• Managing and configuring ASM (Automatic Storage Management) file system
• Good practice in creating function, procedure, package, and trigger.
• Proactive monitoring and performance tuning of production databases using Oracle Enterprise Manager (OEM) and scripts.
• Setting up Standby Database/Data Guard to protect against failures. Configured the Standby Database in such a way that the database is kept synchronized with the Production Database by regularly transferring archived log files from the Production Server to the Standby Database Server.
• Expertise in performance tuning of large databases and SQL/PLSQL programs.
• Hands on experience in situations where on-call 24 x 7 support for mission critical databases and Production support required.

TECHNICAL SKILLS:

Operating Systems: HP UX, Linux, UNIX, Windows2008R2/2005

Databases: ORACLE 9i/10g/11g,/12c Real Application Clusters (RAC 10g/11g), SQL Server 2008R2/2012

Applications: Oracle E: Business Suite R12(12.0.4,12.1.1,12.1.3)/11i(11.5.10,11,5,10,1,11,5,10,2), Oracle Financials (AP, AR, GL, FA), Web ADI (Application Desktop Integrator).

Application Server: Oracle Application Server (9iAS 1.0.2.2) /10gAS/Web Logic server 10g and 11g

Tools: SQL PLUS, SQL*Loader,SQL*Report writer, Export & Import utility, Data Pump, RMAN, Data Guard 9i/10g,TOAD, Statspack, Opatch, Oracle Diagnostics Pack, Discoverer, SQL navigator, AD Utilities, Oracle reports, OAM(Oracle Applications Manager),MS Office, Data Guard &OEM.(Oracle Enterprise Manager)

Languages: SQL, PLSQL, HTML, Perl &Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Gaithersburg, MD

Sr. Oracle Application DBA

Responsibilities:

• Successfully upgraded 11.5.10.2 to R12.1.1 to 12.1.3 with 10.2.0.3 to Oracle 11.2.0.3. Maintaining production, development & test databases and applications.
• Successfully integrated oracle apps 12.1.3 with 11g oracle application manager.
• Converted single instance e-business database to Oracle 11g RAC
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle RAC.
• Applied patches using ADPATCH, ADCTRL utilities.
• AUTOCONFIG customization in the Apps environment and used ADCONFIG, ADBLDXML commands.
• Parallel Concurrent Processing(PCP), SHARED APPLTOP
• GL, AP, AR, OTL, HRMS Family packs and End of year patching.
• Applications/Database Cloning & Refresh using RAPIDCLONE
• Installing Oracle Golden Gate for EBS Reporting Databases
• Oracle and SQL server Database Capture using Oracle Golden Gate 11g
• Data Extract, Conversion and Load using Golden Gate
• Configuring Replicate Parameters ASSUMETARGETDEF, REPOR, DISCARDFILE
• Creating GLOBALS for Golden Gate and Adding database Checking points
• Upgraded Oracle Applications database 9.2.0.4 to 10g (10.2.0.4) on Solaris.
• Web Logic servers development, testing, applying patch and service packs
• Administer middle tier Oracle SOA, Oracle HTTP server
• Administration of Oracle ERP applications version 11.5.10.2 and R12
• Good Knowledge in Data Modeling tools like Erwin & Oracle Financial Analyzer.
• Implemented AUTOCONFIG in the Apps environment and used ADCONFIG, ADBLDXML commands.
• Experience on various modules such as Financials, MFG, CRM, AR, AP, GL, PO, HRMS and INV.
• Conducted pre patch analysis for the patching of the Oracle E-Business Suite 11i.
• Applied the HRMS RUP 3 patch and OracleHRMSQ1-2009 SQWLpatches to development and production environments.
• Upgrading Oracle Golden gate 11.1.1.0 to 11.2.1.0.1
• 24*7 on-call production support for high-availability web-based application running Oracle9i RAC on HP-UX cluster with EMC SAN.
• Involved in developing a disaster recovery (DR) plan.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Configuration of Workflow Notification Mailer, OAM, OEM10g.
• Applying Oracle Applications patches Maintenance Pack, Interoperability patch, Family packs, CPU patches, Patch Sets.
• Oracle Applications Systems Administration.
• Planning and Administration of backup and recovery strategies & configuring backups using RMAN & hot and cold backups using Net App snapshots.

Environment: Oracle Apps R12.1.3/11i (11.5.10, 11.5.10.2), Oracle /10g RAC¸ HP-UX &Windows, Linux, OEM, Oracle Golden Gate 11g(11.2.1.0 and 11.1.1.), SQL Loader, Toad, Oracle Discoverer

Confidential, Basking Ridge, NJ

Sr. Oracle Applications DBA

Responsibilities:

• Install and maintain Oracle Applications in complex environments such as Single-node and multi-node installations on SOLARIS 8 and LINUX AS 5.0.
• Upgrade of Applications from 11.5.8 to 11.5.9 on test servers on SOLARIS 8 system.
• Applying latest releases of the patches using utilities ADPATCH and ADCTRL.
• Cloning instances from production to Test, Development instance to test with Rapid Clone and Autoconfig.
• Upgrading Oracle Golden gate 10.4.1.0 to 11.1.1.0.0
• Oracle and SQL server Database Capture using Oracle Golden Gate 11g
• Data Extract, Conversion and Load using Golden Gate
• DDL replication
• Filter DDL Operations
• Good understanding of Golden gate Manager commands i.e NFO,SEND,START,STATUS,STOP
• Develop and maintain UNIX shell scripts to manage the Oracle Database and ERP Application environments. The major product modules include FND, AR, AP, PO, FA, GL and HR
• Involved in Database Backup strategies & recovery scenarios and implemented Backups using RMAN.
• Involved in time-to-time troubleshooting Oracle Databases.
• Monitoring user sessions, maintaining, administrating and troubleshooting database issues for OLTP -Oracle databases on Solaris and Red hat Linux.
• SUN SOLARIS and Windows Administration activities like USER Management, Oracle APPS File System Management, Mounting the hardware devices etc.
• Applying latest releases of the RDBMS patches from Oracle to the Production and test instance to resolve few technical challenges & issues.
• Configured Data Guard Broker between the primary and standby databases
• Transferring the bulk data from text file into Oracle Database using SQL * Loader and export & Import utility for backup purpose and distributing the tables in multiple environments.
• Monitoring and troubleshooting concurrent manager jobs, manage system profile setups, Troubleshooting printer set-ups and other SYSADMIN responsibilities.
• Installation, configuration, creation of end user layer (EUL), maintenance and troubleshooting of Oracle Discoverer 10g.
• Generated Position Management Reports which involves HR, PSB and GL Modules.
• Configured Business intelligence Oracle Applications 11i, and administering End User Layer.
• Generated Custom workbooks for Public Sector Budgeting using Oracle discoverer.
• Configured Discoverer Custom workbooks on Oracle Self Service Portal
• Installed and configured Single Sign-On and Implemented SSL Security.
• Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning to users.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user.
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP.
• Oracle OID/SSL/Single Sign-on Implementation and Support.
• Oracle Data Guard Implementation for HA and remote DR site.
• Performance tuning of Oracle Database, applications and queries.
• Installation & Integration of Demantra with ASCP environment

Environment: Unix/Linux, Oracle Database 10g (10.2.0.4), Oracle Applications 11i (11.5.10.2), TOAD, SQL Loader, AD Utilities. Oracle Discoverer 10g, Oracle Golden Gate 11g (11.1.1.0 and 10.4.1.)

Confidential, Reno, NV

Oracle Apps DBA

Responsibilities:

• Successfully upgraded Oracle Applications Database from 10.2.0.2 to 10.2.0.4
• Worked closely with technical, functional teams and Oracle Support to troubleshoot and resolve issues during upgrade.
• Performed maintenance tasks like Purging Concurrent manager log files, Gather schema statistics, Purging Workflow Obsolete Runtime Data.
• 24*7 on-call production support handling weekday, weekend, nighttime, and holiday outages with focused effort to minimize downtime.
• Implemented and supported AP, GL, AR, PO, HRMS modules.
• Worked with HR RUP3 patch to development and production environments.
• System Administration responsibilities include application security, scheduling work shifts, registering new concurrent programs / request Sets.
• Participated in a team to maintain and support Oracle Applications in 24 X 7 environments.
• Researched and resolved JInitiator performance issues and suggested migration to Sun JDK.
• Critical patch update/oracle support (TAR)/ application patching activity/Application bug fix as suggested by oracle support.
• Upgraded JInitiator and other technology stack components in development environment.
• Cloning of database and application environments using Rapid Clone and other cloning options to create an in house instance for internal research and development.
• Performance Monitoring, Space Monitoring / Capacity planning, concurrent manager tuning.
• Configured Workflow Notification Mailer for inbound and outbound processing
• Conduct Pre-patch analysis for different types of patches as requested by customer.
• Responding to different types of alerts automation using oracle alerts.
• Troubleshooting / resolving issues with concurrent managers
• Troubleshooting of Oracle Self Service Web Applications, Jserv Debugging.
• Applied Oracle Projects Maintenance pack to Development environments.
• Worked with technical, functional teams and Oracle Support to troubleshoot and resolve issues.
• Performing pre and post health checkups of oracle 11i applications.
• Researched and documented available options to create a DB Link between oracle and SQL Development databases to rewrite the existing interface.

Environment: Oracle Apps 11i, Oracle RAC 10g, HP-UX, HRMS, TOAD, SQL Loader, AD Utilities, EOY Phase1 and Phase2, KBACE

Confidential, NY

Oracle Apps DBA

Responsibilities:

• Installed and maintained oracle applications 11i.
• Cloning of Oracle EBS from different environments like Dev, Test, QA and Project instances.
• Applied additional one of patches to stabilize the environment.
• Applied patches using ADPATCH, ADCTRL utilities.
• Performed number of SYSADMIN functions including Oracle Applications System administration, Created user and attached responsibility to these users, Registered new applications, Monitored user activity, Defined Data groups, Request groups, Menus, Alerts, Workflow, Profiles, Printer installation, Flex fields etc.
• Monitoring the environments from OAM.
• RMAN Cloning
• Implementing OTL and Applied RUP4 patches
• Maintaining and monitoring daily backups.
• Using AD Administration and other AD Utilities
• Data and Transaction analysis using Log Miner
• Patch Management
• Autoconfig configuration
• Database and Application cloning.
• Monitoring and handling Concurrent Managers related issues.
• Assigning the Program to Concurrent Manager (scheduling)
• Interacted with Functional & Technical experts, system administrators, security analysts and other members of the project team to ensure optimum operation of the database.
• Performance turning of PLSQL programs and Oracle reports.
• 24X7 support for databases and production operations teams.

Environment: Oracle E-Business suite 11.5.10, Oracle 9i and 10g, HP-UX and windows, Toad, SQL Loaded, Rman, Adrelink, Adadmin, Adpatch

Confidential

Oracle DBA/Oracle Apps DBA

Responsabilites:

• Working closely with functional and development teams, involved in migrating of data from legacy system
• Configuring the Printer (Style, Driver, Type) compatible to the reports
• Applying Patches/Patch sets/Mini-packs on both the database and application tiers using adpatch
• Monitoring the Database Growth and providing proactive Space Management for database of 50+ GB
• Designing the Backup Strategy, Testing Strategy, Taking Backup (Cold/Hot), Maintaining Backup and Archived files on tapes and Restoring / Recovering the database as and when required
• Configuring the Production Database to be in ARCHIVELOG Mode with mirrored Control, Redo Log files
• Developed Shell Scripts to run the Batch jobs
• Refreshing the Development and Test instances (in NOARCHIVELOG Mode) with Production
• Data stage Administration and Support
• Validate / Schedule / Run / Monitor Jobs using Datastage Scheduler.
• Support approximately 100 users on Oracle Applications
• Cloning Oracle 11i Instance for development and testing purpose.
• Troubleshoot and resolve issues related to Oracle Applications includes Apache Server, Forms Server, Concurrent Managers, Reports, Database.
• Create and maintain custom responsibilities and menus.
• Designed and maintained schemas involving creating tables and indexes with scripts,
• Creating triggers, and creating procedures.
• Used the oracle NET8 Configuration Assistant to establish network sessions between client and server machines using host names and local names methods. (Configuration of TNSNAMES.ORA and LISTENER.ORA).
• Responsible for troubleshooting of the connectivity problems for end- users by configuring tnsnames.ora, listener.ora and sqlnet.ora files.
• Allocating system storage and planning future storage requirements for the database system.
• Maintain database security, user roles and access profiles, Involved in taking cold and hot backups.
• Daily monitoring and checking the Background Dump File (alert SID Logs) and User dump Files for errors.

Environment: Oracle Applications 11i, Oracle 9i, Linux, HP-Ux TOAD, Adadmin, FND Loader, Autoconfig, SQL loader, Replication

Confidential

Oracle DBA

Responsibilities:

• Installed and configured oracle 9i/10g databases. Involved in upgrading Database from9.2.0.8 to 10.2.0.1 using DBUA.
• Involved in PL/SQL Coding, Scripting.
• Worked with a team of IT developers and peer-peer meetings in the Initial Database Design/Data Modeling/Data approval.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase the Performance.
• Configured scripts to monitor activity with database.
• Responsible for optimizing the queries and application tuning.
• Implement Hot, Cold and Logical backup plans.
• Creating tables, indexes, views and synonyms depending upon the need
• Involved in Designing backup and recovery procedures for OLTP systems
• Testing PL/SQL procedures against the test cases. Involved in creating use cases and test cases
• Strong and extensive use of DDL and DML tools/ Maintained database schemas and dictionaries.
• Optimized INIT.ORA parameters like DB block size block buffers, shared pool.
• Netca Configuration for Clients Connection.
• Involved in Performance Tuning of SQL Queries.
• Creating and maintaining triggers, packages, functions and procedures.
• Created users and established the application security by creating roles.
• Used Indexes and Hints for fixing the performance issues.
• Troubleshooting the performance issues with the help of Explain plans.
• Importing/Exporting data from/to different databases using utilities like SQL*Loader.
• Used TOAD for faster application design and developments.
• Implement Hot, Cold and Logical backup plans using RMAN and Data pump tool
• Creating tables, indexes, views and synonyms depending upon the need
• Involved in Designing backup and recovery procedures for OLTP systems
• Testing PL/SQL procedures against the test cases. Involved in creating use cases and test cases
• Strong and extensive use of DDL and DML tools/ Maintained database schemas and dictionaries.

Environment: MS Server 2003R2, Red hat Linux 4, Oracle 9i/10g, RHEL 4, SQL developer, RMAN, DBCA, DBUA, TKPROF, SQL Trace, VMware, SQL, PL/SQL, Shell Scripting,SQL Load.