About the 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.