Oracle11i Apps Dba Resume
Pittsburgh, PA
PROFESSIONAL SUMMARY
Having 9+ Years of goal oriented professional experience in the field of Information Technology with complete focus on Oracle Technologies as an Oracle11i/R12 Apps DBA, Oracle8i/9i/10g DBA, Oracle9i/10g RAC DBA and Oracle8i/9i/10g Developer (SQL, PL/SQL, Forms and Reports) providing 24/7 support of Production, Development and Test instances on Various platforms in Unix environments like Sun Solaris, HP-UX, IBM-AIX, Linux and Windows. An extensive experience in Design, Analysis, installation , implementation , maintenance, supporting, configuring and managing Oracle11i Applications and worked with major industry leaders.
- Thorough understanding of Oracle E-Business Suite R11i/R12 architecture, Oracle9i/10g Database Architecture and Oracle9i/10g RAC architecture.
- Design, Analysis, installation , implementation , maintenance, supporting, configuring and managing
Oracle E-Business Suite Applications (11i/11.5.8/11.5.9/11.5.10/R12) Financials, Manufacturing, HRMS,
Order Management, SCM, Marketing/Sales, Service, Projects and CRM, Oracle Retail etc.
- Installation, Configuration and Maintenance and Tuning of Oracle8i/9i/10g Database and Oracle9i/10g RAC on various operating systems.
- Implementation, installation and cloning Oracle Applications, maintaining concurrent manager processes, Patching, space management issues and User management issues related to Oracle Applications, registration of forms and reports which were developed as part of customization process with Oracle Applications.
- Cloning Oracle Applications by using Rapid clone utility and troubleshooting post clone issues.
- Upgradation of Oracle Applications.
- Debugging and troubleshooting of the Oracle E-Business applications and Oracle Databases.
- Expertise in AD utilities like adadmin, adpatch, admrgpch, adrelink, adaimgr, adctrl etc.
- Performed Application of Patches by using Autopatch (adpatch).
- Patching Performed for RDBMS patches.
- Installation, Implementation and Configuration of Oracle Fusion Middleware like Oracle9i Application server, Oracle Application Server 10g,Oracle Single Sign On, Oracle Internet Directory,LDAP,Oracle Identity Management, Oracle Discoverer and SOA Suite.
- Installation and configuration of OBIEE.
- Excellent skills in database administration, backup and recovery activities, Performance tuning of Oracle RDBMS and Oracle Applications and cloning the databases.
- Oracle11i apps Installation on various platforms by using Rapid Install.
- Successfully did post implementation reviews of many 11i apps implementations..
- Troubleshooting of the Concurrent managers
- Applications System administration tasks like creating and Managing Users and their responsibilities.
- Creating Menus and functions and Assigning forms to the users.
- Creating custom concurrent Managers and assigning work shifts to them.
- UNIX/LINUX shell scripting and PERL scripting.
- Posses Good skills in managing the Oracle resources for logical structures.
- Backup and Recovery by using RMAN and Manual backup and recovery.
- Monitoring and reorganizing the Tablespaces.
- Creating database users, roles, profiles and privileges.
- Management of Redolog files, Control files and monitoring data files.
- Experienced in using Oracle Server Utilities like Export, Import, and SQL Loader.
- Experience in Oracle9i/10g Enterprise Manager(OEM).
- Strong back-end designing and written extensive backend code on the Oracle server-side using SQL and PL/SQL including stored procedures, stored functions, packages, database triggers.
CERTIFICATIONS
- Oracle9i Database Administrator Certified Professional (OCP) from ORACLE CORPORATION.
- Oracle9i Pl/SQL Developer Certified Associate (OCA) from ORACLE CORPORATION.
- Master of Science in Information Technology.
- Post Graduation Diploma in Computer Applications.
Operating Systems: Sun Solaris, LINUX, HP-UX, IBM-AIX, Windows 97/98/2000/XP, MS-DOS.
Languages: Sql, Pl/Sql, C, Pro*c
G.U.I.: Oracle6i/9i/10g Forms and Reports, Visual Basic 6.0
Database: Oracle7.x.8.x, 8i, 9i, 10g Databases, Oracle9i/10g RAC Database, MS-SQL Server, Ms-Access.
E.R.P: Oracle Applications 11i/11.5.8/11.5.9/11.5.10 and R12 (Financials, Manufacturing, HRMS, CRM, MRP, Order Management, Purchasing, Oracle Supply Chain Management, iStore, iProcurement, isupplier, and Workflow etc).
Scripting Languages: UNIX shell Scripting, Perl Script, HTML, VB Script.
Oracle Tools and Utilities: Oracle Discoverer, OBIEE, Oracle9i Application Server, Oracle Application server 10g,SOA Suite,BPEL, Recovery Manager (RMAN), OEM, Sql*Plus, Sql Loader, Toad, sql developer, Pl/sql Developer etc.
Jul’2008 to till date
Confidential,Pittsburgh, PA.
Role : Oracle11i APPS DBA and Oracle10g DBA.
Environment : HP-UX, Oracle10g Database, Oracle Application Server 10g,Oracle SOA Suite, RMAN, TOAD,Oracle10g Enterprise Manager(OEM),Oracle11i Applications 11.5.10.2(Oracle Financials, HRM, Manufacturing, Projects, ASCP, Inventory, Supply Chain Management, Order Management, Purchasing, Marketing/Sales, CRM etc.)
Responsibilities:
- Maintenance, Supporting and Configuration of Oracle Applications 11.5.10.2 on Multi nodes.
- Oracle11i Applications Upgrading, Cloning and Patching.
- Applied Application Patches and Database patches as per requirements.
- Applied Individual and Merged Patches in multiple testing/development and production environment having multiple nodes and shared APPL_TOP.
- Applied Family and Maintenance pack.
- Upgraded the Oracle Applications Database from Oracle9i to Oracle10g.
- Performance Tuning of Applications and Database.
- Closely work with Dev Team to fix their Issues.
- Providing the 24X7 production support to all the instances.
- Troubleshooting the Applications servers (web server, forms server, concurrent processing server etc.)
- Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers, re-schedule requests, purging the concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent manager operations.
- Installation, Implementation and configuration of Oracle Fusion Middleware like Oracle Application Server 10g, Oracle Single Sign On (SSO), Oracle Internet Directory, LDAP, Oracle Identity Management, Oracle10g Portal, Oracle10g Discoverer etc.
- Set up and Configuration Oracle SOA Suite.
- Written UNIX shell scripts.
- Performed System Admin. Tasks.
- Managing front-end application users, responsibilities, and data groups.
- Performing DB Refresh in time.
- Creation of new scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring.
- Oracle Database Security and Auditing.
- Managing the Tablespaces, Datafiles and Redologs.
- Managing and administering users, profiles, roles and privileges according to requirement.
- Monitoring and controlling the user access to the Database.
- Creating and Managing database objects like tables, views and indexes. Finding and re-validating invalid database objects.
- Backup and Recovery.
- Involved in SQL and PL/SQL programming.
- Administering and Maintaining the Oracle Database by SQL scripts, PL/SQL programming, TOAD and Oracle10g Enterprise Manager (OEM) utilities.
Oct’2007 to July’2008
Confidential,Raytown, MO.
Role: Oracle11i/R12 APPS DBA and Oracle9i/10g DBA
Environment: SUN SOLARIS 5.10, Oracle9i/10g Database,Oracle10g RAC, Oracle Application Server 10g, Oracle10g Discoverer, Oracle SOA Suite, OBIEE, TOAD, Oracle9i/10g Enterprise Manager(OEM), Oracle Applications 11.5.10.2/R12 (Manufacturing, CRM, Oracle Financials, Projects, ASCP, Inventory, Order Management, Purchasing, Oracle Retail etc.), RMAN.
Responsibilities:
- Installing and configuring the applications on multi node.
- Applications Upgrading, Cloning and Patching.
- Upgraded the Oracle Applications Database from Oracle9i to Oracle10g.
- Involved in Installation of Oracle Applications 11.5.10.2 and R12 on TEST environments.
- Upgraded the Oracle11i Applications from 11.5.10.2 to R12.
- Installation, Implementation and configuration of Oracle Fusion Middleware like Oracle Application Server 10g, Oracle Single Sign On(SSO),Oracle Internet Directory,LDAP,Oracle Identity Management, Oracle10g Portal, Oracle10g Discoverer etc.
- Involved in Implementation Oracle SOA Suite.
- Performance Tuning of Applications and Database.
- Installation and Configuration of Oracl10g RAC systems and ASM instances.
- Troubleshooting the Applications servers (web server, forms server, concurrent processing server etc.)
- Monitoring Applications, Database Backups and Involved in Backup and Recovery by using RMAN.
- 24/7 Administration Activities and Support.
- System Administration tasks like creation of users and responsibilities, managing and controlling users and responsibilities.
- Menu and functions creations, profile options settings, Creation of Request Group, Data group, value sets and Flex Field setups and printer setups and trouble shooting the printer setup issues.
- Installed and configuration of OBIEE.
- Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers, re-schedule the requests, purging the concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent manager operations.
- Creation of Tablespaces, users, profiles and roles according to requirement.
- Managing and controlling database files, redolog files and control files.
- Creating and Managing database objects like tables, views and indexes. Finding and re-validating invalid database objects.
- Monitoring and controlling the user access to the Database.
- Administering and Maintaining the Oracle Database by SQL scripts, PL/SQL programming, TOAD and Oracle9i/10g Enterprise Manager (OEM) utilities.
- Automated Health checks through Shell Scripting.
- Trouble shooting for the development database.
May’2006 to Aug’2007
Confidential,Newark, NJ
Role: Oracle11i APPS DBA and Oracle9i/10g DBA
Environment: SUN SOLARIS, Oracle9i/10g, Oracle10g RAC,TOAD, RMAN,Oracle Enterprise Manager(OEM),Oracle Application Server 10g,SSO,Oracle SOA Suite, Oracle Applications 11.5.9/11.5.10(Oracle Financials, Oracle Cash Management,Marketing/Sales,HRMS,CRM etc)
Responsibilities:
- Installing, Implementation and configuring fresh Oracle 11.5.9 Applications on Sun Solaris OS using Rapid Install.
- Performed Application cloning using Rapid Clone utility.
- Applied Application Patches as per requirements.
- Applied Family and Maintenance pack.
- Applied RDBMS patches using Opatch.
- Upgrading Oracle Applications from 11.5.9 to 11.5.10.
- Upgrading Oracle Applications Database from 9i to 10g.
- Supported and Maintained the Oracle10g RAC systems.
- Involved in Installation, Implementation and configuration of Oracle Fusion Middleware like Oracle Application Server, Oracle Single Sign On (SSO), Oracle Internet Directory, LDAP, Oracle Identity Management, Oracle Discoverer etc.
- Configure the system and application environmental parameters using AutoConfig Utility.
- Closely work with Dev Team to fix their Issues.
- Providing the 24X7 production support to all the instances.
- Managing Application servers (Web server, Form server, Report Server etc).
- Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers, re-schedule the requests, purging the concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent manager operations.
- Written Unix/Linux shell scripts.
- Performed System Admin. Tasks.
- Managing front-end application users, responsibilities, and data groups.
- Performing DB Refresh in time.
- Creation of new scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring.
- Creation of Tablespaces, users, profiles and roles according to requirement.
- Creating and Managing database objects like tables, views and indexes. Finding and re-validating invalid database objects.
- Monitoring and controlling the user access to the Database.
- Administering and Maintaining the Oracle Database by SQL scripts, PL/SQL programming, TOAD and Oracle9i Enterprise Manager (OEM) utilities
- Backup and Recovery by RMAN utility.
Jul’2005 to Apr’2006
Confidential,IN.
Role: ORACLE11i Apps DBA and ORACLE9i DBA
Environment: IBM-AIX, Oracle9i Database, Oracle9i RAC, Oracle Enterprise Manager (OEM), TOAD, RMAN, Oracle Applications 11.5.9(Oracle Financials, HRM, Oracle Fixed Assets, Order Cash Management, Iprocurement, CRM) etc.
Responsibilities:
- Installing, configuring and supporting the Oracle11i applications on multi node.
- Implemented Oracle Financials11i Project Accounting, Accounts Payable and Accounts Receivable for three European locations in a Multi-Org, Multi-Reporting, Global Accounting environment.
- Setup and implementation of Oracle Financial Analyzer.
- Maintained proactive interaction with the client to understand business practices to aid in system configuration.
- Provided analysis, design, installation and rollout of Oracle11i Accounts Payable and Purchasing.
- Delivered operational analysis, business process re-evaluation, user training and testing of modules.
- Designed customized reports, fit gap analysis and all documentation and deliverables.
- Handled connection issued, bank related problems and printer installations.
- Applications Upgrading, Cloning and Patching.
- Performance Tuning of Applications and Database.
- Involved in installation and implementation of Oracle9i RAC systems.
- Maintaining and Troubleshooting the Applications servers (web server, forms server, concurrent processing server etc.)
- Configuring the Apache webserver, Metricserver, Formsserver and admin server.
- Monitoring Applications and Database Backups.
- 24/7 Administration Activities and Support.
- System Administration tasks like creation of users and responsibilities, managing and controlling users and responsibilities.
- Menu and functions creations, profile options settings, Creation of Request Group, Data group, value sets and Flex Field setups and printer setups and trouble shooting the printer setup issues.
- Managing and trouble shooting concurrent managers, concurrent programs and concurrent requests issues.
- Creation of Tablespaces, users, profiles and roles according to requirement.
- Managing and controlling database files, redolog files and control files.
- Creating and Managing database objects like tables, views and indexes. Finding and re-validating invalid database objects.
- Monitoring and controlling the user access to the Database.
- Automated Health checks through Shell Scripting
- Trouble shooting for the development database.
- Maintained and Managed the Database by using OEM and SQL scripts.
Aug’2004 to Jul’2005
Confidential,KS.
Role: Oracle11i APPS DBA and Oracle9i DBA
Environment: HP-UX, Oracle9i Database, Oracle9i Enterprise Manager (OEM), TOAD, RMAN, Oracle Applications 11.5.9(Oracle Financials, HRM, Oracle Fixed Assets, Order Cash Management, Iprocurement, CRM) etc
Responsibilities:
- Installing and configuring the Oracle11i applications on multi node systems.
- Applications Upgrading, Cloning and Patching.
- Performance Tuning of Applications and Database.
- Troubleshooting the Applications servers (web server, forms server, concurrent processing server etc.)
- Configuring the Apache web server, Metric server, Forms server and admin server.
- Monitoring Applications, Database Backups and Involved in Backup and Recovery by using RMAN.
- System Administration tasks like creation of users and responsibilities, managing and controlling users and responsibilities.
- Managing and troubleshooting of Concurrent Managers.
- Menu and functions creations, profile options settings, Creation of Request Group, Data group, value sets and Flex Field setups and printer setups and trouble shooting the printer setup issues.
- Installation, Implementation, Configuration and Troubleshooting of SSO/OID and Oracle application server.
- Installed and configuration of OBIEE.
- Creation of Tablespaces, users, profiles and roles according to requirement.
- Managing and controlling database files, redolog files and control files.
- Creating and Managing database objects like tables, views and indexes. Finding and re-validating invalid database objects.
- Monitoring and controlling the user access to the Database.
- Automated Health checks through Shell Scripting
- Trouble shooting for the development database.
- Performed the Oracle Database Utilities like Oracle Enterprise Manager(OEM),TOAD and RMAN etc.
- Performed Configuration management tools Clear Case and Clear Quest.
- Supported the Configuration and Change Management Processes and Procedures.
- Designed and maintained the VOBs and the Views (Snapshot and Dynamic).
- Created and maintained Clear Quest users and groups, queries and reports.
Jan’2004 to Jun’2004
Confidential,OH.
Organization: Cozent Software Solutions, Hyderabad, India.
Role: Oracle11i APPS DBA and Oracle9i DBA
Environment: SUN SOLARIS, Oracle9i, Oracle9i Application Server, SSO, OEM, TOAD, RMAN, Oracle Applications 11.5.8/11.5.9, (Manufacturing, Financials, Oracle Retail, Inventory, Order Management, Purchasing, Supply Chain Management etc.)
Responsibilities:
- Installing/Configuring fresh Oracle 11.5.9 Application / Database on Sun Solaris OS using Rapid Install.
- Performed Application cloning using Rapid Clone utility.
- Applied Application Patches as per requirements.
- Applied Family and Maintenance pack.
- Applied RDBMS patches using Opatch.
- Upgrading Oracle Applications from 11.5.8 to 11.5.9.
- Configure the system and application environmental parameters using AutoConfig Utility.
- Closely work with Dev Team to fix their Issues.
- Managing Application servers (Web server, Form server, Report Server etc).
- Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers, re-schedule the requests, purging the concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent manager operations.
- Written Unix/Linux shell scripts.
- Performed System Admin. Tasks.
- Managing front-end application users, responsibilites, and data groups.
- Performing DB Refresh in time.
- Creation of new scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring.
- Creation of Tablespaces, users, profiles and roles according to requirement.
- Creating and Managing database objects like tables, views and indexes. Finding and re-validating invalid database objects.
- Monitoring and controlling the user access to the Database.
- Backup and Recovery.