Waqas Chaudhry

Email: adclbr@r.postjobfree.com

Phone: 416-***-****

Looking for a challenging position as an Oracle DBA

EXPERIENCE SUMMARY:

Extensive experience of 15+ years in IT industry at various positions/levels.

Extensive experience of installation, upgrade, administration, migration, troubleshooting, implementation and support of Oracle 12c / 11g / 10g / 9i / 8i databases on AIX, HP-Unix/Linux and Sun-Solaris servers as an Oracle DBA

Supported Development, Testing/QA, Training and Production environments

Expertise in database Backup/Recovery and Disaster Recovery procedures.

Expertise in Performance Tuning tools ADDM, AWR, ASH, STATSPACK

Extensive experience and in-depth knowledge of Oracle RDBMS (12c/11g/10g/9i/8i)

Effectively worked with Management, Clients/End Users to produce user and technical documentation

Experience of Unix shell scripting

Extensive Coding, Design and Requirements Analysis experience

Strong analytical and problem solving skills

Adaptable and self-motivated, ready to learn and work on new technologies

Excellent interpersonal, presentation and communication skills; and a quick learner of new technologies

A good organized team player and team leader, like to work in a challenging environment, mentor junior DBAs/developers and work to help them out in application development and tuning, managing their workload and making sure the SLAs / Project deadlines are met.

TECHNICAL SKILLS:

Operating Systems

IBM AIX 4.3.3, 5L, 6.1, 7.1 SUN Solaris 8 / 9 /10, HP-UX 11.00 / 11i, RHEL Linux, Oracle Exadata

Microsoft Windows Server 2002 Service Pack 2, Windows Server 2008 Service Pack 2, Windows Server 2012 R2

Database Servers

Oracle 19c / Oracle 18c / Oracle 12c / 11g /10g / 9i / 8i / 8.x / 7.3, Real Application Cluster 12c/11g/10g, Data Guard, ASM, Oracle Clusterware, Golden Gate V10/V11, OCAC, VMC, MS Azure, SQL Server 2008/2012

Backup Tools

Oracle RMAN, IBM Tivoli Storage Manager, VERITAS Netbackup, BCV Split Methodology, IBM's Global Mirror

Performance Tuning Tools

ADDM, AWR, ASH, STATSPACK

Office Automation Tools

MS Office tools, Lotus Notes, IBM Lotus Symphony, HP OpenView, skype

System Access Tools:

Secure CRT, PuTTY, Exceed, Citrix, VNC, Remote Desktop, F-Secure, Mobaxterm, winscp, GitHub, MKS (PC Integrity)

WORK EXPERIENCE:

TD Canada Trust (May 2018 – till date)

Senior Oracle DBA

Tools & Technologies: Oracle 12c, 11g, 10g, Cloud, VM Ware Machines, AIX 5.x/6.1/7.1, Linux ES-4.5, HP-Unix 11.31/11.23, Sun-Solaris 5.9/5.10, AIX, RHEL, OCAC – Oracle Cloud at Customer, VMC, Openstack, AWR, OEM-11g, Grid Control, Data Guard, Oracle-18c/12c/11g RAC, OCAC, Automatic Storage Management (ASM), RMAN Backup, Tivoli Storage Manager (TSM), Service Desk Manager, ServiceNow, MKS (PC Integrity), GitHub…

MAJOR RESPONSIBILITIES:

Planned, Installed, configured and upgraded Oracle server software and related products RAC and non-RAC both with ASM.

Supported DEV/SIT/BAT/PAT & PROD environments for different projects – AML, Filenet

Upgraded and migrated databases from physical (non-cloud) environments to cloud environments

Assisted in database administration and management of Oracle database systems on Exadata.

Upgraded and migrated oracle databases 12cR1 on Linux to 12cR2 Exadata machine using datapump export/import.

Downloaded and managed scripts using source code version control systems like GitHub, MKS (PC Integrity)

Created and Managed Grid/ASM, RAC databases comprising of multiple nodes on AIX, Linux and Solaris systems

