SUMMARY:

• Having 10.2 years in experience Oracle Applications 11i, R12.1 and R12.2, Database administrations in RAC and core environment. Provides database support on various standalone core databases of 11g, 12c environments.
• Involved in ORACLE Database Installing, Administering & Configuring on RH Linux, OEL, Solaris and HP - UX. Implementing and providing service, support and maintaining Oracle Application 11i, R12, 12.2 & 9i, 10g 11g and 12c Databases.
• Database & Application disaster recovery (DR/standby) setup, maintenance and DR testing
• Migrated successfully Oracle EBS customer from on premises to Amazon Web Services(AWS) Cloud.
• Administration of Oracle Exadata machines and exposure to Exalogic environments.
• R12.2.5 upgrade and support. Online patching using ADOP.
• Datacenter migration, worked on three customers datacenter migration projects to modern datacenter.
• Experienced in leading a Team and holding calls with clients interactively and therefore ensuring timely deliveries of services and support to the database and application instances.
• Providing support and maintaining Oracle Databases from 9i, 10g and 11g, 12c running on Oracle EBS 11i/ R12 along with other applications such as OBIEE, Discoverer, Agile, Hyperion.
• Provides on-call support for production environment.
• Performs root cause analysis for system outages and different critical user raised issues.
• Creates problem records of repetitive issues for analysis, identifying solution and implementing fix.
• Effectively communicates to internal and external stake-holders.
• Ability to lead teams and take decisions and a good team player.
• Ability to manage client expectations, foresee risks and manages the team.
• Strong troubleshooting skills and performance tuning skills.
• Good communication and interpersonal skills.
• Highly motivated to resolve problems efficiently. Hardworking and dedicated personality.
• Analyze & provides task details to offshore team for the execution of the work. Handles task/activities assignment and allocations to the offshore team members. We work on a 24/7 environments.
• Following up on task status about its progress for the delivery and works on it to the accomplishment.
• Creating and ensuring the documents is in place for all our regular activities.
• Maintaining document repository for all issue and fixes of our support activities.
• Involves with task planning, co-ordination, resource allocation, task execution, periodic status update and documentation.
• Playing active role in coordinating internal team meeting with onshore and offshore teams.
• Taking feedback for all our support activities and making sure for better delivery and improving the process development.
• Coordinating among various stakeholder for the delivery of the assigned tasks and periodic reviews on the deliverables.
• Building templates on delivery activities for process adherence and improvements.

CAREER SUMMARY:

