Oracle DBA

Vaco; Fairfield (OH); On-site; USD 120,000 - 180,000; Full time

Job summary

Vaco is seeking a Senior Oracle EBS DBA to join our ERP support team. The role focuses on administration, performance, security, and high availability of Oracle EBS R12.2 environments, covering both application and database tiers.

The ideal candidate has 5+ years of Oracle DBA experience, strong SQL/PLSQL, and hands-on ADOP patching, cloning, RMAN, and Data Guard in a 24x7 ERP context. This on-site Ohio role collaborates with IT and business units.

Qualifications

• 5+ years of Oracle Database Administration experience.
• 3+ years supporting Oracle E-Business Suite R12.2 environments.
• Experience with ADOP, cloning, RMAN, Data Guard, and Linux administration.
• Strong SQL and PL/SQL skills.

Responsibilities

• 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.

Skills

Oracle DBA

Oracle EBS

Linux Admin

SQL/PLSQL

ADOP Patch

Education

Bachelor's degree in IT/CS

Tools

Oracle 19c

Oracle EM

RMAN

WebLogic

OIC

Linux

Job description

Senior Oracle EBS Database Administrator (DBA)

Position Summary

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.

Key Responsibilities

Oracle EBS Administration & Support

• 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.

Performance Tuning & Troubleshooting

• 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.

Patching, Cloning & Upgrades

• 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.

Technical Support & Integrations

• Support EBS integrations, interfaces, and middleware connections.
• 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.

Required Qualifications

• 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.

Preferred Qualifications

• 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.

By submitting to this position, you are agreeing to be included in our talent pool for future hiring for similarly qualified positions.