SUMMARY:

• Oracle DBA & Applications DBA with 7 years of experience in software industry and oracle applications administration in production, development and test environments.
• Good experience in Oracle E - Business patching, upgrading and Load balancing.
• 6 years of Oracle Application and Database Administration experience on variety of Database versions 7,8i, 9i,10g,11g on UNIX, Solaris, HP-UX, AIX, Linux, Windows NT 4.0/2000 with HRMS, (HR, Payroll), Financials(AP,AR,GL,FA), Order Management, Compensation, modules using Apps (11.5.8, 11.5.9, 11.5.10), Oracle Application Server 9iAS, Developer 2000 6i (Forms 6i and Reports 6i, Net8, Sql*Plus, PL/SQL, Stored Procedures, DB Triggers etc).
• 5+ yearsexperience in OracleDatabase Administration, Oracle Applications, Analysis, Design, Server Optimization Techniques, Production environment and Applications support.
• 5+ yearsexperience as 10g AS admin.
• Managed many Oracle Applications 11i financial modules: OM, PO, AP, AR, BOM, ASCP along with Oracle databases 9i, 10g &11g.
• 5 + yearsexperience inOracle E-Business Suiteimplementations and Upgrades from CRP, Development, and UAT to production as an Oracle Application DBA.
• Pre-patch analysis for the patches and document preparation with pre and post patch installation steps.
• Implemented Best Practices for Maintenance, Monitoring, Backup/Recovery, Growth Management, Contention Resolution, Defrag etc. scenarios for the various Environments
• Good experience and knowledge in Oracle Applications system administration such as Managing Concurrent Programs and Requests, Configuring Printers, Reports, Administering Concurrent Managers and Work
• Troubleshooting Login, Self Service Application, Concurrent Processing, Jinitiator and Network related issues.
• Installation and configuration of Single or multi node APPS Middle Architecture with Load Balancing.
• Good knowledge on oracle application 11i rapid installation.
• Worked on Oracle Real Application Testing (RAT) with Oracle Database 11g Enterprise Edition.
• Worked extensively with Oracle RDBMS; Comfortable with SQL, PL/SQL, and developing various database objects like Triggers, Stored procedures, Functions, Sequences, Views etc.
• Experienced working in the various phases of the software development life cycle (SDLC) using methodologies like Waterfall and Agile.
• Strong communication, motivational and presentation skills.
• Ability to multi-task and work independently.
• Highly motivated, results-oriented, self-driven IT professional; Good team player

TECHNICAL SKILLS:

ERP environment: Oracle Applications R12, 11.5.10.2, 11.5.9, 11.5.8, 11.5.7, 11.5.5, 11.5.2, 11.5.1. Forms 6.0, 4.5, 10g. Reports 6.0, 4.5, 9i, 10g.

Third Party tools: EMC TimeFider, SRDF (disk to disk mirroring), Shareplex (Object level replication) 3.2, 4.1, 5.2, 170 systems (Markview), Noetix, Veritas software, OID, Oracle Portal, Erwin and DBArtisan, SQL* Loader, VMware Workstation.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK

DB Management: TOAD 7.6/7.5, OEM 9.2/10G (10.1/10.2) Grid control (RAC), RAT.

Databases: Oracle 11.2, 11.1.0.6,10.2.0.4,10.2.0.3,10.2.0.2, 9.2.0.7, 9.2.05, 9.2.0.4, 8.1.7.4(32,64-bit)

Programming: Unix Shell Scripting PERL, Bourne, Korn, AWK-SED, PHP, JavaScript, SQL, PL/SQL, HTML, DHTMLC, C++, Java, FORTRAN 77/80.

Operating Systems: HP-UX 10.x/11.x, AIX 4.3.x/5.1/5.2,WINDOWS NT/2000/2003 Server, RED HAT LINUX 9/8/7.2/7.1/6.2 , RHEL 2.1/3.x/4.x, Sun Solaris 8/9/10, VMware ESX Server 3.0.x/3.5.0.

