Team & Onboarding Best Practices
A condensed summary of the 25 most important team and onboarding practices for PostgreSQL 18.4 organizations - shared portable content; no solo prod DDL.
//
Search across all documentation pages
A condensed summary of the 25 most important team and onboarding practices for PostgreSQL 18.4 organizations - shared portable content; no solo prod DDL.
Assign database buddy day one: Same squad DBA or senior backend for two weeks minimum (Onboarding Basics).
Local Postgres 18.4 before shared environments: Docker compose matches production major.
psql fluency before GUI tools: \d+, \conninfo, ON_ERROR_STOP scripts.
EXPLAIN habit from first PR: No query review without (ANALYZE, BUFFERS) on staging evidence.
Read-only prod week two, not day one: Reduces accident risk; buddy on first five sessions.
No solo prod DDL first 90 days: Migrations merged with DBA reviewer; emergency paired.
CONTRIBUTING.md lists migration and on-call paths: Single source for escalations.
Shadow on-call before primary: At least two non-SEV1 shadows with debrief.
Pair first three ORM query PRs: Pairing on Query PRs prevents N+1 culture.
Skills matrix quarterly with evidence links: PRs, drills, post-mortems - not self-grade only (Skills Matrix).
App dev → DBA path documented: Phases prevent skipping HA before EXPLAIN depth (App Dev → DBA Path).
Office hours weekly for schema questions: Reduces Slack DMs and rogue DDL.
Database council for cross-team schema: Staff chair; ADR for shared table changes.
No hero migrations on Friday deploys: Change window policy in team agreement.
Incident post-mortem updates onboarding checklist: SEV1 becomes next hire's day-three reading.
Rotate review duty fairly: Spread migration review load across mids, not one DBA bottleneck.
Celebrate safe catches: Reviewer who blocked CONCURRENTLY miss gets recognition - builds culture.
Document who owns each schema: Service-to-schema map in repo; no orphan tables.
New hire runs incident bundle script in staging week one: Proves CLI scripts work.
Agent skills introduced week two with guardrails: Agent Skills Basics before free-form ChatGPT SQL.
Separate analytics onboarding path: Replica read-only; different EXPLAIN SLA than OLTP.
Offboarding removes database credentials same day: Role revoke audit in ticket.
Contractors get timeboxed write access: Expiry date on staging roles.
Hiring loop includes live EXPLAIN exercise: Matrix-aligned scorecard.
Annual team retrospective on database incidents: Trends drive training budget.
Often one senior database owner at 8-12 backend engineers; staff governance at multi-squad fleet. Matrix shows when to hire.
Same checklist; add recorded pairing sessions, async EXPLAIN review on PRs, explicit timezone for office hours.
Yes with review. They should not be sole approver or prod applier until matrix mid level.
Stack versions: This page was written for PostgreSQL 18.4 platform and application teams using Flyway and read-only prod access policies.
Reviewed by Chris St. John·Last updated Jul 16, 2026