Systems Analyst 3-Support at Oracle

Job Description

Oracle Corporation is an American multinational computer technology corporation, headquartered in Redwood City, California.

Responsibilities

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.