Systems Analyst 3-Support Job Oracle

IT Jobs In Kenya

There are high expectations from the candidate profile to be very skilled in business communications not only with sales, pre-sales and technical account managers but also with customers. Presentation skills are key too. The candidate nominated for this job should be having a passion to participate in business growth with a very talented technical skills covering the areas below:

Responsibilities

Database Administration

  • 11g/12c/19c General RDBMS Issues and DBA activities.
  • Installing, Designing, Configuring, Administering and troubleshooting of oracle 11g/12c Databases.
  • Administer the complete Oracle environment including databases, Applications and services.
  • Monitor database conditions throughout the network including server Side and client side.
  • Oracle Enterprise Manager Installation, configuration and upgrades.

Backup and Recovery

  • Database Backup (RMAN and User-Managed Backup… etc)
  • Backup strategies according to workload.
  • Database Restore using different methods.
  • Database Recovery by using User-Managed recovery Method or RMAN method.
  • Complete recovery (to the most current point in time).
  • Incomplete recovery by using one of the following methods:
  • Time-Based Recovery – Cancel-Based Recovery.
  • Tablespace Point in Time Recovery.
  • Oracle Secure Backup.
  • Fixing corruptions and using DULL tool.

Oracle Utilities

  • Have knowledge to export and import any of database objects (tablespaces, users…full database).
  • Export/Import using Oracle Data Pump utility.
  • SQL Loader
  • Database Character set conversion

Migration /Upgrades and loading data

  • Migrating database any release into 11gR2/12c/19c databases.
  • Performing different database upgrades from/to different releases using all types of upgrades.
  • Migrating (Moving) databases from server to another with minimal down time.
  • Loading data into any Oracle database release.
  • Database migrations using all methods including Golden Gate, Transportable Tablespaces, Transportable Database.

Oracle Data Guard

  • Configuring, administering and troubleshooting standby (logical/physical) databases environment in single DB instance and RAC/ASM environments.

Oracle Real Application Cluster/ASM

  • Installing, Patching, Upgrading administrating and Troubleshooting RAC environments / ASM.
  • RAC High Availability Test.

Database Security

  • Database Vault
  • Audit Vault and Database Firewall
  • Transparent Data Encryption (TDE)
  • Virtual Private Database (VPD)
  • Oracle Data Masking & Redaction

Read>>>3 Ways Action Words Can Help Your CV Stand Out

How To Apply

Click here to apply