Candidates About

 

Mukharam Khan

SUMMARY

·         Over 11+ years of experience in Oracle Application DBA and Oracle Core DBA.

·         Experience in upgrade, migration, implementation, cloning, patching and support projects.

·         Exceptional understanding of customer business process, skilled with the above-mentioned areas of expertise, which enables to provide cost effective and quality solutions and directions.

·         Working experience on Exadata and Exalogic environments.

·         Good experience in Standby database configuration and maintenance.

 

TECHNICAL SKILLS              

 

Certifications

·         Oracle E-Business Suite R12 Applications Database Administrator Certified Professional.

·         Oracle E-Business Suite 11i Applications Database Administrator Certified Professional.

·         Oracle Database 11g Administrator Certified Professional.

·         Oracle Database 10g Administrator Certified Professional.

·         Oracle9i Database Administrator Certified Professional.

·         Oracle9i Database Administrator Certified Associate.

 

EMPLOYMENT HISTORY

 

EDUCATION

 

Professional Training:

Training on: Oracle Golden Gate 12c

Date: Oct – Dec 2017

 

Technical Skill:

·         Installing Oracle Golden Gate on the Linux OS.

·         Configuring the Manager, Extract, data pump and Replicat processes.

·         Creating, editing and managing the parameter files for the golden gate processes.

·         Performed the DML replication and DDL replication.

·         Performed the Data filtration using the Where and Filter Clause and Data transformation using COLMAP

·         Setup Bidirectional replication and handle the conflict issue.

·         Configured the security feature using the trail file encryption and creating the USERIDALIAS.

·         Troubleshooting the issue using the report files and ggserr.log file.

·         Using the Logdump utility for reading the trail file for the troubleshooting purpose.

 

EXPERIENCE SUMMARY

Organization:   Cognizant Technology Solutions

1.       PROJECT PROFILE

 

ROLES AND RESPONSIBILITIES IN THE PROJECT

·         Oracle EBS R12.2(12.2.4) database migration from VMWare server to Oracle EXADATA server.

·         Cloning the application tier to the new Oracle PCA server.

·         Created the physical standby from the VMWare database to EXADATA server and switchover the standby to primary database during the Go-live phase.

·         Converted the single node database to 4 node RAC database.

·         Configured the database (12.1.0.2) and application (12.2.4) and enabled the autoconfig.

·         Created the active physical standby database for the production database on the EXADATA.

·         Cloning the test and dev EBS R12.2 environment on the dual filesystem.

·         Testing the ADOP patching cycle.

·         Performed the application patching using the ADOP utility and fix the issue during the patching.

·         Troubleshoot and worked with Oracle support on 24x7 severity 1 SRs for resolving the issue during the migration.

 

2.       PROJECT PROFILE

 

ROLES AND RESPONSIBILITIES IN THE PROJECT

·         Database migration from Linux server to Oracle Exadata server.

·         Database management on ASM instance with Exadata server.

·         Database upgrade from 11g (11.2.0.3) to 12c (12.1.0.2) and configuring Oracle application R12 (12.1.3) on the existing Linux server.

·         Disaster recovery(DR) build and configuration.

·         Data guard broker configuration for monitoring.

·         Patching Oracle EBS application.

·         Creating the container database (CDB) using DBCA.

·         Monitoring the health check of the database and application and tuning the database for better performance.

·         Basic knowledge on Golden gate for data replication.

·         User JIRA/Service tickets handling for the production deployments.

·         Working effectively with business users and technical team to resolve issues.

 

3.       PROJECT PROFILE

 

PROJECT DESCRIPTION

Oracle application EBS (R12, 11i) and 11g database support. Oracle EBS R12 Cloning and patching, Upgrading database and applications. Development of the Unix shell script for monitoring.

ROLES AND RESPONSIBILITIES IN THE PROJECT

·         Handling user’s tickets related to database, application and user performance issues.

·         Cloning Oracle application and databases R12 and 11i environment.

