Database Administrator

TalentD; Nagpur District; On-site; INR 600,000 - 900,000; Full time

Job summary

TalentD is seeking a motivated Database Administrator (L2) to provide first-level support for enterprise databases including IBM DB2, Oracle Database, and Microsoft SQL Server. The role focuses on monitoring health, handling routine tasks, and ensuring availability within defined SLAs.

Responsibilities include monitoring, backup verification, incident management, user/security administration, and participating in maintenance windows under supervision.

Qualifications

• Basic knowledge of DB2 database administration, user/schema management, and backup/recovery concepts.
• Familiarity with database monitoring, health checks, and patching activities.
• Experience with Windows and Linux operating systems and basic scripting.

Responsibilities

• Monitor SQL Server, Oracle and DB2 databases using enterprise monitoring tools.
• Respond to alerts, incidents and service requests within SLAs.
• Perform initial troubleshooting and escalate complex issues to L3 teams.
• Monitor availability, performance, storage, backups and growth.
• Handle tickets through ServiceNow and document resolutions.

Skills

DB2

Oracle

SQL Server

Monitoring

ITIL

Windows

Linux

Troubleshooting

Communication

Documentation

Tools

SSMS

RMAN

OEM

SQL Agent

ServiceNow

Job description

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 escalation 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.