Sr Administrator (Support & Operations)

Job Summary

Database Administrator – L2 MS SQL Server | Azure Cosmos DB | MySQL | Oracle | PostgreSQL | IBM Db2 Experience Location Employment Support Model 5–8 Years Bengaluru / Hyderabad Full-Time 24x7 / On-Call / Projects Role Summary The Database Administrator L2 will provide advanced operational administration and technical support across Microsoft SQL Server, Azure Cosmos DB, MySQL, Oracle Database, PostgreSQL and IBM Db2 environments. The role acts as the primary technical escalation point for L1 operations and owns complex incident resolution, backup and recovery, performance troubleshooting, high availability, disaster recovery, patching, security administration, capacity management and service improvement across on-premises, cloud IaaS and managed PaaS platforms. The successful candidate should demonstrate strong hands-on expertise in at least two major database technologies, preferably Microsoft SQL Server and Oracle or a combination of SQL Server and cloud/open-source platforms, together with practical operational knowledge across the remaining technologies.

Key Responsibilities

Key Responsibilities Administer production and non-production databases across on-premises, virtualized, cloud IaaS and managed PaaS environments. Own complex incidents escalated by L1, identify root cause, restore service and coordinate dependencies across application and infrastructure teams. Plan and execute backup, restore, point-in-time recovery, database refresh and recovery-validation activities. Configure, monitor and troubleshoot database high-availability, replication and disaster-recovery solutions. Analyse query and platform performance using execution plans, wait statistics, logs, monitoring tools and workload data. Perform approved database patching, upgrades, parameter changes, maintenance and post-change validation. Administer database identities, roles, privileges, service accounts, auditing and security controls using least-privilege principles. Monitor storage, compute, sessions, connections, transaction logs, replication lag and growth trends and recommend capacity actions. Develop and maintain approved SQL, PowerShell and Shell automation for health checks, reporting and routine administration. Mentor L1 engineers, review escalations, maintain technical runbooks and improve monitoring and operational procedures. Incident, Problem and Change Management Lead technical troubleshooting for P1/P2 database incidents and provide factual updates, recovery options, risks and dependencies. Diagnose outages, connectivity errors, blocking, deadlocks, failed jobs, replication delays, storage constraints and backup failures. Perform root-cause analysis for critical or recurring issues and define corrective and preventive actions with accountable owners. Prepare change plans containing prerequisites, implementation steps, validation, rollback, communication and dependency checks. Complete pre-change health validation, confirm recoverability and perform post-change service, job, backup and replication checks. Maintain complete ServiceNow records, problem records, known-error articles and operational evidence. Database Technology Coverage Microsoft SQL Server Advanced administration across on-premises SQL Server, Azure virtual machines and Azure SQL services. Install, configure, patch and upgrade SQL Server instances and associated services. Administer databases, files, recovery models, maintenance jobs, SQL Server Agent, security and service accounts. Configure and troubleshoot Always On Availability Groups, Failover Cluster Instances, Replication and Log Shipping. Perform backup, restore, point-in-time recovery, database refresh and migration activities. Analyse blocking, deadlocks, waits, CPU, memory, I/O and query performance using Query Store, Extended Events, DMVs and execution plans. Support Azure SQL Database, Azure SQL Managed Instance and SQL Server hosted on Azure virtual machines. Provide platform support for SSIS, SSRS and SSAS where included in scope and automate activities using T-SQL and PowerShell. Expected technical knowledge: SQL Server 2016/2017/2019/2022, SSMS, T-SQL, Always On AG, FCI, WSFC, Replication, Log Shipping, Query Store, Extended Events, backups, recovery, Azure SQL, SSIS/SSRS/SSAS and PowerShell. Azure Cosmos DB Operational engineering for availability, throughput, resiliency, monitoring, security and cost-aware performance. Administer Cosmos DB accounts, databases and containers using approved Azure controls. Monitor availability, latency, failed requests, storage, RU consumption, throttling and Azure service-health events. Investigate hot-partition symptoms and partition-distribution concerns and coordinate data-model changes with application and L3 teams. Review indexing-policy impact, throughput configuration, autoscale settings and workload behaviour before approved changes. Configure and monitor multi-region replication, preferred regions, failover settings and consistency configurations. Validate backup and recovery settings and support platform restore activities. Administer RBAC, k

Skill Requirements

Good-to-Have Skills and Certifications Azure SQL Database, Azure SQL Managed Instance, Azure Cosmos DB, AWS RDS/Aurora or GCP Cloud SQL administration. Datadog DBM, SolarWinds, Azure Monitor or equivalent database observability experience. Automation exposure using Git, Azure DevOps, Terraform, Ansible or CI/CD pipelines. Commvault or another enterprise backup-tool integration experience. Database migration, modernization and managed-services transition experience. Preferred certifications: Microsoft DP-300, Oracle Database Administrator, PostgreSQL/MySQL administrator, IBM Db2 DBA, Azure Fundamentals/Data Fundamentals or ITIL 4 Foundation. Behavioural Competencies Structured troubleshooting and ownership during critical incidents. Clear technical communication and stakeholder coordination. Strong documentation, change-control and audit discipline. Ability to prioritize operational risk and escalate architecture concerns appropriately. Collaboration, mentoring and willingness to cross-skill across database platforms. Role Boundaries The L2 Database Administrator owns complex operations, incident resolution, performance troubleshooting, recovery, HA/DR administration, patching, upgrades, standard automation and L1 mentoring. Enterprise strategy, reference architecture, major platform selection, non-standard resilience patterns, complex cross-engine modernization and final design authority remain with the Database L3 SME or Architect. Role Overview Role Database Administrator – L2 Tower Lot 3 – Database Services Primary Focus Shared L2 administration and technical escalation across six database platforms Experience 5–8 Years Location Bengaluru / Hyderabad Employment Full-Time Support Type 24x7 operations, on-call support and planned project activities Hiring Use External publication, supplier sourcing and technical screening

Other Requirements