Systems Analyst 3-Support at Oracle

Job Description

• 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:

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

• Career Level - IC3

Responsibilities

• Being responsible operationally to support critical customers on site and remote with high skills for troubleshooting and solving technical issues
• Analytical skills are key for this position.