(608) 555-0173 ◇ Madison, WI
anselm.bergqvist@example.com ◇ linkedin.com/in/anselm-bergqvist ◇ anselmbergqvist.com
Database administrator with 9 years running PostgreSQL and MySQL estates, currently 40 instances holding 28 TB for a platform with 900 business customers. Cut unplanned downtime from 14 hours a year to 40 minutes by rebuilding failover and rehearsing it quarterly, and reduced storage spend 31% through archiving. Restores get tested here, not assumed.
Coursework in Database Systems, Operating Systems, Networks, and Distributed Computing.
Also holds AWS Certified Solutions Architect Associate, earned in 2020 and kept current.
- Administer 40 PostgreSQL and MySQL instances holding 28 TB for a platform with 900 business customers.
- Cut unplanned downtime from 14 hours a year to 40 minutes by rebuilding failover and testing it quarterly.
- Reduced storage spend 31% by archiving 9 TB of cold data and reclaiming 6 over-provisioned instances.
- Managed 22 database instances and completed 3 major version upgrades with 0 data loss.
- Tuned 60 slow queries, taking the worst from 47 seconds to under 2 by reworking indexes and joins.
- Built the backup verification process that caught 4 silently failing backups in its first month.
- Monitored 15 instances and handled about 25 access and provisioning requests a week.
- Documented 30 recurring operational tasks into runbooks used by a team of 5.
- Automated nightly backup checks, replacing a 45-minute manual routine every morning.
Failover Rebuild. Rebuilt replication and failover across 12 critical databases and put a quarterly drill on the calendar. Unplanned downtime fell from 14 hours a year to 40 minutes, most of the gain coming from rehearsal rather than from new hardware.
Backup Verification. Built a process that restores a sample from every backup nightly and reports on it. It found 4 silently failing backups in the first month, all of which had been reporting success for months.
Storage Reclamation. Archived 9 TB of cold data and consolidated 6 over-provisioned instances after mapping actual access patterns across 40 databases. Storage spend fell 31% with no change to query performance.
- Attend a Madison PostgreSQL user group monthly, having presented twice on vacuum and bloat.
- Maintain 2 open-source database monitoring scripts with about 40 stars between them.
- Volunteer technical support for a nonprofit, maintaining 3 small databases on personal time.
- Serve as the on-call escalation point for a platform team of 24 engineers.
- Trained 6 application developers to read execution plans, cutting database tickets by 35%.
- Introduced the quarterly disaster recovery drill now run across all 40 production instances.

.webp)



.webp)


%20Which%20Should%20You%20Use.webp)