Database
Administrator
Database performance, backups and integrity you can rely on — from $14/hr + GST.
What a Database Administrator does
Data is the business. A database administrator keeps it fast, backed up and intact — tuning performance, managing backups and safeguarding integrity.
Every StaffingSolutions.io database administrator is recruited, hired and managed by us — reference-checked for your tools, working your business hours, and backed by our zero-risk promise: no placement fee, money-back first week, and a free replacement if the fit isn't right.
What they handle
- Performance tuning — queries and indexes.
- Backups & recovery — tested.
- Integrity & security — enforced.
- Monitoring — health and capacity.
- Migrations — planned and run.
- Documentation — schemas and jobs.
A week in the role
Databases do not fail politely. This role is the maintenance and performance discipline behind them: backup and restore that has actually been tested, index and statistics upkeep, tuning against real execution plans, and the access controls deciding who can read what. Usually SQL Server, PostgreSQL or MySQL.
Reviews SQL Agent job history each morning — Ola Hallengren backup, DBCC CHECKDB integrity and IndexOptimize runs — and investigates any failure, long-running step, or job that silently skipped a database created since the maintenance configuration was last touched.
Restores production backups into a scratch instance on a set schedule, times the restore against the agreed recovery objectives, verifies the data landed intact, and records the result so recovery time is a measured figure rather than an estimate.
Pulls top waits and highest-cost statements from Query Store or pg_stat_statements, reads the actual execution plan for key lookups, scans and skewed row estimates, then proposes an index or rewrite with before-and-after timings for the developer to review.
Adjusts fragmentation thresholds and sampling rates so rebuilds do not flood the transaction log on databases sitting in an availability group or log shipping pair, and removes duplicate or never-read indexes identified from index usage statistics.
Watches synchronisation state, redo queue and send queue across AlwaysOn replicas or the replication distributor, investigates latency spikes back to their source, and confirms failover targets sit on the same patch build before any planned failover.
Tracks data and log file growth, tempdb contention and disk headroom per instance, pre-sizes files instead of letting autogrowth fragment them, and gives your infrastructure lead a storage forecast ahead of the budget cycle.
Audits logins, orphaned users left behind after a restore, and membership of sysadmin or db_owner, replaces individual object grants with role membership, and reports standing elevated access to your data owner to approve or revoke.
Reviews developer migration scripts for blocking operations, missing indexes on new foreign keys and non-sargable defaults, dry-runs them against a copy of production, and executes the deployment in the approved window with the rollback script ready.
Plans cumulative update and minor version upgrades, tests on non-production first, checks vendor support matrices for the applications sitting on top, and executes inside a maintenance window with a pre-patch backup and a verified rollback path.
Writes and schedules the extracts feeding Power BI datasets or downstream systems, tunes the underlying views, and keeps a record of every ad hoc query run against production so repeat requests become scheduled jobs instead of interruptions.
Captures deadlock graphs and blocked process reports through extended events, traces the offending transactions back to the calling application and code path, and hands the developer the isolation level or index change that removes the contention.
Refreshes development and test databases from production copies on request, applies the agreed masking or scrambling rules to personal, health and payment fields before handing the environment over, and documents exactly which datasets were obfuscated.