Administrator (Support & Operations) (IN)
HCLTech
HCLTech
Join our team as a Database Operations Engineer L1, providing essential first-line support for a diverse database environment including Microsoft SQL Server, Azure Cosmos DB, MySQL, Oracle, PostgreSQL, and IBM Db2. This role focuses on broad operational coverage, ensuring service health, validating alerts, and executing standard procedures. You'll play a crucial part in monitoring, troubleshooting, and escalating issues to specialized L2/L3 teams.
Provide comprehensive first-line operational monitoring and support across various relational and NoSQL database platforms. Conduct regular health checks, focusing on availability, connectivity, storage, backups, and replication. Acknowledge and triage incidents, performing initial troubleshooting steps and maintaining accurate records in ServiceNow. Fulfill standard requests such as status checks, access activities, and log collection. Monitor backup completion, identify failures, and escalate risks related to backup chains, retention, capacity, or recoverability. Oversee high-availability and replication configurations, escalating synchronization and latency issues. Support planned changes by completing pre-checks and post-change validations. Maintain operational documentation, including SOPs and runbooks. Collaborate effectively with cross-functional teams, including application, cloud, and network specialists.
Participate in major incident management by providing real-time database health updates and executing assigned diagnostic actions.
Demonstrate first-line operational support experience with Microsoft SQL Server, including monitoring services, jobs, logs, and backups. Familiarity with Always On Availability Groups, Log Shipping, and Replication is expected. Basic T-SQL knowledge for checking database status is required.
Gain exposure to Azure Cosmos DB operations, monitoring account availability, service health, and request throttling. Understand RU/s, partition keys, and geo-replication concepts. Utilize the Azure Portal and Azure Monitor for operational checks.
Provide first-line support for Oracle Database, monitoring instance availability, listeners, tablespaces, and backups. Awareness of RAC, ASM, and Data Guard is beneficial. Experience with Oracle Enterprise Manager or SQL Developer is a plus.
Offer operational monitoring and routine support for PostgreSQL, including service availability, storage growth, and backups. Familiarity with streaming or logical replication and pgAdmin is needed.
Deliver first-line monitoring and operational support for MySQL databases, ensuring service availability and monitoring backups.
Key working knowledge for SQL Server includes services, databases, SSMS, Agent, backup/recovery, file structures, Always On, Log Shipping, Replication, and basic T-SQL. For Cosmos DB, expect awareness of accounts, databases, containers, RU/s, partition keys, geo-replication, Azure Portal, and Azure Monitor. Oracle requires understanding of instance/database concepts, listeners, tablespaces, RMAN, RAC, ASM, Data Guard, OEM, SQL Developer, and basic SQL*Plus. PostgreSQL knowledge should encompass architecture basics, pgAdmin, WAL, backups, replication, sessions, locks, and basic SQL. MySQL skills involve basic monitoring of services, backups, and instances.
HCLTech
IT Consulting