Overview
Skills
Job Details
Title : Oracle Apps DBA
Location : Chicago, IL
Fulltime/Direct Hire
Hybrid
Summary
The role of the Senior Oracle Applications DBA is responsible for supporting Oracle E-business suite 12i instances and other mission-critical Oracle systems. The position has the responsibility for researching and troubleshooting application and database issues for the Oracle Applications teams including SCM, ASCP, Finance, HRMS and Order-to-Cash. Support extends to boundary systems such as Weblogic, OBIEE, OAM/OID, Demantra, Discoverer and Informatica. The DBA will partner with technical and business groups to ensure that database performance standards adhere to enterprise service level agreements. The ideal candidate will assist in all facets of infrastructure lifecycle management, perform administrative activities such as cloning, backup/restore, and patching and will ensure quality control and auditing of databases is accurate. KEY ACCOUNTABILITIES AND RESPONSIBILITIES
Installs, patches, upgrades, configures, tunes and maintains the Oracle E-business Suite 12i and 11g/12c Oracle databases. Collaborates with system and network administrators. Installs system enhancements and assists in hardware, software and data utilization analysis to ensure maximum efficiency. Participates in the design, implementation and testing of the disaster recover procedures. Provides DBA support for custom application development efforts
Provides level 2 support (24x7) for the Production environment, which includes high-volume business critical applications.
Analyze performance issues in the application, concurrent manager, and database tiers of E-Business Suite installations. Assist developers with performance tuning. Responsible for capacity planning, database space management.
Responsible for overall architecture, design, development, and support of all Oracle Application Technology Stack components including but not limited to Oracle 11g RAC, core Oracle Database, Oracle E-Business Suite 12i, OID/OAM, OBIEE, Demantra, Discoverer, Middleware (Weblogic)
Experience in implementing and supporting Oracle ERP Applications
Ability to analyze and resolve difficult technical issues quickly in a high pressure environment
Support 3rd party applications like Informatica, Vertex, Noetix, iScramble etc.
Write UNIX shell scripts. Clones 12i environments. Establishes and maintains Oracle ASM/RAC databases. Tunes the Oracle E-business 12i application, the Oracle databases and PL/SQL code. Proactively identifies and corrects 12i performance problems and monitors space usage.
Ensures the 12i system is appropriately secured and periodically audits the security of the 12i system.
Documents DBA processes. Prepares documentation for new and modified systems, environments, hardware, software or databases
Participate in on-call rotation providing 24X7 support.
Perform other tasks and functions as requested by USG. Minimum Qualifications
Bachelor's Degree in Computer Science, Information Systems, or equivalent.
Minimum of 10 years IT experience, with the following specific experiences: Oracle E-business 12i administration, UNIX, PL/SQL coding, and Oracle database administration
Experience in running Oracle E-business 12i including activities like Patching, Cloning, Replication, System Administration, troubleshooting in HA and DR environments
Good knowledge of SQL with Performance Tuning skills
Experience implementing Oracle Real Application Clusters and Oracle Data Guard for high availability, data protection, and disaster recovery.
Experience administering Oracle EBS Financials, Supply Chain, and HR/Payroll applications.
Experience administering Oracle Business Intelligence Enterprise Edition (OBIEE)
Experience administering systems in Unix/Linux and Windows environments
Experience using Oracle Enterprise Manager and other tools for availability and performance monitoring
Excellent analytical, problem solving, interpersonal and communication skills.
Must be able to work some weekends, nights and holidays.