Cloud-Hybrid Database and Application Administrator

Location: Geneva, GE, ch

Company Description

We are the world’s largest independent energy and commodities trading company. Every day we use our expertise and logistical networks to distribute energy around the world, efficiently and responsibly. From 40 offices worldwide, we seek to add value across the energy supply chain, including deploying our scale and market understanding to help facilitate the energy transition. To date, we have committed over $1 billion of capital to renewable projects, and are identifying and developing low-carbon opportunities around the world.

Our people are our business. Talent is precious to us and we create an environment in which individuals can reach their full potential, unhindered by hierarchy. Our team comprises more than 65 nationalities and we are committed to developing and sustaining a diverse work force. Learn more about us here.

Job Description

You will be part of a global, evolving and dynamic team of database administrators. As part of this team and based in Geneva, you will have both regional and global responsibilities. We are looking for someone who can fill in this unconventional role, straddling both traditional, on premises databases and also being an important player in our cloud ecosystems. If this is you or you have a vested interest to upskill yourself in Cloud database setup and administration, coming from a more traditional DBA background, we would like to hear from you.

Main duties and responsibilities:

• Ensure deployment, support and being accountable on-premises and in the Cloud on the following areas: 
  • Databases hosting & infrastructure
  • Databases Administration & Security
  • Oracle middleware products
  • CTRM (Commodity Trading and Risk Management platform) and Analytics applications: installation, critical business process monitoring and business & developer support

• Support and interact with teams across infrastructure, security, network and applications both regionally and globally
• Document standards and follow procedures
• Monitor and manage databases and Unix equipment WW
• Performance Tuning

Desirable Personal attributes

• Team player (both locally and as part of a worldwide team) with an open, direct, nonjudgemental style
• Proactive and always thinking ‘improvement’ to bring further efficiency to both business and technical data flows.
• Takes ‘ownership’ of outcome and is comfortable in a fast-paced environment
• Flexible and ready to work long hours when required and also the occasional week-end work
• Can work independent and report to his manager

Qualifications

• At least 5 years of experience in similar or equivalent position with the following requirements
  • Hands on Oracle Databases v19+ included knowledge in DataGuard, Pdb-Cdb, RMAN, RAC, Monitoring (OEM), ASM & Performances tools & options
  • Databases hosting and Operating Systems : Oracle Solaris and Oracle Linux in a standalone & Cluster environment, on-prem or in Cloud

• Strong experience with the following Oracle Middleware products:
  • OGG: Oracle Golden Gate ( data replication, Zero Downtime maintenances)
  • Oracle Veridata
  • OUD: Oracle Unified Directory
  • DMU: Data Migration Utility
  • Oracle Lifecycle Management Pack

• Strong experience in managing and supporting Databases and Services in Public Cloud-hybrid Environment (AWS, OCi,… )
• Experience in Database infrastructure environment : Oracle Sparc, HPe servers and NetApp Storages and Oracle Engineered Systems
• Experience in automation using shell and Python scripting to streamline processes and improve system efficiency.
• Experience in orchestration and scheduling using Prefect and Active Batch
• Proven ability to diagnose and resolve complex hardware/software issues, conduct root cause analysis, and implement mitigation strategies.
• Strong analytical skills
• Excellent communication skills in English, both written and spoken

Additional Information

• Nice to have
  • Databases
    • PostgreSQL / MariaDB / MySQL / MongoDB / Redis / Influx & Snowflakes
    • Desirable: Cloud DB: DynamoDB / S3 / Redshift / Aurora
  • Oracle Forms Application servers
  • Development PL/SQL
  • Experience in automation using tools such as Terraform, Ansible, Puppet etc.