ACS Principal Database Engineer, Cloud Platform at ORACLE

Job Overview

Location
Lagos, Kebbi
Job Type
Full Time
Date Posted
3 years ago

Additional Details

Job ID
1648
Job Views
170

Job Description

  • Application Deadline:
  • Position: ACS Principal Database Engineer, Cloud Platform

  • Job Type Full Time

  • Qualification BA/BSc/HND

  • Experience

  • Location Not specified

  • Job Field ICT / Computer 



Preferred Qualifications


Candidate should have the below technical skills:


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

  • Oracle Label Security


Systems - Exadata



  • Exadata configuration, Administration, Patching, Baremetal restore, Performance Tuning, Migrations, Upgrades, DBFS, VLAN tagging and HCC compression.

  • Exadata IORM implementations.

  • Exadata High Availability Test.

  • ZFS storage configuration and administration for backup and recovery.


Oracle Golden Gate



  • Golden Gate Installation Configuration.

  • Golden Gate replications Classic , Integrated and Coordinated.

  • Oracle database migration using Golden Gate

  • Golden Gate performance.

  • Golden Gate Veridata installation and configuration for creating comparisons.

  • Golden Gate Plugin for OEM


Oracle Performance Tuning



  • Troubleshooting different performance issues

  • Hang analysis & Cluster eviction issues

  • SQL Tuning with different methodologies , SQL Profiles , SPM and SQL restructure

  • Gather Statistics with different strategies based on workload and business

  • Oracle Real Application Testing (RAT).

  • Oracle SQL Performance Analyzer (SPA)

  • Database Tuning , Memory Tuning , Backup Tuning & Data Pump Tuning

  • Works with different performance utilities AWR, ADDM , ASH and others.

  • Database Resource Manager (DBRM)


Enterprise Manager & Cloud



  • Installation of Enterprise Manager Systems

  • Patching and Upgrade of OEM to different versions

  • Engineered System Machine Discovery ( Exadata , Super Cluster and ZFS)

  • Install Different Plugins , Siebel , Golden Gate

  • Email Notification for different metrics and thresholds

  • Good Knowledge of Cloud Management including Paas , DBaas , Service catalogue and Snap Clone

  • Migrating Oracle Databases to Database as a Service.


Business and communications skills are mandatory required, selected candidate will be wortking along with sales/pre-sales to build LoEs and customer orientation meetings


Similar Jobs

Cookies

This website uses cookies to ensure you get the best experience on our website. Cookie Policy

Accept