06 Aug
|
lactalis india
|
Chennai
06 Aug
lactalis india
Chennai
SAP BASIS Consultant (with Oracle & HANA Administration Expertise) – 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.
- 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
- 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
).
- 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.Robust ownership, accountability, an d governance mindse t.
- 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