SUMMARY

• Sr. IT Consultant with overall experience of 20+ years in IT industry, recent 15+ Years of experience as oracle applications DBA / system administrator in production, development, UAT and test environments. Good experience in Oracle E - Business Patching, Upgrading and Load balancing. Support in multiple operation system levels like Linux/Unix, Sun Solaris, HP-UX and Windows Server
• Experience and proficient with Oracle E-Business suite applications (11.5.9, 11.5.10.2 12.0.4 , 12.1.2 and 12.1.3, 12.2.6) in Sun Solaris, Red Hat Enterprise Linux, HP UX and Windows environment (currently working on Upgrade project of 12.2.6)
• Performed Application installation, migrations and upgrades of 11i (single node and multi node)
• Performed Database installation and upgrades of 9i/10g/11g/12c
• Experience in Oracle Database Administration, Oracle Applications, Analysis, Design, Server Optimization Techniques, Production environment and Applications support.
• Installation, configuration and maintenance of Oracle 10g RAC, 9iAS/10gAS, E-business 11i, R12, OBIEE
• Expert in Installs of Release R 12 12.0.4 12.2.6 & 12.1 with ASCP,
• Managed many Oracle Applications 11i financial modules: CE, OM, PO, AP, AR, BOM, INV, WIP, General Ledger, iASCP, FA, Procurement, Supplier along with Oracle databases 9i, 10g 11g & 12c.
• Hands on experience in Oracle E-Business Suite implementations and Upgrades from CRP, Development, and UAT to production as an Oracle Application DBA.
• Experience in implementation and administration of Service Contracts, Install base, INV, OA Framework
• Installation and Configuration of Oracle 10g Real Application Clusters (RAC) with 2 nodes and Implemented High Availability solutions with Oracle 10g RAC, Standby (DATAGAURD)
• Pre-patch analysis for the patches and document preparation with pre and post patch installation steps.
• Applied Oracle application patches, critical patches, security patches, end of the year patches, mini packs, family pack patches and applied Oracle database patches using Opatch utility.
• Well versed in Rapid Install, adpatch, adadmin, adctrl utilities for Oracle Applications and involved in Apache Load Balancing.
• Good experience in implementing Shared APPL TOP, ASCP, Online patching 12.2.6
• Strong Experience in Cloning & Patching 11i, R12 Instance using Rapid and manual cloning.
• Proficient in installation and upgrading Oracle Applications 11i e-business suite to R12
• Experience implementing Oracle Single Sign-On (SSO), Oracle Internet Directory (OID), Oracle Identity Management, Oracle Grid Control, Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Data Integrator, Oracle Transportation Management (OTM), Oracle Collaboration Suite, Real Application Clusters (RAC), or high-availability Oracle operating environments.
• Implemented Best Practices for Maintenance, Monitoring, Backup/Recovery, Growth Management, Contention Resolution, Defrag etc. scenarios for the various Environments.
• Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures and Triggers.
• Oracle WebCache, Oracle HTTP Server, Oracle Single Sign-On Server, HTTP Load balancer, Secured HTTP (HTTPs), Oracle Internet Directory.
• Integration of Oracle Application Server 10g components like Single Sign-On/Portal/Discoverer/ Oracle Internet Directory (OID) with Oracle Applications 11.5.10
• Good experience and knowledge in Oracle Applications system administration such as Managing Concurrent Programs and Requests, Configuring Printers, Reports, Administering Concurrent Managers and Work Shifts, User Registration, Customization and Assignment of Responsibilities, Incorporating Custom programs and Managing Profile Options.
• Creating maintaining, Tuning Standby databases.
• Concurrent Manager Setup and troubleshooting. System Administration of Oracle Apps.
• Application’s sysadmin tasks like creating and managing users and their responsibilities, Menus, Functions, Profiles, Alerts.
• 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.
• Automated regular activities like hot backup, daily database refresh, and database health check and space monitoring using shell programming and Building Schema Index bugs.
• Good knowledge of Oracle XML Publisher, developing the XML Reports in Microsoft word and integrate to the Oracle Applications 11i E-Business Suite.
• Knowledge on Oracle Applications E-business suite R12 and Oracle 10g Application server.
• Upgraded the databases from 9.2.0.x to 9.2.0.7, 9i to 10gR2 and 10.2.0.1 to 10.2.0.2 to 11.1.0.7, 11.1.0.7 to 11.2.0.4
• Experience on Database Administration on Oracle Applications 11i, Oracle 9i/8i/8/7.x RDBMS on RHEL
• Installed Oracle Cluster s/w, database 10g and implemented two nodes 10gRAC on HP UX Environment.
• Good knowledge on oracle application 11i rapid installation.
• Hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.
• Advise, provide guidance and develop Disaster Recovery strategies for the Exadata Database machine
• Experience in taking Export, Import and Loading data.
• Involved in SQL tuning using EXPLAIN PLAN and TKPROF.
• Worked on Oracle Real Application Testing (RAT) with Oracle Database 11g Enterprise Edition.
• Using SPA, predicted the impact of system changes on a workload, and forecasted changes in response times for SQL after making any change, like parameter changes, schema changes, hardware changes, OS changes, or Oracle upgrades.
• Knowledge on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.
• Wrote SQL*Loader control files for uploading legacy data to interface tables.
• Monitored the performance of Database, Tuning of Shared Pool by Tuning of Library Cache, Dictionary Cache, and Buffer Cache, Tuning of SGA and Tuning of memory allocation.
• Tuning of I/O, which includes Separating of Data files and Redo log files on different locations, and Separating of tables and indexes on different locations. Applications Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, etc.
• Analytical problem solving and a good team player with strong interpersonal and communication skills.
• Experience with Markview, GRC (Governance, Risk and Compliance ) application
• Good working knowledge with Oracle Endeca application used to manage contracts

