Curriculum Vitae

AMJAD SHAIKH Lead - Oracle Apps DBA / DBA – OCA / OCP , Oracle Apps OCPOracle Exadata Certified , ITIL , PRINCE2 Certified

Mobile : +974 33570645Email : amjadshk@gmail.com

OBJECTIVE

To work and lead in a challenging environment, where I can enhance and deliver my technical and leadership skills to the best of my capabilities and talent aiming towards benefit of the Organization

EXECUTIVE SUMMARY

Master of Computer Application (MCA) and Bachelor of Computer Science (BCS) with Total of Experience around 11 years into Oracle Database Administrator , Oracle Applications DBA and Big data - Hadoop Administrator.

Exadata and Exalogic Implementation with R12.2.5 version of Oracle Applications Oracle Application upgrade from R12.2.4 to R12.2.5 with latest CPU and PSU patches Installation of R12.2 application with upgrade from R12.2.0 to R12.2.5 Support of Oracle R12.2 and R12.1 Application hosted on Exadata (X4-Half Rack) and

Exalogic(X4-2) Sun Solaris Platform Big data- Hadoop Administrator , Worked on implementation and Support project on AWS Experience in Oracle Apps Cross Platform migration from Solaris to Linux for 11i and R12. Integration of SOA with R12.2 instance Setup SSO,OAM,OIM,WebGate,registrations on R12.2.4 and R12.1 Environment Team Lead experience of handling 18 DBA’s in production Support and 6 DBA’s in Upgrade

Projects Completed 5 Production Database recovery with no Data loss. 3 Node RAC Implementation and support on E –Business Suite configuring it with a total of 6

node application. Recent Golden gate and De-Mantra Installation on around 10 Production Instance Multiple E-Business suite upgrade from 11i to R12 OnSite Travel to US ,Mexico, Brazil and UK for Implementation of projects Database upgrade from 9i to 10g and 10g to 11g Installation of of OBIEE and OBIA OAM Installation with all modules on R12.1.3 and R12.2.4 instance Cross Platform Migration and upgrade from Solaris to Linux (Exadata / Exalogic Machine) RMAN Backup setup for 30 databases Production, development, CRP and UAT support for Oracle Apps 11.5.9, 11.5.10 and R12 in

complex environment.

Experience in installation on Test, Configuration, Maintenance, Upgrade, Administration and Support of Oracle Applications 11i and R12.

OEM installation, upgrade and configuring database and applications part in OEM. Worked on Demantra 7.3 ,ASCP and Noetix installation and configuration with E-Business suite Installing New Language like Arabic, Turkey, Latin American, French and Spanish. Cloning of complex RAC and Non –RAC multi-node and Single node environment JRE Upgrade and Oracle Base Line patches on 11i Applications Done production Go-Live after successfully implementing 4 CRP’s and UAT’s from US and

Mexico Single Node to Multinode configuration of 11i Applications Remote support to various Oracle Apps and Non Apps environment.

EMPLOYMENT HISTORY

Current Employer :

KPIT Technologies LTD, Pune, Febuary-08 to till date.Present Job Title : Team Lead – Principle Oracle Apps DBA.

Previous Employers :

Wipro Infotech, Mumbai, July-07 to Febuary-08. Job Title : Oracle Apps DBA / DBA – Consultant.

I-Edge Software Pvt. Ltd. Hyderabad, June-05 to July-07.

Job Title : Associate DBA

CERTIFICATION

Oracle 10g Certified Professional (OCP) Oracle 10g Certified Associate (OCA) Oracle 11i Install, Patch and Maintain Applications Certified. Exadata, Exalogic and performance tuning training and certificate from Oracle 1Z0-485 Oracle Exadata Database Machine 2014 Implementation Essentials ITIL Certification Prince2 Certification in process

EDUCATIONAL QUALIFICATION

B.Sc. (Computer Science) from UNIVERSITY OF PUNE in 2004.

MCA from UNIVERSITY OF PUNE in 2007

