Oracle Cloud Apps DBA

Role: Oracle Cloud Apps DBA

Location: Dallas / Austin, Texas

Duartion:6 Months

Type: Contract

 Security Architecture & Role Governance

·       Design, configure, and maintain Fusion Security, including:

o   Job roles, abstract roles, duty roles, custom roles, privileges

o   HCM Data Roles & Aggregate Privileges

o   Data Security Policies

·       Maintain scalable and least‑privilege‑focused role catalogs.

·       Maintain and govern Segregation of Duties (SoD) and remediation strategies.

·       Secure OTBI/BIP subject areas, folders, and custom reports.

·       Secure integrations using:

o   Oracle Integration Cloud (OIC)

o   OCI-hosted APEX applications integrated with Fusion

o   ATP Database management

o   Databricks and Fivetran pipelines

o   Fusion REST/SOAP APIs

·       Manage OAuth tokens, service credentials, and certificate-based integration authentication.

·       Govern OCI IAM policies related to Fusion/APEX integration security.

·       Ensure all integration and data-access patterns align with least-privilege and audit requirements.

Identity, Access & User Lifecycle

·       Manage user lifecycle processes for ERP, HCM, and EPM: onboarding, offboarding, and periodic access reviews.

·       Administer accounts using Security Console, HDL, and REST APIs.

·       Maintain consistent worker/person identity between Fusion, Workday (if applicable), and other connected systems.

·       Configure and support DUO SSO/MFA integrations (SAML/OIDC).

·       Service Account Governance:

o   Create and maintain Fusion service accounts for integrations and automation.

o   Enforce privileged-access restrictions, password rotation, and secrets vaulting.

o   Maintain audit logs and lifecycle governance for non-human accounts.

o   Ensure compliance and security standards.

 Automation & Operational Efficiency

·       Automate Fusion administrative workflows:

o   HDL/UDL bulk loads

o   Role provisioning

o   Security synchronization

o   Audit data extraction and reconciliation

·       Build scripts, tools, and dashboards to improve security operations and reduce manual effort.

·       Implement automation for cross-system consistency checks (e.g., Fusion ↔ Workday).

Audit, Compliance & Risk Management

·       Lead quarterly access reviews and produce audit-ready evidence.

·       Support SOX, SoD, GDPR/CCPA, and internal audit frameworks.

·       Conduct cross-application access reconciliation and remediation.

·       Implement preventive and detective controls to meet audit and compliance needs.

Environment Management, DR & Operations

·       Support security in DEV/TEST/STAGE/PROD environments.

·       Lead security validation and regression testing during quarterly Oracle updates.

·       Manage Oracle SRs and coordinate issue resolution.

·       Manage GitHub for version and change control.

·       Develop, maintain, and test Disaster Recovery (DR) plans and runbooks.

·       Validate end-to-end DR readiness across Fusion, OIC, OCI, and integrated systems.

Stakeholder Engagement

·       Partner with HR, Payroll, Finance, IT Security, Audit, Data Engineering, PMO, and other teams.

·       Provide Tier 3 support and deep technical assistance for escalated incidents.

·       Train teams on access request workflows and compliance practices.

·       Work with business stakeholders to define security requirements and translate needs into system configurations.

·       Support impact analysis for new modules, features, and business processes.

·       Participate in POCs for new products/tools to ensure alignment with enterprise security architecture and governance standards.

 Required Qualifications

·       Strong expertise of Oracle Fusion Cloud Security experience.

·       Strong expertise with OCI, OIC, APEX, ATP databases, Databricks, Fivetran.

·       Strong background in service account governance and least-privilege role design.

·       Hands-on exposure to Security Console, HDL, REST APIs, and Fusion data security.

·       Experience automating Fusion operations and controls.

·       Excellent documentation and communication skills.

·       Ability to support Rosendin business US hours

 Preferred Qualifications

·       Oracle EPM Cloud security experience (EPBCS/FCCS/ARCS).

·       OCI or Oracle Cloud Security certifications.

·       Experience developing secure APEX integrations.

Thanks!

Anshika Gupta