Senior Database Administrator (Chennai)

Senior Database Administrator (Chennai)

21 Nov
|
SRM Technologies
|
Chennai

21 Nov

SRM Technologies

Chennai

SeniorDatabase Administrator – Job Description

Role purpose

Ownadvanced 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 databaseavailability.

·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; implementapproved 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 wheresupported, 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/failbacktests for SQL Server FSx clusters and RDS PaaS.

·Review and approve database deployment scripts, schema/storedprocedure 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 resourcemanagement.

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

·Support complex SQL logic, business rules,



code review andoptimization; application feature development excluded unless separatelyagreed.

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

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

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

Required skills and experience

·Robust hands-on Microsoft SQL Server administration; practicalPostgreSQL/MySQL and managed RDS knowledge.

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

·Database internals, storage, memory, locking, transactions andconcurrency.

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

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

·Database security, patch/change management, RCA and technicalcommunication.

·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/escalatedon 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 notindependently establish 18×7 dedicated DBA coverage.

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

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

📌 Senior Database Administrator (Chennai)
🏢 SRM Technologies
📍 Chennai

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: senior database administrator (chennai) / chennai

Subscribe to this job alert:

Get the latest job offers by email for: senior database administrator (chennai) / chennai