Database Administrator resume example

• 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.
• 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.
• 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.
• Owned a database recovery drill using isolated backup restores, resolved missing transaction logs and completed SQL consistency checks before reopening the test service.
• Built replication monitoring using automation and replayed failures, reduced recovery verification from 70 to 30 minutes and published the tested runbook.

• Removed unused privileges and rotated 93 service credentials. Prevented the same exception from recurring in the next review.
• Investigated a discrepancy between a published metric and its source records, traced the transformation that changed the population, and corrected the calculation with a reproducible query.
• Compared the last successful data refresh with a failed run, separated missing source data from transformation errors, and reran only the affected interval. Kept the original query and corrected result together for review.

• Migrated 8 critical databases with replica cutover and rollback criteria
• 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.