Pawan Kumar

Oracle Technical Support Analyst/Apps DBA

PHONE: +92-333-*******

E-MAIL: acwx2j@r.postjobfree.com

OBJECTIVE

Seeking an opportunity in an esteemed organization that provides exposure to the hanging trends in the field of System, Database and Application Management along with interaction with professional work force and exciting projects to fully exploit the knowledge in order to achieve higher degree of professionalism.

EXPERIENCE

More than Four Years of experience in the IT Field.

PROFESSIONAL EXPERIENCE

Jun13 – Present Oracle Technical Support Analyst/Apps DBA

eAccess Group (Pvt.) Ltd., Karachi – Pakistan

ENGRO Food Limited

http://www.engro.com

EBS Cloning, Patching and restore backup

EBS Tuning,Data Guard on EBS

ENGRO Incentive system

http://www.engro.com

Installation of Apache Tomcat,Servicemax

Create Prod, UAT and Development environment.

Taking RMAN Backup, Export data pump

Cloning and scripting.

March2013 – Jun2013 Oracle Database Administrator/Apps DBA

Resident Engineer in Silk bank (Pvt.) Ltd., Karachi – Pakistan

MAJOR RESPONSIBILITIES

Monitoring Oracle Database Rac 10g with GPFS on AIX-5 64 Bit.

Implementation of Oracle Physical Data Guard on Rac Environment .

Switch Over From Primary Database To standby Database In RAc Environment and also revert back To Primary Database.

RMAN Backup, Patching and cloning in EBS R12.

Tuning the Internal Concurrent Manager and Purging Concurrent Requests.

Jun10 – Jun2013 Oracle Technical Support Analyst/Apps DBA

Ora-Tech Systems (Pvt.) Ltd., Karachi – Pakistan

Ora-Tech Systems has been partnered with Oracle© Software Corporation since 1990 and was the first ever partner in the region to attain Certified Advantage Partner status. The highest level of Oracle Partnership available anywhere in the world.

Passionate about viability, continuity and extensibility of the solutions we deliver. Ora-Tech is an industry-focused technology firm. We achieve measurable business results for you using world’s best database technology and a strategic and complementing suite of applications. Applications that enhance your operational performance, optimize your value chain, and improve your bottom line. Ora-Tech has the distinction of being the first Oracle Certified Solution Partner (OCSP) in Pakistan.

MAJOR RESPONSIBILITIES

Oracle

Provide reliable, innovative and cost effective IT solutions catering to the needs of individual, small & medium size businesses and enterprise customers.

Troubleshoot & resolve Oracle and Linux issues by telephone or email.

Visit client premises to resolve critical Oracle and Linux problems.

Install and Configure Oracle Enterprise Linux 4 & 5 on enterprise servers

Install Oracle VM server and manager on Linux and its configuration for virtualization.

Install Oracle Audit Vault and it agent for auditing on UNIX family platforms.

Install Oracle database version 8i, 9i, 10g and 11g on Windows, UNIX & Linux platforms

Responsible for maintenance and support for company 24/7production database..

Responsible for the implementation, planning, configuration, installation and ongoing management of all oracle databases.

Performance monitoring on Oracle systems related to Oracle and Linux.

Monitor scheduled backups on Oracle databases.

Implementation of Oracle Data Guard (Physical/Logical/Active/Broker) Technology on Windows and UNIX family.

Implementation of Oracle RAC 10g & 11g with OCFS2/ASM.

Installation of grid control and agent, Grid patching, Use Oracle Grid Control to manage multiple Databases.

Perform backup and Recovery using RMAN. Command on Export, Import and Data Pump.

Migration of Database from old version to latest version.

Installation of Oracle E-business suite (11i/12) on unix family.

Installation of 6i/10g forms and configuration.

Assist in Oracle Connectivity issues. General Troubleshooting.

Configuring Oracle EM, Repository recreation of Oracle EM,Table Partitioning.

Maintaining SR.

Redhat Enterprise/Advance Linux

Install Red hat Enterprise Linux 3, 4 & 5 on enterprise servers.

Configure FTP Server.

Configure user quota, Group quota, File permissions, Group Permissions, User permissions.

Tune Linux for Oracle, Configuration of SSH and RSH

Auto Start and Shutdown Scripts of 10g Database and Application Server on Redhat

Scheduling the auto backup tasks of Oracle database using crontab and job.

CLIENTS INCLUDE/PROJECTS IMPLEMENTED

Lucky Cement

Linux 5 U 3 /10g Database and Data Guard implementation on Testing Machine

Linux 5/oracle 10g/Expdp Impdp/Database patching

Karachi Stock Exchange

Change the IP and Hostname of Clonning of Oracle 11.5.10.2 EBS and DB

HBL Bank Ltd

Linux 5 /Oracle 10g and Client /OS Support

Standard Chartered Bank

MS 2003 server /Oracle 10g /OS Support

Hamdard Laboratory

Linux Installation/Database 10g and Client

Atlas Battery

AWR Report and Health Check of Database and ERP

Tapal Tea

Rman Backup Strategy

KASB

Active Data Guard Implementation on Production Server

Silk Bank

Two Node Rac Configure on AIX And Switchover and Failover.

Getz Pharma

Upgrade oracle Database from 10g to 11g on same Operating system on Production Database

Migration from oracle database 11g windows 32 bit to SUSE Linux 11 64 bit

And also support other oracle clients for normal oracle issues, bugs etc

EDUCATION

2005 – 2009 BE (Software engineering) - 1st Division

Mehran University of Engineering & Technology, jamshoro – Pakistan

2004 – 2005 Secondary School Certificates (SSC)

Government Muslim Science College Hyderabad - Pakistan

2002 – 2003 High School Certificates (HSC)

Govt Higher Sec School Chachro – Pakistan

CERTIFICATION

11g New Feature Oracle certified professional (OCP)

10g Oracle certified professional (OCP)

Oracle Enterprise Linux

TRAININGS

Oracle Database 10g training from TECHNO-ED.

RHEL Essential 5 training from TECHNO-ED.

RHEL Essential and Administration 5 training from TECHNO-ED

Oracle Exa Logic 5 Days training from Esys.

PROFESSIONAL SKILLS

Database Administration Oracle 9i,10g & 11g

Virtualization Oracle VM

Administration Tools Oracle EM/Grid Control

Oracle Security Oracle Audit Vault, Database Vault

Operating System MS XP, 2003 Server, RHEL,OEL, Aix

Application Server Oracle Application Server 10g

ERP Oracle EBS 12R

OTHER SKILLS Research Analysis, Communication skills, Decision making ability.

PERSONAL INFORMATION

Contact Address F#108 B#A1 Karachi center new town university road Karachi

Date of Birth 6th May, 1987

Nationality Pakistani

Marital Status Married

Languages English & Urdu

REFERENCES

Gladly furnished upon request

Contact this candidate