OBJECTIVE:

To obtain a challenging software consultant position with an opportunity to work as an Oracle applications DBA/Data warehouse Architect utilizing my ORACLE, ORACLE APPLICATIONS, UNIX, C, C++, JAVA, SQL, OBIEE, INFORMATICA, HYPERION and PL/SQL skills.

SUMMARY:

• 17 years experience as an Oracle applications DBA, 17 years experience as a physical and logical Oracle
• DBA. Strong skills of Oracle applications, Oracle databases and management tools.
• Administered the databases of 16 TB size through the complete cycle of projects. Strong expertise in performance tuning, backup recovery, Architecture, Capacity Planning and troubleshooting.
• Ability to work effectively in a team environment and provide logical and efficient solutions. Strong sense of ownership and commitment to technical excellence. Strong communication, Presentation and Customer Management Skills.
• Installation, maintenance, cloning, Patching and upgrade of Oracle applications HRMS and Financials.
• Installation, upgrade, Patching and management of Oracle databases on Unix and Windows Platforms.
• Logical and Physical design of Oracle databases using Erwin.
• Strong skills of Oracle applications Architecture and Oracle application stack.
• Strong skills of Performance tuning and optimization of Oracle databases and applications.
• Design and Implementation of backup and recovery, disaster Planning and failover plans.
• Installation, configuration and support of Oracle WebLogic and Other Fusion Midlleware Components.
• Design and Implementation of data warehouse including Dimensional Modeling.
• Strong skills of Data modeling, Data warehouse, Data Mining, Informatica and ETL tools.
• Design, Implementation and Administration of distributed databases and Oracle Replications.
• Capacity Planning, Architecture Recommendations and Project Management.
• Creation of table spaces, datafiles, roles, redo logs, rollback segments, stored procedures and Triggers
• Strong skills in SQL* Loader, Import/Export Server Manager, SQL* PLUS, PL/SQL, Developer 2000, Unix Shell scripts, awk, 'C' programming.
• Strong skills of Unix, Network, Tuxedo, Weblogic, Apache, Oracle 10gAS and iPlanet administration.
• On call technical support for 24x7 mission critical production databases
• Used n - tier architecture design extensively.
• Mentoring Junior team member.

TECHNICAL SKILLS:

Good skills: C++, Java, XML, Perl, Visual Basic, JSP, ASP, OID, EDI, OAM.

Databases: Oracle 12c, Oracle 11g, DB2, SQL Server 2008, Sybase, Informix and MS-Access

Tools: SQL* Loader, Import/Export, ERWIN 3.5, Oracle grid 12c, SQL Enterprise Manager, Sybase Central, Sun Cluster, Rman, Discoverer,,OBIEE

Platform: Sun Solaris E25K, HP - PA8700, Confidential p690, Windows 2008 Servers

Operating Systems: HP-UX 11i, Linux, AIX 5L, Solaris 9 to 10, Windows 2003, and Windows 2008

Languages: 'C', C++, 'SQL', SQL*PLUS,'PL/SQL', Shell Scripting, Perl, Java, CGI.

EXPERIENCE:

Oracle ERP Architect/DBA (Tech Lead)

Confidential, Dallas, TX

Responsibilities:

• Upgrade of Oracle apps from 11.5.10.2 to 12.2.4 and 12.2.5
• Upgrade of Oracle database from 11g to 12c
• Set up of Parallel Conc Processing for High Availability on Conc Managers Nodes.
• Installation, Configuration and Administration of Oracle OEM 12c.
• Strong Skills of Oracle Container database(CDB) and Pluggable database(PDB) features.
• Used Oracle 12 C Flex ASM and Hub and Leaf Nodes for Oracle 12c RAC .
• Administration, Configuration and Tuning of Informatica and Informatica Mappings.
• Installation, configuration and support of Oracle WebLogic and Other Fusion Midlleware Components.
• Setup of High Availability for Weblogic server, SOA Suite and Fusion Midlleware.
• Installation and Administration and support of Oracle SOA suite.
• Installation, Configuration and Administration of Exadata using Oracle OEM 12c.
• Set up Online Patching and Editioning with Oracle ERP 12.2.4
• Document the best use of Online Patching and Editioning for the Current Environment.
• Tuning of the databases on Exadata using Oracle Best Practices.
• Tuning of Oracle apps Conc managers, SQL, Tech stack and DB Tier.
• Implemented SOX compliance and set up of security and Auditing on Oracle apps.
• Support to developer for development and upgrade tasks.
• Set up of MAA architecture using Oracle RAC and Dataguard.
• Setup and support for Bi-directional Golden Gate for non apps databases.
• Install and Configure OBIEE and support the development effort.
• Install Oracle apps 12.1.0 and apply patches using adpatch.
• Set up of Shared Appl Tier, SSL for Oracle Applications 12.2.4
• Implement Oracle isupplier, iprocurement, istore using Oracle DMZ configurations.
• Supported Demantra/ASCP and resolved many performance issues.
• Apps dba Support for Demantra/ASCP Instances and ERP instances.
• Implementation of High availability using Load Balancer and RAC 12c on Solaris Platform.
• Installation of Oracle Applications server 10gAS and configure High Availability.
• Implemented Oracle Access Manager with Oracle apps 12.2.4
• Cloning of environments from RAC to non RAC and support to 60 developers.
• Worked for Various Tar Resolutions and worked with Oracle support using Metalink.
• Complete Life cycle implementation of Oracle Financials, Projects, Oracle HRMS and CRM
• Tuning of various data load jobs and database and Oracle apps 12.2.4 Tuning.
• Strong Knowledge of Oracle AIM Methodology

