Oracle DBA

Skills

1. Strong knowledge on Database architecture design Oracle Real Application Clusters (RAC) DR/HA/backup solutions ASM support Golden Gate & Shell Scripting. 2. Participate in client/project meeting(s) for needs assessment and design review & change. Design develop implement and maintain database for internal and external users. 3. Experience 10to11Yrs 4. Required Skills Oracle Database Administration Goldengate Oracle RAC 5. Shift Day 08AM TO 05PM EST Roles & Responsibilities 1. Strong knowledge on Database architecture design Oracle Real Application Clusters (RAC) DR/HA/backup solutions ASM support Golden Gate & Shell Scripting. 2. Participate in client/project meeting(s) for needs assessment and design review & change. Design develop implement and maintain database for internal and external users/clients 3. Should have good previous experience in administering/upgradation/Migration Oracle DBs versions 11 12 to 19c in a high availability environment experience in implementing DB upgrades & Migration.

Description

1.Oracle RAC DBA, Oracle Core DBA
2. Oracle Goldengate
3. Oracle Migration skill

Responsibilities

• a. Run a zero-downtime upgrade using Oracle Golden Gate for replication.
• b. Run a zero-downtime upgrade using Oracle Data Guard for replication.
• c. Customize zero-downtime upgrades using the user-action framework of Fleet Patching and Provisioning.
• d. Database Upgrade Assistant
• e. Manual Command-line Upgrade
• f. Transportable Tablespaces
• g. Data Pump export/import
• 4. Strong Experience with Oracle KVA & PCA, Oracle Linux Golden Gate, Veridata, Streams a plus
• 5. Analyse the needs and requirements of users of existing and proposed database systems and develops technical, structural, and organizational specifications to include access methods, access time, job control language, statistical methodologies, device allocation, validation checks, protection and security
• 6. Create, document, and implement standards and/or modelling to monitor and enhance the capacity and performance of the database Program and write codes as necessary.