TECHNICAL SKILLS

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

Third Party tools: Noetix, Veritas software, OID, Oracle Portal

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK

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

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, SQL, PL/SQL

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/5.x, Sun Solaris 8/9/10

Hardware: Sun 6900 with 20 CPUs 128 GB Memory, E6900, E5100, IBM Hardware.

PROFESSIONAL EXPERIENCE

Confidential

Team Lead Environment and Configuration

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.1.2, R12.2.6.
• Installed Oracle Applications E-business suite 11.5.10.2 (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, 12.1.2, 12.1.3).
• 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 Tablespaces 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.
• Responsible for developing a plan to upgrade the existing production environment from 11.5.9 to 11.5.10 to R12.
• Cloning Oracle Applications 11.5.10.2 for testing and development purpose.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one off patch, Security patches etc on 11.5.10.2 instances.
• Customized technology stacks components (Apache, Form servers).
• Implemented backup and recovery strategies using RMAN (Recovery Manager).
• Troubleshoot Concurrent service and Concurrent manager issues.
• Setup a crontab to receive alerts related to TS issues, OS level space issues, locking issues, Database down, CM down issues etc. Periodically purged log files, trace files, concurrent request log and out files.
• System Administration activities like user creation setups, creation of function, menus, responsibilities, register concurrent programs, printer setup.
• Creation of Reports through report builder, reports registration, forms registration etc on 10g RAC.
• Performing day-to-day database and oracle apps tasks like code movements, package and form compilations and troubleshot various issues related to java class deployment using load java. Oracle Database Administration on 24x7 critical productions.
• Performed application cloning single to single node and dual to single node.
• Installation, configuration and upgrading of Oracle server software and related products
• Evaluate Oracle features and Oracle related products
• Establish and maintain backup and recovery policies and procedures
• Oracle X4/X5 Half rack Exadata machine Solaries X-86 64
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Perform database tuning and performance monitoring
• Perform application tuning and performance monitoring
• Setup and maintain documentation and standards.
• Create test web servers, web listeners, form servers, concurrent managers, and databases from the production environment.
• Troubleshoot problems with web server, web listener, forms server, concurrent managers
• Support Kofax MarkView application which is integrated with EBS to reduce AP invoice preparation
• Apply applications patches.
• Make changes to standard Oracle Applications forms and reports using Designer/Developer for testing purposes as advised by Oracle Support.
• Upgrade from 11.5.9 to 11.5.10.2.
• Create custom concurrent requests to perform database maintenance.
• Write SQL scripts to monitor tablespace and extent growth.
• Perform 2-tier and 3-tier clones of Oracle Applications 11i instances.
• Install Oracle database 9i/10g/11g
• Install and configure 9iAS.
• Install and configure Oracle Portal.
• Install NLS software when new language support is required.
• Configure JVM and jserv processes for load balancing.
• Configure form servlets.
• Troubleshoot problems with concurrent managers, Apache, Jserv processes, and database performance.
• Apply database and applications patches.
• Perform SQL tuning.
• Assist developers with coding PL/SQL.
• Working with using IBM Rational ClearCase for custom code version control
• Strong knowledge on BR100, MD120 and MD50 documents

Environment: Oracle applications 11.5.10, 11.5.10.2,R12 ERP and ASCP, Chain link, Cleare case Sun Solaries 9/10, Loftware Printer Softare PL/SQL, Forms 6.0, TOAD 9.0/10

Confidential