Oracle ERP Architect/DBA (Tech Lead)

Confidential, Texas

Responsibilities:

• Upgrade of Oracle apps from 11.5.10.2 to 12.1.3/12.2.3
• Upgrade of Oracle database from 10g to 11g
• Installation, configuration and support of Oracle WebLogic and Other Fusion Midlleware Components.
• Administration, Configuration and Tuning of Informatica and Informatica Mappings.
• Installation, Configuration and Administration of Exadata with Oracle consulting.
• Strong Skills of Oracle Container database(CDB) and Pluggable database(PDB) features.
• Used Oracle 12 C Flex ASM and Hub and Leaf Nodes for Oracle 12c RAC .
• Tuning of the databases on Exadata using Oracle Best Practices.
• Installation, configuration and support of Oracle WebLogic and Other Fusion Midlleware Components.
• Setup of High Availability for Weblogic server, SOA Suite and Fusion Midlleware.
• Supported Demantra/ASCP and resolved many performance issues.
• Apps dba Support for Demantra/ASCP Instances and ERP instances.
• Installation and Administration and support of Oracle SOA suite.
• Set up of Parallel Conc Processing for High Availability on Conc Managers Nodes.
• Tuning of Oracle apps Conc managers, SQL, Tech stack and DB Tier.
• Implemented SOX compliance and set up of security and Auditing on Oracle apps.
• Support to developer for development and upgrade tasks.
• Set up of MAA architecture using Oracle RAC and Dataguard.
• Setup and support for Bi-directional Golden Gate for non apps databases.
• Install and Configure OBIEE and support the development effort.
• Install Oracle apps 12.1.1 and apply patches using adpatch.
• Set up of Shared Appl top, SSL for Oracle Applications 12.1.3/12.2.3
• Implement Oracle isupplier, iprocurement, istore using Oracle DMZ configurations.
• Implementation of High availability using Load Balancer and RAC 11g on Solaris Platform.
• Installation of Oracle Applications server 10gAS and configure High Availability.
• Implemented Oracle Access Manager with Oracle apps 12.1.3/12.2.1
• Cloning of environments from RAC to non RAC and support to 60 developers.
• Worked for Various Tar Resolutions and worked with Oracle support using Metalink.
• Complete Life cycle implementation of Oracle Financials, Projects, Oracle HRMS and CRM
• Tuning of various data load jobs and database and Oracle apps 12.1.3/12.2.3 Tuning.
• Strong Knowledge of Oracle AIM Methodology.

Oracle ERP Architect/DBA (Tech Lead)

Confidential, Texas

Responsibilities:

• Upgrade of Oracle apps from 11.5.10.2 to 12.1.3.
• Upgrade of Oracle database from 10g to 11g
• Administration, Configuration and Tuning of Informatica and Informatica Mappings.
• Installation, Configuration and Administration of Exadata using Oracle OEM 11g.
• Installation, configuration and support of Oracle WebLogic and Other Fusion Midlleware Components.
• Setup of High Availability for Weblogic server, SOA Suite and Fusion Midlleware.
• Installation and Administration and support of Oracle SOA suite.
• Tuning of the databases on Exadata using Oracle Best Practices.
• Tuning of Oracle apps Conc managers, SQL, Tech stack and DB Tier.
• Set up of Parallel Conc Processing for High Availability on Conc Managers Nodes.
• Implemented SOX compliance and set up of security and Auditing on Oracle apps..
• Support to developer for development and upgrade tasks.
• Install, Upgrade and Maintenance of Oracle Golden Gate bi-directional replications..
• Install and Configure OBIEE and support the development effort..
• Install Oracle apps 12.1.1 and apply patches using adpatch.
• Set up of Shared Appl top, SSL for Oracle Applications 12.1.3
• Implement Oracle isupplier, iprocurement, istore using Oracle DMZ configurations.
• Supported Demantra/ASCP and resolved many performance issues.
• Apps dba Support for Demantra/ASCP Instances and ERP instances.
• Implementation of High availability using Load Balancer and RAC 11g on Solaris Platform.
• Installation of Oracle Applications server 10gAS and configure High Availability.
• Implemented Oracle Access Manager with Oracle apps 12.1.3
• Implementation of MAA architecture using RAC and Dataguard.
• Cloning of environments from RAC to non RAC and support to 40 developers.
• Worked for Various Tar Resolutions and worked with Oracle support using Metalink and OWC.
• Complete Life cycle implementation of Oracle Financials, Projects, Oracle HRMS and CRM
• Tuning of various data load jobs and database and Oracle apps 12.1.3 Tuning.
• Strong Knowledge of Oracle AIM Methodology.

