Database Administrator → Database Performance Engineer

A realistic transition from Database Administrator to Database Performance Engineer: transferable skills, the gaps to close, a step-by-step learning plan and alternative routes. Estimated skill overlap 21%. Difficulty: Medium.

Difficulty: Medium7 stepsDuration: 9 to 13 monthsOverlap: 21%

Transition from Database Administrator to Database Performance Engineer.

Transferable skills

  • Resource tuning

Skills to learn

  • Query optimisation
  • Indexing strategy
  • Execution plan analysis
  • Capacity planning
  • Wait statistics
  • Observability

Step-by-step learning plan

  1. 1. Build on your Database Administrator experience

    2–4 weeks

    Leverage

    • Resource tuning

    Map transferable skills — Resource tuning — against what a Database Performance Engineer needs.

  2. 2. Close the partial gaps toward Database Performance Engineer

    3–6 weeks

    Improve

    • Python / scripting

    Raise Python / scripting to the level a Database Performance Engineer relies on.

  3. 3. Learn the core of the Database Performance Engineer role

    6–10 weeks

    Learn

    • Query optimisation
    • Indexing strategy
    • Execution plan analysis

    Technologies

    EXPLAINpg_stat_statementsAWR

    Cover the biggest gaps first: Query optimisation, Indexing strategy, Execution plan analysis.

  4. 4. Master advanced Database Performance Engineer skills

    6–10 weeks

    Learn

    • Wait statistics
    • Capacity planning
    • Observability

    Technologies

    Query StoreDatadogGit

    Handle the advanced topics: Wait statistics, Capacity planning, Observability.

  5. 5. Get productive with the Database Performance Engineer toolchain

    4–8 weeks

    Technologies

    EXPLAINpg_stat_statementsAWRQuery StoreDatadogGitDockerKubernetes

    Be hands-on with EXPLAIN, pg_stat_statements, AWR and the rest of the target stack.

  6. 6. Practise Database Performance Engineer work in real conditions

    4–8 weeks

    Ship a portfolio project or take on Database Performance Engineer tasks at work.

  7. 7. Get certified and position yourself as a Database Performance Engineer

    4–8 weeks

    Technologies

    Oracle SQL Tuning ExpertMicrosoft Certified Database AdministratorPostgreSQL Professional

    Update your CV and LinkedIn around Database Performance Engineer, then apply to target roles.

Alternative routes