Oracle APPS DBA
Oracle APPS DBA
NTT Data- Posted 4 hours ago
- Be among the first 10 applicants
Job 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.
More Info
Job Type:
Industry:
Function:
Employment Type:
Key Skills
context files
valid-node checking
profile options
adop
EBS AccessGate
EBS Asserter
ICX sessions
EBS authentication internals
DBC files
Oracle Database 12c
AutoConfig
AdminDesktop