Oracle ERP Architect/DBA (Tech Lead)

Confidential, Texas

Responsibilities:

• Upgrade of Oracle apps from 11.5.10.2 to 12.1.3
• Upgrade of Oracle database from 10g to 11g
• Administration, Configuration and Tuning of Informatica and Informatica Mappings.
• Installation, Configuration and Administration of Exadata with Oracle consulting.
• Installation, Configuration and Administration of Exadata using Oracle OEM 11g.
• Installation, configuration and support of Oracle WebLogic and Other Fusion Midlleware Components.
• Setup of High Availability for Weblogic server, SOA Suite and Fusion Midlleware.
• Supported Demantra/ASCP and resolved many performance issues.
• Apps dba Support for Demantra/ASCP Instances and ERP instances.
• Tuning of the databases on Exadata using Oracle Best Practices.
• Tuning of Oracle apps Conc managers, SQL, Tech stack and DB Tier.
• Implemented SOX compliance and set up of security and Auditing on Oracle apps..
• Support to developer for development and upgrade tasks.
• Upgrade of Solaris 9 to Solaris 10 with Oracle apps 12.
• Install and Configure OBIEE and support the development effort..
• Install Oracle apps 12 and apply patches using adpatch.
• Set up of Shared Appl top, SSL for Oracle Applications 12.
• Implementation of High availability using Load Balancer and RAC 11g on Solaris Platform.
• Installation of Oracle Applications server 10gAS and configure High Availability.
• Implemented Oracle Portal, OID/SSO with Oracle apps 12.
• Cloning of environments from RAC to non RAC and support to 80 developers.
• Worked for Various Tar Resolutions and worked with Oracle support using Metalink and OWC.
• Complete Life cycle implementation of Oracle Financials, Projects, Oracle HRMS and CRM
• Tuning of various data load jobs and database and Oracle apps 12 Tuning.
• Strong Knowledge of Oracle AIM Methodology.

Oracle ERP Architect/DBA (Tech Lead)

Confidential, Knoxville, TN

Responsibilities:

• Upgrade of Oracle apps from 11.5.10.2 to 12.0.4
• Upgrade of Oracle database from 9i to 10.2.0.4
• Administration, Configuration and Tuning of Informatica and Informatica Mappings.
• Tuning of Oracle apps Conc managers, SQL, Tech stack and DB Tier.
• Implemented SOX compliance and set up of security and Auditing on Oracle apps..
• Support to developer for development and upgrade tasks.
• Implement Oracle isupplier, iprocument using Oracle DMZ configurations.
• Install and Configure Oracle Golden Gate for Replication.
• Installation, configuration and Administration of Oracle OBIEE.
• Set up of Shared Appl top, SSL for Oracle Applications 12.1.3
• Implementation of High availability using Load Balancer and RAC 11g on Solaris Platform.
• Installation of Oracle Applications server 11gAS and configure High Availability.
• Implemented Oracle Portal, OID/SSO with Oracle apps 12.
• Cloning of environments from RAC to non RAC and support to 40 developers.
• Worked for Various Tar Resolutions and worked with Oracle support using Metalink and OWC.
• Complete Life cycle implementation of Oracle Financials, SCM, Projects, Assets, iStore in 500 sites.

Oracle ERP Architect/DBA (Tech Lead)

Confidential, Chicago

Responsibilities:

