Experience
Senior Database Administrator
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 oracle 11g databases in DEV, SIT, PAT & PROD to 19c using data-pump export/import.
Upgraded and migrated databases from physical (non-cloud) environments to cloud environ-ments
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 sup-port.
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 per-formance using ASH, statspack, OS Statistics
Performed Application and database tuning, worked with Developers helping optimized SQL per-formance using AWR/ADDM, sql profiles.
Setup and Managed Standby databases - Data Guard for performing both planned and un-planned 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 docu-mentation e.g. ASDP Docs.
Participated and conducted annual Disaster Recovery (DR)/Business Continuity/Contingency Plan (BCP) testing
Responsible for testing, patching, troubleshooting, optimization and maintenance of SQL Server 2012/2014/2016 databases
Install and setting up SSIS, SSAS and SSRS servers, deploy SSIS/SSRS packages and pro-jects.
Checked and monitored database replication, log shipping, mirroring, backup/ restore and maintenance jobs.
Education
M.Sc
Master's in Computer Science