Location : Downtown Chicago - 2 days onsite/week Duration : Contract until end of year with extension/conversion possibility Job Summary The Senior Oracle Applications DBA's role is responsible for supporting Oracle E-business suite 12i instances and other mission-critical Oracle systems.
The position is responsible 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 ensure quality control and auditing of databases is accurate.
The DBA will also help develop the roadmap and migration of workloads to cloud platforms such as private/public, Oracle, Azure, and AWS cloud.
Duties And Responsibilities Install, patches, upgrades, configures, tunes, and maintains the Oracle E-business Suite 12i and 11g/12c/19c 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 the 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 challenging 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 Experience in Oracle database (RAC/ASM) upgrades from11g/12c to 19c.
Experience in the cloud "lift and shift" projects and migration of Oracle/SQL Server databases from On-Prem to Private/Public cloud Participate in on-call rotation providing 24X7 support.
Perform other tasks and functions as requested by USG.
Local Candidate Preference: HQ Hybrid Practice 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 Oracle database performance tuning skills Experience in 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 communicational skills.
Must be able to work some weekends, nights, and holidays.
Required Skills : - Senior (5 years) of Oracle E-business administration, UNIX, PL/SQL coding, and Oracle database administration experience - Good knowledge of Oracle database performance tuning skills - Oracle OID/OAM (SSO) and SSL support experience is nice to have -Experience administering Oracle Business Intelligence Enterprise Edition (OBIEE) is nice to have -SQL server administration experience is nice to have Basic Qualification : Additional Skills : Background Check :Yes Drug Screen :Yes Notes : Selling points for candidate : Project Verification Info : Candidate must be your W2 Employee :Yes Exclusive to Apex :No Face to face interview required :No Candidate must be local :No Candidate must be authorized to work without sponsorship ::No Interview times set : :No Type of project :Other Project Type Master Job Title :DBA: Oracle Branch Code :Chicago