Junior Database Administrator

SRM TechnologiesChennai, Tamil NaduOn-siteFull-timeJunior, 1–2 yearsListed 12 hours ago

Apply now

About this role

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.