An experienced Oracle Database Administrator with more than 10+ years of real time experience in the fields if core database admin activities like installations, patching, online database upgrades, CDC sync using oracle godengate and Dataguard, possess great expertise with oracle Sql and Plsql languages in both windows and Linux platforms.
➢ Install software, create Database, configure monitoring & backups as per standards.
➢ Work with application team for deploym...
➢ Install software, create Database, configure monitoring & backups as per standards.
➢ Work with application team for deployments.
➢ Work on alerts, requests, incidents, change requests/tasks.
➢ Production database enhancements and implement long term fixes
➢ Backup validation by performing restoration tests.
➢ Maintain high availability and in-sync DR for the databases.
➢ Drive towards maintaining latest software version of Oracle 12c-19c upgrade roll outs.
➢ Implemented centralized monitoring for Oracle databases using Oracle 12c/13c Cloud control.
➢ Configured a two node SQL 2019 Cluster.
➢ Installed configured Oracle EBS 11i and its oracle database installation and configuration.
➢ Install software, create Database, configure monitoring & backups as per standards
➢ Work with application team for deployme...
➢ Install software, create Database, configure monitoring & backups as per standards
➢ Work with application team for deployments.
➢ Work on alerts, requests, incidents, change requests/tasks.
➢ Production database enhancements and implement long term fixes
➢ Backup validation by performing restoration tests.
➢ Maintain high availability and in-sync DR for the databases.
➢ Worked on migration of all Databases from one Datacenter to another on a new hardware.
➢ Drive towards maintaining latest version of Oracle software and 12c upgrade roll outs.
➢ Implemented Goldengate replication.
➢ Writing anonymous pl/sql blocks, stored procedures to facilitate the Database administration.
➢ Proactive tuning of the database.
➢ Installed configured Oracle EBS 11i and its oracle database installation and configuration.
➢ Responsible for patching of oracle RDBMS and applications.
➢ Configured a three node SQL 2019 Cluster.
➢ Upgraded the production mission critical databases from 11.2.04 to 12.1.0.2.
➢ Configured Oracle Vault and VPD.
I worked onsite for the client NCB to upgrade & migrate various versions of Oracle databases on different hardware.
➢ Database...
I worked onsite for the client NCB to upgrade & migrate various versions of Oracle databases on different hardware.
➢ Database upgrades and migrations from Oracle 10gR2 & 11gR1 on IBM Power Systems & Conventional hardware to Oracle 11gR2, Oracle 12cR2.
➢ Configuring Oracle databases (Linux/Windows) in Oracle 12c Cloud control for monitoring.
➢ Proactive performance monitoring and regular health checks of databases.
➢ Maintain physical standby database in sync with production.
➢ Performed various installations for 2-node 11gR2 RAC on Linux and Windows.
➢ Plan and devise suitable backup strategy for databases and perform backup-restore test drills.
➢ Perform switchover test drills
➢ SQL Server installations and monitoring.