Support Revolution is the leading provider of independent third-party software support and maintenance for Oracle and SAP systems - saving our customers up to 90% on their vendor support costs. But customers don't just come to us for the savings, because we have more than 25 years of experience in the Oracle and SAP market, and the fact that we provide 24/7 support for our customers and support any and all software versions and customisations (so no more upgrades).

Environment: Oracle 19c/12c/11g Linux/Windows. Responsibilities: Installation & Configuration of Oracle software in HP-UNIX/Linux/Windows platforms. Creation of Database using DBCA and proficient in client installations.  Basic knowledge on OEM 12c. Oracle 12c installation on Redhat 7. 12c db administration. 12c listener and their logs. Install Oracle GoldenGate 12c and, set up and manage replication. Schema/database refreshes across different… Show more Environment: Oracle 19c/12c/11g Linux/Windows. Responsibilities: Installation & Configuration of Oracle software in HP-UNIX/Linux/Windows platforms. Creation of Database using DBCA and proficient in client installations.  Basic knowledge on OEM 12c. Oracle 12c installation on Redhat 7. 12c db administration. 12c listener and their logs. Install Oracle GoldenGate 12c and, set up and manage replication. Schema/database refreshes across different databases/servers using exp/expdp and imp/impdp as per the client’s requirements. ADRCI utility. Database restoration/recovery and Cloning using RMAN to new servers. Identifying corrupted blocks using RMAN and rectifying it. Install Oracle GI and create RAC database instances. Managing RAC instances and Dataguard enabled databases. Patching 2 node RAC instances using OPatch utility. Database upgrades using DBUA. Creating physical standby using RMAN active duplicate. Switchover/Failover (activate standby) databases in case of a DR situation. Migration of primary and standby databases across data centers. Dataguard DR Drill test (manual switchover and failover). Performance monitoring and identifying long running queries, blocking/locking sessions using Oracle utilities like ADDM, AWR, STATSPACK and kill the blocking sessions as required. Proficient in understanding SQL queries or PL/SQL procedures and writing SQL queries. Communication with Oracle On demand - raising SRs for newly reported issues/bugs and fixing them. Basic knowledge on Linux administration and shell scripting. Installing and creating Oracle RDS instances on AWS. Upgrading RDS instances to newer versions as recommended by Oracle/AWS. Changing classes. Creating/modifying option groups and parameter groups and modifying them as needed. Performance monitoring and providing solutions for the same to customer. Restarting RDS instances when requested. Show less

Database Managed Services Oracle DBA Client: Johnson and Johnson, NA & EMEA region Role: Oracle DBA Duration: June 2011 to Feb 2015 Environment: Oracle 8i/9i/10g/11g/Unix/Linux/Windows. Responsibilities:  Installation & Configuration of Oracle software in HP-UNIX/Linux/Windows platforms. Creation of Database using DBCA and proficient in client installations.  Implementing and maintaining Database Security (create and maintain users and roles… Show more Database Managed Services Oracle DBA Client: Johnson and Johnson, NA & EMEA region Role: Oracle DBA Duration: June 2011 to Feb 2015 Environment: Oracle 8i/9i/10g/11g/Unix/Linux/Windows. Responsibilities:  Installation & Configuration of Oracle software in HP-UNIX/Linux/Windows platforms. Creation of Database using DBCA and proficient in client installations.  Implementing and maintaining Database Security (create and maintain users and roles, assign privileges and enabling auditing at DB level).  Schema/database refreshes across different databases/servers using exp/expdp and imp/impdp as per the client’s requirements. Automating them as required. Monitoring various database activities like number of users/sessions connected, CPU/memory usage, alert log and trace files for any errors.  Strong experience in Database sizing, Space management and Table space management.  Enhance database administration by developing scripts to check database instance availability, listener availability, alert log files for errors, clean up old log files. Applying CPU Patch & Quarterly Patch with Patch Set.  Implementing and scheduling backups for the DBs using exp/expdp or RMAN (hot or cold) as per the client standards. Creating private/public Database links and managing them.  Performance monitoring and identifying long running queries, blocking/locking sessions using Oracle utilities like ADDM, AWR, STATSPACK, & TKPROF and providing suggestion to the Customer to optimize the query using explain plan/SQL TRACE or kill the blocking sessions as required. Oracle Net Configuration, troubleshooting of connectivity issues due to tnsnames.ora or listener configuration.  Communication with Oracle On demand by raising SRs for newly reported issues/bugs. Basic knowledge on Unix/Linux administration and shell scripting. Show less