SUBHASH KUMAR DAWIRA

Room Number ***, Saray Musherib Hotel Doha, Qatar.

Email: adabjh@r.postjobfree.com

Skype ID: subhashkd

Contact: +974-********

Date of Birth: 01/02/1993

SUMMARY: More than 4 years of consulting experience in various roles like Oracle Applications DBA, Core DBA and System administrator contributing in various areas of Database and Applications ensuring customer satisfaction in fast-paced, deadline-driven environments.

WORK EXPERIENCE:

MEEZA, a Qatar Foundation Joint venture (July 2018 – Present) o Oracle RAC 12c Administration

o SQL Server Failover Cluster 2014 Administration

Pakistan Stock Exchange Limited (July 2018 – March 2018) o Oracle RAC 11g Administration

o Oracle Apps Database Administration

o Weblogic 11g and 12c Administration

o Secure Socket Layer Implementation at OHS Weblogic o MySQL Database Administration

o Microsoft SQL Server Always-On cluster Administration o Implementation of Data Guard with Maximum Availability Protection mode.

Freelancer (September 2017 – June 2018)

o Professional Training to Crescent Steel and Allied Products

Oracle Application DBA Training

o Oracle DBA Support to NRSP Microfinance Bank Pakistan

Implementation of EBS R12 (12.2) with 12c Database on Solaris 10 (OS)

Upgrade of EBS R12 from 12.2.0 to 12.2.5

o APPS Database Administration support to Qatar National BroadBand Network

Jaffer Consulting (JC), Jaffer Brothers (Private) Limited (May 2016 – Aug 2017) o Database support to Crescent Steel Pakistan

Cloning And Patching

Enterprise Manager Configuration Database Security implementation

Linux and Database Audit Management

Configuration of Oracle links with Non Oracle Databases (MYSQL,SQL SERVER)

Performance Tuning of Database on VMware based architecture

Oracle EBS 12.1 Support

o Oracle Application DBA support to Al-Rahim Textile Pakistan

Oracle Dataguard (Physical) Implementation

Backup Management using RMAN EBS Patching And Cloning

Performance and Tuning Oracle EBS 12.1 Support

Support during data centre switch activity.

o Database support to Jaffer Brothers Pvt Ltd

Disaster Recovery Site implementation

Oracle Business Intelligence Application 11g Implementation Oracle Database

Upgrade 10.2.0.4 to 11.2.0.4

Hot backup Configuration along with HP Data protector Tape Drive Utility

Managing Servers on VMWare based architecture

Configuration of Non Oracle links (MYSQL,SQL SERVER) with Oracle Databases

EBS 12.1/Siebel CRM Support

Administration of MYSQL and SQL SERVER Databases

Administration of Real Application Cluster(Oracle RAC)

Shell Scripting (Development) for automation of routine activities EBS/Database Security

o Oracle RAC Core DBA Support at Jubilee General Insurance

Oracle RAC to single Instance Datagaurd (Physical) Implementation

Physical Datagaurd to primary switchover drill and vice versa

Backups Management using RMAN

Backup Management using Oracle Data Pump (Exp/Imp)

Enterprise Manager Configuration

Performance issues diagnoses and resolution

o Database support to Qatar National BroadBand Network Oracle RAC Support

Cloning Using RMAN Duplication Patching using ADOP

Oracle EBS R12.2 Support Oracle EBS Cloning training.

Diagnoses and Resolution of EBS Issues

o Real Application Cluster Implementation at South Asia Pakistan Terminal

Assisted my team mate in Configuration of Oracle 6-Node Real

Application Cluster with dual HP 3-PAR Storage, Provided redundancy among Nodes as well as Storage's.

o Oracle RAC DBA support to ZONG China Mobile Pakistan

Performance Tuning 12c Database

Oracle EBS R12.2 Support

Synergy Computers (Pvt.) Ltd ( May 2015 to April 2016) o Database support to Engineer at United Energy Pakistan(Former: British Petroleum)

Oracle Physical Dataguard Implementation SQL Server Database Administration

Oracle database Performance and Tuning EBS 12.1 Support

Performance and Tuning

Oracle Database support for IBM MAXIMO

o Database Administration Support to Employees Old-Age Benefits Institution (EOBI) Pakistan

Implementation of Oracle Physical Dataguard Performance and Tuning

Database security

Linux Shell Scripting at EOBI Pakistan

Automation (programming) of regular monitoring tasks

Working on WMware Virtual Machines based environment

Internee Database Administration (June 2014 to May 2015 ) o Oracle DBA support to IoBM Pakistan

Disaster Recovery Site management

Backup Management (RMAN) and data pump (exp/imp)

Patching And Cloning of databases

Working on WMware Virtual Machines based environment EDUCATION:

SZABIST Shaheed Zulfikar Ali Bhutto Institute of Science and Technology, Karachi

Masters In Project Management (MPM), (2016)

IoBM Institute Of Business Management, Karachi

BS(Computer Science),(2015)

SZABIST Intermediate College

HSCII (Commerce),(2010)

“A” Grade

The City School

SSCII(Science),(2008)

“A” Grade

HONOURS / ACHIEVEMENTS:

o Oracle Certified Professional Database Administration (OCP)

Oracle Database 11g: Introduction to SQL

o Oracle Database 11g: Administration 1

Oracle Database 11g: Administration 2

o Oracle Database 11g Performance Tuning Certified Expert

o JBS Training on VMWare Implementation VMware ESXi 6 o NCC Education (Computer Pioneers) certification of LEVEL 5 and LEVEL 6. o Certified Computer (Information Technology) at HSC Part II Larkana. MAJOR TERM PROJECTS/ RESEARCH WORK / REPORTS DURING ACADMINCS: o Software development Project presentation in Primavera p6 enterprise manger o Project Management: Project Initiation to Completion of VENDING MACHINE IMPLIMENTATION o Web Engineering : Students Books Library Web application with MYSQL database o Visual Programming : Checkers Game(Visual Basic) o Computer Graphics: Web Template Design(Adobe Flash Player) o Management: Report Work On UNILEVER MANGEMENT

INTEREST AND ACTIVITIES:

o Sociality: - Outing with friends, dinning with colleagues, o Hobbies: - Listening music, Reading Blogs and Books, Internet Surfing LANGUAGES:

o English

o French (Elementary)

o Urdu

o Sindhi

Contact this candidate