Internship Database Administrator resume example

• Under supervision, examined query plans and lock waits before changing an index, measured write overhead after the change, and restored a backup into an isolated database to verify recoverability.
• The team tuned indexes, vacuum settings, and query plans for the top 20 workload consumers; I supported research preparation, validation, and documentation under mentor review. The team removed recurring manual work from the operating flow; confirmed with my mentor that my contribution was limited to the assigned support and validation work.
• The team implemented point-in-time recovery checks and quarterly restore drills for 12 clusters; I supported research preparation, validation, and documentation under mentor review. The team reduced repeat incidents from the same failure mode; confirmed with my mentor that my contribution was limited to the assigned support and validation work.
• Under supervision, owned a database recovery drill using isolated backup restores, resolved missing transaction logs and completed SQL consistency checks before reopening the test service.
• Under supervision, built replication monitoring using automation and replayed failures, reduced recovery verification from 70 to 30 minutes and published the tested runbook.

• In a mentor-reviewed simulation, tested database backup and recovery against a stated recovery point, restoring full and transaction-log backups into an isolated environment and reconciling row counts before sign-off.
• As a second supervised exercise, performed performance tuning using execution plans and lock waits, then added replication-lag automation that paused a cutover when the replica had not caught up.
• Under supervision, the team migrated 8 critical databases with replica cutover and rollback criteria; I supported research preparation, validation, and documentation under mentor review
• Generated synthetic source records with duplicates, late arrivals and corrected values; wrote assertions for row counts and key uniqueness, and recorded the expected effect of each case on the reported metric.
• Compared the analytical output with a manually calculated reference table, traced differences to a transformation step, and retained a data dictionary and rerun instructions alongside the corrected query.
• Owned the synthetic-data validation using a manually calculated reference, resolved duplicate-key inflation and completed a notebook that reproduces the corrected totals.

Relevant coursework: Algorithms, operating systems, databases, computer networks

Query plan analysis · Index tuning · Lock analysis · Backup restoration

• Published an independent methods note using reproducible queries, explaining the data grain, excluded records and sensitivity of the result to a changed denominator.