Job Description

Enterprise Products Partners L.P. is one of the largest publicly traded partnerships and a leading North American provider of midstream energy services to producers and consumers of natural gas, NGLs, crude oil, refined products and petrochemicals. Our services include natural gas gathering, treating, processing, transportation and storage; NGL transportation, fractionation, storage and import and export terminals; crude oil gathering, transportation, storage and terminals; petrochemical and refined products transportation, storage and terminals; and a marine transportation business that operates primarily on the United States inland and Intracoastal Waterway systems. The partnership’s assets include approximately 50,000 miles of pipelines; 260 million barrels of storage capacity for NGLs, crude oil, refined products and petrochemicals; and 14 billion cubic feet of natural gas storage capacity.   

The Senior Database Administrator is responsible for supporting the Oracle databases and ensuring their performance, availability, and security.  Requires in-depth skills in Oracle database administration. Responsibilities to include:

·         Good experience in Oracle 19c database administration with strong skill in concepts and architecture, and hands on experience on Oracle RAC (ASM) databases.

·         Monitoring and management of databases using Oracle Enterprise Manager (OEM) 13c.

·         Back-up and recovery using RMAN (ZDLRA knowledge is a plus)

·         Oracle E-business suite R12.2 maintenance, patching, cloning and code migration.

·         Oracle WebLogic Server Administration.

·         Working with High availability systems and load balancers.

·         Database Performance and System tuning.    

·         Python, Shell Scripting and Ansible for automation of the following day to day tasks:

o   Cloning

o   Patching

·         Running databases in VMs.

·         Knowledge with on-prem Exadata is a plus        

Qualifications

The successful candidate will meet the following qualifications:

Bachelor’s degree or equivalent experience required.
Minimum 10 years of hands-on experience in Oracle DBA skills
Experience in Oracle 19c database administration with strong skills in concepts and architecture and hands on experience on Oracle RAC databases.
Must have expertise in Oracle Enterprise Manager (OEM) 13c monitoring and management. Patching OEM components and target metrics administration are required.
Thorough working experience on multitenant architecture. Container and Pluggable database administration and cloning.
Ansible and/or Unix shell scripting expertise for automation of day-to-day tasks like cloning, patching.
Backup and Recovery skills, Active Data guard configuration & monitoring skills required.
Experience in DR setups, High availability system and knowledge on load balancers.
Strong knowledge in Database Performance and System tuning in Oracle Core DBA.
Strong production support experience of ORACLE databases running on multi-node RAC (ASM)
Should have worked with HANG Analyzer, system state dump, SQL Tuning, AWR analysis, Trace file analysis etc.
Should have experience in Oracle E-Biz R12.2 Maintenance, Support, Projects, Upgrades and Migrations.
Good knowledge in Oracle WebLogic Server Administration.
Should have working experience in different OS platforms and cross platform migration skills.
Excellent written and verbal communication skills to interact with other teams.