Senior database administrator

Job highlights
Identified by Google from the original job post
Qualifications
Requires in-depth skills in Oracle database administration
Bachelor's degree or equivalent experience required
Minimum 10 years of hands-on experience in Oracle DBA skills
Experience in Oracle 1+c database administration with strong skills in concepts and architecture
Strong production support experience of 1+c ORACLE databases running on multi-node RAC (ASM)
Experience configuring Transaction application Continuity (TAC) in Oracle 1+c RAC
Must have expertise in Oracle Enterprise Manager (OEM) 13c monitoring and management
Patching OEM components and target metrics administration are required
Thorough knowledge on multitenant architecture
Container and Pluggable database administration and cloning
Unix shell scripting expertise for automation of day-to-day tasks like cloning, patching
RMAN Backup and Recovery skills, Active Data guard configuration & monitoring skills required
Experience in DR setups, High availability system and knowledge on load balancers
Knowledge in Database Performance and System tuning
Should have worked with HANG Analyzer, system state dump, SQL Tuning, AWR analysis, Trace file analysis etc
Responsibilities
The Senior Database Administrator is responsible for supporting the Oracle databases and ensuring their performance, availability, and security
Good experience in Oracle 1+c database administration with strong skill in concepts and architecture, and hands on experience on Oracle RAC (ASM) databases
Hands on knowledge of setting up Standby databases for Disaster recovery using Dataguard broker
Monitoring and management of databases using Oracle Enterprise Manager (OEM) 13c
Database Performance and System tuning
Shell Scripting and Ansible for automation of routine tasks like Cloning, Patching etc
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 1+c database administration with strong skill in concepts and architecture, and hands on experience on Oracle RAC (ASM) databases.
• Hands on knowledge of setting up Standby databases for Disaster recovery using Dataguard broker.
• Monitoring and management of databases using Oracle Enterprise Manager (OEM) 13c.
• Back-up and recovery using RMAN (ZDLRA knowledge is a plus)
• Database Performance and System tuning.
• Shell Scripting and Ansible for automation of routine tasks like Cloning, Patching etc.

Requirements

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 1+c database administration with strong skills in concepts and architecture.
• Strong production support experience of 1+c ORACLE databases running on multi-node RAC (ASM)
• Experience configuring Transaction application Continuity (TAC) in Oracle 1+c RAC.
• Must have expertise in Oracle Enterprise Manager (OEM) 13c monitoring and management. Patching OEM components and target metrics administration are required.
• Thorough knowledge on multitenant architecture. Container and Pluggable database administration and cloning.
• Unix shell scripting expertise for automation of day-to-day tasks like cloning, patching. Ansible knowledge is a plus.
• RMAN Backup and Recovery skills, Active Data guard configuration & monitoring skills required.
• Experience in DR setups, High availability system and knowledge on load balancers.
• Knowledge in Database Performance and System tuning.
• Should have worked with HANG Analyzer, system state dump, SQL Tuning, AWR analysis, Trace file analysis etc.
• Experience in Oracle E-Biz R12.2 Maintenance, Support, Projects, Upgrades and Migrations is a plus.

Last updated : 2024-0+-08