Experience Summary:

• Specialized in Oracle Applications R12/11i Database and System Administration with over 7 years' experience in Oracle under UNIX environment.
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning or Refreshing Database and Oracle Applications.
• Experienced and proficient with Oracle E-Business suite application R12 12.1.3,12.1.1/12.0.x, 11.5.7, 11.5.8, 11.5.9 and 11.5.10 and Oracle Applications Server 9i/10g in Sun Solaris, Red Hat Linux, AIX and Windows environment.
• Performed Application installation and upgrades.
• Expert in upgrading Oracle Applications to 11.5.10.2 to 12.1.1 and 12.1.1 to 12.1.3.
• Experienced in Oracle E-Business Suite implementations and Upgrades from CRP, Development, and UAT to production as an Oracle Application DBA.
• Performed database installation and upgrades. Experience in setting up HTTP Load Balancing.
• Expert in upgrading Oracle Applications Technology stack Developer patch sets, JDK, J initiator etc .
• Good knowledge of Oracle XML Publisher, developing the XML Reports in Microsoft word and integrate to the Oracle Applications 11i E-Business Suite.
• Expert in Cloning using ADCLONE, Rapid clone and ADCONFIG.
• Expertise in implementing Shared APPL TOP and PCP.
• Expertise in troubleshooting Workflow and Notification Issues.
• Expertise in using ORADEBUG, TKPROF and SQLT for fixing performance tuning issues.
• Proficient in analyzing and optimizing queries, performance tuning and providing reports using STATSPACK, TKPROF and Explain Plan.
• Proficient in Oracle tools and utilities Net8, Svrmgr, WebDB, OAS 4.0.8, Data Browser, Developer Suite, Export, Import, SQL Loader, PL/SQL, OEM, IA, SQL Navigator, DB Artisan, ER Studio, Glance, SQL Expert in UNIX Sun Solaris, AIX, HP-UX Windows environment.
• Experience in installation and configuration of Oracle SOA suite 10g/11g.
• proficient in handling Oracle Applications Manager which provides a powerful set of features to manage Oracle Workflow, Patching, Configuration Utilities and Concurrent Processing
• Great experience in handling and administering Oracle 11i Instances using AD utilities such as adadmin, adctrl, admerge, adsplice, adpatch etc.
• Expertise in converting single instance database to Real Application Cluster RAC / Automatic Storage Management ASM
• Good Experience on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc
• Oracle Data Guard Implementation for High Availability and remote Disaster Recovery DR site.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases
• Experience in general troubleshooting, firefighting, and development of scripts, documentation, issue resolution, and TAR support.
• Well versed in implementing System Management and Monitoring procedures.
• Strengths include skills in Shell Programming, SQL and PL/SQL.
• Well versed with User Management, Performance Tuning, and Concurrent Processing Settings.
• Experience in Security Management and Database Auditing.
• Implemented Sabrix Taxing Software and integrated with 12.0.4 Applications.
• Implemented DMZ for i-store users.
• Tuning the databases for optimal performance and monitoring CPU performance.
• Good Experience on Oracle 10g new features like Data pump, flashback tables, ASM, ADDM, AWR, etc.
• Database Upgrading from one server to another using Export and Import utility.
• Expertise in installing Discoverer and integrating to ERP Applications.
• Expertise in RMAN for recovery and cloning.
• Expert in Configuring Workflow Mailer.
• Expertise in applying security patches.
• Improving Query Performance by rewriting the problematic queries.
• Performing R D and analysis to benefit from new releases/features of Oracle Database.
• Basic Administration of UNIX systems Solaris, LINUX, HP-UNIX TRU64, AIX .
• Troubleshooting Login, Self Service Application, Jinitiator and Network related issues.
• Experienced in writing UNIX shell scripts and setting up cron jobs for database needs.
• Monitor system performance, identify bottlenecks and ensure problem resolution.
• Implemented 10g Grid Control and applied Applications Management Pack for monitoring Applications.
• Expertise in Cloning of databases from RAC to RAC and RAC to non-RAC.
• Maintaining Hot Backups, Cold Backup.
• Strong Analytical skills and ability to interact with end-users, managers, and technical personnel.
• Good team player, self-motivated and a quick learner.

TECHNICAL SKILLS

ERP

• Oracle E-Business Suite
• R12: 12.1.3/12.1.1/12.0.6
• 11i: Ver 11.5.5, 11.5.6, 11.5.7, 11.5.8, 11.5.9, 11.5.10.2.
• RDBMS
• Oracle Server 8i/9i/10g/11g for Sun Solaris, Linux, AIX,HP-UX
• Operating Systems
• Sun Solaris 2.6/2.5.1 SUN OS 5.5.1 , AIX, HP-UX, Windows 95/98/NT, Windows NT 4.0 Server
• Languages
• SQL/ PL/SQL, UNIX Shell Programming Bornshell, Csh, Ksh Crontab
• Software Tools/ GUI
• Oracle Developer2000, Oracle Enterprise Manager OEM , SQL Navigator, SQL Plus and TOAD.
• Application Servers
• Oracle 10g/9ias R2.