• Installation of Oracle Application 11.5.10, 11.5.10.2, Release 12, 12.1.1 & 12.1.3 and 12.2 on RHEL, OEL & Solaris.
• Worked on multiple Oracle Application upgrades for different customers from 11.5.10.2 to R12 (12.0.3, 12.1.1 & 12.1.3). Performed recent upgrade from R12.1.3 to R12.2.5. Along with the different databases upgrades from to latest releases such as 11.2.0.3, 11.2.0.4, 12.1.0.1, 12.1.0.2
• Migration to (AWS) Amazon Web Services Cloud, worked as a lead dba for my supported customer Confidential
• This migration was from premises to AWS Cloud (Amazon Web Services). Confidential customer having foot print of Oracle EBS 12.1.3 running on 11.2.0.3 database. Successfully migrated the customer’s 12.1.3 EBS application & 11.2.0.3 database to Amazon Web Services Cloud.
• Providing day to day support, migrate codes, performs regular refreshes/clone in AWS cloud.
• Datacenter migration project, worked on datacenter migration projects for 3 customers. Two customers migrated their Oracle EBS and core databases from the hosted datacenter to state-of-the-art datacenter. End to end migration and coordination with infra structure team, customer and offshore team.
• Worked on R12.2 migration for the Mutual Material customer upgrade project from 11.5.10.2 to R12.2.5 and database 11.2.0.4 to 12c (12.1.0.2). And supporting this customer.
• Worked for the 6 customers R12 Upgrade projects, customer are - MERU Networks, Symmetricom, Arivana, Confidential, Source Interlink and ASPEN (upgrade from 11.5.10.2 to 12.1.3 along with database) with database migration/upgrade/conversion.
• Worked on Arivana EBS application and database migration project from Solaris to Linux server along with EBS (11.5.10.2 to 12.1.3) and database upgrade (10.2.0.4 to 11.2.0.3).
• Upgrading Oracle Apps for multiple customers from R12 (12.0) to latest R12 (12.1.3)
• Applying application patches in Oracle Application such as minimum base line, CPU/security, bug fix
• Upgrading Oracle Application 11.5.8 to 11.5.10.2
• Extensive experience in Patching, applying minimum baseline patches for 11i
• Analyzed and applied various CPU patches, PSU patches etc.
• Applied required and/or recommended OPatches database patches on the Oracle Home
• Extensive experience in Cloning of Oracle Application instances from production instances
• Managing Concurrent Managers and concurrent requests/programs/workshifts.
• Administrating and troubleshooting Apache, forms, login issues
• User management and assigning responsibilities to the users in Oracle Applications
• Worked extensively on 11i and R12 prod and non-prod environments
• Monitoring and managing the databases both in VERITAS cluster managed RAC and non-RAC
• Configuring Workflow notification mailer & administrating in non-prod after every refresh
• Experience on Recovery Manager (RMAN) scenarios for database backup, restore & recovery.
• Implementing of 10g RAC using ASM (Automatic Storage Management) on RH Linux AS 4.0
• Worked on Discoverer, OBIEE, Vertex (pay roll) data update
• Creation of database, Managing Tablespaces and Undo Management, user/role management.
• Monitor and work on the tickets by ticketing tool HP PPM (Kintana), Support Central, Assure service desk, Infradesk, Jira.
• Migration of new/updated versions of codes and scripts to various 11i/R12 environment servers
• Preparing standard technical/process documents for DBA activities
• Configuring, managing and troubleshooting the 10g/11g Stand by database (DR databases)
• Performing regular DR activation and validating our DR solution.
• Handled database space requirements and adjust for future needs for supported database.
• Upgrading Java, JRE, JDK in Oracle application 11i and R12 for the Customer requirement
• Configuring and troubleshooting Workflow notification mailer
• Using ComVault as our backup solution form infrastructure side.
• Good working knowledge on Oracle Exadata and Exalogic servers.
• Worked with MWA services, Unitasks

TECHNICAL PROFICIENCY:

ERP: Oracle Applications 11.5.9, 11.5.10, 11.5.10.2, Release12.0.6, 12.1.3 & 12.2.5

Database: Oracle 9i, 10g and 11g, Oracle 10g RAC, 10g RAC on Veritas Cluster, 12c

Operating System: HP UX 11.31, RHEL 4,5 & 6,7 OEL 5: Solaris 5.9, 5.10: Windows NT, 2000 Server

Ticketing Tools: Service Now based Assure Service Desk, JIRA, HP PPM (Kintana), Support Central & Remedy

Monitoring Tools: CheckMK, HEMS, OEM 12c, Site scope and Nagios

Other Tools: AppWorx, Toad, SQL Developer, Sub Version, Code migration using HP PPM/PVCS

ERP Printer Utility: Unitask, Clear Orbit etc.

WORK EXPERIENCE:

Confidential

Oracle DBA

Responsibilities:

• Managed Service provide hosting, DBA and technical support to customers. In recent datacenter migration project responsible for migrating, upgrading OS, databases, building new instances in fresh hardware. Also closely worked with infra structure team, technical team for ongoing activity, change and rollouts.
• On data center migration projects for 3 customers. One customer migrated from company datacenter to AWS Cloud (Amazon Web Services). Successfully migrated the customers Oracle EBS 12.1.3 application to Amazon Web Services Cloud. Other two customer migrated their Oracle EBS form the exiting datacenter to modern datacenter.
• Worked on R12.2 migration for the Mutual Material customer upgrade project from 11.5.10.2 to R12.2.5 and database 11.2.0.4 to 12c (12.1.0.2). And supporting this customer.
• R12.2 new features and installation, configure, upgrade of R12.2.
• ADOP Online patching, ADOP commands and phases prepare, apply, finalize, cutover
• Clone of 12.2.5 environments . Refreshing database. Applying and providing end-to-end support for R12.2.5 EBS Applications.
• Weblogic installation and support. OACORE troubleshooting and tuning
• Providing end-to-end support for the customers ORACLE core databases and 11i / R12 application, Discoverer, OBIEE, Agile, Hyperion, Web Logic, GRCC, mobile apps, MWA servicesPrinter related support Uni-tasks, Clear-Orbits etc.
• Good knowledge on Exadata database machine architecture.
• Good understanding on database machine network architecture, InfiniBand network, topology & external connectivity.
• Exadata storage server processes, cell user accounts, processes, logs, utilities - CellCLI, DCLI
• Exadata cell disk layout, objects, cell disks, grid disks, ASM disks, ASM disk-groups.
• Mirroring of ASM disk-groups and failure groups, Exadata auto disk management .
• Configuring DB Servers to access Exadata Cells, ASM and Database Instances to Access Exadata Cells.
• Cell services starting/stopping. DCLI utility and commands on cell nodes & db nodes.
• Adding physical disks & flash disks to the cell server.
• Creating ASM disk-groups using grid disks based on hard disks & flash disks.
• Goldengate replication:
• Good knowledge on Oracle Goldengate architecture, concepts and components of Oracle Goldengate
• Installation and configuration of Goldengate 11g, 12c
• R12.2 new features and installation of R12.2
• Upgraded R12.1.3 to R12.2.5 for customer Mutual material with database version 12.1.0.2.
• Supporting the R12.2 environment.
• R12.2.5 ADOP (online patching). Monitoring and analyzing patching process and resolving failures.
• Cloning and creating non-prod R12.2.5 environments (TEST, DEV).
• Monitoring and managing the both RAC and core databases
• Providing day to day support, migrate codes, performs regular refreshes/clone in AWS cloud.
• Datacenter migration project, worked on datacenter migration projects for 3 customers. Two customers migrated their Oracle EBS and core databases from the hosted datacenter to state-of-the-art datacenter. End to end migration and coordination with infra structure team, customer and offshore team.
• Worked on R12.2 migration for the Mutual Material customer upgrade project from 11.5.10.2 to R12.2.5 and database 11.2.0.4 to 12c (12.1.0.2). And supporting this customer.
• Applying maintenance pack and perform point upgrades Oracle Apps for customers from R12 (12.0) to latest R12 (12.1.3)
• Applying application patches in Oracle Application such as minimum base line, CPU/security, bug fix
• Pre-Patch analysis, applying patching in test/development instance
• Troubleshoot problems with respect to patch issues, failure, invalid objects etc.
• Extensive experience in Cloning of different Oracle Application instances from prod to non-prod.
• Supporting extensively on R12 environments.
• Building new instances existing instances.
• Performance issue analysis. Recommending and resolving the database performance.
• Creating DR/Stand by databases for the production databases and maintaining these DR databases
• Upgrading Java, JRE, JDK in Oracle application 11i and R12 for the Customer requirement
• Configuring and troubleshooting Workflow notification mailer
• Experience in Autoconfig management
• Experience with all other adutilities i.e. adadmin, adctrl, adaimgr, adrelink, admrgpch etc.
• Administrating and troubleshooting Oracle Application Server i.e. Apache
• Using ComVault as our backup solution form infrastructure side.

Confidential

DBA support

Responsibilities:

• Providing support for the pool of customers ORACLE Database administration and 11i / R12 application, Discoverer, OBIEE, Agile, Hyperion, Portal, Web Logic, GRCC, MWA, Unitasks et
• Worked for the 6 customers R12 Upgrade projects from 11.5.10.2 to 12.1.3 along with database) with database migration/upgrade/conversion.
• Worked on Arivana EBS application and database migration project from Solaris to Linux server along with EBS (11.5.10.2 to 12.1.3) and database upgrade (10.2.0.4 to 11.2.0.3).
• Upgrading Oracle Apps for multiple customers from R12 (12.0) to latest R12 (12.1.3)
• Applying application patches in Oracle Application such as minimum base line, CPU/security, bug fix
• Pre-Patch analysis, applying patching in test/development instance
• Troubleshoot problems with respect to patch issues, failure, invalid objects etc.
• Extensive experience in Cloning of different Oracle Application instances from prod to non-prod.
• Supporting extensively on R12 environments.
• Building new instances existing instances.
• Performance issue analysis. Recommending and resolving the database performance.
• Creating DR/Stand by databases for the production databases and maintaining these DR databases
• Upgrading Java, JRE, JDK in Oracle application 11i and R12 for the Customer requirement
• Configuring and troubleshooting Workflow notification mailer
• Experience in Autoconfig management
• Experience with all other adutilities i.e. adadmin, adctrl, adaimgr, adrelink, admrgpch etc.
• Administrating and troubleshooting Oracle Application Server i.e. Apache