Hardware: SunFire 15K with 72 CPUs 144GB Memory, SunFire 6900 with 40 CPUs 80 GB Memory, E6900, IBM XSERIES 346 with 4 CPU’s 12GB Memory .

PROFESSIONAL WORK HISTORY:

Confidential, Southborough, MA

Oracle Application DBA

Environment: Oracle Applications 11.0.3/11i/R12, Oracle 8i/10g/11g, RHEL4.x/5.x, Solaris 10, OEM, TOAD.

Responsibilities:

• Providedoncall DBA supportfor Oracle Applications 11.0.3/11i/R12 and Oracle 10g/11g production, QA, DEV databases on RHEL and Solaris forOLTPandData warehouseEnvironments.
• Applied Baseline patches for the modules Configurator, Projects, Contracts, Sales.
• Applied RDBMS and Interoperation patches for upgrading the database from 10g to 11g.
• Performed the Pre Patch analysis and post patch support for the baseline patches.
• Upgraded the database and clusterware from 10.2.0.4 to 11.2.0.2.
• Installed 8 node VM cluster and configured the VIPs for the new SAP ERP instances.
• Backup and Recovery proceduresfor production, non- production databases usingRMANin conjunction with periodic Complete and Incremental Backups,BCV backups.
• Integrated the Backup Status Reporting for all the databases in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and Bash Shells.
• Troubleshoot the various issues related to the Configurator, Sales modules and Apache.
• Installed and upgraded the DNB Integration Manager application which is used by the Oracle 11i Application for creating new customers.
• Troubleshoot the various performance issues for the mission critical RQF project.
• Data Refresh/CloningOracle Applications from Production environment to setup Test/Development Environments.
• Performed capacity planning and reorganization of the various tablespace for efficient use of the storage.
• Tuning various queries using the HINTS or creating indexes.
• Writing various shell and Perl scripts for the database and application monitoring.
• Worked with Shareplex support for the various issues related to critical Reporting data based on Shareplex
• Replatform a large 8TB database from Solaris to Linux using the complex Transportable Tablespace and RMAN Convert

Confidential, Dallas, TX

Sr. Oracle DBA /Apps DBA

Responsibilities:

• Responsible for both creation and manage Production, Development, Unit and Test instances of Oracle Version 9.2.0.6,10g & Oracle Applications 11.5.10.2, R12.
• Installed Oracle Applications E-business suite 11.5.10.2 on sun Solaris 2.10 (Single node and Multi-node installation) and upgraded oracle applications E- Business suite 11.5.8 to R12 and 10gAS.
• Oracle Applications Upgrade from Oracle Applications(E-Business Suite) 11i (11.5.8¸11.5.9, 11.5.10) to R12/12i(12.0.4)
• Implemented maintenance plans, scheduled scripts for concurrent request details, table space growth, archive log monitoring and many other maintenance activities.
• Experience in writing UNIX shell scripts for automating daily, weekly and monthly activities, experienced in developing exhaustive documentation for all activities performed.
• Experience in taking Export, Import and Loading data using SQL*Loader, Punchout and Bulk Loader.
• Used Oracle Application maintenance utilities like adadmin, adpatch, adctrl and adrelink etc.
• To Review the team members weekly status reports, preparing Customers Monthly status Report.
• Database health check, pinning of objects, Monitoring the Database Growth and increasing the tablespace sizes, Reorg of Tablespaces, Identifying and Recompiling invalid schema objects and Building Schema Index bugs.
• Migrating Portal from Solaris to Linux with integration of Portal OID with Microsoft Active Directory.
• Upgraded Oracle Applications E-Business suite 11. .5.10.2 to R12.Upgraded Database from 10.2.0.2 to 10.2.0.3.
• Installed and configured oracle 9iAS, 10giAS, OID, Discoverer, Idiscoverer via the Application Server Portal.
• Configured Oracle 10G Data Guard for disaster recovery. Implemented Oracle 10G Flashback feature for recovery operations.
• Data export/import using Data pump an oracle 10g feature. Data movement using Transportable Tablespaces.
• Implemented security in a DMZ environment. Like Implementing SSL, Implementing an externalfirewall, implementing a reverse proxy between the external users and the external web server.
• JDE Administration experience, Proficient in utilizing the JDE Technical Foundation tools and CNC functionality, Experience with JDE installation, setup, configuration, package builds and deployment.
• Worked on SOA architecture, Orchestration and Integration Technologies in the areas of Web Services, ESB, SOAP, WSDL, BPEL, XML, XSD, UDDI, XML, WS-*, WS-Basic Profiles, and Web services Security and Virtualization of Services OWSM.
• Expertise in Business Process Integration, Service Orchestration, and Routing using Oracle SOA Suite Fusion Products (BPEL, ESB, WebServices,). Successfully completed numerous SOA Projects using SOA Framework with Oracle Fusion Middleware Components like BPEL / ESB / OWSM and Web services Manager.

