Role: SAP Oracle DBA
Engagement: Contract / T&M
Experience: 8–10+ years
Environment: SAP on Oracle
Mandatory Requirement
- Hands-on experience with SAP BRTools (BRSPACE, BRBACKUP, BRARCHIVE) – must-have
Scope of Work / Responsibilities
SAP Oracle DBA Core Activities
- Perform standard DBA activities in SAP on Oracle environments (24x7 production support as required).
- Work closely with SAP Basis teams for planned activities and incidents.
Compression Knowledge (Mandatory)
- Strong understanding of Oracle Standard Compression and Advanced Compression.
- Ability to identify compressed DBA objects:
- Tables
- Indexes
- LOBs / SecureFiles
- Assess compression usage from technical and licensing perspectives.
DBA Object Identification & Management
- Identify and manage DBA objects in SAP schemas (tables, indexes, partitions, LOB segments).
- Perform table reorganization, index rebuilds, and space reclamation activities.
Storage & Tablespace Management
- Create and manage Tablespaces and Datafiles.
- Monitor and manage database growth, space utilization, and capacity planning.
- Perform datafile resize, add/drop datafiles as per SAP standards.
SAP-Specific DBA Operations
- Execute database activities using BRTools:
- BRSPACE for space and object management
- BRBACKUP / BRARCHIVE for backup coordination
- Follow SAP Notes, SAP-recommended procedures, and change management.
Performance & Stability
- Monitor database performance and ensure system stability.
- Gather optimizer statistics and support performance tuning activities.
Mandatory Skills
- SAP Oracle DBA with strong hands-on production support experience.
- Proven expertise in Oracle compression (Standard & Advanced).
- Strong knowledge of BRTools (mandatory).
- Solid experience in tablespace, datafile, and storage management.
Good to Have
- Exposure to Oracle licensing and audit scenarios.
- Automation using SQL / PL/SQL or shell scripting.
Key Outcome
- Stable SAP Oracle database operations with correct compression usage, optimal space management, and compliance with SAP standards.
