Senior Database Administrator
TD Canada Trust
Keywords
Oracle Databases
Microsoft Azure
Cloud Computing
Database Administration
IBM AIX
Backup Devices
Databases
Oracle Data Guard
Oracle Exadata
HP-UX
Skills
backups, Backup, Citrix, Cloud technologies, Cloud, Cloud Service, Commvault, cron jobs, Data Centre, Storage Management, database tuning, databases, database, datapump, Disaster Recovery, GitHub, Grid Control, HP OpenView, HP-UX, HP UX, AIX, IBM AIX, Lotus Notes, Lotus, Filenet, IBM's, IBM Tivoli Storage Manager, Computer Science, Linux, MKS, MS-Azure, MS Azure, Microsoft Azure, MS Office Tools, SQL Server, SQL Server 2008, MS Windows Server, MongoDB, VERITAS Netbackup, servers, node, Openstack, Operating Systems, Oracle, Oracle Cloud Infrastructure, Data Guard, Dataguard, 12c, 9i, Oracle DBA, Oracle database, oracle databases, Oracle 11g, Oracle 10g, Oracle-10g, Oracle 9i, Oracle Exadata, Exadata, Performance Tuning, Postgresql, PuTTY, RMAN, RHEL, database constraints, Cloud Backup, Remote Desktop, REST API, SQL, SQL*Plus, ServiceNow, Shell scripts, Skype, version control systems, Solaris, SUN Solaris, SQL Tuning, Symphony, Tivoli, Unix, Unix shell scripting, VNC, VMWARE, VM Ware, Windows Server 2008, Windows Server 2012 R2
Project history
05/2018
-
10/2018
Databases, Tools & Technologies: Oracle 19c, 18c, 12c, 11g, 10g (RAC & Non-RAC), Gen 1 Exadata Cloud
at Customer - exaCC, 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), Delphix,
Commvault, ServiceNow, MKS (PC Integrity)...
MAJOR RESPONSIBILITIES:
* 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
at Customer - exaCC, 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), Delphix,
Commvault, ServiceNow, MKS (PC Integrity)...
MAJOR RESPONSIBILITIES:
* 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
02/2018
-
05/2018
Senior Database Administrator
IBM
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
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
11/2015
-
11/2017
Senior Database Administrator
TD Canada Trust
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
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
08/2013
-
08/2015
Senior Database Administrator
TD Canada Trust
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.
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.
09/2012
-
08/2013
Senior Database Administrator
IBM; Alberta Health Services (AHS))
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.
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.
Certifications
Microsoft Certified: Azure Fundamentals
Microsoft
2019
Oracle Cloud Infrastructure 2019 Certified Architect Professional
ORACLE
2019
Oracle Autonomous Database Cloud 2019 Certified Specialist
ORACLE
2019
Local Availability
Open to travel worldwide