Environment: Oracle applications 12,11.5.10.2, Oracle 9i, 10g,10g RAC, RMAN,10g Data Guard, RAT, Oracle 10g Flashback, Datapump, PL/SQL, MKS Tool kit, CYGwin, SQL *Loader, tkprof, Statspack,Pstools, CWRsync, Forms 6.0, 4.5, Report builder, Basis2.2.3.2, 2.3.3.

Confidential, Beloit, WI

Sr. Oracle Apps DBA

Responsibilities:

• Responsible for, both manage and support all Production, Development and Test instances of Oracle Version 9.2.07, 9.2.0.5, 8.1.7.4 & Oracle Applications E-Business suite 11.5.10, 11.5.9, 11.5.8, 11.5.5, 11.5.2 and 10gAS.
• Maintaining (VLDB) OLTP databases in 24x7 Production environments on Multiple Applications Tiers with Load balancing of forms tiers. Upgraded QA instance from 11.5.9 to 11.5.10.
• Implemented a 10g Application Server with Oracle Single Sign-On (SSO).
• Handled database migrations of Oracle Applications (11.5.10, 11.5.9, 11.5.8, 11.5.5, 11.5.2 and 10gAS) production (3-tier), test and development instances.
• Cloning Oracle Applications (11.5.10, 11.5.9, 11.5.8, 11.5.5, 11.5.2, 10gAS) from production system, for testing and development purpose.
• Implemented a Green Belt Project by developing automated complete clone Using shell scripting. The script is designed to perform preclone, database removal, restoration (datafiles and application binaries restoration), db recover, Adconfig (on both DT and AT), postclone, generating validation report in HTML format.
• Implemented a Lean project by developing automated post-clone process using shell scripting. Post-clone activity involves changing passwords (system, apps, standard, custom), profile values, dropping and creating dblinks, restoring env file’s from backup, uploading responsibilities, and performing validation and generating a HTML report.
• Developed a UNIX shell script to reduce the restoration (datafiles) to half the actual time.
• Development of BPEL/SOA best practices and standards.
• Performed disaster recovery, wide area network data transfer and data warehousing purposes using MGA.
• Installed MGA duplica on 10g Application server.
• Installing Oracle Internet Directory with Microsoft Active Directory and Integrating Oracle Application Server with Microsoft AD synchronization in Oracle E-business suite 11.5.10.2 with RAC.
• Implemented the rsync methodology to reduce the time on restoration of binaries during a clone.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one off patch, Security patches etc on 11.5.2 through 11.5.10 instances.
• Installed Oracle Internet Directory (OID) and Novell EIV on a Solaris OS in Oracle 11.5.10.2 with RAC.
• Fine tuned Memory, I/O and Database Objects.
• SQL Performance Analyzer (SPA) to foresee SQL performance changes (execution plans, statistics).
• Excellent experience in Installation and configuration of Oracle 8i, 9i, 10g RAC in UNIX/LINUX and Windows environment.
• Performed day-to-day database and oracle apps tasks like code movements, package and form compilations.
• Worked with SQL Performance Analyzer(SPA) to allows for the comparison of SQL performance statistics.
• Maintenance tasks like bouncing the production database, services through veritas.
• BPEL/Workflow performance troubleshooting and tuning.
• Implemented security in a DMZ configuration.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, disk space availability, checking for errors in alert logs etc and Building Schema Index bugs.
• Setup a crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues etc.
• Single Sign on (SSO) and SSL implementation.
• Troubleshot Concurrent service and Concurrent manager issues
• Sync Split activity (hot and cold) through EMC TimeFinder using BCV's.
• Document standards and operating procedures.
• Develop and Maintain BPEL process reports as required