Application Database administrator

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 (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, 12.1.2, 12.1.3).
• Implemented maintenance plans, scheduled scripts for concurrent request details, table space growth, archive log monitoring and many other maintenance activities.
• Oracle X3/X4/X5 Half rack Exadata machine, Linux X64 box / Solaries X-86 64
• Hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.
• Advise, provide guidance and develop Disaster Recovery strategies for the Exadata Database machine
• Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
• 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 Tablespaces 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.
• Responsible for developing a plan to upgrade the existing production environment from 11.5.9 to 11.5.10 to R12.
• Cloning Oracle Applications 11.5.10.2 for testing and development purpose.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one off patch, Security patches etc on 11.5.10.2 instances.
• Customized technology stacks components (Apache, Form servers).
• Implemented backup and recovery strategies using RMAN (Recovery Manager).
• Troubleshoot Concurrent service and Concurrent manager issues.
• Setup a crontab to receive alerts related to TS issues, OS level space issues, locking issues, Database down, CM down issues etc. Periodically purged log files, trace files, concurrent request log and out files.
• System Administration activities like user creation setups, creation of function, menus, responsibilities, register concurrent programs, printer setup.
• Creation of Reports through report builder, reports registration, forms registration etc on 10g RAC.
• Performing day-to-day database and oracle apps tasks like code movements, package and form compilations and troubleshot various issues related to java class deployment using load java. Oracle Database Administration on 24x7 critical productions.
• Performed application cloning single to single node and dual to single node.
• Installation, configuration and upgrading of Oracle server software and related products
• Evaluate Oracle features and Oracle related products
• Establish and maintain backup and recovery policies and procedures
• Take care of the Database design and implementation
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Perform database tuning and performance monitoring
• Perform application tuning and performance monitoring
• Setup and maintain documentation and standards.
• Create test web servers, web listeners, form servers, concurrent managers, and databases from the production environment.
• Troubleshoot problems with web server, web listener, forms server, concurrent managers
• Apply applications patches.
• Make changes to standard Oracle Applications forms and reports using Designer/Developer for testing purposes as advised by Oracle Support.
• Upgrade from 11.5.9 to 11.5.10.2.
• Create custom concurrent requests to perform database maintenance.
• Write SQL scripts to monitor tablespace and extent growth.
• Perform 2-tier and 3-tier clones of Oracle Applications 11i instances.
• Install Oracle database 9i/10g/11g
• Install and configure 9iAS.
• Install and configure Oracle Portal.
• Install NLS software when new language support is required.
• Configure JVM and jserv processes for load balancing.
• Configure form servlets.
• Troubleshoot problems with concurrent managers, Apache, Jserv processes, and database performance.
• Apply database and applications patches.
• Perform SQL tuning.
• Assist developers with coding PL/SQL.

Environment: Oracle applications 11.5.10, 11.5.10.2,R12 ERP and ASCP, Chain link, Cleare case Sun Solaries 9/10, Loftware Printer Softare PL/SQL, Forms 6.0, TOAD 9.0/10

Confidential

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 & Oracle Applications E-Business suite 11.5.10 and 10gAS .
• 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 and 10gAS) production (3-tier), test and development instances.
• Cloning Oracle Applications (11.5.10, and 10gAS) from production system, for testing and development purpose.
• Installing, configuring and maintaining Oracle Grid Control (10g grid)
• 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.
• Installed and Configured Discoverer 11.1.1.2 and Oracle OID 11.1.1.2 with Ebusiness R12
• Performed disaster recovery, wide area network data transfer and data warehousing purposes using MGA.
• 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) on a HP UX 1.1 and 2.1 in Oracle 11.5.10.2 with RAC.
• Fine tuned Memory, I/O and Database Objects.
• 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 to allow for the comparison of SQL performance statistics.
• Maintenance tasks like bouncing the production database, services through veritas.
• 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
• Document standards and operating procedures.
• Oracle e-business suite 11.5.10.2 with database 10.2.0.2 on RAC with integrated single sign on/discoverer/portal
• Migration of ERP and OID database which is on RAC with RAW file system to new server with updated OS version(HP-UX 11.11 to 11.23)
• Migration of Dual node e-business suite application node with parallel concurrent processing to the new server.
• Migration of Two node Application server for SSO/Discoverer/Portal to new server
• Integration of SSO/Discoverer/Portal with e-business suite application.
• Configuring Hard-ware F5 load balancing for application server and e-business suite nodes
• Configuration of DR server for ERP and OID database.
• Implementation of RMAN backup for PROD and ODI-database.
• Configuration of new Development node using Rapid cloning.

Environment: Oracle applications 11.5.10.2, Oracle 10g HP UX 1.1/2.1 RAC 10G, AS9i, PL/SQL, Forms 6.0, TOAD 9.0/10