JuniorDatabase Administrator – Job Description
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 escalated 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.