Sr Administrator (Support & Operations) (IN)
HCLTech
HCLTech
Seeking an experienced Database Administrator (L2) to provide advanced operational administration and technical support. This role involves managing a diverse range of database environments including Microsoft SQL Server, Azure Cosmos DB, MySQL, Oracle, PostgreSQL, and IBM Db2. You will serve as the primary technical escalation point, resolving complex incidents, managing backups and recoveries, optimizing performance, and ensuring high availability and disaster recovery.
Your expertise will span on-premises, cloud IaaS, and managed PaaS platforms. We are looking for a candidate with strong hands-on experience in at least two major database technologies, ideally Microsoft SQL Server and Oracle, or SQL Server with cloud/open-source platforms, complemented by operational knowledge across the other listed technologies.
Key responsibilities include administering production and non-production databases across various environments. You will own complex incidents escalated from L1, perform root cause analysis, and coordinate resolutions with application and infrastructure teams. This includes planning and executing backup, restore, and recovery validation. You will configure, monitor, and troubleshoot high-availability, replication, and disaster-recovery solutions.
Performance analysis using execution plans and monitoring tools is crucial. You will also handle database patching, upgrades, and security administration, ensuring adherence to least-privilege principles. Monitoring capacity, developing automation scripts, and mentoring L1 engineers are also integral parts of the role. Leading technical troubleshooting for critical incidents and managing incident, problem, and change processes are key duties.
Essential technical knowledge encompasses SQL Server 2016/2017/2019/2022, SSMS, T-SQL, Always On AG, FCI, WSFC, Replication, Log Shipping, Query Store, Extended Events, backups, and recovery. Experience with Azure SQL, SSIS/SSRS/SSAS, and PowerShell is expected.
For Azure Cosmos DB, operational engineering for availability, throughput, resiliency, monitoring, security, and cost optimization is required. This includes administering Cosmos DB accounts, monitoring performance, investigating issues, and configuring multi-region replication and failover settings. Collaboration, clear technical communication, structured troubleshooting, and strong documentation skills are vital behavioural competencies.
HCLTech
IT Consulting