SUBHASH KUMAR DAWIRA
Room Number ***, Saray Musherib Hotel Doha, Qatar.
Email: ***********@*****.***
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