HCLTech Hiring Database Administrator (L2) in Nagpur | Apply Now

Job Summary

We are looking for 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 role covers monitoring database health, handling routine operational tasks, responding to alerts, performing basic troubleshooting, and keeping databases available within defined SLAs.

Key Responsibilities

Database Monitoring & Support

• Monitor 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 Support

• Monitor 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 Administration

• Create, modify and disable database user accounts.
• Grant and revoke database permissions based on approved requests.
• Support password resets and access-related activities.

Routine Database Maintenance

• Perform 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 Management

• Handle tickets through ServiceNow.
• Document incidents, resolutions and operational procedures.
• Coordinate with application and infrastructure teams for issue resolution.
• Take part in shift handovers and daily operational reviews.

Documentation & Compliance

• Maintain operational documentation and runbooks.
• Follow change management and compliance processes.
• Ensure adherence to security and audit requirements.

Skill Requirements

IBM DB2

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

Oracle Database

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

Microsoft SQL Server

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