Junior Database Administrator – Job Description
Perform routine database operations, health monitoring, scheduled maintenance and first-line database troubleshooting under Senior DBA technical direction.
· 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.
· 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.
· 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.
· 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.