SRM Technologies Logo

SRM Technologies

Senior Database Administrator

Posted 3 Days Ago
Be an Early Applicant
In-Office
Chennai, Tamil Nadu, IND
Senior level
In-Office
Chennai, Tamil Nadu, IND
Senior level
Owns advanced administration, troubleshooting, performance optimization, security, backup and recovery for SQL Server, PostgreSQL and MySQL environments. Leads incident resolution, replication, HA/DR testing, database changes, capacity planning, migrations within scope, and recovery validation. Maintains DBA standards and runbooks while coaching junior DBAs.
The summary above was generated by AI

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.



HQ

SRM Technologies Chennai, Tamil Nadu, IND Office

Chennai, India

SRM Technologies Chennai, Tamil Nadu, IND Office

Perungudi, Campus 1A, 5th Floor, RMZ Millenia Business Park, , , , Chennai, Tamil Nadu, India, 600096

Similar Jobs

2 Months Ago
Easy Apply
Hybrid
Chennai, Tamil Nadu, IND
Easy Apply
Senior level
Senior level
Cloud • Information Technology
Supports Db2 LUW databases for multiple clients, including environment design, installations, upgrades, patching, migrations, troubleshooting, security, backup and recovery, performance tuning, and high-availability management. The role collaborates with clients and global DBA teams, supports projects and 24x7 incidents, develops automation and documentation, resolves complex issues, and mentors junior administrators. Rotating shifts and on-call participation are required.
Top Skills: AIAnsibleAWSDb2 ConnectDb2 HadrDb2 LuwGCPItilLdapPythonQ-ReplicationShell ScriptingSql ReplicationTerraformTsa/PacemakerUnix/LinuxWindows
2 Months Ago
In-Office
Chennai, Tamil Nadu, IND
Senior level
Senior level
Agency
Owns the reliability, security, performance, availability, backup, recovery, and lifecycle management of enterprise Microsoft SQL Server environments. Responsibilities include troubleshooting, tuning, patching, upgrades, high availability, disaster recovery, security administration, automation, incident leadership, migrations, BI workload support, documentation, and mentoring. The role partners with developers and data engineers on schema design, query optimization, releases, and modernization initiatives including Azure SQL adoption.
Top Skills: Always On Availability GroupsAzure SqlMicrosoft Sql Server 2019+Power BIPowershellSource ControlSql Server AgentSqlcmdSsasSsisSsrsT-SqlWindows Server
3 Months Ago
In-Office
Chennai, Tamil Nadu, IND
Senior level
Senior level
Fintech • Payments • Financial Services
Administer PostgreSQL, Cassandra, and ClickHouse databases for high-volume fintech workloads. Design schemas, indexing, partitioning, replication, disaster recovery, and point-in-time recovery strategies. Tune queries and capacity, automate operations with Shell and Python, manage database security and compliance, and resolve production incidents with root-cause documentation. Collaborate with engineering teams, maintain technical documentation, and participate in 24/7 on-call support.
Top Skills: CassandraClickhouseCqlLinuxPl/PgsqlPostgresPythonShellSQLUnix

What you need to know about the Chennai Tech Scene

To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account