Lead SQl DBA

L2 Database Administrator

Support level : L2

Tower / POD : Database (POD D)

Experience : 3–5 years

Coverage : 24×5 + weekend Sev-1/2 on-call

Reports to : L2 Database POD Lead

Location : Pune, Bangalore, Chennai

Role Purpose : Administer Patterson's Azure data platforms: 87 SQL servers hosting 2,551 databases, 61 Cosmos DB accounts, 34 Redis instances, plus PostgreSQL and MySQL.

Key Responsibilities :

Monitor database availability and performance; resolve incidents and service requests within SLA.

Perform query, index and blocking analysis and apply tuning recomm endations.

Manage backup validation, point-in-time restore and geo-replication / failover operations.

Apply patches and minor version updates during approved maintenance windows.

Manage logins, roles and permissions; perform periodic access reviews under least privilege.

Administer Cosmos DB throughput, partitioning and consistency settings; support Redis cache operations.

Support database refreshes and environment cloning using approved processes.

Escalate complex performance, HA/DR or corruption issues to the L3 DBA SME with evidence.

Required Skills

Azure SQL Database, SQL Managed Instance and SQL Server on VMs

Azure Database for PostgreSQL and MySQL

Cosmos DB and Azure Cache for Redis operations

T-SQL, performance tuning and execution plan analysis

Backup/restore, HA and DR concepts

PowerShell/Azure CLI automation

Certifications

DP-300 (preferred); AZ-104; DP-420 (desirable)

Success Measures / KPIs

Database incident resolution within SLA;

Backup success and restore test rate;

Patch compliance;

Performance incident recurrence;

Change success rate.

Final targets to be agreed with Patterson.