Senior Database Administrator
SRM Technologies Chennai, Tamil Nadu, India
Information Technology & Services · 1,001-5,000 employees
Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.
About the role
The Senior Database Administrator will own advanced database administration, technical escalation, and performance management across SQL Server, PostgreSQL, and MySQL workloads. Responsibilities include resolving complex incidents, managing capacity, ensuring backup and recovery integrity, and overseeing database security and deployment standards.
What they look for
Requirements
Candidates must have strong hands-on experience with Microsoft SQL Server, PostgreSQL, and MySQL, including managed RDS environments. Proficiency in database internals, query optimization, scripting (PowerShell/Python), and HA/DR strategies is essential for this role.
Full description
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.
Similar roles
-
Senior Database Administrator - Oracle
Quantrics Enterprises Inc. Manila, Metro Manila, Philippines
-
Senior Database Administrator - Production Support (AWS and Databricks)
LED FastStart Louisiana, Missouri, United States · $116K–$158K/yr
-
Database Administrator L2 - MSSql
Vontier Bangalore, Karnataka, India
-
DBA - Database administrator (m/f/n)
ENCEVO S.A. Luxembourg, Luxembourg
-
Database Administrator II
State of North Carolina Wake County, North Carolina, United States · $88K–$131K/yr
-
Gateway Database Administrator
Toccata Inc Boca Raton, Florida, United States · $110–$135/yr