SAP Oracle DBA

Scope of Work / Responsibilities

• 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.

• Strong understanding of Oracle Standard Compression and Advanced Compression.
• Ability to identify compressed DBA objects:
• Tables
• Indexes
• LOBs / Secure Files
• Assess compression usage from technical and licensing perspectives.

• Identify and manage DBA objects in SAP schemas (tables, indexes, partitions, LOB segments).
• Perform table reorganization, index rebuilds, and space reclamation activities.

• 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.

• BRSPACE for space and object management
• BRBACKUP / BRARCHIVE for backup coordination
• Follow SAP Notes, SAP-recommended procedures, and change management.

• Monitor database performance and ensure system stability.
• Gather optimizer statistics and support performance tuning activities.

• SAP Oracle DBA with strong hands-on production support experience.
• Strong knowledge of BRTools (mandatory).
• Solid experience in tablespace, datafile, and storage management.

• Exposure to Oracle licensing and audit scenarios.
• Automation using SQL / PL/SQL or shell scripting.

• Stable SAP Oracle database operations with correct compression usage, optimal space management, and compliance with SAP standards.