Project Advisor - Oil & Gas Production

Role Overview

Project Advisor serves as a key technical consultant and strategic guide for offshore and onshore production initiatives. This role provides executive-level direction, risk mitigation, and technical oversight across the entire lifecycle of oil and gas production projects - combining deep domain expertise in production optimization with robust industrial data architecture, including enterprise database systems like PostgreSQL.

Key Responsibilities

· Strategic & Technical Advisory: Lead field development planning (FDP) and offer expert guidance on production facility design, artificial lift systems, flow assurance, and digital field architecture.

· Database & Data Architecture Management: Architect, manage, and optimize PostgreSQL and relational database systems to store, structure, and query large-scale production time-series data

· Digital Oilfield & Software Integration: Drive modern upstream software integration, cloud deployments, and automated data pipelines connecting systems to backend PostgreSQL data stores.

· Project Governance & Risk Management: Conduct Stage-Gate technical reviews, data security audits, process safety reviews, and risk assessments to ensure regulatory compliance and high availability.

· Production & Query Optimization: Analyze asset performance metrics, write optimized SQL queries, and configure database indexing and partitioning strategies for high-frequency production data retrieval.

· Operations Readiness: Oversee Commissioning and Start-Up (CSU) processes, ensuring seamless handover of physical assets and digital database management systems to daily operations.

Qualifications & Competencies Domain & Technical Experience

· Industry Experience: 17+ years in oil and gas production, technical sales, software advisory, or engineering consultancy across upstream/midstream sectors.

· Database Expertise: Hands-on experience with PostgreSQL administration, database schema design, indexing strategies, and performance tuning for oil and gas analytics platforms.

· Upstream Domain Knowledge: Deep understanding of surface production facilities, hydrocarbon processing, well monitoring, and enhanced oil recovery (EOR) methods.