Oracle DB Consultant
We are looking for an experienced Oracle DB consultant to join our team in Zurich.
Main Responsibilities:
* Deploy and install new Oracle database infrastructure
* Install, maintain, administer and patch Oracle appliance bare metal systems with virtualization technology
* Migrate on-premises and cloud databases
* Patch and update databases using Ansible for large-scale patching
* Deploy and configure high availability databases (Data Guard for EE version, dbvisit for SE version, RAC, etc.)
* Offer solutions to meet customer requirements (Snapshots, container database, etc.)
* Implement, configure and manage database backups
* Recover databases following incidents
* Replicate and move data using various technologies (RMAN duplicate, Data Pump Export/Import, etc.)
* Replicate, filter and transform data with Oracle GoldenGate
* Solve database performance issues (study and analyze database performance)
* Administer and troubleshoot Oracle databases (user support)
* Licensing audit
* Create shell scripts, SQL and PL/SQL scripts
* Prepare technical documentation for projects and solutions
Your Profile:
* Confirmed experience with the Oracle database server
* Excellent knowledge and strong experience of Oracle RMAN backup and restore
* Oracle Tuning is part of your skillset
* Knowledge of high availability with Dataguard or Real Application Cluster
* A good team player
* Fluent French and/or German and proficient in English
* Knowledge about Apex and PL/SQL