31 Aug
|
lactalis india
|
Chennai
31 Aug
lactalis india
Chennai
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 sk illed SAP BASIS Cons ultant with strong experti se in Oracle Database Administration, HANA Administration, and SQL Database mana gement. 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.Adm inister Oracle RAC cluster including installation, patching, reconfiguration, and failover
testing.End -to-end DR drill e xecution for Oracle da
tabases. Perform database startup/ shutdown, health chec ks, and manual mo nitoring withou
t tools.Backup & recovery using RMAN and ad-hoc/manual backup e
x
ecution. Perform data restore op erations for Oracle envir
onments.Tablespace and table partition man
agement.Deep knowledge of SQL queries, execution plans, and performance optim
ization .Handle data corruption, d ata 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
patchin g.Manage SAP application patching, SAP Bundle Patch d eployment, 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 m a
nagement.Foresee and manage BASIS task s across L1/L2/L 3
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 expe rience with HANA HA (Active-Active wit h
Pacemak er).Execute HA NA 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.Solid 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
ritical infrastructure
📌 SAP BASIS Consultant (with Oracle & HANA Administration Expertise) (Chennai)
🏢 lactalis india
📍 Chennai