PROJECT SUMMARY

1. Implementation of R12.2.5 on exadata (X4 & X5) and exalogic servers 2. Cross Platform migration from Solaris to Linux on exadata and other environments.3. Oracle OEM 12C implementation4. Golden Gate 11 Implementation on multiple Production Instances 5. Project DBA for implementation of Oracle E-Business Suite R12 with 11g RAC6. Oracle Applications Upgrade from 11.0.3 to R12 and Implementation7. Advanced Compression on R12 E-Business Suite having 11g database.8. Upgrading Oracle Application from 11.5.10.2 to R 12.0.69. Database upgrade on 11g ,12C versions10. Multiple Language Installation 11. Implement OEM Grid based monitoring solution and Upgrades 12. Implementing OATM13. Installation, Migration and Upgrade to R1214. Support of multiple Oracle Applications R11 and R12 suite15. DataGuard Setup and active dataguard implementation 14. Various Support Project for EBS and Database

PROJECT DETAILS

Project No. # 1Project R12.2.4 Implementation on exadata and exalogic servers

Environment Oracle R12.2.4,Linux Exadata and Exalogic server X4-Half RackProject details Installation of database on exadata servers

Installation of R12.2.4 into exalogic and exdata server AD7 Patching and R12.2.5 upgrade Enabling online patching Custom code Migration using online Patching Migration of data using Chainsys S/W Configure Parallel Concurrent Processing Setup DMZ ,F5 Load Balancing MWA Configuration Check & configure 12c OEM Grid control from front-end.. ASCP instance setups Oracle Home patching Enable online Patching Audit Vault implementation Integration with SOA , APCC and OBIA Apply application patches and migration using adop (Online

Patching) TDE ,Advanced Compression, FDA implementation Setup SSO,OAM,OIM,WebGate,registrations on R12.2.4 Integration of SOA with R12.2 instance

Project No # 2Project Oracle Applications Database Cross Platform Migration from

Solaris to Linux( Transportable Tablespace method and Export/Import)

Environment Oracle Applications R12 Sun Solaris 5.10, RHEL Linux 5.9Project details Operating system related pre-requisite steps on target server.

Obtained and applied the Applications consolidated Source System Preparation( export/import utility patch, set

tablespace set read only, export tablespace set and objects, copy datafiles)

Target System Preparation (database and JVM installation, setup SYS/system schemas.)

Import target database objects (convert endian format of datafiles, import tablespace set and objects).

Update target database instance. Fix issues

Project No. # 3Project Golden Gate Implementation

Environment Golden Gate 11,Oracle R12,Oracle 11g,Sun SolarisProject details Add supplemental Log data for all columns on the tables .

Create GGUSER with special privileges on the both sides Install GG on the source and target machine Configure and start Manager Process on the both side Configure and start Extract process on the source side. Add and Start extract with SCN’s timestamp Configure and start pump process Import at target side Configure and start replicate process Validate replicate process

Project No. # 4Project 11g RAC Implementation on R12 E-Business Suite.

Environment Oracle RAC11g, Oracle 11g Dattabase ,R12 E-Business Suite ,Sun Solaris 5.10Project details Configuration Prerequisites and Perform the pre-requisites.

Set up the required cluster hardware and interconnect medium Software and Hardware Configuration Database Installation and Oracle RAC Migration Install Oracle Clusterware 11g Release 2 Install Oracle Database Software 11g Release 2 and Upgrade

Applications Database to 11g Release 2 Configure Listener Configure Shared Storage Convert Database 11g Release 2 to Oracle RAC Post- Migration Steps Enable AutoConfig on Database Tier Establish Applications Environment for Oracle RAC Configure Parallel Concurrent Processing Setup F5 Load Balancing MWA Configuration Check & configure OEM Grid control from front-end..

Project No # 5Project Oracle Applications Upgrade to 12.1.3

Environment Oracle 9i,10g, Oracle Applications 11i, Sun Solaris 5.10Project details Operating system related steps