·         Patching application and performed RPC4 patching.

·         Database upgrade from 11.2.0.3 to 11.2.0.4.

·         Monitoring and Supporting OBIEE environment.

·         Configuration printer in CUPS and EBS environment.

·         Handling P1 and P2 tickets during Oncall support.

·         Vertex and Cognos administration task.

·         Database migration from X3 to X4 Exadata servers.

·         Creating Jira story and completing for the project task tracking and planning.

·         OBIEE,Vertex,Cognos administration

·         Oracle Transport Management Administration activities.

·         Configuring and maintaining data guard using physical standby database.

·         Good Working experience in Exadata and Exalogic hardwares.

 

 

4.       PROJECT PROFILE

 

PROJECT DESCRIPTION

Oracle application and database support. Oracle EBS R12 Implementation, upgrading database and applications, Cloning and patching. Setting up the RMAN backup for the development and production instances. Development of the Unix shell script for monitoring.

ROLES AND RESPONSIBILITIES IN THE PROJECT

·         Implementation of R12 12.1.3 EBS with 2 node RAC.

·         Configuring and Administering Oracle 10g/11g Automatic Storage Management (ASM).

·         Configuring External Web tier in E-Business Suite in demilitarized zone (DMZ).

·         Installed the CPU patches and upgraded the JDK and JRE from 1.6.0_10 to 1.7.0_45.

·         Cloning the R12/11i instances using the RMAN backups.

·         Troubleshooting and resolving the performance issue in R12 and 11i environments.

·         Monitoring database activities (Database status, space consumption, long transaction, server top sessions) using OEM and scripts.

·         Clone database using RMAN Active Database feature.

·         Performed the RMAN backup - Full and Incremental Backups and Automated the RMAN backup using shell scripting.

·         Resolving block corruption issues during RMAN backup.

·         Works with the end-users on the incidents (tickets).

·         Working on the tablespace/datafile/temp space related issues.

·         Applying the oracle EBS application patches based on the SR and users request.

·         Developed Unix shell scripts for monitoring database.

·         Converted non-autoconfig database tier to Autoconfig.

·         Installed and configured oracle software and database tools.

·         Working with Oracle support for troubleshooting the issues and resolving it.

·         Working on the 24/7 production on-call support.

Organization:   Wipro Technologies

5.       PROJECT PROFILE

 

PROJECT DESCRIPTION

Monitoring, cloning and providing support to multiple databases and applications.

ROLES AND RESPONSIBILITIES IN THE PROJECT

·         Cloning database and application on the new hosts (new setup).

·         Checking the storage for refresh on the target system and raising case with system administrator for the storage.

·         Setting up cronjob for the refresh activity. (recovery cronjob)

·         Refreshing databases and oracle applications on different file system and OS.

·         Taking pre-refresh backups of the configuration files and taking logical backup of the tables.

·         Refreshing the target system from the hot backup or from the Data Guard. Generating the dd script for the copy.

·         Recovering database by applying the archives if the copy is from the hot backup.

·         Removing the production database links from the target.

·         Setting up the RAC environment. Converting Non-RAC into RAC environment.

·         Configuring parallel concurrent processing (PCP).

·         Completing the cloning post steps and doing the complete sanity check before releasing the target instance.

·         Handling user’s issues/requests and troubleshooting.

Organization:   OneAPPS Enterprise Technologies

6.       PROJECT PROFILE

 

PROJECT DESCRIPTION

Monitoring, cloning and providing support to multiple databases and applications.

ROLES AND RESPONSIBILITIES IN THE PROJECT

·         Refreshing databases on different file system and OS.

·         Refreshing the target system from the hot backup or from the Data Guard.

·         Setting up the RAC environment. Converting Non-RAC into RAC environment.

·         Resolving the issue during cloning. Completing the post steps of cloning.

·         Doing the first level sanity for the target system.

·         Troubleshooting and resolving the user’s issues.

Organization: OneAPPS Enterprise Technologies

 

7.       PROJECT PROFILE