The Role
Perform Oracle EBS database engineering and administration, including patching, upgrades, performance tuning, backup and recovery, disaster recovery, security, monitoring, and troubleshooting. Maintain multi-node EBS environments using RAC, ASM, CRS, RMAN, Data Guard, and EBS administration utilities. Automate tasks with PL/SQL, Shell, and Perl, monitor system integrity and compliance, and recommend infrastructure, security, and platform improvements.
Summary Generated by Built In
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.
• 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
Skills Required
- Bachelor’s degree or equivalent in Engineering, Computer Science, or a directly related field
- 10+ years of progressive experience in Oracle Financials infrastructure administration
- 10+ years of hands-on experience as an Oracle Applications DBA
- Experience with system analysis and design, data flow diagrams, data dictionaries, CASE tools, entity-relation modeling, database troubleshooting, data warehousing, and Oracle server/application tool installation and upgrades
- Experience with physical disk storage, disk hardware architecture, RAID, cache controllers, disk load balancing, storage planning, and storage tuning
- Experience with relational database security and role-based security
- Experience with Unix, Windows, ODBC, JDBC, and Shell scripting
- Experience installing, upgrading, patching, and supporting Oracle Database 11g or 12c
- Experience administering Oracle E-Business Suite R12
- Experience with backup and recovery methods using Veritas, Legato, or ADSM
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Staples India is Staples’ technology and innovation hub in Chennai, building platforms, systems, and digital solutions that support the company’s global operations and future of work. Staples serves consumers and businesses with workplace products and services, including office supplies, janitorial products, technology, furniture, breakroom essentials, print and marketing, shipping, travel, and promotional offerings. Its India teams focus on engineering, eCommerce, process optimization, and enterprise solutions.
