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.
Free tool / Resume tailor
Tailor your resume for this job
Paste your resume and get 3 to 8 of your own lines rewritten in the words this posting uses, with the reason for each change. The job is already filled in, and you don't need an account.
Job description provided by SRM Technologies.
View the original posting