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.