WAQAS CHAUDHARY



[pic][pic][pic][pic]

Waqas Chaudhry

Email: w.rehman70@

Phone: (416)-720-9048

----------------------------------------------------------------------------------------------------------------------------------------------

Looking for a challenging position as an Oracle/SQL Server/MongoDB/Postgresql DBA/Consultant

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 19c / 18c / 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

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

▪ Experience of Unix shell scripting

▪ Well versed with MS-Azure and ORACLE Cloud technologies

▪ 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 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, MS Windows Server 2002 SP2, Windows Server 2008 SP2, Windows Server 2012 R2 |

|Databases |Oracle 19c / 18c / 12c / 11g /10g / 9i / 8i / 8.x / 7.3 , Real Application Cluster – (RAC), |

| |Data Guard, ASM, Oracle Clusterware, OCAC, SQL Server 2008 / 2012 |

|Cloud Technologies |MS Azure, Oracle Cloud |

|Backup Tools |Oracle RMAN, IBM Tivoli Storage Manager, VERITAS Netbackup, BCV Split Methodology, IBM's Global|

| |Mirror |

|Performance Tuning Tools |ADDM, AWR, ASH, STATSPACK, Explain Plan, SQL Trace, TKPROF |

|Software’s, Applications, Tools |MS Office Tools, Lotus Notes, IBM Lotus Symphony, HP OpenView, Skype, MS Teams, Secure CRT, |

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

| |Integrity), Golden Gate V10/V11, DBUA, DBCA, Data Pump, SQL*Plus, SQL*Loader, |

WORK EXPERIENCE:

TD Canada Trust (May 2018 – till date)

Senior Database Administrator

Databases, Tools & Technologies: Oracle 19c, 18c, 12c, 11g, 10g (RAC & Non-RAC), OCAC – Oracle Cloud at Customer, VMC, Openstack, AIX, Linux, HP-Unix, Sun-Solaris, AWR, OEM-11g, Grid Control, Data Guard, Automatic Storage Management (ASM), RMAN Backup, Tivoli Storage Manager (TSM), Commvault, ServiceNow, MKS (PC Integrity)…

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 OCAC - 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.

▪ Experience of managing Oracle12c on Cloud such as OCAC, Rackspace and VMWARE.

▪ 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 ASH, statspack, OS Statistics

▪ Performed Application and database tuning, worked with Developers helping optimized SQL performance using AWR/ADDM, sql profiles.

▪ 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 Database Administrator

Databases, Tools & Technologies: Oracle 12c, 11g, 10g, 9i, VM Ware, AIX, Linux, HP-Unix, Sun-Solaris, 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 Database Administrator

Databases, Tools & Technologies: Oracle 12c, 11g, 10g (RAC & Non-RAC), OCAC – Oracle Cloud at Customer, VMC, Openstack, AIX, Linux, HP-Unix, Sun-Solaris, AWR, OEM-11g, Grid Control, Data Guard, Automatic Storage Management (ASM), RMAN Backup, Tivoli Storage Manager (TSM), Commvault, ServiceNow, MKS (PC Integrity)…

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 Database Administrator

Databases, Tools & Technologies: Oracle 11g, 10g (RAC & Non-RAC), OCAC – Oracle Cloud at Customer, VMC, Openstack, AIX, Linux, HP-Unix, Sun-Solaris, AWR, OEM-11g, Grid Control, Data Guard, Automatic Storage Management (ASM), RMAN Backup, Tivoli Storage Manager (TSM), Commvault, ServiceNow, Rivermine …

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 Database Administrator

Databases, 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.

CERTIFICATIONS:

▪ Oracle Cloud Infrastructure 2019 Certified Architect Professional

▪ Microsoft Certified: Azure Fundamentals

▪ Oracle Autonomous Database Cloud 2019 Certified Specialist

▪ Oracle Cloud Infrastructure 2019 Architect Associate

▪ Oracle Cloud Infrastructure Foundations 2020 Certified Associate

▪ M001: MongoDB Basics, MongoDB Inc.

▪ M103: Basic Cluster Administration, MongoDB Inc.

▪ M201: MongoDB Performance, MongoDB Inc.

▪

PROFESSIONAL TRAINING:

Attended the following training courses:

▪ Oracle Autonomous Database Cloud Certified Specialist

▪ Oracle Cloud Infrastructure 2019 Certified Architect Professional

▪ Oracle Cloud Infrastructure Certified Architect Associate

▪ M001: MongoDB Basics, MongoDB Inc.

▪ M103: Basic Cluster Administration, MongoDB Inc.

▪ M201: MongoDB Performance, MongoDB Inc.

▪ Oracle Cloud At Customer

▪ Microsoft Azure Fundamentals Online Course.

▪ Oracle 10g: RAC Administration, Dataguard Administration

▪ Oracle 11g: New Features for Admins, Performance Tuning

▪ HP UX System Administration I

REFERENCES:

Available upon request.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download