Oracle APPS DBA
Posted Updated
Description
Location / allocation: Offshore (India), full time through delivery; reduced in hypercare.
Purpose: prepares and configures the on-premises EBS instances (FSB2, QUAL, PROD) to trust the Asserter, so users log in to EBS through Entra SSO and MFA.
Key responsibilities
- Check EBS release, patch levels, HTTPS and AutoConfig health against Oracle's Asserter prerequisites; list any missing patches for MKS.
- Create and secure the EBS account the Asserter uses (Apps Schema Connect role); store credentials in Vault.
- Register the Asserter nodes with EBS and generate the DBC files; supply the valid-node (allowed IP) entries to MKS.
- Capture current profile values; set APPS_AUTH_AGENT, SSO type and SSO login types; configure local login for break-glass accounts; run AutoConfig and bounce services.
- Write and test the rollback script that restores native EBS login.
- Run the FND_USER alignment audit for all three environments (SQL against FND_USER and the Entra export); produce the mismatch list for MKS.
- Identify non-interactive and integration accounts that stay on native login.
- Test end-to-end SSO, deep links, logout, Forms, ECC and APEX pages; support MKS UAT; execute the PROD cutover steps.
- Write the EBS sections of the runbook, including post-clone SSO steps.
Required skills and experience
- 8+ years Oracle EBS R12 Apps DBA (12.1.3 and 12.2.x): AutoConfig, adop, context files, profile options, service management.
- EBS authentication internals: APPS_AUTH_AGENT, AdminDesktop / DBC files, ICX sessions, valid-node checking.
- SQL and PL/SQL for audit queries; Oracle Database 12c / 19c basics.
- Prior EBS SSO work (Oracle Access Manager, EBS AccessGate or EBS Asserter).
Preferred: Oracle EBS R12 Applications DBA certification.
Deliverables owned: FND_USER Alignment Audit Report; EBS configuration per instance; rollback script; EBS sections of the runbook.
Skills
Sign in to read and join the discussion.