Company: Saudi Aramco
Skills: IT - Programming & Database
Experience: 9 + Years
Education: Bachelors/3-5 yr Degree
Employment Type: Full Time Salaried Employee
Location: Dhahran, Saudi Arabia
No location/work authorization restrictions found.
Req Number: 18169BR
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.
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
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.