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.