Oracle Database Administrator

Oracle EBS Database Administrator

JOB DESCRIPTION

POSITION OVERVIEW

The Oracle EBS Database Administrator is responsible for managing and maintaining Industrial Scientifics Oracle EBusiness Suite (EBS) environments ensuring their performance availability and security. This role involves managing and maintaining the configuration patching and upgrades of the Oracle EBS applications and Oracle databasesThe position requires a strong understanding of database management cloud infrastructure and the ability to troubleshoot and optimize database operations including integrated applications.

RESPONSIBILITIES AND DELIVERABLES

• Manage and maintain database systems including Oracle EBusiness Suite (EBS) and Oracle Cloud Infrastructure (OCI) ensuring high availability performance and security.
• Perform database administration tasks such as installation configuration patching and upgrades of Oracle EBS applications and Oracle databases.
• Monitor and optimize database performance troubleshoot issues and implement solutions to ensure system reliability.
• Develop and maintain backup and recovery strategies for Oracle EBS and OCI environments.
• Implement and oversee database security measures to protect sensitive data and ensure compliance with security policies standards and best practices.
• Collaborate with application developers system administrators and other stakeholders to support and enhance Oracle EBS applications and design database solutions.
• Participate in daily standups project calls and allhands meetings to ensure effective communication and project progression.
• Lead Oracle projects and validate new versions of Oracle and operating systems to ensure optimal system performance.
• Provide support for critical production systems as needed.
• Document database configurations processes and procedures.

ORGANIZATIONAL ALIGNMENT

• This position will report to Manager of Oracle Technology & Data

QUALIFICATIONS

• Bachelors degree in Computer Science Information Technology or a related field.
• 5 years of experience as a Database Administrator with a minimum of 5 years supporting Oracle databases.
• Experience in configuring and supporting active/active configurations.
• Proficiency in patching Oracle databases.
• Experience with Oracle Cloud Infrastructure (OCI).
• Knowledge of cloudbased database solutions and services.
• Knowledge of Oracle Recovery Appliances (backup and recovery).
• Proficiency in SQL and database scripting.
• Experience with automation tools and scripting languages (e.g. Python Shell) is a plus.
• Experience with database performance tuning and optimization.
• Familiarity with database security best practices.
• Excellent problemsolving and analytical skills.
• Strong communication and teamwork abilities.
• Certification in Oracle Database Administration or OCI is preferred.

REQUIRED

• Experience in Code migration deployment using TAR files
• Experience in Handling of production incidents creation of knowledge base
• Ability to follow up with Oracle Support on Product Issues
• Ability to interact at all levels of organization. Strong verbal written and interpersonal communication skills
• Ability to work in an offshoreonsite global support model context (Application Managed Services)
• Capable of leading process improvement initiatives and using tools like Six sigma to solve problems

PREFERRED

• Experience in Oracle PaaS and SaaS (ERP Cloud) implementations
• Demonstrated experience in working with global teams and supporting global business functions
• Ability to quickly troubleshoot problems that may arise in Oracle EBS instance
• Ability to partner with business analysts and AMS members to identify course of resolution for application issues
• Strong understanding of system design and system integrations.

TECHNICAL COMPETENCIES

Required

• Oracle Cloud (SaaS PaaS)
• Oracle EBusiness Suite R12/11i
• Oracle Developer (Forms 6i/9i/10g and Reports6i/10g)
• Oracle Workflow
• OAF and Oracle 8.x/9.x/10g
• SQL PL/SQL
• UNIX Shell Scripts
• SQL* Loader

Preferred

• Oracle Cloud Infrastructure (OCI) Administration