Oracle DBA Administrator candidate in Bangalore, Karnataka, India

Summary

Experienced Oracle Database Administrator with extensive expertise in database management across production, development, and stagingenvironments. Over a career spanning multiple roles, skills demonstrated include installation, configuration, and upgrades of Oracle databases (versions19c to 21c) and OEM tools (24 AI and 13.5), alongside proficiency in data migration using RMAN and Expdp/Impdp, high availability setups like RAC andData Guard, and ASM instance administration. Advanced troubleshooting of OMS/OMA issues, incident management within SLAs, and implementationof monitoring solutions contributed to enhancing operational efficiency. Utilizes tools such as Srvctl/Crsctl commands for cluster environmentsalongside methodologies like AWR/ASH report analysis for query optimization, demonstrating problem-solving acumen. Seeks opportunities in rolesfocusing on enterprise-scale database management that leverage expertise in Oracle technologies while aligning with operational excellence objectives.

Expectations

Work experience

Oracle India Private Limited June 2022 - Till Date
Enterprise Manager Technical Analyst
Conducted comprehensive administration of Oracle Enterprise Manager (OEM), including target discovery, agent and OMS configuration, troubleshooting, monitoring, and alert management.
Installed and upgraded OEM versions 24 AI and 13.5, performed RU patching, and set up Cloud Control plugins alongside dashboard configuration and monitoring.
Demonstrated advanced troubleshooting capabilities for key components of Oracle Enterprise Manager such as Oracle Management Server (OMS), Oracle Management Agent (OMA), and Oracle Management Repository (OMR).
Managed incident rules administration, target metrics setup, monitoring templates, and reporting workflows within OEM to enhance operational efficiency.
Led database upgrades to Oracle Database 21c and coordinated installation of the 23 AI database version.
Utilized expertise in OEM tools to ensure seamless integration between systems while streamlining enterprise IT monitoring processes.

DXC Technology December 2016 - June 2022
Professional II database Administrator
Upgraded Oracle database from version 19c to 21c and managed installation, setup, and configuration of Oracle database versions 21c, 19c, 12c, and 11g on Unix/Linux environments.
Installed and patched OEM (Oracle Enterprise Manager) versions 24 AI and 13.5, including RU patching on OMS (Oracle Management Server) and Management Agents.
Performed high availability implementations, including Physical Standby Data Guard setups, RAC configurations, Active Data Guard setups, and regular RU maintenance through out-of-place (OOP) patching.
Conducted database performance tuning at query, instance, and database levels by creating SQL profiles/baselines and analyzing AWR/ASH SQL reports; optimized performance by addressing problematic queries in OEM through plan adjustments and stat updates.
Designed and implemented database backup strategies for production and non-production databases using RMAN; executed data migration between databases via RMAN as well as Expdp/Impdp utilities.
Administered ASM instances with tasks such as adding disks to ASM Disk Groups; performed management of RAC environments using Srvctl/Crsctl commands for monitoring instances/databases and controlling startups/shutdowns.
Good knowledge on Fleet maintenance and Agent deployment.
Worked on applying latest quarter/half/annual RU maintenance by OOP patching.

KPIT Technologies July 2016 - December 2016
Database Administrator
Managed and supported all production, development, and staging Oracle database instances (versions 9i, 10g, 11g, 12c) to ensure optimal performance and reliability.
Monitored databases daily, including RAC instances and ASM disk groups usage, addressing space utilization by resizing or adding datafiles as necessary.
Coordinated activities for high-priority incidents (P1 and P2), ensuring timely resolution in compliance with SLAs and providing round-the-clock response to critical events.
Performed database maintenance tasks such as relinking grid/database homes post OS patching/upgrades, resolving FRA issues in primary/standby configurations, and gap monitoring.
Conducted installations and configurations of Oracle Clusterware and database software while troubleshooting common issues related to integration (e.g., bugs, network issues, OCR problems).
Executed database migrations for Oracle versions 11g and 12c Work experience

Oracle India Private Limited June 2022 - Till Date
Enterprise Manager Technical Analyst
Conducted comprehensive administration of Oracle Enterprise Manager (OEM), including target discovery, agent and OMS configuration, troubleshooting, monitoring, and alert management.
Installed and upgraded OEM versions 24 AI and 13.5, performed RU patching, and set up Cloud Control plugins alongside dashboard configuration and monitoring.
Demonstrated advanced troubleshooting capabilities for key components of Oracle Enterprise Manager such as Oracle Management Server (OMS), Oracle Management Agent (OMA), and Oracle Management Repository (OMR).
Managed incident rules administration, target metrics setup, monitoring templates, and reporting workflows within OEM to enhance operational efficiency.
Led database upgrades to Oracle Database 21c and coordinated installation of the 23 AI database version.
Utilized expertise in OEM tools to ensure seamless integration between systems while streamlining enterprise IT monitoring processes.

DXC Technology December 2016 - June 2022
Professional II database Administrator
Upgraded Oracle database from version 19c to 21c and managed installation, setup, and configuration of Oracle database versions 21c, 19c, 12c, and 11g on Unix/Linux environments.
Installed and patched OEM (Oracle Enterprise Manager) versions 24 AI and 13.5, including RU patching on OMS (Oracle Management Server) and Management Agents.
Performed high availability implementations, including Physical Standby Data Guard setups, RAC configurations, Active Data Guard setups, and regular RU maintenance through out-of-place (OOP) patching.
Conducted database performance tuning at query, instance, and database levels by creating SQL profiles/baselines and analyzing AWR/ASH SQL reports; optimized performance by addressing problematic queries in OEM through plan adjustments and stat updates.
Designed and implemented database backup strategies for production and non-production databases using RMAN; executed data migration between databases via RMAN as well as Expdp/Impdp utilities.
Administered ASM instances with tasks such as adding disks to ASM Disk Groups; performed management of RAC environments using Srvctl/Crsctl commands for monitoring instances/databases and controlling startups/shutdowns.
Good knowledge on Fleet maintenance and Agent deployment.
Worked on applying latest quarter/half/annual RU maintenance by OOP patching.

KPIT Technologies July 2016 - December 2016
Database Administrator
Managed and supported all production, development, and staging Oracle database instances (versions 9i, 10g, 11g, 12c) to ensure optimal performance and reliability.
Monitored databases daily, including RAC instances and ASM disk groups usage, addressing space utilization by resizing or adding datafiles as necessary.
Coordinated activities for high-priority incidents (P1 and P2), ensuring timely resolution in compliance with SLAs and providing round-the-clock response to critical events.
Performed database maintenance tasks such as relinking grid/database homes post OS patching/upgrades, resolving FRA issues in primary/standby configurations, and gap monitoring.
Conducted installations and configurations of Oracle Clusterware and database software while troubleshooting common issues related to integration (e.g., bugs, network issues, OCR problems).
Executed database migrations for Oracle versions 11g and 12c