Oracle EBS Engineer

Zoho; Chennai District; On-site; INR 2,500,000 - 3,500,000; Full time

Job summary

Staples India Business Innovation Hub Private Limited is seeking an experienced Oracle EBS DBA to manage the multi-node EBS environment, patching, backups, and performance tuning. You will work on RAC clusters, RMAN, Data Guard and OEM/Grid Control to ensure security and recoverability.

The role requires 10+ years in Oracle Applications DBA with strong shell scripting and PL/SQL skills, in an enterprise Linux/Unix environment.

Qualifications

• Bachelor’s degree in Engineering, Science or related field with 10+ years of Oracle DBA experience.
• Hands-on experience as an Oracle Applications DBA with Oracle EBS R12.
• Experience with RAC, RMAN, Data Guard, ASM/CRS and grid control tooling.

Responsibilities

• Perform patching, backup/restore strategies and upgrades for Oracle EBS environment.
• Manage multi-node EBS Suite with Concurrent Managers and Workflows.
• Monitor security, integrity and compliance of Oracle EBS systems.
• Troubleshoot ERP tasks and manage disaster recovery planning.
• Automate tasks with Shell and Perl scripts.

Skills

Oracle EBS DBA

Oracle RAC

RMAN

Data Guard

Oracle ASM/CRS

Shell scripting

PL/SQL

Patch management

Backup and recovery

Security/compliance

Education

Bachelor’s degree in Engineering, Science, or related field

Tools

Veritas

Legato

ADSM

Oracle EBS utilities

Job description

Staples India Business Innovation Hub Private Limited | Permanent

Position Description: Perform Oracle EBS Applications database engineering and administration (DBA)

tasks including patching, creating backup and recovery strategies, upgrading, performance

tuning/optimization of Oracle EBS systems for recoverability, security, confidentiality, and integrity to

ensure that: EBS applications and database configurations meet Oracle ERP goals, Oracle EBS

requirements, and Staples standards; patches are applied on a timely basis; data integrity and security are

maintained; backups are performed as scheduled or deemed necessary; and upgrades are made. Utilize

Oracle EBS R12 applications DBA (AD) utilities to perform maintenance of the multi-node e-Business

Suite environment with Shared File System, managing and administering Concurrent Managers,

Concurrent Programs, Request Sets, Request Groups, Workflows, and troubleshooting Workflow

Mailer/Notification issues; Oracle Real Applications Clusters (RAC) to maintain a clustered database to

provide performance, scalability, and resilience with Automatic Storage Management (ASM) and Cluster

Ready Services (CRS) in an AIX/Linux operating system (O/S); Oracle Recovery Manager (RMAN) and

Data Guard for backup and disaster recovery; Oracle Application Manager (OAM) and Oracle Enterprise

Manager (OEM) Grid Control for proactive monitoring and notification of system status; and Procedural

Language/Structured Query Language (PL/SQL) packages, Shell, and Perl scripts for task automation.

Proactively monitor, test, and report on Oracle EBS system integrity, security, and compliance measures.

Identify opportunities to upgrade or replace software to meet the current and future requirements of

business areas and end-users. Recommend changes and participate in the implementation and follow-up

management of upgrades or replacements. Evaluate critical Oracle EBS security issues and make

recommendations, such as disaster recovery plans and upgrades to new versions of Oracle EBS R12 or

successor releases.

Requirements

Required Experience/Skills: Requires a Bachelor’s degree (or equivalent) in Engineering, Computer

Science, or a directly related field plus 10+ years of progressive experience in Oracle Financials

infrastructure administration. Experience must include:

10+ years of experience in the following (experience may be gained concurrently):

• Hands-on experience as an Oracle Applications DBA.
• System analysis and design involving, data flow diagrams; data dictionary techniques; CASE tools; entity-relation modeling and design techniques; database troubleshooting; data warehouse concepts; and installing and upgrading the Oracle server and application tools.
• Working with physical disk storage involving understanding of disk hardware architecture; RAID implementation; cache controllers; and disk load balancing.
• Relational database security including role-based security, including experience with Unix, Windows, ODBC, JDBC, Shell scripting.
• Installation, upgrade, patching, and support of Oracle databases 11g or 12c.
• Working with physical disk storage involving system storage planning or fine tuning.
• Backup and recovery methods including Veritas, Legato, or ADSM