Administrator (Support & Operations) at HCLTech · Nagpur

Job Summary

We are seeking a motivated and detail-oriented Database Administrator (L2) to provide first-level support for enterprise database environments including IBM DB2, Microsoft SQL Server and Oracle Database. The candidate will be responsible for monitoring database health, handling routine operational tasks, responding to alerts, performing basic troubleshooting, and ensuring database availability in accordance with defined SLAs.

Key Responsibilities

Database Monitoring & SupportMonitor SQL Server, Oracle, and DB2 databases using enterprise monitoring tools.Respond to database alerts, incidents, and service requests within agreed SLAs.Perform initial troubleshooting and escalate complex issues to L3 teams.Monitor database availability, performance, storage utilization, and backups.Validate database services and scheduled jobs.

Backup & Recovery SupportMonitor and verify backup completion status.Execute standard backup and restore requests as per documented procedures.Ensure backup failures are identified and reported promptly.Assist in recovery testing activities.

User & Security AdministrationCreate, modify, and disable database user accounts.Grant and revoke database permissions as per approved requests.Support password resets and access-related activities.

Routine Database MaintenancePerform health checks and routine maintenance activities.Monitor tablespace, disk space, transaction logs, and database growth.Execute predefined maintenance tasks and scripts.Support patching and upgrade activities under supervision.

Incident & Service Request ManagementHandle tickets through ServiceNow.Document incidents, resolutions, and operational procedures.Coordinate with application and infrastructure teams for issue resolution.Participate in shift handovers and daily operational reviews.

Documentation & ComplianceMaintain operational documentation and runbooks.Follow change management and compliance processes.Ensure adherence to security and audit requirements

Skill Requirements

IBM DB2Basic knowledge of DB2 database administration.User and schema management.Backup and recovery concepts.Database monitoring and health checks.

Oracle DatabaseBasic Oracle database administration knowledge.Oracle Enterprise Manager (OEM) familiarity.User management and tablespace monitoring.Backup concepts using RMAN.

Microsoft SQL ServerBasic understanding of SQL Server Architecture.SQL Server Management Studio (SSMS).Backup and restore concepts.SQL Agent job monitoring.Basic T-SQL queries.

Other Requirements

Basic SQL scripting knowledge.Experience with monitoring tools.Understanding of ITIL processes.Knowledge of Windows and Linux operating systems.Good analytical and troubleshooting skills.Strong communication and documentation skills.