21 Nov
|
SRM Technologies
|
Chennai
21 Nov
SRM Technologies
Chennai
JuniorDatabase Administrator – Job Description
Role purpose
Performroutine database operations, health monitoring, scheduled maintenance andfirst-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; validateovernight Plaza/POS backups using the agreed CHECKSUM process.
·Monitor S3 backup-transfer status and reconcile expectedcompletion with source database/job status.
·Monitor replication status and lag dashboards; perform initialdiagnostics and escalate failures to Senior DBA.
·Perform approved routine maintenance including index/statisticsmaintenance, integrity checks and job monitoring where documented.
·Carry out first-line troubleshooting for connection failures,common SQL errors, stored procedure/function issues and basic blockingsymptoms.
·Collect diagnostics for deadlocks, blocking and slow queries;preserve logs, query details and timestamps.
·Execute approved database deployment scripts and routineconfiguration changes only with a change request, implementation and rollbackplan.
·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 assignedsteps and record evidence.
·Maintain DBA checklists, runbooks, job schedules, backup recordsand shift handover documentation.
·Support data transfer/validation and migration tasks only whenspecifically assigned and approved.
Required skills and experience
·Working SQL Server administration and practical PostgreSQL/MySQLexposure.
·SQL querying, basic/intermediate programming and stored proceduretroubleshooting.
·Backup/restore, CHECKSUM, jobs, maintenance plans and recoveryconcepts.
·Locking, blocking, deadlocks, indexes, replication and performancemetrics.
·Health monitoring, alert triage, operational reporting anddocumentation.
·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 frommissed checks.
Authority and boundaries
·Routine tasks follow documented procedures and Senior DBAoversight.
·Complex tuning, production recovery decisions, schema redesign andhigh-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