Senior Database Administrator, Senior Database Administrator, Senior Database Administrator

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

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

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