7+ Years of experience on Oracle DBA , Performance Tuning ,Oracle GoldenGate , Data Guard , RAC , SQL and PL/SQL Developer.
•Over 7 years of experience as an Oracle DBA (12c / 11g / 10g) in Production Environment and as Online Oracle DBA Trainer.
•Good Understanding of Oracle Database Architecture.
•Good experience in Installation and Administration of Oracle database server 12c / 11g / 10g on Windows and Linux Environment
•Having good knowledge in Configuring and maintaining RMAN
•Expertise in implementing backup & recovery strategy for databases using RMAN
•Having good experience in cloning the database through Cold, Hot and RMAN
•Having good experience with the tools like Datapump and traditional Export/Import.
•Extensive hands-on experience in Table space Management, Users Management, Roles & Privileges.
•Performing Performance Tuning using Explain Plan, TkProf, AWR.
• Experience in upgrading database from Oracle 11g to 12c.
•Knowledge on upgrading oracle database from 10g to 11g and patch set level up gradation from 10.2.0.1 to 10.2.0.5.
•Experience in Writing Oracle SQL,PL/SQL Code - Creating of Database Object like Table,View,Sequence,Synonyms,Index,Procedure,Function,Trigger,Packages,Cursor - Implicit and Explicit
•Experience in Implementing Oracle Data Guard - Physical Standby , Active Data Guard , Logical Standby , Snapshot Standby Database , Data Guard Patching , Rolling upgrade in Data Guard Environment.
•Experience in Implementing 2 Node RAC on linux and Windows Environment , Migrate Single Instance to Two Node RAC.
•Experience in Configuring Oracle GoldenGate Replication on Oracle Database 12c
Work Terms
Hours of operation - 20 hours Max.
Payment terms - weekly
preferred communication language - English