SRM Technologies

Junior Database Administrator

SRM Technologies Chennai, Tamil Nadu, India

Information Technology & Services · 1,001-5,000 employees

14 h ago
dba Junior (0-2 yrs) Full-time India
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

Perform routine database operations, health monitoring, and scheduled maintenance under the direction of a Senior DBA. Execute first-line troubleshooting for database issues and assist with deployment scripts and security administration.

What they look for

SQL Server PostgreSQL MySQL Database Administration Health Monitoring Backup And Recovery Performance Tuning PowerShell Python SQL Replication Troubleshooting Change Management Integrity Checks Scripting

Requirements

Requires practical experience with SQL Server, PostgreSQL, and MySQL administration. Candidates should possess skills in SQL querying, scripting, and understanding of backup, recovery, and performance metrics.

Full 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.

Similar roles