OBJECTIVE

• A challenging and rewarding career in an organization of repute, where I can use my knowledge to the fullest and which would help in my personal development. As a Oracle Applications Database Administrator, I am keenly interested to serve the organization skillfully and efficiently to attain the defined goals of the organization and get better exposure to the cutting edge of technology.

SUMMARY

• Over 9 years of experience in IT Industry as an Oracle Apps DBA in implementation, Administration, Testing, Maintenance and support.
• Extensive experience as an ORACLE Applications DBA in a variety of different environments like AIX, SUN SOLARIS, Linux and WIN NT/2000/2003
• Installation, Configuration & Deployment of Oracle E - Business Suite 11i/R12.
• Extensive Experience in Oracle E-Business suite applications (R12.1.1,11.5.10.2, 11.5.9,11.5.3) on Linux, HP, AIX & Sun Solaris.
• Oracle Applications Release R12, 11i installation & Configuration Good problem-solving capabilities.
• Served as Oracle Applications DBA. Responsible for installation, upgrades, patches, TAR support, database tuning, concurrent manager administration, cloning. Duties included database creation, database tuning, SQL statement tuning, Web Server, backup/recovery, general troubleshooting, script development, and documentation.
• Installed and patched R12.1.1, 11.5.9, 11.5.10.2 instances and Discoverer 4.1.48.06.
• Worked on AD utilities like adpatch, adadmin, adctrl, adrelink, adsplice, admerge, adclone, adconfig, etc.
• Cloning R12, 11i databases using through oracle applications and rapid clone technique.
• Appling the OS patches for Linux R12, 11i and Oracle Application patches and upgrade the Application databases from 9.2.0.4 to 9.2.0.5/10g/11g.
• Very strong in Auto Patch, Upgrade, cloning.
• Management of schemas, objects & Partitioning the tables & indexes.
• Performed backups and tested crash recoveries using conventional Hot & Cold backups and RMAN
• Expertise in installing, maintaining and administering Oracle Applications 11i (11.5.3, 11.5.9, 11.5.10, R12) instances.
• Expertise in Maintenance, Patching, Cloning, troubleshooting and Performance tuning of Oracle Applications e-Business Suite.
• Upgraded the RUP version from 3 to 7 in Oracle Applications 11.5.10.2.
• Upgraded the Oracle Applications from 11.5.10.2 to R12(12.1.1).
• Upgraded the database from 9.2.0.8 to 10g to 11g as part of R12 upgrade.
• Expertise on Installation, Configuration of Oracle Application Server 10g.
• Expertise in handling Many Oracle Applications Databases with sizes varying from 300 GB to 5 Tera Bytes.
• Having knowledge on Sql server, Providing application support and backend database support.
• Experienced in Oracle Apps Administration and Sysadmin tasks
• Experience in supporting Oracle Application modules like Oracle Financials - Financials Accounting Hub(Subledger Accounting), AP, AR, GL, FA, FCG, CM, HRMS, LM, SCM, Iprocurement, Iexpense
• Tune and applied patches on the Oracle Financials - Financials Accounting Hub (Subledger Accounting) module.
• Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases (Data Guard). Thorough Experience with supporting the Production Database with complete lifecycle including Installations, Upgrade, Patching, Cloning, Backup/Recovery, High Availability including Oracle Real Application Cluster (RAC) and Data Guard
• System Administration of Oracle Application using Application Object Library and System administration module, using listed tasks: Registering New Application, Registering New schema, Registering Customized Tables using Application Standards, Creating new customized responsibilities, Menus, Request group, Functions, Concurrent programs. Administering Concurrent Processes and Managers and Automating the Request.
• Good experience in Installing and providing support In OBIEE applications as well.

TECHNICAL SKILLS

Operating Systems: Windows 98/2000/2003/ XP, Sun Solaris 8.0 and 9.0 and Several flavors of Linux.

RDBMS: Oracle9i, Oracle10g. Oracle 11g, Oracle GoldenGate Repository

ERP: Oracle Applications 12.1.1/12.1.3/11 i (R12.1.1,R12.1.3,11.5.4, 11.5.9, 11.5.10.2)

Modules: Subledger Accounting, AP, AR, GL, FA, FCG, CM, HRMS, LM, SCM, Iprocurement, Iexpense

Other Tools: RMAN, Tkprof, Statspack, Forms and Reports6i, Discoverer

Network Protocol: Net 8, SQL*Net

Scheduling Tools: Cronjob (UNIX), Oracle Enterprise Manager

PROFESSIONAL EXPERIENCE

Confidential, Memphis, TN