Confidential

PROFESSIONAL EXPERIENCE

Confidential

Upgrade, Support Maintenance

Responsibilities:

• As an Oracle Apps DBA responsible for both manage and support of all Production, Development and Test Databases and Applications, Successfully upgraded 11i version 11.5.10.2 to 12.1.1 and 12.1.1 To 12.1.3 R12 ,installed and worked on two products CHRM and PHUB by providing full support as an apps dba.
• Maintaining VLDB OLTP databases in 24x7 Production environments on Multiple Applications Tiers with Load balancing of forms tiers.
• Experience in various modules such as Financials, GL, AP, AR, PO and CRM.
• Installed Multi Node Oracle E-Business Suite R12 12.1.1 on 11g RAC.
• Worked on day to day issues in RAC environments and applied ASM, Grid Infrastructure GI patches and bug fix when and where required.
• Troubleshoot Concurrent service and Concurrent manager issues.
• System Administration activities like user creation setups, creation of function, menus, responsibilities, register concurrent programs, printer setup.
• Performed disaster recovery, wide area network data transfer and data warehousing purposes.
• Enabled and Tested Oracle Data Guard 11g new feature Active Data Guard with Sqlplus and Data Guard Manager.
• Design and implementation of the Oracle BPEL platform including archiving and maintenance strategies. Provided technical leadership in Oracle E-Business Suite, SOA, BPEL integration, and BI/DW projects.
• Created and Rebuild standby databases for EDW environments.
• 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.
• Used Oracle Application maintenance utilities like adadmin, adpatch, adctrl and adrelink etc.
• Experience in taking Export, Import and Loading data using SQL Loader, Punchout and Bulk Loader.
• Cloning Oracle Applications R12 12.1.2 from production system, 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 .
• Configured and Managed the Oracle Application Server 10g infrastructure.
• Minimized the transmission of redundant data using the OAS 10g Web Cache.
• Implemented backup and recovery strategies using RMAN Recovery Manager .
• Tested, Implemented and Scheduled database backups in Commvault Application. Restored Test and DEV databases from Prod using Commvault Application.
• Setup a crontab to receive alerts related to TS issues, OS level space issues, locking issues, Database down, CM down issues etc.

Environment: SUN Solaris 10, Red hat Linux 5, Windows XP, 2003, Oracle 8i 8.1.7 , 9i 9.2.0 10g 10.2.0 ,11g R12, Oracle Applications EBS 11i/R12, Oracle 9i 10g RAC, TOAD, Developer 6i .

Confidential

Upgrade, Support Maintenance

As an Oracle Apps DBA, Successfully upgraded 11i version 11.5.10 to 11.5.10.2,11.5.10.2 to 12.0.4 and 12.0.4 to 12.1.1R12 and also performed database from Oracle 8.1.7 to Oracle 10g.

Responsibilities:

• 24x7 Production Oracle Applications Administration.
• Maintaining production, development test databases and applications.
• Good knowledge on Oracle applications 11i Rapid Installation.
• Upgraded Oracle Applications 11i 11.5.10 Database Version 8.1.7.4 to 10g 10.2.0.4 on Solaris.
• Upgraded Oracle E-Business Suite 11.5.10 to 11.5.10.2, 11.5.10.2 to 12.0.4 and 12.0.4 to 12.1.1 and database 9.2.0.8 to 10g
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle Database which is on RAC.
• Applied patches using ADPATCH, ADCTRL utilities.
• 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.
• Successfully upgraded Oracle Applications 11.5.10.2 to R12 12.0.4 in multinode configuration.
• Performed installation and configuration of oracle SOA suite 10g/11g for the integration of Application and Database.
• 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
• Created test environment through cloning production environment for developers to test on live data
• Administration of Oracle ERP applications version 11.5.10.2.
• Implemented AUTOCONFIG in the Apps environment and used ADCONFIG, ADBLDXML commands.
• Implementation, customization and personalization of Oracle iProcurement.
• Experience on various modules such as Financials, ASCP, MFG, CRM, AR, AP, GL, PO, and INV.
• 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 pack .
• Oracle Applications Systems Administration. RMAN used in scheduled recovery, hot and cold backup of Oracle10G database.
• Installed and configured Single-Sign-On SSO and Implemented SSL Security.
• Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigned to users.
• Planning and Administration of backup and recovery strategies.
• Oracle 10g Database Implementation/Upgrade/Support.
• Good Knowledge in Data Modeling tools like Erwin.
• Oracle 10g Application Server Implementation/Upgrade/Support.
• Oracle Data Guard Implementation for High Availability and remote Disaster Recovery DR site.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Performance tuning of Oracle Database, applications and queries.