Environment: Oracle applications 11.5.10, 11.5.9, 11.5.8, 11.5.5, 11.5.2, Oracle 8i,9i, 10g,RAT, Sun Solaris 2.10, Veritas software, EMC TimeFinder, SRDF, PL/SQL, SunFire 6900 servers with 40 CPUs 80 GB Memory, 15K with 72 CPUs 144GB Memory, SQL*Loader, SPA, statspack, tkprof, Forms 6.0, 4.5, Reports 6.0, 4.5, Oracle Portal, OID.

Confidential, Carlsbad, CA

Oracle DBA /Apps DBA

Responsibilities:

• Implemented a Lean project by developing automated pre-clone using shell scripting. Preclone activity involves backing up env files (both on DB tier and Application tier), dblinks, and downloading responsibilities.
• Installed and Upgraded 11.5.5 QA instance to 11.5.8 instance.
• Responsible for, both manage and support all Production, Development and Test instances of Oracle Version 8.1.7.4, 9.2.0.5, 10gAS& Oracle Applications E-Business 11.5.8,11.5.7,11.5.5.
• Maintaining ASCP and OLTP databases in 24x7 Production environments on Multiple Applications Tiers with Load balancing of forms tiers.
• Handled database migrations of Oracle Applications E-Business suite (11.5.8, 11.5.5, 11.5.2) production (3 Tier), test and development instances.
• Cloning Oracle Applications (11.5.8, 11.5.5, 11.5.2) from production system, for testing and development purpose.
• Installed Secure Sockets Layer (SSL) configuration in a Single Sign On server (SSO).
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one off patch, Security patches etc on 11.5.5 through 11.5.8 instances and 10g AS instances.
• Standardize MRC scripts during patch application.
• Maintenance tasks like bouncing the production database, services through veritas.
• Performed day-to-day database and oracle apps tasks like code movements, package and form compilations and and Building Schema Index bugs.
• Sync Split activity (hot and cold) through EMC TimeFinder and EMC SRDF using BCV's.
• Automated Sync Split (hot) Process and also integrated post recover activities as a part of automated script.
• Installed and Upgraded Shareplex (4.1 to 5.2) a replication tool for reporting environment.
• SSL and SSO implementation.
• Reduced the upgrade time by transporting the shareplex internal tables for re-use.
• Setup reverse replication in shareplex.
• Data replication by using MGA replica.
• Actually started with resource limitation of only 2 members providing 24X7 Support to reporting environment.
• As the availability of reporting instance is critical to business Implemented pro-active scripts across the reporting servers to reduce the failure of replication.
• Identified the cause for failure of replication or slow replication, built indexes to enhance the replication process.
• Implemented a shell script to speed up the capture process in shareplex during high archive log generation.
• Worked as a part of Software Quality Assurance team in implementing "Shared pool" for standardizing alert monitoring across the project.
• Performed SQL tuning by using Explain Plan and Tkpro.
• Bouncing sqlflow managers and OC4J server.

