20 Nov
|
SRM Technologies
|
Chennai
20 Nov
SRM Technologies
Chennai
Job Information
- Date Opened 11/19/2026
- Job Type Full time
- City Chennai
- State/Province Tamil Nadu
- Country India
- Zip/Postal Code 600096
- Industry Technology
Job Description
Junior Database Administrator – Job Description
Role purpose
Perform routine database operations, health monitoring, scheduled maintenance and first-line database troubleshooting under Senior DBA technical direction.
Key responsibilities
-
Execute daily health/resource checks for SQL Server FSx clusters, standalone SQL instances, RDS PostgreSQL and MySQL estates.
-
Monitor database space, data/log growth, storage thresholds, database status, CPU/memory indicators, connections and job/service status.
-
Monitor routine database jobs and backup execution; validate overnight Plaza/POS backups using the agreed CHECKSUM process.
-
Monitor S3 backup-transfer status and reconcile expected completion with source database/job status.
-
Monitor replication status and lag dashboards; perform initial diagnostics and escalate failures to Senior DBA.
-
Perform approved routine maintenance including index/statistics maintenance, integrity checks and job monitoring where documented.
-
Carry out first-line troubleshooting for connection failures, common SQL errors, stored procedure/function issues and basic blocking symptoms.
-
Collect diagnostics for deadlocks, blocking and slow queries; preserve logs, query details and timestamps.
-
Execute approved database deployment scripts and routine configuration changes only with a change request, implementation and rollback plan.
-
Assist with database setup/configuration, patch preparation,
access reviews and routine security administration under Senior DBA approval.
-
Participate in restore tests and DR exercises; execute assigned steps and record evidence.
-
Maintain DBA checklists, runbooks, job schedules, backup records and shift handover documentation.
-
Support data transfer/validation and migration tasks only when specifically assigned and approved.
Required skills and experience
-
Working SQL Server administration and practical PostgreSQL/MySQL exposure.
-
SQL querying, basic/intermediate programming and stored procedure troubleshooting.
-
Backup/restore, CHECKSUM, jobs, maintenance plans and recovery concepts.
-
Locking, blocking, deadlocks, indexes, replication and performance metrics.
-
Health monitoring, alert triage, operational reporting and documentation.
-
Change management, runbook adherence and escalation discipline.
-
Basic SQL, PowerShell or Python scripting.
KPIs / expected outcomes
-
Daily database checks and scheduled jobs completed with evidence.
-
Backup and replication exceptions escalated within target.
-
Routine DBA tickets completed accurately and on time.
-
Maintenance/deployment tasks completed within approved windows.
-
Complete diagnostics and handovers; low repeat incidents from missed checks.
Authority and boundaries
-
Routine tasks follow documented procedures and Senior DBA oversight.
-
Complex tuning, production recovery decisions, schema redesign and high-risk changes are escalated.
-
Junior DBAs do not independently approve high-risk changes, failovers, restores or access/security changes.
📌 Junior Database Administrator (Chennai)
🏢 SRM Technologies
📍 Chennai