Refreshed/Cloned DEV/SIT/BAT/PAT & PROD environments for project teams using datapump export/import, RMAN active database duplication and restore

Used SQL*Loader as per requirement.

Developed Shell scripts to automate different database tasks.

Hardening of the databases across environments related to security and auditing as per TD standards.

Created and modified databases, objects, BIG/Small encrypted - non encrypted tablespaces, services, datapump directories etc.

Enforced and maintained database constraints to ensure the integrity of the database

Coordinated with different teams e.g. Unix, AIX, SAN, and Network for database build and support.

Monitored users, tablespaces, memory structures, logs and alerts.

Configured Oracle RMAN Online/Offline/Full/Incremental with Tivoli.

Planned and carried out RMAN database backup and recovery in different PROD and Non-PROD environments as required from time to time.

Performed Application and database tuning, worked with Developers helping optimized SQL performance using AWR/ADDM, ASH, statspack, OS Statistics

Setup and Managed Standby databases - Data Guard for performing both planned and unplanned switchovers and failovers

Rebuild Standby/Disaster Recovery (DR) environments using RMAN - incremental backups, RMAN active database duplication.

Provided on-site and off-site support in all environments.

Collected, managed and analyzed statistical data and produced reports for capacity planning

Monitored the databases, and appropriate action was taken on the alerts

Performed diagnostics, testing, and troubleshooting of database issues

Worked with Application Team(s) for new Deployments/ Enhancements

Engaged Oracle Support to work with and resolve Critical Sev1 & 2 issues

Analyzed and applied quarterly patches in DEV/SIT/BAT/PAT and finally planned and applied those patches in the production environment during maintenance window

Analyzed and developed improvements to DBA Services, Processes and Practices

Effectively worked with Management, Clients/End Users to produce user and technical documentation e.g. ASDP Docs.

Participated and conducted annual Disaster Recovery (DR)/Business Continuity/Contingency Plan (BCP) testing

Followed TD change management process to apply required changes in DEV/SIT/BAT/PAT & PROD as per requirement

IBM – Canada (Client: Encana) (Feb. 2018 – May 2018)

Senior Oracle DBA

Tools & Technologies: Oracle 12c, 11g, 10g, 9i, VM Ware, AIX, Linux, HP-Unix, Sun-Solaris, OEM-11g, RMAN Backup, Tivoli Storage Manager (TSM), …

MAJOR RESPONSIBILITIES:

Supported DEV/SIT/BAT/PAT & PROD environments for IFRS and other projects

Refreshed/Cloned DEV/SIT/BAT/PAT & PROD environments for project teams using datapump export/import, RMAN active database duplication and restore

Used SQL*Loader as per requirement.

Developed Shell scripts to automate different database tasks.

Hardening of the databases across environments related to security and auditing as per Rogers standards.

Created and modified databases, objects, application BIG/Small encrypted - non encrypted tablespaces, services, datapump directories etc.

Enforced and maintained database constraints to ensure the integrity of the database

Coordinated with different teams e.g. Unix, AIX, SAN, and Network for database build and support.

Monitored users, tablespaces, memory structures, logs and alerts.

Collected, managed and analyzed statistical data and produced reports for capacity planning

Monitored the databases, and appropriate action was taken on the alerts

Performed diagnostics, testing, and troubleshooting of database issues

Worked with Application Team(s) for new Deployments/ Enhancements

Engaged Oracle Support to work with and resolve Critical Sev. 1 & 2 issues

Analyzed and developed improvements to DBA Services, Processes and Practices

Followed IBM & Encana’s change management process to apply required changes in DEV/SIT/BAT/PAT & PROD as per requirement

TD Canada Trust (Nov. 2015 – Nov 2017)

Senior Oracle DBA

Tools & Technologies: Oracle 12c, 11g, 10g, 9i, AIX 5.x/6.1, Linux ES-4.5, HP-Unix 11.31/11.23, Sun-Solaris 5.9/5.10, AWR, OEM-11g, Grid Control, Data Guard, Oracle-12c/11g RAC, Automatic Storage Management (ASM), RMAN Backup, Tivoli Storage Manager (TSM), Service Desk Manager, ServiceNow…

