Database Administrator, Oracle EBS

1 Year ago • 5 Years +

Programming

Job Description

The Oracle Application and Database Administrator will be responsible for managing and maintaining Oracle Application databases, including installing, configuring, upgrading, administering, monitoring, maintaining, and performance tuning. They will also provide on-call support and secure Oracle Applications and Databases. The DBA will collaborate with developers to ensure smooth operation of production environments by deploying code, ensuring data integrity, handling backups and recovery tasks, and coordinating service requests with Oracle support. Essential skills include excellent interpersonal and communication skills, as well as the ability to learn new technologies. The role involves acting as the principal DBA for the company's Oracle E-Business Suite (EBS) ERP, performing patching, cloning, and migration, developing and deploying scripts, and ensuring data security.

Must Have:

5+ years of experience as an Oracle Apps DBA (R12.2.10) and Oracle Database Administrator (19c)
Bachelor's degree in Computer Science or related field, or equivalent experience
Strong knowledge of Oracle Applications and its components.
Experience with Oracle EBS modules like Financials, Supply Chain, HRMS, etc.
Deep technical expertise and experience in Oracle Reports/BI Publisher/PLSQL/Forms Personalization/Workflow
Excellent troubleshooting and problem-solving skills.
Good verbal and written communication skills
Ability to work independently and in a team environment.

Add these skills to join the top 1% applicants for this job

communication

problem-solving

oracle

linux

oracle-database

sql

shell

Job Summary

Reporting to the Associate Director of Business Systems, the Oracle Application and Database Administrator is responsible for managing/maintaining Oracle Application databases along with other technologies and applications. The job requires proficiency in installing, configurating, upgrading, administrating, monitoring, maintaining, performance tuning, providing on-call support and securing Oracle Applications and Databases along with proficiency in Linux, Oracle VM and SAN storage. The DBA will work together with developers ensuring smooth operation of production environments by deploying code, ensuring data integrity, handling backups and recovery tasks, and coordinating service requests with Oracle support. Excellent interpersonal as well as good verbal and written communication skills combined with ability to learn new technologies are essential to succeed in this role.

Duties and Responsibilities

Act as principal DBA of the Company’s Oracle E-Business Suite (EBS) ERP
Install, configure, and maintain Oracle E-Business Suite (EBS) and Oracle Databases
Perform patching, cloning, and migration of Oracle Applications and Databases
Monitor system performance and troubleshoot issues related to Oracle Applications and Databases
Develop, test, and deploy Linux shell scripts to invoke database calls and other integrations
Develop, test, and deploy scheduled jobs and shell scripts.
Enhance and maintain backup (RMAN) and recovery strategies
Ensure data security and integrity within the Oracle environment
Provide technical support and guidance to developers, system administrators, and other IT staff
Implement and enforce best practices for Oracle Applications and Databases administration
Stay updated on Oracle technologies and recommend improvements
Document procedures, configurations, and troubleshooting steps
Closely work with other IT groups on projects, remediations and incidents
Coordinate with hybrid onsite/offshore teams

Requirements

5+ years of proven hands-on work experience as an Oracle Apps DBA (R12.2.10) and Oracle Database Administrator (19c)
Bachelor’s degree in Computer Science or a related field, or equivalent experience
Strong knowledge of Oracle Applications and its components including SQL packages, functions, and procedures
Experience with Oracle EBS modules like Financials, Supply Chain, HRMS, etc.
Deep technical expertise and experience in Oracle Reports/BI Publisher/PLSQL/Forms Personalization/Workflow
Excellent troubleshooting and problem-solving skills
Good verbal and written communication skills
Ability to work independently and in a team environment