This is the section where round two of the screen actually happens, the closing gate before an
interview hits your inbox. A recruiter takes their time here, and even at that, the current
role still drives around 95% of the result.
That tracks: nothing proves what you can run in production today like the seat you sit in
right now. To earn a "yes", the section has to hit every entry on the
Database Admin role profile, one bullet per domain you named in Domain
Expertise above. Every bullet has to come off something you genuinely held in production,
never a ticket that landed on your queue.
1
Database Administration & Schema Design
You run databases the whole company can trust. Hiring managers read real DBA judgment behind it, not
"I run some SQL", so this is where a database admin proves out. Talk about how you used schema
design and an index strategy, across PostgreSQL and SQL Server, to keep the databases you managed
healthy under load.
Techniques
Schema design & review
Index strategy
Partitioning
User & role management
Tools
PostgreSQL 14 / 15 / 16
MySQL 8, MariaDB
SQL Server 2019 / 2022
Metrics
Databases under management
Data volume
Schema-change throughput
2
Query Performance & Tuning
You make slow databases fast. p95 latency is a number a hiring manager can check, so a real
before-and-after beats "optimized the database". Show them how you used EXPLAIN plan analysis
and index design, with pg_stat_statements and PMM, to cut p95 latency and shrink the slow-query count.
Techniques
EXPLAIN plan analysis
Index design
Statistics & vacuum
Query rewriting
Tools
pganalyze, pg_stat_statements
Percona PMM, slow query log
Datadog DBM, SolarWinds DPA
Metrics
p95 / p99 latency cut
CPU per query reduced
Slow-query count down
3
Replication, HA & Failover
You fail over cleanly when a node dies, with replication behind it. Failover that works only on paper is
the classic trap, so hiring managers want proof yours holds in a real drill. Point out how you used
streaming replication and automated failover, with Patroni and Orchestrator, to hold availability and
cut failover time.
Techniques
Streaming replication
Automated failover
Read-replica routing
Switchover drills
Tools
Patroni, repmgr, pg_auto_failover
MySQL Group Replication, Galera, Orchestrator
SQL Server Always On, MSSQL AGs
Metrics
Availability held (four 9s)
Failover time cut
Replica lag p99
4
Backup, Recovery & Disaster Recovery
You get the data back whatever happens. Data loss is the one mistake you can't walk back, so hiring
managers want restore drills, not just a backup job that says success. Mention how you used
point-in-time recovery and cross-region snapshots, with pgBackRest and WAL-G, to hold RPO and RTO and
keep restores reliable.
Techniques
RPO / RTO design
Point-in-time recovery
Cross-region snapshots
Restore drills
Tools
Barman, WAL-G, pgBackRest
MySQL Xtrabackup, mysqldump
SQL Server backups, RMAN
Metrics
RPO / RTO held
Restore success rate
Data volume under restore testing
5
Capacity Planning & Storage
You size storage and connections before they hit a wall. Two things ride on it for a hiring manager:
IOPS headroom before the busy season, and storage cost that doesn't creep. Walk them through how
you used connection pooling and capacity forecasting, with pgBouncer and gp3 storage, to hold the
connection ceiling and cut cost per GB.
Techniques
Storage sizing
Connection pooling
Tablespace planning
Workload forecasting
Tools
pgBouncer, ProxySQL, HAProxy
EBS, gp3 / io2, Aurora storage
NetApp, Pure, Dell PowerStore
Metrics
IOPS headroom
Connection ceiling held
Storage cost per GB cut
6
Database Security & Compliance
You lock the data down and pass the audit. Get security right and the business trusts you with its most
sensitive data, so a hiring manager reads it as real responsibility. Lay out how you used role-based
access and audit logging, with Vault and pgaudit, to pass audits and hold privileged-access reviews.
Techniques
Role-based access
TDE & TLS in transit
Audit logging
Data masking
Tools
Vault, AWS KMS, CMKs
pgaudit, MySQL Enterprise Audit, SQL Server Audit
Imperva, DataSunrise
Metrics
Audits passed
Privileged-access reviews held
Sensitive-field coverage
7
Migration & Upgrade Programs
You move a live database without users noticing. A clean cutover versus a painful outage is exactly what
a hiring manager is weighing here, so the downtime number matters. Spell out how you used online schema
change and logical-replication cutover, with gh-ost and AWS DMS, to hold the downtime budget and keep
the rollback rate low.
Techniques
Online schema change
Logical replication cutover
Blue-green database
Engine swap
Tools
pg_upgrade, pg_repack
gh-ost, pt-online-schema-change
AWS DMS, Cloud SQL DMS, Azure DMS
Metrics
Downtime budget held
Data migrated
Rollback rate
8
Monitoring, Tooling & Automation
You automate the routine: schema as code, migration CI. Companies keep the DBAs who automate the grind,
not the ones hand-running migrations at midnight, so hiring managers look for it. Tell them how you used
schema as code and migration CI, with Liquibase and Flyway, to ship more migrations while reclaiming
toil hours.
Techniques
Schema as code
Migration CI
Vacuum & reindex jobs
Runbook libraries
Tools
Liquibase, Flyway, Schemahero
Ansible, Terraform DB providers
Prometheus exporters, Grafana, PagerDuty
Metrics
Toil hours reclaimed
Migrations per week
Mean time to acknowledge