Diverse Lynx - Eden Prairie, MN

posted 5 months ago

Full-time
Eden Prairie, MN
Administrative and Support Services

About the position

The Oracle EBS Apps DBA position is a critical role within our IT infrastructure team, primarily focused on the administration and support of Oracle E-Business Suite applications. The successful candidate will be responsible for performing various technical and functional tasks related to the Oracle E-Business Suite R12, ensuring optimal performance and reliability of the applications. This role requires a deep understanding of the architecture of Oracle E-Business Suite, as well as hands-on experience with database administration tasks, including cloning, performance tuning, and troubleshooting. In this position, you will be expected to perform Oracle E-Business Suite cloning using RMAN and ad utilities, which is essential for maintaining development, testing, and user acceptance testing environments. You will also be tasked with resolving performance issues reported for applications and databases, tuning queries to improve response times, and providing extensive technical assistance to IT operations and application support teams. Additionally, the role involves monitoring application-related products, managing SSL certificates, and handling alerts raised by the alert monitoring system from both databases and applications. The ideal candidate will have experience in starting and stopping Oracle E-Business application services, troubleshooting concurrent managers, and executing code migrations using Datafix and Package execution. A good knowledge of Oracle Enterprise Manager (OEM) and RMAN for backups and recovery is also required. This position is based in Eden Prairie, MN, and is an on-site role, emphasizing the importance of collaboration and direct support within the team.

Responsibilities

  • Perform Oracle E-business suite cloning 12.1 using RMAN and ad utilities.
  • Resolve various performance issues reported for applications and databases and tune queries to improve response time.
  • Design and inspect infrastructure modeling and provide extensive technical assistance for IT infrastructure, IT OPS, App Support, and other support groups.
  • Monitor application-related products, including Apache, oacoare, oafm, etc.
  • Troubleshoot concurrent managers, workflow, and ad utilities.
  • Handle alerts raised by the alert monitoring system from databases and applications.
  • Manage SSL certificates and the renewal process.
  • Troubleshoot long-running requests raised by the application support team.
  • Execute code migration using Datafix and Package execution.
  • Start and stop Oracle E-business application services.

Requirements

  • Preferred to be Oracle E-Business Suite R12 Applications Database Administrator Certified Professional.
  • Good understanding of the high-level architecture of Oracle E-business suite application 12.1.3.
  • Experience in cloning processes from Production to DEV, TEST, UAT environments.
  • Good knowledge of OEM (Oracle Enterprise Manager).
  • Good knowledge of RMAN for backups and recovery.

Nice-to-haves

  • Experience with performance tuning of Oracle databases.
  • Familiarity with application support processes and troubleshooting methodologies.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service