MAJOR RESPONSIBILITIES:

Planned, Installed, configured and upgraded Oracle server software and related products RAC and non-RAC both with ASM.

Supported DEV/SIT/BAT/PAT & PROD environments for FATCA and other projects

Created and Managed Grid/ASM, RAC databases comprising of multiple nodes on AIX, Linux and Solaris systems

Refreshed/Cloned DEV/SIT/BAT/PAT & PROD environments for project teams using datapump export/import, RMAN active database duplication and restore

Used SQL*Loader as per requirement.

Developed Shell scripts to automate different database tasks.

Hardening of the databases across environments related to security and auditing as per TD standards.

Created and modified databases, objects, application BIG/Small encrypted - non encrypted tablespaces, services, datapump directories etc.

Enforced and maintained database constraints to ensure the integrity of the database

Coordinated with different teams e.g. Unix, AIX, SAN, and Network for database build and support.

Monitored users, tablespaces, memory structures, logs and alerts.

Configured Oracle RMAN Online/Offline/Full/Incremental with Tivoli.

Performed Application and database tuning, worked with Developers helping optimized SQL performance using AWR/ADDM, ASH, statspack, OS Statistics

Setup and Managed Standby databases using Oracle-11g Data Guard for performing both planned and unplanned switchovers and failovers

Rebuild Standby/Disaster Recovery (DR) environments using RMAN - incremental backups, RMAN active database duplication.

Provided on-site and off-site support in all environments.

Collected, managed and analyzed statistical data and produced reports for capacity planning

Monitored the databases, and appropriate action was taken on the alerts

Performed diagnostics, testing, and troubleshooting of database issues

Worked with Application Team(s) for new Deployments/ Enhancements

Engaged Oracle Support to work with and resolve Critical Sev1 & 2 issues

Analyzed and applied quarterly patches in DEV/SIT/BAT/PAT and finally planned and applied those patches in the production environment during maintenance window

Analyzed and developed improvements to DBA Services, Processes and Practices

Effectively worked with Management, Clients/End Users to produce user and technical documentation e.g. ASDP Docs.

Participated and conducted annual Disaster Recovery (DR)/Business Continuity/Contingency Plan (BCP) testing

Followed TD change management process to apply required changes in DEV/SIT/BAT/PAT & PROD as per requirement

TD Canada Trust (Aug. 2013 – Aug. 2015)

Senior Oracle DBA

Tools & Technologies: Oracle 11g, 10g, 9i, AIX 5.x/6.1, Linux ES-4.5, HP-Unix 11.31/11.23, Sun-Solaris 5.9/5.10, AWR, OEM-10g, Grid Control, Oracle-10g Data Guard, Oracle-11g/10g RAC, Automatic Storage Management (ASM), RMAN Backup, Tivoli Storage Manager (TSM), Service Desk Manager, Rivermine, ServiceNow…

MAJOR RESPONSIBILITIES:

Installed, configured and upgraded Oracle server software and related products

Supported DEV/SIT/BAT/PAT & PROD environments

Created and Managed ASM, RAC databases comprising of multiple nodes on AIX, Linux and

Solaris systems

Refreshed/Cloned DEV/SIT/BAT/PAT & PROD environments for project teams using datapump export/import, RMAN active database duplication and restore

Developed Shell scripts to automate different database tasks.

Upgraded RAC and non-RAC Oracle 10g &11g Environments with ASM.

Created and modified databases, objects, application BIG/Small enctypyed - non encrypted tablespaces, services, datapump directories etc.

Enforced and maintained database constraints to ensure the integrity of the database

Coordinated with different teams e.g. Unix, AIX, SAN, and Network for database build and support.

Monitored users, tablespaces, memory structures, rollback segments, logs and alerts.

Configured Oracle RMAN Online/Offline/Full/Incremental with Tivoli.

Performed Application and database tuning, worked with Developers helping optimized SQL performance using AWR/ADDM, ASH, statspack, OS Statistics