Confidential, Chicago

LinX Apps DBA Support

Responsibilities:

• Database upgrades 9.2.0.4 to 10.2.0.4. Support of database administration.
• Oracle Application upgrade for Confidential from R12 (11.5.10) to latest R12 (12.0.6)
• Applying application patches in Oracle Application such as minimum base line, CPU/security, bug fix
• Pre-Patch analysis, applying patching in test/development instance
• Troubleshoot problems with respect to patch issues, failure, invalid objects etc.
• Extensive experience in Cloning of different Oracle Application instances from prod to non-prod.
• Supporting extensively on R12 environments.
• Building new instances existing instances.
• Performance issue analysis. Recommending and resolving the database performance.
• Creating DR/Stand by databases for the production databases and maintaining these DR databases
• Upgrading Java, JRE, JDK in Oracle application 11i and R12 for the Customer requirement
• Configuring and troubleshooting Workflow notification mailer
• Experience in Autoconfig management
• Experience with all other adutilities i.e. adadmin, adctrl, adaimgr, adrelink, admrgpch etc.
• Administrating and troubleshooting Oracle Application Server i.e. Apache
• Managing Concurrent Managers and concurrent requests, workshift etc.
• User management and assigning responsibilities to the users in Oracle Applications
• Monitoring & Managing various log and output files generated by different adutilities
• Worked on Discoverer, OBIEE, Vertex (pay roll), Agile and Hyperion administration
• Tacking necessary core database activities such as
• Database schema refresh from production to non-prod databases environments
• Monitor and troubleshoot the jobs scheduled by a 3rd party job scheduler Appworx integrated with Oracle 11i/R12
• Implementing 10g RAC using ASM (Automatic Storage Management) on RH Linux AS 4.0
• Maintaining 10g RAC database
• Backup & Recovery in clustering environment-using RMAN.
• Taking backup from standby database using RMAN
• Installing and upgrading the Oracle database server
• Plan for future storage requirements for the database system
• Database creation in Unix platforms
• Managing tablespaces, tablespace growth and undo management
• Managing export and import utility, data pump, transportable tablespace & reorganization of database
• Configuring, managing and troubleshooting the 10g/11g Stand by database (DR databases)
• Performing regular DR activation and validating our DR solution.
• Handled database space requirements and adjust for future needs for supported database.

Confidential

Technical support

Responsibilities:

• Strong knowledge in Oracle E-Business suite 11i file system and architecture
• Patch analysis, applying patching in test mode and applying patch
• Troubleshoot problems with respect to patch
• Experience in Cloning Oracle database
• Administrating and troubleshooting Apache
• User management and assigning responsibilities to the users in Oracle Applications
• Apps Back-End database administration and TAR Support
• Monitoring & Managing various log and output files generated
• Database creation in Unix platforms
• Creating primary database storage structures (tablespaces).
• Code migration s. a. creating primary objects (tables, views, indexes, package etc).
• Modifying the database structure, as necessary.
• Taking back up (manual/script) and restoring the database on demand
• Monitoring alert log file frequently.
• Managing export and import utility.
• Adding and resizing data files

Confidential

Technical Support executive

Responsibilities:

• Implementing and maintaining a large volume of data for HR, admin and security reason.
• Customizing the software and testing the validity of the data as and when required.
• Generating various types of reports through the software.
• Maintain the Server Database integrity in handling the voluminous transactions in accordance with customs guidelines, Access Control and administration related activities.
• PC and Network troubleshooting in a large network environment.
• Network troubleshooting over TCP/IP and RS 232 Serial communications.
• Client systems and Software Asset Management
• Configuring and maintaining of servers and desktop PC’s in the facility.
• Installing necessary software’s and utilities for the end user.
• Monitoring of all the servers and running backup & maintaining Print Server of NT/2000.
• Maintaining office network, employees’ day-to-day problem regarding PC operating system, network connectivity, hardware, installation of software etc.
• Implementing and Supporting Microsoft Windows NT Server 4.0 in Enterprise Security & Authorization access.