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 inOracle E-Business Suiteimplementations 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.
• Experience in general troubleshooting, fire fighting, 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.
• Applications sysadmin tasks like creating and managing users and their responsibilities, Menus, Functions.
• 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.
• Diagnostic Ability - Ability to go to the core of the problem.
• Willing to learn and adapt to new challenges & capabilities to take initiatives.
• 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: R12 12.1.3/ 12.1.1/12.0. 6

Oracle E-Business Suite: 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.

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

Applications DBA

Responsibilities:

• 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 10gWeb 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),11gR2, Oracle Applications EBS 11i/R12, Oracle 9i & 10g RAC, TOAD, Developer 6i .

Confidential, Pleasanton, CA

Oracle Apps DBA

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 TuningPack, 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, Raleigh, NC

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, Atlanta, GA

Oracle Apps DBA

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.