Oracle Apps DBA

Responsibilities:

• Worked Oracle R12(12.1.1) Application.
• Upgraded the Oracle Databases from 10.2.0.5 to 11.2.0.4
• Worked on 10g, 11g databases, and R12.1.1 applications.
• Maintaining, Monitoring and Administering for Oracle applications environmeny on RAC architecture
• Performed Multi Node installation of Oracle EBS R12.1.1
• Cloning the Oracle Applications R12 environment from Production to UAT, QA, DEV boxes.
• Setup the RAC one node.
• Set up Printers and Workflow mailer in Oracle Applications R12.1.1 Prod, UAT,QA,DEV Environments
• Worked closely with Functional/Developers and helping them in fixing issues
• Upgrade Oracle Application from R12.1.1 to R12.1.3.
• Applying latest patches from Oracle Support to the Test and Production Instances for resolving issues or Enhancing features.
• Cloning 11i & R12 ERP Instances from Production to Test, Development Instances and coordinate with Testing and Development Teams.
• Backups- Logical and Physical for Multiple Instances.
• Controlling and Monitoring of User Access to the Database including Granting and revoking of Privileges and Roles and Tablespace Quotas.
• Experience in Upgrading 11gR1 to 11gR2 for R12.1.1 Environment
• Raising the Service Request and working with Oracle Team.
• Installed and configured 10g Discoverer on Oracle Application environment.
• Installed Web ADI on the user’s desktops and fixed the Application Problems.
• Created users, responsibilities, Menus, Functions and migrated them to remaining environments through FNDLOAD in Oracle Applications Environment.
• Scheduled the Rman Backup scripts in a cron job.
• Applied Patches for Developers Bug fixes and Scheduled Maintenance on Oracle Applications
• Implemented DR setup on the Oracle Applications R12 environment as per Client Standards.
• Oracle Applications Concurrent Manager Administration & tuning for R12 applications.
• Installed the Oracle 10g, Oracle 11g databases and Created Tablespaces on ASM environment.
• Done Full Exports and Imports of the database at schema as well as tablespace level for different customers.
• Performed the Restore of Oracle 10g/11g databases on a One node RAC environment.
• Tested the relocate of the One node RAC environment.
• Install, configure and write scripts for RMAN
• Daily DBA activities as Performance Monitoring, Instance Health Check etc
• Working with FNDCPASS to change Passwords of APPLSYS,APPLSYSPUB and SYSADMIN
• Provided Production support in Oracle Production Databases as well as Oracle Applications environments.
• Experience in supporting Oracle Financial modules like (AP, AR, GL, FA, FCG, CM)
• Cloning the Oracle 9i/10g/11g Databases from Production to UAT, QA, DEV databases through rman.

Environment: Oracle Database10g, Oracle Database 11g,Oracle Applications 12.1.1, Toad, DBartisian, MobaXterm, ASM, Oracle Enterprise Manager (OEM) Grid Control, RMAN, Red Hat Linux ES6.

Confidential, Miami, FL

Oracle Apps DBA

Responsibilities:

• Providing Support to R12 (12.1.1) Application users through ticketing system.
• Upgraded the Oracle Databases from 10.2.0.4 to 11.2.0.2
• Worked on 9i, 10g, 11g databases, R12 applications.
• Maintaining, Monitoring and Administering for 12 Instances on RAC architecture
• Performed Multi Node installation of Oracle EBS R12.1.1
• Cloning the Oracle Applications R12 environment from Production to UAT, QA, DEV boxes.
• Set up Printers and Workflow mailer setup in Oracle Applications R12 Prod, UAT,QA,DEV Environments
• Working closely with Functional/Developers and helping them in fixing issues
• Raising the Service Request and working with Oracle Team.
• Installed and configured 10g Discoverer on a Application environment.
• Installed Web ADI on the user’s desktops and fixed the Application Problems.
• Created users, responsibilities, Menus, Functions and migrated them to remaining environments through FNDLOAD In Oracle Applications Environment.
• Scheduled the Rman Backup, Obsolete, ageing of alert log jobs through Autosys in Oracle applications R12 environment.
• Applied Patches for Developers Bug fixes and Scheduling Maintanence on Oracle Applications
• Implemented DR setup on the Oracle Applications R12 environment as per Client Standards.
• Migrated the Oracle forms and reports from One sever to another, compiled them through f60gen in Oracle Applications Environment.
• Oracle Applications Concurrent Manager Administration & tuning for R12 applications.
• Installed the Oracle 10g databases and Created Tablespaces.
• Done Full Exports and Imports of the database at schema as well as tablespace level for different customers.
• Provided 24*7 and On Call support in Oracle Databases and Oracle Applications(11i.R12).
• Experience in supporting Oracle Financial modules like (AP, AR, GL, FA, FCG, CM)
• Cloning the Oracle 9i/10g/11g Databases from Production to UAT, QA, DEV databases through rman.

