Senior Database Administrator

SRM Technologies LLC

Chennai

On-site

INR 900,000 - 1,500,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

SRM Technologies LLC in Chennai seeks a Senior Database Administrator to own and optimize SQL Server, PostgreSQL and MySQL environments, including on FSx/EC2 and RDS deployments. You will handle performance tuning, backup/recovery, replication, and high availability while enforcing security and change control.

The role focuses on incident management, capacity planning, and ensuring data integrity across multi-tenant architectures, with a strong emphasis on scalable, resilient database operations.

Qualifications

  • Hands-on SQL Server administration; PostgreSQL/MySQL and cloud RDS experience.
  • Advanced SQL, stored procedures, execution plans, indexing and query optimization.
  • Knowledge of database internals, storage, memory, locking, transactions and concurrency.
  • Backup/recovery, PITR, restore testing and recovery planning.
  • Replication, clustering, HA/DR, failover/failback.
  • Database security, patch/change management, RCA and communication.
  • Scripting for routine DBA checks (SQL, PowerShell, Python).

Responsibilities

  • Own complex database incidents: blocking, deadlocks, query failures and availability.
  • Administer and troubleshoot SQL Server, PostgreSQL and MySQL; include RDS deployments.
  • Investigate deadlocks, blocking chains, wait conditions, execution plans, slow queries and bottlenecks; implement remediation.
  • Lead capacity and performance analysis across CPU, memory, I/O, storage, connections and workload.
  • Own backup/recovery assurance, PITR, full restore tests and recovery evidence.
  • Lead replication configuration and troubleshooting, including lag; validate network path.
  • Assess HA/DR readiness and plan/execute failover/failback tests for SQL Server FSx clusters and RDS.
  • Review deployment scripts, schema/stored procedure changes; ensure rollback plans.
  • Perform setup/configuration, operations and maintenance; enforce indexing, partitioning and resource management.
  • Provide database security input, privileged access reviews and patch planning.
  • Support complex SQL logic, business rules and code review; app development excluded unless agreed.
  • Contribute to data modelling, partitioning and multi-tenant design.
  • Lead migration/conversion planning and data validation in scope.
  • Maintain DBA runbooks, known-error records and coach Junior DBAs.

Skills

SQL Server administration
PostgreSQL
MySQL
RDS knowledge
Advanced SQL
Indexing/query optimization
Backup and recovery
Scripting: PowerShell/Python

Tools

PowerShell
Python

Job description

SeniorDatabase Administrator – Job Description


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


  • Strong 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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Sql Server DBA-MNC Financial Organization
Senior Sql Server DBA-MNC Financial Organization

RiverForest Connections Inc • Mumbai

On-site
INR 1,400,000 - 2,000,000
DBA Administrator
DBA Administrator

HTC Global • Hyderabad

On-site
INR 1,200,000 - 2,400,000
Junior Database Administrator
Junior Database Administrator

SRM Technologies LLC • Chennai

On-site
INR 500,000 - 700,000
Sr. SQL Server DBA Engineer
Sr. SQL Server DBA Engineer

Global Software Solutions Group • Bengaluru

On-site
INR 3,000,000 - 5,500,000
Database Administrator
Database Administrator

Natus Sensory Inc. • Bengaluru

On-site
INR 3,500,000 - 7,000,000
Advisor - MySQL Database SME
Advisor - MySQL Database SME

enGen Global • Hyderabad

On-site
INR 1,500,000 - 2,100,000
Senior Database Administrator
Senior Database Administrator

Maersk • Bengaluru

On-site
INR 2,000,000 - 3,200,000
Senior Database Administrator
Senior Database Administrator

i2b Technologies Pvt Ltd • Hyderabad

On-site
INR 1,000,000 - 3,000,000
Sr. SQL Server DBA Engineer
Sr. SQL Server DBA Engineer

GSS Group • India

On-site
INR 1,200,000 - 2,400,000
Database Administrator (Microsoft SQL Server)
Database Administrator (Microsoft SQL Server)

PepsiCo Inc. • Hyderabad

On-site
INR 2,500,000 - 4,200,000