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