Job Summary

Transformation - Database L2

Key Responsibilities

- Database Administration: Install, configure, upgrade, and maintain relational databases (SQL Server, Oracle, PostgreSQL, MySQL) across physical, virtual, and cloud environments.
- Backup & Recovery: Execute routine database backups, test restore procedures and ensure compliance with strict RPO/RTO data recovery policies.
- Performance Tuning: Monitor database health, optimize slow-running queries, manage indexes, and resolve blocking/deadlocking issues.
- L2 Incident Management: Act as the primary technical resolver for escalated database alerts, connection failures, and capacity issues within ServiceNow.
- Access & Security: Manage user access, roles, and privileges, ensuring databases are hardened against unauthorized access and comply with security audits.
- Transformation Support: Assist senior architects in executing database migrations (e.g., on-premises SQL to Azure SQL Managed Instance or GCP Cloud SQL).
- Patching & Upgrades: Schedule and apply routine security patches and cumulative updates to database engines with minimal business disruption.

Skill RequirementsMust have Skills:

- Technical:

- 4+ years of dedicated experience in Database Administration in a large-scale enterprise environment.
- Strong hands-on experience managing Microsoft SQL Server (2014-2022) and/or Oracle databases.
- Proficiency in writing, analyzing, and tuning complex T-SQL or PL/SQL queries.
- Solid understanding of database high-availability (HA) concepts, such as SQL Server AlwaysOn Availability Groups, Log Shipping, or Oracle Data Guard.




- Familiarity with cloud-based database services (IaaS VMs and PaaS offerings like Azure SQL or Cloud SQL).
- Experience managing database storage, filegroups, table spaces, and capacity forecasting.

- Non-Technical ITSM Operations:

- Proven experience adhering to strict Incident, Change, and Problem Management workflows using ITSM tools like ServiceNow.
- SLA Compliance: Strong track record of meeting strict resolution targets and minimizing database downtime during critical business hours.
- Documentation: Ability to follow and update standard operating procedures (SOPs), runbooks, and build-guides for database deployments.
- Cross-Functional Collaboration: Ability to work closely with Wintel, Linux, and Storage teams to troubleshoot underlying OS or disk latency issues.

Other RequirementsGood to Have Skills:

- Experience with open-source and NoSQL databases (e.g., MongoDB, Cosmos DB, MySQL).
- Basic scripting skills (PowerShell or Python) for automating routine DBA tasks and health checks.
- Familiarity with database migration tools (e.g., Azure Database Migration Service).

Soft Skills:

- Analytical Thinking: Methodical approach to diagnosing and resolving hidden performance bottlenecks.
- Proactive Monitoring: A mindset geared towards finding and fixing issues before they impact the end-user.
- Communication: Transparent verbal and written communication skills to articulate database issues to non-DBA stakeholders.
- Certifications: DP-300 or Oracle Database Certification (OCA/OCP), AZ-900 or DP-900.

Overview

- Role: Transformation - Database L2
- Experience Level: 4+ years
- Job Location: Bengaluru / Hyderabad
- Job Type: Full-Time
- Support Type: 24x7 Operational Support & Project Engagements

📌 Sr Administrator (Support & Operations) (Bengaluru)
🏢 HCL Technologies
📍 Bengaluru