Oracle APPS Database Administrator (Information Technology)
The Oracle Application and Database Administrator is responsible for managing and maintaining Sumitomo Rubber North America's live Oracle applications and databases, along with associated technologies such as middleware and other relevant applications. This includes administering and maintaining the production environments, such as Oracle EBS, SOA, B2B, Real-Time Reporting, MWA, and other applications and databases. Key duties involve installing, configuring, and updating software; handling backup and recovery tasks; performance tuning; monitoring; code deployment; ensuring data integrity; documentation; managing service requests with Oracle support; ensuring JSOX compliance; and providing on-call support for the systems. The role also requires close collaboration with the DBA Manager, proficiency in Linux, and an understanding of SAN storage. A willingness and ability to learn and support new technologies are also essential for this position.
Essential Job Functions
- Application Administration: Manage the administration of Oracle EBS and other applications in the environment.
- Database Administration: Oversee the administration of Oracle databases, ensuring optimal performance and availability.
- Performance Tuning: Perform regular tuning to optimize system performance.
- Backup & Recovery: Implement and manage backup and recovery processes to safeguard data integrity.
- Production Support: Provide ongoing support for production environments, addressing issues promptly to minimize downtime.
- Code Migration: Manage the migration of code changes across different environments.
- Patching & Upgrading: Apply patches and upgrades to maintain system security and functionality.
- JSOX Compliance: Ensure compliance with JSOX requirements.
- Monitoring: Monitor systems to detect and resolve issues proactively.
- Security: Implement and manage security measures to protect data and applications.
- Cloning: Perform cloning of databases and applications for testing and development purposes.
- On-call Support: Provide on-call support to address and resolve critical system issues outside regular business hours.
Additional Requirements
- Collaboration: Work closely with the DBA Manager to align activities with organizational goals.
- Linux Proficiency: Demonstrate strong proficiency in Linux for effective system management.
- SAN Storage Understanding: Understand SAN storage concepts to support database and application requirements.
- Learning and Adaptability: Show a strong ability and willingness to learn and support new technologies as they are adopted.
This role is critical for ensuring the reliability, performance, and security of SRNA's Oracle applications and databases, supporting the company's business operations and strategic initiatives.
Work Experience:
A minimum of ten (10) years of overall experience, including at least three (3) years of current experience as an Oracle EBS Apps DBA (preferably R12.2) in a production environment, along with an additional three (3) or more years as an Oracle Core DBA.
Education & Training:
A Bachelor's Degree in Information Technology from an accredited institution, relevant IT certifications (Oracle, UNIX/Linux), or an equivalent combination of education and experience sufficient to effectively perform the essential job duties.
Skills & Competencies:
- Proficiency in Oracle ERP (EBS R12), Oracle 19c database, Oracle 12c Application Server, and associated tools.
- Strong knowledge of Linux/Unix operating systems, as well as Microsoft Office Suite (Word, Excel, PowerPoint, and Outlook).
- Experience with SQL Server and PostgreSQL is a plus.
- Highly detail-oriented, self-motivated, and well-organized, with the ability to manage multiple projects simultaneously.
- Excellent customer service skills and strong problem-solving abilities.
Physical Demands:
Must be able to stand, sit, move, and use fingers for extended periods. May involve walking on level surfaces, reaching above shoulder height and below the waist, and occasionally lifting up to 25 pounds.
Work Environment:
Typical office environment with controlled air and maintained at comfortable temperatures.