• Upgrade of Discoverer 4i to 10g and Training
• Supported the Cognos Planning and Cognos report.
• Supported the functional team for various tars in Treasury, iStore, Financials, PJP, Projects.
• Administration, Configuration and Tuning of Informatica and Informatica Mappings.
• Support to developer for Informatica Development.
• Upgrade of Solaris 9 to Solaris 10 with Oracle apps.
• Tuning of RAC, Conc. managers, SQL and Tech Stack, Forms etc,
• Implemented Sox compliance and Set up of Auditing in Oracle apps.
• Install and Configure Mercury ITG, Object Migrator, Load Runner.
• Help the Customer in the Migrations etc using ITG and OM.
• Install Oracle apps 11.5.10.2 and apply patches using adpatch.
• Set up of Shared Appl top, SSL for Oracle Applications 11.5.10.2.
• Implementation of High availability using Load Balancer and RAC 10g on Solaris Platform.
• Installation of Oracle Applications server 10gAS and configure High Availability.
• Implemented Oracle Portal, OID/SSO with Oracle apps 11.5.10.
• Cloning of environments from RAC to non RAC and support to 25 developers.
• Worked for Various Tar Resolutions and working with Oracle support using Metalink and OWC.
• Complete Life cycle implementation of Oracle Financials and HRMS in 10 countries.
• Worked with Oracle support using Metalink and OWC for tar resolutions.

Oracle ERP Architect/DBA (Tech Lead)

Confidential, Dallas, Texas

Responsibilities:

• Implementation of High Availability for Oracle ERP 11.5.10 having Order management.
• Implemented Oracle 10g RAC and Load Balancer on Linux.
• Integration of Oracle apps server 10g with Oracle ERP 11.5.10.
• Cloning, Patching, performance tuning of Instances.
• Worked as Customer Contact for Oracle on Demand Solution.
• Advised the Customer for new products and directions in Oracle ERP.
• Supported the oracle apps 11.5.10.2 with istore, iprocurement, isupplier, Inventory, Order Management.

Sr. Consultant (Oracle Applications Architect)

Confidential, Dallas Texas

Responsibilities:

• Implementation of Single Sign on using Oracle Internet Directory OID.
• Installation and implementation of Oracle 10g Application server.
• Installation and Administration of Hyperion Essbase, Planning, Reports, Analayzer.
• Upgrade of Oracle apps from 11.5.9 to 11.5.10.
• Performance Tuning of Oracle ERP 11.5.9 having Manufacturing, Financials and Supply Chain.
• Design of Architecture of Oracle ERP 11.5.9 for High Availability and Scalability.
• Implementation of Hardware Load Balancing for forms and Apache.
• Tuning the Various Components of Oracle apps like Tech Stack, Conc. managers, DB Tier, SQL etc.
• Implemented Sox Compliance and set up of Oracle apps Auditing.
• Implementation of Oracle Real Applications Cluster (RAC) for ERP 11.5.9.
• Design and Implementation of Physical and Logical Standby databases using Data Guard.
• Design and Implementation of Backup using Rman.
• Implementation of Hyperion Planning, Analyzer and Reports.
• Installation of Hyperion Essbase, Planning, Reports and Analyzer.
• Worked as Solution Architect for Oracle Applications and Hyperion.
• Design and Implementation of Disaster Recovery Strategy.

Sr. Consultant (Oracle Applications Architect)

Confidential, Texas

Responsibilities:

• Upgrade of Oracle applications from 11.5.8 to 11.5.9.
• Patching of Multi Node Oracle apps instances having GL, FA, AP, AR and Projects.
• Cloning of Multi Node Oracle apps instances using Rapid Clone.
• Configuration of Oracle Workflow and Oracle Approvals Management Engine (AME).
• Capacity Planning, Project Management and Architecture Recommendations.
• Implementation and Upgrade of Noetix Views.
• Strong Knowledge of Oracle Applications Architecture and Applications Object Library (AOL).
• Troubleshoot the issues related to Forms, Reports 6i, database, Apache and Concurrent Manager.
• Tuning of the Concurrent Manager using specialized Concurrent Managers.
• Upgrade of Oracle databases from Oracle 9.2 to Oracle 10g.
• Implementation of Load Balancing for Forms Server.
• Implementation of Backup and Recovery strategy using Shadow Image and Veritas Netbackup.
• Tuning the Oracle databases and Batch Processes using Statspack, SQL Trace, and Explain Plan.
• Upgrade of Oracle Applications Server to 9iAS and Discoverer 4i.
• Implementation of Physical and Logical Standby databases using Data Guard.
• Installation and Configuration of Oracle Retail (Retek) 11.x with RMS, AIP, POS, RPAS modules.
• Used Oracle OEM and Quest tools extensively for Database Monitoring and Troubleshooting.
• On Call Support for 24x7 Mission Critical Production databases having Oracle apps Financials.
• Mentoring the junior Team Members.

Sr. Consultant (Oracle Applications DBA)

Confidential, Texas

Responsibilities:

• Design and Implementation of High Availability for Oracle 9iAS Portal.
• Installation of Oracle 10g Applications server and Site Minder 5.x
• Implementation of SSL and single sign on.