Environment: Oracle applications 11.5.8, 11.5.7, 11.5.5, 11.5.2, Oracle 8i, 9i, Shareplex 4.1, 5.2, Sun Solaris 2.8, 2.6 Veritas software, EMC TimeFinder, SRDF, PL/SQL, Windows 2000, Sqlflow managers, OC4J server, SPA, tkprof, Forms 6.0, 4.5, Reports 6.0, 4.5, SunFire 6500 servers with 30 CPUS.

Confidential

Oracle Apps DBA

Responsibilities:

• Installed and Upgraded Shareplex (3.2 to 4.1) a replication tool for reporting environment.
• Noetix installation for reporting Environment
• Actually started with resource limitation of only 1 member providing 24X7 Support to reporting environment.
• As the availability of reporting instance is critical to business Implemented Pro-active scripts across the reporting servers to reduce the failure of replication.
• Identified the cause for failure of replication or slow replication, built indexes to enhance the replication process. SSL and SSO Implementation.
• Automated compare - repair utility in Shareplex to keep the tables (target) in sync with source.
• Performed day-to-day database and oracle apps tasks like code movements, package and form compilations.
• Implemented shell scripts to reduce the time for large code movements during cut over tasks.
• Responsible for, both manage and support all Production, Development and Test instances of Oracle Version 8.1.7.4 & Oracle Applications E-business suite 11.5.5,11.5.2.
• Handled database migrations Cloning Oracle Applications (11.5.5, 11.5.2) production system, for testing and development purpose using rapid clone.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one off patches etc on 11.5.5 and 11.5.2instances.
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary. Online/Offline Database Backups and managing database recovery with RMAN.
• Provide technical assistance to developers in all matters concerning performance, application related issues.
• Monitor database and make recommendations to improve performance when appropriate, and schedules/perform table and index reorgs as necessary.
• Maintenance tasks like bouncing the production database, services through veritas.
• Gathering the statistics for pinning the objects. Resolving listener and tnsnames.ora issues.
• Performed numerous application and database tuning assignments on Oracle Applications, legacy, custom and third party systems.

Environment: Oracle applications 11.5.5, 11.5.2, Oracle 8i, Shareplex 4.1, 3.2, Sun Solaris 2.6, Noetix, Veritas software, EMC TimeFinder, SRDF, PL/SQL, Forms 6.0, Reports 6.0.

Confidential

Oracle dba/appsdba

Responsibilities:

• Installation of Oracle Application 11.5.2.
• Cloning of Application Instance -- Single node to two node Using AD Clone. Applied the patches using ADPATCH.
• Performed Application admin tasks using ADADMIN utility. Applied India Localization patches & resolving with Oracle.
• Registered Forms, created Form Functions and Menus. Registered Executables, created Concurrent Programs and Request Groups.
• Created Responsibilities and Application Users System Administration of 11i Setting up of printers in applications.
• Maintenance of concurrent processing requests and concurrent managers. Created and resized the new Data files. Pinning of Packages, Procedures and functions in SGA Run preparatory scripts -- admin server.
• Reset ORACLE schema passwords update configuration-related profiles apply product customizations to environment and files.
• Set rollback segments for normal use validate and compile APPS schema Creation of Schema objects and Space Management. To take backups as per the corporate policy and perform recovery as and when required.
• Developed Data Loading Scripts designed the database structures for the custom module Performed the maintenance of Database and Production support.
• Management. To take backups as per the corporate policy and perform recovery as and when required.
• Developed Data Loading Scripts designed the database structures for the custom module Performed the maintenance of Database and Production support.

Environment: Oracle applications E-Business suite 11.5.2, 11.0.3, Oracle 8i, SunSolaris 2.2, EMC TimeFinder, SRDF, PL/SQL, Forms 4.5, Reports 4.5.