Oracle APPS DBA
At a glance
Mid-level Data Architecture & Governance role at NTT DATA. Bengaluru.
Pay not stated Data Architecture & Governance salary
dataroles summary, based on the employer's posting.
What you'll do
- Check EBS releases, patches, HTTPS and AutoConfig against Asserter prerequisites, then flag gaps for MKS
- Set up the Asserter account, credentials, registered nodes and DBC files across the EBS instances
- Update authentication profiles, preserve emergency local access, run AutoConfig and restart services
- Audit FND_USER against Entra exports, identify accounts staying on native login, and report mismatches
- Test SSO flows and related pages, support MKS UAT, carry out production cutover and document rollback and runbook steps
What you bring
- At least eight years as an Oracle EBS R12 Apps DBA, including AutoConfig, adop, context files and service management
- You know EBS authentication internals such as APPS_AUTH_AGENT, DBC files, ICX sessions and valid-node checks
- You can write audit queries in SQL and PL/SQL and have basic Oracle Database 12c or 19c knowledge
- You have handled EBS SSO using Oracle Access Manager, EBS AccessGate or EBS Asserter
Who this fits
This role suits an experienced EBS DBA who can handle configuration, authentication audits, SSO testing and production cutover. The work is offshore in India and full time through delivery, with reduced involvement during hypercare. An EBS R12 Applications DBA certification is preferred.
From the employer
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.