Environment: Oracle Database10g, Oracle Applications 12.1.1,Oracle Applications 11.5.10.2, Toad, DBartisian, Oracle Enterprise Manager (OEM) Grid Control, RMAN, Red Hat Linux ES4.

Confidential, Atlanta, GA

Oracle Apps DBA

Responsibilities:

• Upgraded the Oracle applications from 11.5.10.2 to R12(12.1.3)
• Upgraded the Oracle Databases from 9.2.0.8 to 10.2.0.5
• Worked on 9i, 10g, 11g databases and 11i(11.2.0.1,11.2.0.3), R12 applications.
• Supported the 2- node, 3-node, 4-node and multi-node RAC environment.
• Maintaining, Monitoring and Administering for 12 Instances on RAC architecture
• Performed Multi Node installation of Oracle EBS R12.1.1
• Migrating the Oracle Applications 11.5.10.2 and Oracle 10g databases from Confidential Servers to Confidential Servers.
• Cloning the Oracle Applications R12 environment from Production to UAT, QA, DEV boxes.
• Set up Printers and Workflow mailer setup in Oracle Applications R12 Prod, UAT,QA,DEV Environments
• Working closely with Functional/Developers and helping them in issues
• Handling Tars
• Installed and configured SOA, BPEL, Single sign on Setup and Providing the Application support.
• Installing and providing support In OBIEE applications as well.
• Implemented SSO/OID with E-Business Suite
• Installed 10gias 10.1.4.0.1 infra as part of sso implementation
• Installed Web ADI on the user’s desktops and fixed the Application Problems.
• Created users, responsibilities, Menus, Functions and migrated them to remaining environments through FNDLOAD In Oracle Applications Environment.
• Scheduled the Rman Backup, Cleanup, size check, ageing of alert log jobs through Autosys in Oracle applications R12 environment.
• Applied Patches for Developers Bug fixes and Scheduling Maintanence on Oracle Applications
• Implemented DR setup on the Oracle Applications R12 environment as per Client Standards.
• Migrated the Oracle forms and reports from One sever to another, compiled them through f60gen in Oracle Applications Environment.
• Oracle Applications Concurrent Manager Administration & tuning for R12 applications.
• Installed the Oracle 10g Datawarehouse databases and Created Tablespaces.
• Done Full Exports and Imports of the database at schema as well as tablespace level and loaded data into database.
• Installed Oracle software 9.2.0.5, Upgraded it to 9.2.0.8 database.
• Experience in supporting Oracle Financial modules like Oracle Financials - Financials Accounting Hub(Subledger Accounting Subledger Accounting,AP, AR, GL, FA, FCG, CM
• Cloning the Oracle 9i/10g Databases from Production to UAT, QA, DEV databases through RMAN.
• Experience with OIM, SSO, OID integration with EBS.
• Worked Closely with Unix Team and Provided Specifications for Installing Oracle applications on a Red hat Linux 4 Enterprise Server.
• Performed SQL tuning, Database Tuning, Application Tuning and Improved the performance of database/applications.
• Created users, Profiles, Assign Grants, Granted Roles and Quota to users.
• Creating and Managing Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts & Functions. Views, Indexes, user accounts, roles, grants and performing day-to-day operations
• Creating the Customized Menus, Responsibilities, Request groups, Request sets and Application Users as part of sysadmin
• Worked with Functional and Technical engineer and helped them in issues
• Prepared the documentation for day to day activates as apps dba for post production, architecture details, pre plan for Production Assessment

Environment: Oracle Database10g, Oracle Applications 12.1.1,Oracle Applications 11.5.10.2, Toad, DBartisian, Erwin, Oracle Enterprise Manager (OEM) Grid Control, RMAN,Red Hat Linux ES4.

Confidential, Atlanta, GA

Oracle DBA & Apps DBA

Responsibilities:

• Migrate the Oracle10g databases, Oracle Applications 11.5.10.2 from one datacenter to another datacenter.
• Installed and configured Single-Sign On (SSO), Oracle internet directory (OID) 11g and Access manager 11g.
• Cloning the Oracle Applications from production to UAT & Dev & QA.
• Supported the 2- node, 3-node, 4-node RAC environment.
• Configured 2 node RAC with PCP for Ebusiness R12 along with DG setup
• Performing the Oracle Applications failover from Prod server to DR server and reverted back from DR to Prod server as per Client Standards
• Cloning the Oracle Applications Databases from Production to UAT, QA, DEV databases.
• Applied CPU patches in Oracle Databases 10g and Oracle applications 11.5.10.2 Every Quarter as per requirements.
• Setup XML Publisher 5.6.3 in Oracle Applications 11.5.10.2
• Work closely with the Developers and Application Users to fix there issues in Database and Applications.
• Experience in supporting Oracle Financial modules like Oracle Financials - Financials Accounting Hub(Subledger Accounting),AP, AR, GL, FA, FCG, CM
• Performing the Oracle Applications failover from One Prod server to another server.
• Installing a Oracle 10g Data Warehouse Environment and Maintaining the database.
• Applied the CPU patch in Oracle Application Databases and Core databases.
• Applied Patches and Doing Maintanence on Oracle Applications
• Cloning the Oracle Applications from production to Dev & QA.
• Created users and Assign Grants, Roles, Quota to users in Oracle Applications.
• Upgraded the 10g database from 10.2.0.1 to 10.2.0.2
• .Done Full Exports and Imports of the database at schema as well as table space level.
• Restoring the Applications databases from production to Dev & QA & UAT Databases.
• Migrating the Oracle applications database from Oracle9i to Oracle10g Database.
• Upgraded Oracle Applications Jinitiator version from 1.3.21 to 1.6.
• Executed the turnovers as per developer’s doc and migrated code from Development to remaining Oracle applications environments.
• Applied Patches for Developers Bug fixes and Scheduling Maintanence on Oracle Applications

Environment: Oracle Database10g, Oracle Applications R12, Oracle Applications 11.5.10.2, Toad, DBartisian, Erwin, Oracle Enterprise Manager (OEM) Grid Control, RMAN, Red Hat Linux ES4.

Confidential, Dallas

Oracle Apps DBA

Responsibilities:

• Install Oracle 10g software on the server and initial Creation of the database.
• Configuring listener using NETCA tool.
• Database upgrades (9i to 10g)
• Created users and Assign Grants, Roles, Quota to users.
• Monitoring the production and development databases by checking database
• Wrote Pl/sql procedure scripts to load PWS data from one server to another.
• Done Full Exports and Imports of the database at schema as well as tablespace level.
• Wrote UNIX scripts to monitor size of the tablespaces and scheduled it in crontab.
• Installed MetaSolve software in test environment.
• Creating Oracle scripts for Oracle exports, Hot / Cold backups, RMAN and Windows Scripts for Scheduling jobs through windows scheduler
• Interact with developers on SQL and Oracle support teams.
• Oracle patching for updates and Bug fixes using opatch utility
• Provided partitioning of the large tables to reduce the access time.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Using Spot light tool to monitor the databases and Toad, SQL developer for advanced coding.
• Taking care of the performance issues for the Confidential servers.
• Handing the regular Service tickets from the developers and application users for issues concerning to database.

Environment: Oracle database10g, Toad, SQL Plus, Oracle Enterprise Manager (OEM) Grid Control, RMAN, Solaris 10.

Confidential

Oracle Applications DBA

Responsibilities:

• Installation of Oracle software and Creation of Oracle Databases on Various platforms.
• Cloning, Patching, and Administering the Concurrent Mangers.
• Interacting with development team, carrying out the jobs as and when required/ as per schedule.
• Monitoring and supporting Production server issues.
• Refreshing the database.
• Troubleshooting the user issues, interacting with the end users/ coordinating between development team / Users to carry out the Patching/ implementing new changes to the system.
• Applying patches on production servers.
• Performed AD Utilities such as ADADMIN, Auto patch and ADCTRL etc.
• Good Understanding in Setting up the RMAN backup and recovery Scenarios.
• Worked On Modules like HRMS and Financials.
• Periodically cloning the production server on to Development Server.
• Concurrent Manager Administration & tuning.
• SGA Tuning
• Developing Hot, cold and logical backup scripts to automate the backup procedures. Planning for storage spaces requirements and placing them for optimum I/O performance.
• Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
• Tuning the databases for optimal performance.
• Meeting the end users to know database issues like performance
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Up gradation of Oracle Server and applying Database and Application patches. Writing scripts for the system and database for the effective functionality and report generation.
• Installation of Solaris and other OS and applying patches at OS level.
• Verifying the backups

Environment: Linux, Solaris, windows, Oracle Applications Rel.11i (11.5.9), Oracle 10g/9i, SQL, PL/SQL, TOAD.