Waqas Yousaf Chaudhry

OCP *, OCP *i, OCP *i, OCP 11g, OCP 12c

LinkedIn: https://www.linkedin.com/in/waqas-chaudhry-a56bb614 Email: addmdg@r.postjobfree.com

CAREER SUMMARY

Oracle certified Database administrator having 16+ years of extensive experience in successfully managing oracle database servers, in 24x7 production environments, on Windows and Red Hat Linux operating systems.

SKILLS SUMMARY:

Real Application Clusters using ASM/OCFS2 (RAC 11.2.0.4)

Oracle 9i/10g/11g Data Guard Configuration

Oracle Advanced Replication

Oracle GoldenGate (12.2, 12.3)

Backup and Recovery using RMAN (Recovery Manager)

Migration of Database Servers from lower to higher version.

Installation of database patches.

SQL and PL/SQL Tuning/Optimization.

Database performance tuning.

RAC 12.1.0.2.0 using ASM on RHEL 7.1

Oracle High Availability and Disaster Recovery Solutions i.e. RAC and Data Guard.

Re-organization of database servers.

Table partitioning

Materialized views (Complete and Fast Refresh)

Log miner

ADDM/AWR

Oracle Enterprise Manager. (OEM)

OAS Forms and Report services 10gR2

Installation of 12c WebLogic Server

Installation, Configuration and Administration of Oracle Databases on Windows and Red Hat Linux OS.

Hardware RAID configuration

Scripts writing for creating test environment.

Capacity Planning.

Database Security.

TOAD

PROFESSIONAL CERTIFICATIONS

OCP 8, OCP 8i, OCP 9i, OCP 11g, OCP 12c

EMPLOYMENT HISTORY

Manager IT (Oracle DBA) Nov 2016 – To Date Full Time

Masood Textile Mills Fabric Division Faisalabad PAKISTAN.www.masoodtextile.com

Key projects:

Migrated HRMS/INVENTORY/ATTENDANCE 11.2.0.4 database to 12cR2 with zero down time.

Configured GoldenGate consolidation topology to consolidate data from various garments store databases to a centralized location.

Configured Bi-directional GoldenGate replication between 11g R2 and 12c R2 using GoldenGate version 12.3 for testing purpose.

Configured 12c R2 RAC using ASM on RHEL 7.6 for R&D testing purpose.

Manager IT (Promoted) (Oracle DBA) Nov 2012 – Aug 2016 Full Time

Masood Textile Mills Fabric Division Faisalabad PAKISTAN.www.masoodtextile.com

Key projects:

Achieved load balancing and high availability by configuring oracle 11.2.0.4 RAC, using ASM, on Red Hat Linux operating system.

Achieved better read/write performance and less communication overhead, on network, between primary and remote sites, by configuring Multi Master Replication using 11.2.0.4 database.

Configured 12c R1 RAC using ASM on RHEL 7.1 for R&D testing purpose.

To overcome situations like natural disaster configured remote disaster recovery/failover site.

Deputy Manager IT (Oracle DBA) Sep 2008 – Oct 2012 Full Time

Masood Textile Mills Fabric Division Faisalabad PAKISTAN. www.masoodtextile.com

Key projects:

To achieve the benefits of new 11g features migrated 9i and 10g production databases to 11g R2 version.

To achieve maximum/better utilization of memory (RAM) and to accommodate more database user sessions, migrated oracle production databases from 32 bit architecture to 64 bit architecture.

To keep down time minimum with zero data loss, in case of production DB server failure, configured Data Guard Servers for all oracle production DB servers

To be able to recover database at BLOCK level, in case of DB block corruption, and to perform incremental backups, configured Recovery Manager (RMAN) for taking DB backups.

To allow access to applications to overseas users, over the internet, configured OAS 10g Forms and report services

To achieve optimal data retrieval speed, tuned application code of slow running Forms/reports

Senior Oracle Database Administrator Jul 2005 – Aug 2008 Full Time

Interloop Ltd Faisalabad PAKISTAN. www.interloop-pk.com

Key projects:

Part of oracle Technical team during implementation of oracle R12

Migrated 9i databases to 10g version.

To achieve the ability to perform incremental backups of production databases, configured RMAN for taking DB backups.

To achieve the goal of zero data loss, in case of primary DB failure, configured Data Guard for oracle production servers.

Reorganized all production database servers to overcome data fragmentation issues, which in turn also improved the performance of DB servers.

Oracle Database Administrator Aug 2003 – Jun 2005 Full Time

Masood Textile Mills Apparel Division Faisalabad PAKISTAN.www.masoodtextile.com

Key projects:

To achieve increased reliability, availability, better performance and user load balancing, configured multi master replication using 9i database between remote sites.

To keep downtown to minimum, in case of DB server failure, configured standby servers for oracle production Servers

Automated database Backup routines.

EDUCATION

MCS (Master in computer sciences) 2001-2003

National College of Information Technology Pakistan GPA 3.29

B.Sc. (Mathematics and Statistics) 1995-1997

Punjab University Lahore Pakistan. Marks Obtained 483/800

TRAININGS

2007 Red Hat Certified Engineer APTECH computer college Faisalabad Pakistan.

2004 MCSE 2003 Experts computer college Faisalabad Pakistan.

2001 Oracle DBA training Nicon Institute of computer sciences Faisalabad Pakistan.

1998 C++, Java Scripting, HTML, MS office Langara College Vancouver Canada.

1997 Dos, Fox pro, LAN, MS office.

LANGUAGES

English, Urdu, Punjabi

LEGAL STATUS IN CANADA

Permanent Resident of Canada (Landed Immigrant)

REFERENCES

Muhammad Irfan Manager IT Masood Textile Mills addmdg@r.postjobfree.com +923*********

Tahir Butt Manager HR Masood Textile Mills addmdg@r.postjobfree.com +923*********

Contact this candidate