11 Oct
|
HCLTech
|
Hyderabad
Administrator (Support & Operations) Hyderabad, Telangana
Job Summary
Database Operations Engineer – L1 MS SQL Server | Azure Cosmos DB | MySQL | Oracle | PostgreSQL | IBM Db2 Experience Location Employment Support Model 2–4 Years Bengaluru / Hyderabad Full time 24x7 Rotational Support Role Summary The Database Operations Engineer L1 will act as the common first-line operations resource for the Lot 3 database estate covering Microsoft SQL Server, Azure Cosmos DB, MySQL, Oracle Database, PostgreSQL and IBM Db2. The role is designed for broad operational coverage rather than deep platform specialization. The engineer will monitor service health, validate alerts, perform standard checks and requests, collect diagnostics, execute approved runbooks and escalate complex issues to the relevant L2 or L3 specialist.
Key Responsibilities
Key Responsibilities Provide first-line operational monitoring and support across the assigned relational and NoSQL database platforms. Perform scheduled health checks covering database availability, connectivity, storage, backups, scheduled jobs, logs and replication status. Acknowledge and triage database incidents, execute approved L1 troubleshooting steps and maintain accurate ServiceNow updates within agreed service levels. Fulfil standard requests such as status checks, approved access activities, password resets, log collection, connectivity validation and execution of authorized scripts. Monitor backup completion, identify failures, capture error details and escalate backup-chain, retention, capacity or recoverability risks. Monitor high-availability and replication configurations and escalate synchronization, latency, listener, replica or service-health issues. Support planned changes by completing pre-checks, post-change health validation and evidence capture under L2 guidance. Maintain shift handovers, operational dashboards, SOPs, runbooks, knowledge articles and inventory records. Coordinate with application, cloud, Windows/Linux, network, storage, backup and security teams for dependency-related incidents. Participate in major incident bridges by providing factual database-health updates and completing diagnostic actions assigned by L2/L3.
Skill Requirements
Database Technology Coverage Microsoft SQL Server First-line operational support for SQL Server instances hosted on-premises or on cloud infrastructure. Operational responsibilities Monitor SQL Server services, instance and database availability, SQL Server Agent jobs, error logs, connectivity, database-file growth and transaction-log utilization. Validate full, differential and transaction-log backup completion and capture failure details for escalation. Monitor Always On Availability Groups, replica synchronization, listeners, Log Shipping and Replication using approved tools and scripts. Use SQL Server Management Studio and basic T-SQL queries to check database state, sessions, blocking, jobs and backup status. Escalate corruption alerts, repeated job failures, severe blocking, backup-chain gaps, capacity risk and availability-group issues. Expected working knowledge: SQL Server services and databases, SSMS, SQL Server Agent, backup and recovery models, MDF/NDF/LDF files, Always On monitoring, Log Shipping, Replication, basic T-SQL. Azure Cosmos DB Operational monitoring of Azure Cosmos DB accounts and workloads without requiring L1 ownership of data-model or partition design. Operational responsibilities Monitor account and regional availability, Azure service-health notifications, request failures, latency, storage and configured alerts. Review request-unit consumption and throttling indicators and capture the affected account, database, container and time window. Validate connectivity and access-related incidents using approved procedures and coordinate with cloud, network and application teams. Monitor backup configuration and platform status where exposed through approved dashboards. Escalate sustained throttling, partition-related concerns, indexing-policy issues, consistency changes,
regional incidents and capacity design matters. Expected working knowledge: Cosmos DB accounts, databases and containers, RU/s and throttling, partition-key awareness, geo-replication awareness, Azure Portal, Azure Monitor, basic connectivity and access checks. Oracle Database First-line operational support for Oracle database services and availability components. Operational responsibilities Monitor database and instance availability, listener status, alert logs, tablespace usage, archive destinations and scheduled jobs. Validate RMAN backup completion and collect job logs and error details for failed or delayed backups. Monitor RAC instance availability, ASM-related alerts and Data Guard transport/apply status through approved tools. Use Oracle Enterprise Manager, SQL Developer or basic SQL*Plus commands for documented health and status checks. Escalate RAC, ASM, Data Guard, RMAN, corruption, archive-log, listener and performance issues to the Oracle L2 DBA. Expected working knowledge: Oracle instance and database concepts, listeners, tablespaces, RMAN, RAC and ASM awareness, Data Guard monitoring, OEM, SQL Developer, basic SQL*Plus. PostgreSQL Operational monitoring and routine support for PostgreSQL database services. Operational responsibilities Monitor PostgreSQL service and database availability, connection utilization, logs, storage growth and scheduled maintenance tasks. Validate backup completion and collect evidence for failed base backups, WAL archival or backup-tool jobs. Monitor streaming or logical replication status and identify replication lag or standby connectivity issues. Use pgAdmin or approved SQL commands for database status, sessions, locks and replication checks. Escalate advanced vacuum, performance, parameter, replication, recovery and major-version concerns to L2. Expected working knowledge: PostgreSQL architecture basics, pgAdmin, WAL concepts, backup fundamentals, streaming and logical replication awareness, sessions and locks, basic PostgreSQL SQL. MySQL First-line monitoring and operational support for MySQL databases hosted on servers or managed cloud services. Operational responsibilities Monitor MySQL s
Other Requirements
📌 Administrator (Support & Operations) (Hyderabad)
🏢 HCLTech
📍 Hyderabad