Senior Database Administrator
Srmtech · Chennai, Tamil Nadu, India
- First seen
- 19 November 2026
- Reposted
- Not since September 2026
- Last checked
- Today · still on the employer's board
All reasons
In its favour
- Posted yesterday
- Still listed on the employer's own board
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.
Skills
More jobs at Srmtech
All 32- Cloud NOC LeadSrmtech · Chennai, Tamil Nadu, Indiayesterday
- Junior Database AdministratorSrmtech · Chennai, Tamil Nadu, Indiayesterday
- Site Reliability EngineerSrmtech · Chennai, Tamil Nadu, Indiayesterday
- System AnalystSrmtech · Chennai, Tamil Nadu, Indiayesterday
- Sr. Backend Developer 2 (Batch & Integration)Srmtech · Chennai, Tamil Nadu, India3d ago
Similar roles
- Associate Data AnalystLabcorp · Bengaluru, KA, IndiaUpdated today
- Staff Software Engineer (Data Platform)Databricks · Bengaluru, Indiatoday
- Senior Software Engineer (Data Platform)Databricks · Bengaluru, Indiatoday
- Principal Data EngineerPrecision Medicine Group · Remote · Indiatoday
- Senior Data EngineerOkta · Bengaluru, Indiatoday
- Senior Database AdministratorEnsono · Bengaluru, India · Chennai, India · Hyderabad, India +1today