
Principal Success Services Engineer, CSS Tech Delivery, Database
- Saudi Arabia
- Permanent
- Full-time
- 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.
- 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.
- 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
- 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.
- Configuring, administering and troubleshooting standby (logical/physical) databases environment in single DB instance and RAC/ASM environments.
- Installing, Patching, Upgrading administrating and Troubleshooting RAC environments / ASM.
- RAC High Availability Test.
- Database Vault
- Audit Vault and Database Firewall
- Transparent Data Encryption (TDE)
- Virtual Private Database (VPD)
- Oracle Data Masking & Redaction
- Oracle Label Security
- 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.
- 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
- 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)
- 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.
- Oracle Cloud IaaS: VCN, ADs, Instance, Storage, IAM, LB, Database, and DNS
- Oracle Engineered Systems, Exadata, PCA, ZFS Storage and Backup Appliances, InfiniBand Switches, Ops-center, OVM, Enterprise Manager, ZDLRA
- Oracle Sun Solaris OS, Network and Cluster Administration, Solaris 8, 9, 10, 11
- Oracle Sun Hardware V/T/M-Series SPARC and x86 design, implementation, support
- OVM, Xen, PDoms, LDoms, zones, SVM, UFS, ZFS, NFS, Flash Archive, Jump start, AI Installer