Oracle DBA

VACO LLC
Mason, OH, United States
13 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
3 years minimum
Working hours
Regular working hours
Job source

Tech stack

Application Programming Interfaces (APIs) Amazon Web Services Application Services Microsoft Azure Oracle WebLogic Server Cyber Security Databases Concurrent Computing Data Migration Database Security Oracle Data Guard Disaster Recovery
+21 more
Linux System Administration Oracle Databases Oracle (Applications) Performance Tuning Standard Sql Recovery Manager (RMAN) Service Pack Shell Script PL-SQL SQL Databases Software Vulnerability Management Backup and Restore Oracle Enterprise Manager System Availability Database Optimization Database Performance Information Technology Oracle Ebusiness Oracle Erp Oracle Integration Oracle Cloud Infrastructure

Job description

We are seeking an experienced Senior Oracle EBS Database Administrator (DBA) to join our Oracle ERP support team. This role is responsible for the administration, maintenance, performance, security, and availability of the Oracle E-Business Suite (EBS) platform and its underlying Oracle database environment., The ideal candidate will possess strong expertise supporting Oracle EBS R12.2.x environments, including database administration, EBS application tier management, cloning, patching, upgrades, performance tuning, and disaster recovery. This individual will work closely with Oracle functional, technical, infrastructure, and development teams to ensure a stable, secure, and highly available Oracle ERP ecosystem., * Administer and support Oracle E-Business Suite R12.2 environments across Development, Test, QA, and Production.

  • Manage Oracle EBS application services, concurrent managers, workflow services, and web/application tiers.
  • Monitor the health and performance of Oracle EBS environments and proactively address issues.
  • Support business-critical Oracle EBS modules including Financials, Supply Chain, Procurement, Manufacturing, Inventory, and Order Management.

Oracle Database Administration

  • Install, configure, upgrade, and maintain Oracle databases supporting Oracle EBS.
  • Perform database administration activities including:
  • Backup and recovery
  • Database refreshes
  • Capacity planning
  • Security management
  • Database patching
  • Performance optimization
  • Manage Oracle Database 19c and related technologies., * Diagnose and resolve Oracle EBS application and database performance issues.
  • Analyze AWR reports, trace files, wait events, and execution plans.
  • Optimize SQL, PL/SQL, indexing strategies, and database configurations.
  • Troubleshoot concurrent processing, workflow, forms, OAF, and integration issues., * Lead Oracle EBS patching activities using ADOP and Oracle Online Patching methodologies.
  • Execute EBS environment cloning and refresh activities.
  • Support Oracle EBS upgrades, quarterly patching, and security updates.
  • Coordinate system downtime, cutover, and deployment activities.

Backup, Recovery & High Availability

  • Manage RMAN backup and recovery strategies.
  • Support Oracle Data Guard and disaster recovery environments.
  • Conduct recovery testing and validate business continuity procedures.
  • Ensure high availability of Oracle EBS environments.

Security & Compliance

  • Maintain user access controls and database security standards.
  • Implement Oracle security patches and vulnerability remediation activities.
  • Support audit requirements and compliance initiatives.
  • Ensure adherence to segregation-of-duties and change management processes., * Troubleshoot interfaces utilizing APIs, flat files, Oracle Integration Cloud (OIC), and third-party applications.
  • Work with development teams supporting RICEW objects:
  • Reports
  • Interfaces
  • Conversions
  • Extensions
  • Workflows
  • Assist with data migration, conversion, and environment deployment activities.

Requirements

  • Bachelor’s degree in Information Technology, Computer Science, Engineering, or related field.
  • 5+ years of Oracle Database Administration experience.
  • 3+ years supporting Oracle E-Business Suite R12.2 environments.
  • Experience administering Oracle Database 19c or newer.
  • Hands-on experience with:
  • Oracle EBS Architecture
  • ADOP Online Patching
  • Environment Cloning
  • RMAN
  • Oracle Data Guard
  • Oracle Enterprise Manager
  • Linux Administration
  • Strong SQL and PL/SQL skills.
  • Experience supporting production ERP systems in a 24x7 environment., * 8+ years of Oracle DBA experience.
  • Oracle Certified Professional (OCP) certification.
  • Experience supporting manufacturing, distribution, or supply chain organizations.
  • Experience with Oracle Integration Cloud (OIC).
  • Familiarity with WebLogic Administration.
  • Experience with shell scripting and automation.
  • Experience supporting cloud-hosted Oracle EBS environments in OCI, Azure, or AWS.
  • Knowledge of EBS security architecture and auditing controls.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…