SAP BASIS Consultant (with Oracle & HANA Administration Expertise)

SAP BASIS Consultant (with Oracle & HANA Administration Expertise)

Job Description – SAP BASIS Consultant (with Oracle & HANA Administration Expertis

e)Position: SAP BASIS & Database administrato

r.Experience Level: Mid–Senior level(6-1

0)Location: Chenn

aiEmployment Type: Full-tim

e.Weightage: BASIS (30%), Oracle (50%), HANA/SQL (20%

).

Role S

ummaryWe are seeking a highly skilled SAP BASIS Consultant with strong expertise in Oracle Database Administration, HANA Administration, and SQL Database management. The consultant will be responsible for end‑to‑end administration, performance tuning, patching, high availability (HA), DR drill management, and L1–L3 support across SAP and database l

ayers.The work distribution for this ro

• le is:Oracle Administration
• – 50%SAP BASIS
• – 30%HANA & SQL Database Administration

– 20%This is a critical role requiring hands-on experience in managing large-scale SAP landscapes, Oracle RAC clusters, HANA HA (including pacemaker), and handling critical outages with minimal dow

ntime.

Oracle Database Administrati

• on (50%)Manage Oracle database architecture, configuration, performance tuning, and troubles
• hooting.Administer Oracle RAC cluster including installation, patching, reconfiguration, and failover
• testing.End-to-end DR drill execution for Oracle da
• tabases.Perform database startup/shutdown, health checks, and manual monitoring withou
• t tools.Backup & recovery using RMAN and ad-hoc/manual backup e
• x
• ecution.Perform data restore operations for Oracle envir
• onments.Tablespace and table partition man
• agement.Deep knowledge of SQL queries, execution plans, and performance optim
• ization.Handle data corruption, data loss, log management, and recovery sc
• enarios.Manage Oracle parameters, patches, updates, and u
• pgrades.DB space management & alert a

nalysis.
B. SAP BASIS Administrat

• ion (30%)Perform SAP system startup/shutdown, health checks, and availability mo
• nitoring.SAP user administration, role modifications, and authorizations (as app
• licable).SAP kernel configuration, upgrades, and
• patching.Manage SAP application patching, SAP Bundle Patch deployment, SPAM/SAINT updates, and SAP lifecycle ma
• nagement.Analyze and troubleshoot SAP performance issues (ABAP stack, work processes, buffers, RFCs, enqueu
• e, etc.).Coordinate outages, communicate planned downtime, and prepare change docum
• entation.Support OpenText archiving and ma
• nagement.Foresee and manage BASIS tasks across L1/L2/L3

support.Complete documentation, runbooks, SOPs, and governance co

mpliance.

C. SAP HANA & SQL Database Administ

• ration (20%)Perform HANA and SQL database health checks, performance tuning, and
• monitoring.Hands-on experience with HANA HA (Active-Active with
• Pacemaker).Execute HANA DR drills
• end-to-end.HANA and SQL database backup/restore
• operations.Manage HANA/SQL user accounts and security

• parameters.
  
  Handle table partitioning, in-memory performance tuning, and column/table store a
• dministration.Updates/upgrades for HANA & SQL
• environments.Manage HANA/SQL parameters, memory configurations, and DB-level tr
• oubleshooting.Address critical outages for HANA and SQL databases with quic

k restoration.

3. Core Technic

al Skills

• RequiredSAP BASISSAP system administration, kernel upgrades, tr
• ansport managementSAP patching, S
• PAM/SAINT, SUM/DMOSAP performance tuning &
• workload analysisSAP authorizat
• ion and user adminSAP archiving c

oncepts (OpenTe

• xt)Oracle DatabaseOra
• cle RAC, ASM, RMANSQL tuning & perfor
• mance optimizationOracle patches/upgrades (PSU/C
• PU/Bundle patches)Tablespace & pa
• rtition managementDR drill &
• amp; HA operationsOracle parameter &
• memory managementData c

orruption recovery

• SAP HANA & SQLHANA Studio, Cock
• pit administrationHANA HA (system replication, p
• acemaker clusters)SQL datab
• ase backup/restoreHANA/SQL patching and
• revision upgradesMemory, CPU, disk

performance tuning
4. Addition

• al ResponsibilitiesCoordinate cross-functional teams durin
• g critical outages.Provide L1/L2/L3 support across SAP a
• nd database layers.Prepare RCA (Root Cause Analysis) and in
• cident resolutions.Participate in capacity planning & p
• erformance reviews.Ensure documentation accuracy and governance compliance (change management

, audit readiness

• ).
  5. QualificationsBachelor's degree in computer science, I
• T, or related field.3-6 years of combined experience in SAP BASIS, Oracle DBA, and
• HANA Administration.Certifi
• cations (preferred):
• SAP BASIS / SA
• P HANAOracle OCP/OCALinux/

Unix OS fundamentals
6.

• Required Soft SkillsStrong analytical and tr
• oubleshooting skills.Ability to work under pressure dur
• ing critical outages.Excellent communication and
• coordination skills.Strong ownership, accountability, an

d governance mindse

• t.
  7. Work EnvironmentWillingness to support on-call rotatio
• n for critical issues.Ability to handle production systems and mission‑c