SUMMARY:

• Over 11 Plus years of Experience in IT with specialization in Oracle DBA, Oracle Golden Gate, Exadata DMA,Retek DBA)/WebLogic Administration product support, development and implementations.
• Experience in Database Replication using Oracle Golden gate Unidirectional and Bi - directional.
• Experience in configuration Replication method Oracle Golden gate Initial load by using Direct Load method.
• Installation, configuration and administering Oracle Golden Gate replication.
• Experience in configuration OEM Cloud Control 12c to Monitor Exadata database machine.
• Experience in Exadata database machine Initial Configuration.
• Experience in Exadata database machine Storage configuration.
• Experience in Exadata Process Familiarization, High Availability, Object Familiarization, Smart Flash Cache Familiarizaton.
• Experience in Migrating Database to Exadata using Transportable Table space .Experience in Tuning database/Application for Exadata features.
• Experience in Exadata Bulk Data loading by using oracle DBFS.
• Experience in Implement of oracle Active Data guard on Exadata database.
• Experience in Implement of adding Far Sync Instance Active Data guard.
• Experience Install, Patch, Upgrade, Maintain Oracle E-Business Suite 12.2.
• Experience in Upgrade Oracle E-Business Suite 12.2 to 12.2.4.
• Implementation of Oracle Retail modules such as ORMS (merchandising system), ORPOS (Stores Implementations).
• Experienced in Real Application Clusters (RAC) installation and Configuration and Maintain.
• Configuration and setup of web and application server instances including Clustered and Non-Clustered environment - Load balancing setup and Maintenance.
• ORACLE database used as primary relational database, perform timely escalation of critical production incidents and proactively identify patterns of recurring incidents to improve service stability
• Expertise in deploying Oracle Retail Suites. Products involved RMS, ALLOCATION, RPM, REIM, RIB, ORCO, ORBO, ORPOS and SIM.
• Expertise in deploying Oracle SOA Suite Product.
• Performance Tuning, Table & index partitioning, generating & analyzing explain.
• Expertise database migration, capacity growth planning, Backup and Recovery.
• Experienced in Oracle Single sign on setup (SSO, OAM and OID,WEBGATE,WEBTEIR,).

TECHNICAL SKILLS:

Application Servers: Oracle WebLogic Server, Oracle Application Server, Oracle FormsSingle Sign On Oracle Access Manager, OIM, OID

RDBMS: Oracle 11g, Oracle 12c, 12c Golden gate.X4-2Exadata database.

Languages/Scripting: Pro*C, PL/SQL, UNIX Shell Scripting

Tools: & Utilities Oracle Forms builder, RMAN, Toad, SQL Developer, OEM

Operating System: Windows 7, LINUX, UNIX, Sun Solaris,AIX

PROFESSIONAL EXPERIENCE:

Confidential

Sr.Oracle DBA/FMW DBA

Responsibilities:

• Installation & configuration of Middleware technologies including SOA Suit, Forms server, WebLogic server, OID (for LDAP authentication).
• Installation & Configuration of Oracle Golden gate 12c for Database Replication (Unidirectional and Bi-directional).
• Implemented of oracle Active Data guard for Zero Data loss.
• Experience in Create, Manage, and monitor Physical Standby Databases.
• Implemented 12c OEM for Database Performance Monitoring.
• Handled large database, DB size is 7 TB and Upgraded Oracle RAC database from 11g to 12c.
• Installation, Upgradation, configuration, testing and troubleshooting of Oracle Databases for Oracle SOA Suite and PLM modules.
• Establish and maintain sound backup and recovery policies and procedures.
• Performs ongoing tuning of the database instances.
• Enforces and maintains database constraints to ensure integrity of the database.
• Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Assists with impact analysis of any changes made to the database objects.
• Troubleshoots with problems regarding the databases, applications and development tools.
• Create new database users as required. Manage sharing of resources amongst applications.
• Identifying and optimizing the queries causing bottlenecks.
• Used OEM/AWR/ADDM tools for performance monitoring.
• Automated the tasks with Shell scripting.
• Database cloning using with RMAN.

Confidential

Lead Oracle DBA/Exadata DMA/FMW DBA

Responsibilities:

• Installation of Oracle Retail Applications of Retail v14.
• Upgraded Oracle Retail Applications from Retail v14 to v15
• Installation & configuration of Oracle 12c RAC and 12c cluster WebLogic servers for Oracle Retail Products.
• Implemented Oracle Single Sing On for Retail Application.
• Experience in configuration OEM Cloud Control 12c to monitor Exadata database machine.
• Experience in Migrating Database to Exadata using Transportable Tablespace .Experience in Tuning database/Application for Exadata features.
• Experience in Installing, Patching of Oracle DB and Applications.
• Implemented Oracle Fusion Middleware Product on top of Web logic server cluster environment.
• Review, design, develop, document and implement data models as per user requirements.
• Working with Oracle Support services through Oracle Metalink.
• Preparation of DBA works plans, Perform Daily, Weekly and Monthly tasks of the DBA.
• Experience in configuration and implementation of Disaster Recovery Systems.
• Installation, upgradation, configuration, testing and troubleshooting of Oracle Databases for Oracle Retail.

Confidential

Lead Oracle DBA

Responsibilities:

• Installation & configuration of 11g RAC database for Retail Application.
• Design Architecture, installation and Administration of Oracle Databases and WebLogic Servers to Address Business process.
• Implemented Oracle retail application for High availability &Load Balancing on top of WebLogic servers cluster environment.
• Implemented oracle stream for data replication.
• Performs ongoing tuning of the database instances.
• Testing of the Oracle Retail Application as per Defined design.
• Design Architecture, installation and Administration of Oracle Databases and WebLogic Servers.
• Performing the Operational DBA Duties like Modifying the Initialization parameter of the Database, I/O and Application tuning to improve the system performance.
• Regular monitoring of databases for any locks and their resolutions so that the customer does not face any performance issues.
• Environment creation of Retail Modules for Development and Support.
• Supporting the Implementation during the Cut Over from Offshore.
• Design Oracle Retail Infrastructure Architecture to Address Business process.

Confidential

Sr.Oracle DBA/FMW

Responsibilities:

• Installation & configuration of Oracle Retail Applications Retail v13.
• Implemented Oracle Single Sing On for Retail Application.
• Provide Level 2 and Level 3 support for Oracle Retail.
• Applying the Mandatory and conditionally required patches.
• Installation, upgradation, configuration, testing and troubleshooting of Oracle Databases for Oracle Retail and PLM modules.
• Implemented and maintained database security (create and maintain users and roles, assign privileges).
• Establish and maintain sound backup and recovery policies and procedures.
• Raising Service Request to Oracle when there is bugs in base code and conducting web conferences till it got resolved/solution delivered.
• Applying different type of oracle retail patches across all the environment.
• Create new database users as required. Manage sharing of resources amongst applications.
• Identifying and optimizing the queries causing bottlenecks.
• Used OEM/AWR/ADDM tools for performance monitoring.
• Installation & configuration of Middleware technologies including Forms server, Weblogic server, OID (for LDAP authentication).
• Automated the tasks with Shell scripting.
• Database cloning using with RMAN.

Confidential

Oracle DBA

Responsibilities:

• Planning, Installation and Integration of different modules of Oracle Retail Applications from CRP to production, Supported the Implementation during the Cut Over from Offshore/Onsite
• Applying different type of oracle retail patches across all the environment

Confidential

Oracle DBA

Responsibilities:

• Created environments of Retek 13 suit for Development, CRP and System and integration testing. Products involved RMS, RIB, RPM, SIM, and REIM and Implemented and Integrated Retail products with Custom Modifications.
• Create technical documents for online modules (Oracle Forms) as well as batch (Pro*C / PL/SQL) and Developed and modified data conversion scripts.

Confidential

Oracle DBA

Responsibilities:

• Analyze existing system process and identify points of pain. Gather requirements for different batches item, pricing, store hierarchy, merchandising hierarchy and employee.
• Integrate between ORPOS and EBS.
• Prepared Technical and functional documentations and presentations.
• End-to-End flow testing between all Retail products and E-Business.
• Support given to onsite and offshore teams.

Confidential

Oracle DBA

Responsibilities:

• Environment creation for development and Support and system and integration testing. Products involved RMS, RIB, RPM, SIM, and REIM.
• Installation and configure oracle point of sales (POS).

Confidential

Oracle APPS DBA/Retek DBA

Responsibilities:

• Environment created and integrated, Products involved RMS, RIB, RPM, SIM, and REIM.
• Installation and configuration of Oracle EBusiness suite and oracle database on different operating system.
• Database instance tuning (buffers, logs, latches, locks).
• Database object tuning (table reorganizations, index rebuilds).
• Providing SQL tuning expertise to application developers on a consultative basis.

Confidential

Oracle DBA

Responsibilities:

• Creation of Endeavor Packages for movement of the changed elements to production and delivering the changed software elements to onsite coordinators who will be coordinating in moving them to production.
• Developing and maintain tools that automate repetitively performed tasks in the project.