Senior Database Administrator

SRM TechnologiesChennai, Tamil NaduOn-siteFull-timeSenior, 5–8 yearsListed 12 hours ago

Apply now

About this role

Senior
Database Administrator – Job Description

Role purpose

Own
advanced database administration and technical escalation across SQL Server,
PostgreSQL and MySQL workloads in scope, including performance, resilience,
security and controlled recovery.

Key responsibilities

· Own complex database incidents involving blocking, deadlocks,
stored procedure/function failures, query regressions and database
availability.

· Administer and troubleshoot SQL Server, PostgreSQL and MySQL,
including SQL Server on FSx/EC2 and RDS PostgreSQL/MySQL.

· Investigate deadlock graphs, blocking chains, wait conditions,
execution plans, slow queries, indexes and resource bottlenecks; implement
approved remediation.

· Lead database capacity and performance analysis across CPU,
memory, I/O, storage growth, connections, query workload and scaling.

· Own backup/recovery assurance, point-in-time recovery where
supported, full restore tests and recovery evidence.

· Lead replication configuration and advanced troubleshooting,
including replication failures and lag; coordinate network-path validation.

· Assess HA/DR readiness and plan/execute approved failover/failback
tests for SQL Server FSx clusters and RDS PaaS.

· Review and approve database deployment scripts, schema/stored
procedure changes and production database changes with peer review,
implementation and rollback plans.

· Perform database setup/configuration, operations and maintenance;
maintain standards for indexing, partitioning, configuration and resource
management.

· Provide database security input, privileged access review,
stale-access removal and patch planning.

· Support complex SQL logic, business rules, code review and
optimization; application feature development excluded unless separately
agreed.

· Contribute to data modelling, partitioning and multi-tenant design
under approved project/change.

· Lead migration/conversion planning and data validation only when
explicitly in approved scope.

· Maintain DBA runbooks, known-error records and procedures; coach
Junior DBAs.

Required skills and experience

· Strong hands-on Microsoft SQL Server administration; practical
PostgreSQL/MySQL and managed RDS knowledge.

· Advanced SQL, stored procedure/function troubleshooting, execution
plans, indexing and query optimization.

· Database internals, storage, memory, locking, transactions and
concurrency.

· Backup/recovery, point-in-time restore, CHECKSUM, restore testing
and recovery planning.

· Replication, clustering, HA/DR failover/failback.

· Database security, patch/change management, RCA and technical
communication.

· SQL, PowerShell or Python scripting for routine DBA checks.

KPIs / expected outcomes

· Database availability/performance against agreed SLAs.

· P1/P2 database incidents technically owned and resolved/escalated
on time.

· Backup success, restore-test completion and recovery evidence.

· Replication health and lag exceptions managed.

· Reduction in recurring blocking/deadlock/query issues.

· Approved database changes with validation and rollback evidence.

Authority and boundaries

· One Senior DBA is the advanced technical owner; this does not
independently establish 18×7 dedicated DBA coverage.

· Define out-of-hours rota/on-call, escalation backup and leave
coverage.

· Migrations, major redesign, application SQL development and large
platform upgrades require explicit scope.