Database Administrator, Oracle EBS
Power Integrations
Job Summary
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.
Job Description
- 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
- 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