Oracle Database Administrator

Job Description

Req Number: 18169BR

Position Description:
We are seeking an Oracle Database Administrator to join Upstream Database Service Division (UDSD) under EXPEC Computer Operations Department (ECOD).

UDSD provides and maintain upstream structured & unstructured data repositories, application middle-tier and Information Management services. Develop infrastructure & security applications for Upstream. Implement upstream data modeling, data security, data integration, data quality, data governance for enterprise data. Facilitate collaboration and provide consultation guidelines for business process management, and knowledge management services.

Minimum Requirements:
The successful candidate should hold a Bachelor’s degree in Computer Science or equivalent.

Minimum of 9 years’ experience directly related to Oracle Database Administration.

Expert Database Administration knowledge to perform production administration for a scalable Oracle database for IR 4.0

Expertise in Oracle Real Application Cluster and Clusterware

Expertise in Oracle Data Gurad

Expertise in Oracle GoldenGate and SQL Data Import / Export tools

Expertise in performance tuning

Working knowledge of Oracle Advanced Analytics options (In Memory, Data Mining, Oracle Enterprise R)

Working knowledge of the Data Engineering and Data Science.

Knowledge of and experience with Hadoop implementations, NoSQL databases is desirable

Duties & Responsibilities:
You are expected to be able to perform the following:

Meet the continuing operational demands of the IR 4.0 environment

Support projects and be the primary focal point for the Advanced Analytics environment

Build and maintain data pipelines, productionize machine learning models, monitor and optimization analytical queries, and perform SQL performance tuning

Design database architecture

Perform regular backups of databases

Perform partial and complete data recovery as required

Monitor the database environment

Ensure database integrity

Ensure high availability of the database environment

Patch and upgrade the database environment

Conduct database consolidation and migration projects

About us:
Saudi Aramco’s Exploration & Producing (E&P) business line oversees the world’s largest reserves of conventional crude oil, and the fourth-largest reserves of natural gas. The Company’s reserves portfolio include Ghawar, the world’s largest onshore oil field, and Safaniya, the largest offshore field. Company geologists are actively seeking additional reserves in many areas of the Kingdom, offshore in the Gulf and the Red Sea and onshore in the deserts and mountains. Petroleum engineers and earth scientists in E&P work with cutting-edge technology to manage and produce these reserves, including 3D visualization, reservoir simulation and remote geosteering of multilateral wells. The Company’s Exploration and Petroleum Engineering Center, or EXPEC, is home to one of the industry’s most powerful computer centers. Research and development into subsurface upstream technology is conducted at the EXPEC Advanced Research Center. For more than two decades in a row, Saudi Aramco has been ranked the No. 1 oil company in the world by Petroleum Intelligence Weekly, a testament to the dedication and professionalism of the men and women of Exploration & Producing.