Environment: Red Hat Linux 4/5, SUN Solaris 9, HP-UX 11i v1 B.11.11 , Windows XP, Oracle 8i 8.1.7 , 9i 9.2.0 10g 10.2.0 , Oracle Applications EBS 11i/R12, Oracle 9i 10g RAC, TOAD, Developer 6i .

Confidential

Senior Oracle Apps DBA

Responsibilities

• Upgraded 9i database to 10g 10.2.0.3 database.
• Upgraded Oracle Applications from 11.5.10.2 to R12.
• Post go-live support of Oracle Applications R12.
• Maintenance of 10g databases and other non-ERP Databases.
• Implemented parallel concurrent processing pcp in R12.
• Cloning DEV and UAT instances from Production for testing.
• Configured custom Output Post Processor.
• Migrated the Production database from Old servers to new servers.
• Successfully implemented 3-node RAC setup and made the environment stable.
• Have good knowledge on 10gAS OID, SSO and complete infrastructure and middle
• Tier components of 10g.
• Configured load balancing on Apache and Forms Servers.
• Monitored databases using 10g OEM grid control.
• Created and monitored the concurrent managers.
• Provided valuable suggestions for allocating system storage and planning future storage requirements.
• Responsible for Cloning of Database and Applications as per functional requirements.
• Implemented Oracle Applications upgrades, patches using various AD utilities.
• Prepared analysis for resolving system errors, disk space problems, and huge file sizes errors.
• Worked with End Users and Functional Analysts on issue resolution concurrent manager problems, one off patches etc.
• Developing UNIX and SQL scripts for the smooth functioning of database and applications related issues.
• Auto Trace, SQL Trace, TKPROF, STATSPACK advanced version of UTLBSTAT and UTLESTAT .
• Gathered database/Objects statistics using DBMS UTILITY, DBMS STATS, and
• FND STATS packages and ANALYZE command.
• Responsible for setting up the printers in Application environment.

Environment: Oracle Applications 11i 11.5.9 , Oracle 8i/9i, HP UNIX TRU-64, Precise, OEM, SQL plus, SQL Loader, Toad, Oracle Discoverer, JDK 1.1/1.3.1

Confidential

Oracle Apps DBA

As an Confidential , responsible for installation, implementations, upgrades and smooth functioning of Oracle ERP applications on UNIX system and Oracle databases.

Responsibilities:

• Maintained Oracle Applications Release 11i 11.5.10.2
• Successfully completed 3 Test upgrades from 11.5.7 to 11.5.10.2
• Upgraded Oracle Application databases from 8i to 9i 9.2.0.7
• Upgraded Oracle Application databases from 9i to 10gR2
• Implemented Parallel Concurrent Processing
• Installed, upgraded and maintained Oracle ERP applications version 11.5.9
• Upgraded application from 11.0.3 to 11i using Auto Upgrade.
• Administration of Oracle ERP applications version 11.5.10.2.
• Setup and implementation of Oracle Financial Analyzer.
• Performed database and application cloning of Production database on TEST environment to provide users the live data for testing purpose.
• Performed Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan, AWR, ADDM, and ORADEBUG.
• Setup system profiles in Apps.
• Setup of test 9i RAC Cluster using Linux.
• Oracle Applications server including OID.
• Implementation of Oracle Applications Server for use with Portal, Custom Forms and Reports and Discoverer 6i.
• Worked with Orchestration Team to simplify the integration Architecture and Transition to ESB.
• Implemented Oracle 9i RAC on Windows.
• Registered customized applications, Apps Users, created responsibilities, customized menus, attached menus to responsibilities and finally this to users.
• Installed, Configured and Integrated OID with Single Sign On against 9i Database.

Environment: Unix/Linux, Oracle 9i 10g, Oracle Applications 11i

Confidential

Oracle Database administrator

Responsibilities:

• Responsible for managing production, development test databases and applications.
• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
• Wrote Stored Procedures according to specs and control files for input to SQL Loader utilities for loading data from external files into the Oracle database.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database. .
• Implement Hot, Cold and Logical backup plans.
• Used Oracle UTL file features to create flat files and Procedures for Data Extraction.
• Oracle Configuration. Oracle Tuning. Oracle Patch Administration.
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Creation of Users and Granting them privileges and roles.
• Performed Database Tuning. Performed Database Security and Integrity. .
• Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.
• Writing Pl/SQL procedures and functions. Writing shell scripts to automate the data loading.
• Monitoring the data loading jobs and tuning the Sql queries.

Environment: Oracle 8i, SQL Server 2000, UNIX Sun Solaris , Windows NT/2000/Advanced Server , TOAD, OEM, SQL PLUS, Explain Plan, UNIX Shell Scripting, Quest software tools, PL/SQL navigator.