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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.