Oracle EBS Engineer

Staples India; Chennai District; On-site; INR 2,400,000 - 4,000,000; Full time

Job summary

Staples India is seeking an experienced Oracle EBS DBA to manage the Oracle EBS R12 environment on AIX/Linux. The role involves patching, backup strategies, upgrades, tuning, and ensuring data integrity and security for enterprise processes.

You will work with RAC/ASM, Data Guard, and OEM Grid Control for proactive monitoring and administration. A Bachelor’s degree and 10+ years in Oracle infrastructure are required.

Qualifications

• Bachelor's degree in Engineering, Computer Science or related field.
• 10+ years of progressive Oracle Financials infrastructure administration experience.
• Hands-on experience as an Oracle Applications DBA.
• Experience with Oracle E-Business Suite R12 administration.
• Knowledge of RMAN, Data Guard, RAC, ASM and CRS.

Responsibilities

• Perform Oracle EBS DBA tasks including patching, backup and recovery strategies, upgrades and performance tuning.
• Manage multi-node EBS environment with Shared File System and Concurrent Managers.
• Monitor and maintain security, integrity and recoverability of Oracle EBS systems.

Skills

Oracle EBS DBA

R12 Administration

RMAN Backup

Data Guard

OEM Grid Control

Shell scripting

PL/SQL

Unix/Linux

Education

Bachelor's degree in Engineering/CS

Tools

Veritas

Legato

ADSM

Job description

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:

• 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.
• Oracle e-Business Suite R12 administration.
• Working with physical disk storage involving system storage planning or fine tuning.
• Backup and recovery methods including Veritas, Legato, or ADSM