Setup and Managed Standby databases using Oracle-11g Data Guard for performing both planned and unplanned switchovers and failovers

Rebuild Standby/Disaster Recovery (DR) environments using RMAN - incremental backups, RMAN active database duplication.

Worked on Projects with Application Teams for new Deployments/ Enhancements

Analyzed and applied patches in DEV/SIT/BAT/PAT and finally planned and applied those patches in the production environment during maintenance window

Engaged Oracle Support to work with and resolve Critical Sev1 & 2 issues

Analyzed and developed improvements to DBA Services, Processes and Practices

Effectively worked with Management, Clients/End Users to produce user and technical documentation e.g. ASDP Docs.

Followed TD change management process to apply required changes in DEV/SIT/BAT/PAT & PROD as per requirement.

IBM – Canada (Client: Rogers Communications

Alberta Health Services (AHS)) (Sep. 2012 – Aug. 2013) and

(Sep. 2011 – June 2012)

Senior Oracle DBA

Tools & Technologies: Oracle 11g, 10g, 9i, AIX 5.x/6.1, Linux ES-4.5, HP-Unix 11.31/11.23, Sun-Solaris 5.9/5.10, AWR, SQL Tuning Advisor, OEM-10g, Grid Control, Oracle-10g Data Guard, Oracle GoldenGate, Oracle-11g/10g RAC, Automatic Storage Management (ASM), RMAN Backup, Veritas NetBackup and Tivoli Storage Manager (TSM).

MAJOR RESPONSIBILITIES:

Installed, configured and upgraded Oracle server software and related products

Supported production, development, Testing/QA and training environments

Created and Managed ASM, RAC databases comprising of multiple nodes on AIX, Linux and

Solaris systems

Refreshed UAT/DEV environments for project teams using BCV, RMAN clone and restore

Cloned databases to setup identical databases in the production and development environments

Scripts written to automate daily refresh of BCV servers.

Assisted in database administration and management of Oracle database systems on Exadata.

Upgraded RAC and non-RAC Oracle 9i,10g &11g Environments

Created and modified databases, objects, application tablespaces etc.

Enforced and maintained database constraints to ensure the integrity of the database

Coordinated with different teams e.g. Unix, AIX, SAN, and Network for server builds and support.

Performed security health checks on databases as per IBM standards.

Performed capacity planning, proposed/implemented as per requirement e.g. changing backup strategy, disk resource management.

Monitored users, table-spaces, memory structures, rollback segments, logs and alerts

Configured Oracle RMAN Online/Offline/Full/Incremental with Veritas Netbackup

Developed RMAN scripts for database backup and recovery including hot and cold backup.

Performed Application and database tuning, worked with Developers helping optimized SQL performance using AWR/ADDM, ASH, statspack, OS Statistics

Installed and configured OEM-10g Grid Control.

Setup and Managed Standby databases using Oracle-10g Data Guard for performing both planned and unplanned switchovers and failovers

Initiated, planned and implemented DR Testing as a team member for Disaster Recovery (DR) Exercises

Rebuild Disaster Recovery (DR) environments using incremental backups, active database duplication, IBM's global mirror etc.

Initiated, planned and implemented Data Centre Move

Worked on Projects with Application Teams for new Deployments/ Enhancements

Transferred data with export/import, Data Pump

Analyzed and applied patches in development, QA/test and finally planned and applied those patches in production during maintenance window

Analyzed and developed improvements to DBA Services, Processes and Practices

Effectively worked with Management, Clients/End Users to produce user and technical documentation.

Followed strict change management process. Applied changes in development, QA/test and rolled them out in production after following formal process of obtaining formal approvals etc.

EDUCATION:

M.Sc in Computer Science

M.Phil in Electronics.

PROFESSIONAL TRAINING:

Attended the following training courses:

Oracle 9i Database Administration Course

Oracle 10g : RAC Administration, Dataguard Administration

Oracle 11g: New Features for Admins, Performance Tuning

HP UX System Administration I

Oracle Cloud At Customer

Microsoft Azure Fundamentals Online Course.

REFERENCES:

Available upon request.

Contact this candidate