Pre Upgrade steps Database Upgrade Application Upgrade Post Upgrade DBA Activities Code migration ,code review Index rebuilding done on ASCP and EBS instance after each

conversions and major activities Automated Unix Scripts created for supporting CRP and Production Instance Refresh done on Regular basis as per requirements Patches applied on CRP and Production as per requirement 82 New responsibility created including Menu and Request group

created for each responsibility Noetix View Regeneration on regular Interval as per the requirement of

project at different project Phase User mapping of around 500 users to noetix using NVA Tool More them 500 users created with different responsibility assignment

according to their role on Production and CRP Instance

Project No. # 6Project 11g Upgrade Project

Environment Sun Solaris.Oracle 11iProject details Review and Apply Server Pre-Requisites

Review and Apply Database Pre-Requisites Using the Pre-Upgrade Information Tool Check for INVALID database components and objects in the Source

database Check for TIMESTAMP WITH TIMEZONE Datatype Patch (patch 10404530) Apply latest patches to RDBMS Complete pre-upgrade steps Upgrade Database Post Patch Upgrade activities Complete post-upgrade steps Copy AutoConfig to the RDBMS ORACLE_HOME The AutoConfig check utility Fix Issue’s

Project No. # 7Project Implement of De Mantra 7. 3 and 12.2Environment Windows,Sun Solaris5.9,10gAS,DemantraProject details Perform the pre-requisites.

Configure Oracle Demantra for 11g Database Configure Analytic Engine to run in Windows Batch Mode Configure Web Application on 10g AS Configure Demantra Data Source Oracle Application Setups DeMantra URL Setup War File Creation and Redeployment JAVA_HOME Setup Known Issue Fixes

Project No. # 8Project Support to installed Oracle Applications R11 and R12 suite. Environment Oracle Applications R11,R12, Linux, Sun Solaris, Oracle 9i,10g.Project details Perform System administration tasks.

Monitored the Applications using OEM and OAM. Apply applications patches using adpatch Performed Application admin tasks using ADADMIN utility Administration of CM and Concurrent Processing Reset SYSADMIN, APPS schema passwords using FNDCPASS. Installation of Printers at Operating System level and then defining it in

Oracle Applications. Bouncing the Concurrent Manager, Apache. Performed Oracle 11i Application Patch Analysis, Patch Application,

Upgrades, Refreshes. Purging the concurrent requests. Configuration of Oracle Alert and Workflow. Cloning Oracle Applications instances as required. Upgraded Oracle Application. Working with appworx for maintaining the backup jobs and various

schedule jobs for database and applications Working with legacy press software for printing purpose. Interacting with customers regarding their issue and whenever they need

to consult Install of OEM agent on database and application environment. Renaming Data files to different location Purging of apps and database environment. Addressing various support related issues.

Project No. # 9Project Implementing OATM Environment Oracle Application 11.5.10.2, Oracle 9i. ,Sun SolarisProject details There are three major phases involving several steps are performed:

Preparatory Phase Perform the pre-requisites. Run OATM Migration Utility. Report on estimated tablespace sizing Create new Tablespaces and datafiles

Migration Phase Execute migration commands. Run Migration reports and monitor the status with migration Status

report. Post Migration Phase

Run post migration steps.

STRENGTH Sustained upgrading of technical and professional skills. Willingness to take on challenges. Ability to work under pressure. Hard working - "do what it takes" attitude Level headed and analytical frame of mind, when facing crisis situations Ability to manage changing priorities and manages time effectively. Seeks and shares information with clients and coworkers and respond to concerns with timely,

meaningful, fact-based, and constructive feedback. Good team player with excellent leadership qualities. Possess excellent communication and conversational skills.

PERSONAL INFORMATIONDate of Birth : 02nd August 1984.Sex : Male.Nationality : Indian. Blood Group : O +ve.Linguistic Ability : English, Hindi, Marathi.Passport Number : N5226281

(AMJAD SHAIKH)