рднреВрдорд┐рдХрд╛-рд╡рд┐рд╢рд┐рд╖реНрдЯ рдХреМрд╢рд▓

Database management and administration test for hiring

See how candidates reason through practical decisions that come up in day-to-day database work.

  • 10 рдорд┐рдирдЯ
  • 15 рд╕рд╡рд╛рд▓
  • рдордзреНрдпрдо рд╕реНрддрд░
  • рдмрд╣реБрд╡рд┐рдХрд▓реНрдкреАрдп
  • рдЕрдВрдЧреНрд░реЗрдЬрд╝реА рдореЗрдВ рдкреНрд░рд╢реНрди
  • рдлреЛрди рдФрд░ рдбреЗрд╕реНрдХрдЯреЙрдк

рдЫреЛрдЯрд╛ рдЬрд╡рд╛рдм

The Database Management and Administration test is an intermediate hiring assessment for DBAs, data platform and analytics engineers, and others who look after production databases or the data built on them. It uses short work scenarios to assess judgment in schema changes, recovery, query performance, security and integrity, and data warehousing.

рдпрд╣ рдХреНрдпрд╛ рдорд╛рдкрддрд╛ рд╣реИ

Practical judgment in schema design and change, availability and recovery, query performance, security and integrity, and data warehousing.

Design reviews and change

Candidates consider schema reviews and how to plan database changes.

Availability and recovery

Candidates consider how to keep data available and restorable.

Performance tuning

Candidates reason about tuning slow queries.

Security and integrity

Candidates consider how to protect data and keep it consistent.

Data warehousing

Candidates work through scenarios involving the operation of a data warehouse.

рдкреНрд░рд╢реНрдиреЛрдВ рдХреЗ рдлрд╝реЙрд░реНрдореИрдЯ

рдмрд╣реБрд╡рд┐рдХрд▓реНрдкреАрдп

рдЙрдореНрдореАрджрд╡рд╛рд░: рдПрдХ рдЫреЛрдЯреА рд╕реНрдерд┐рддрд┐, рддрд╛рд▓рд┐рдХрд╛ рдпрд╛ рдХрдерди рдкрдврд╝рдХрд░ рд╕рд╣реА рдЬрд╡рд╛рдм рдпрд╛ рд╕рднреА рд╕рд╣реА рдЬрд╡рд╛рдм рдЪреБрдирддрд╛ рд╣реИред

рдЖрдкрдХреЛ рджрд┐рдЦрддрд╛ рд╣реИ: рдХреНрдпрд╛ рдЙрдореНрдореАрджрд╡рд╛рд░ рд╕рд╛рдордЧреНрд░реА рдХреЛ рд╕рд┐рд░реНрдлрд╝ рдкрд╣рдЪрд╛рдирдиреЗ рдХреЗ рдмрдЬрд╛рдп, рдЙрд╕реЗ рд▓рд╛рдЧреВ рдХрд░рдиреЗ рдХреЗ рд▓рд┐рдП рдкрд░реНрдпрд╛рдкреНрдд рд░реВрдк рд╕реЗ рдЬрд╛рдирддрд╛ рд╣реИред

10 рдорд┐рдирдЯ рдореЗрдВ 15 рдкреНрд░рд╢реНрди, рдПрдХ-рдПрдХ рдХрд░рдХреЗ рджрд┐рдП рдЬрд╛рдПрдБрдЧреЗред

рдпрд╣ рдЯреЗрд╕реНрдЯ рдХрд┐рди рднреВрдорд┐рдХрд╛рдУрдВ рдХреЗ рд▓рд┐рдП рдЙрдкрдпреБрдХреНрдд рд╣реИ

People who look after production databases or the data built on them: DBAs, data platform and analytics engineers, backend developers who own their own schemas and migrations, and leads of database operations teams.

What this test can show

  1. Recovery judgment before an outage

    Availability and recovery scenarios show how a candidate keeps data restorable, evidence that a resume listing database products cannot give.

  2. Reading a query plan

    Questions built around small query plans show whether a candidate can find why a query is slow, without depending on one productтАЩs tools.

  3. Warehouse work alongside operations

    The same test covers running a data warehouse as well as production databases, useful when one hire looks after both.

рд╣рд░ рдЙрдореНрдореАрджрд╡рд╛рд░ рдХреЗ рд▓рд┐рдП рдЖрдкрдХреЛ рдХреНрдпрд╛ рдорд┐рд▓рддрд╛ рд╣реИ

рдЙрджрд╛рд╣рд░рдг рд░рд┐рдкреЛрд░реНрдЯ (рдХрд╛рд▓реНрдкрдирд┐рдХ рдбреЗрдЯрд╛)рдбреЗрдЯрд╛рдмреЗрд╕ рдореИрдиреЗрдЬрдореЗрдВрдЯ рдФрд░ рдПрдбрдорд┐рдирд┐рд╕реНрдЯреНрд░реЗрд╢рди
81%рдкрд░реНрд╕реЗрдВрдЯрд╛рдЗрд▓ 68ред рдмреЗрдВрдЪрдорд╛рд░реНрдХ: HireValid рдХреЗ рдЙрдореНрдореАрджрд╡рд╛рд░, n = 614
Design reviews and change71%
Availability and recovery90%
Performance tuning85%
Security and integrity88%
Data warehousing71%
Integrity ScoreрдЙрдЪреНрдЪ рднрд░реЛрд╕рд╛
  • рдкреВрд░реЗ рдЯреЗрд╕реНрдЯ рдХреЗ рджреМрд░рд╛рди рдЯреЗрд╕реНрдЯ рдЯреИрдм рдкрд░ рд░рд╣реЗ
  • рдЬрд╡рд╛рдм рдХреЙрдкреА-рдкреЗрд╕реНрдЯ рдирд╣реАрдВ рдХрд┐рдП рдЧрдП
  • рдПрдХ рд╕реНрдерд┐рд░ рдЧрддрд┐ рд╕реЗ рдЬрд╡рд╛рдм рджрд┐рдП

рд╕реНрдХреЛрд░, рдкреНрд░реЛрдлрд╝рд╛рдЗрд▓ рдФрд░ Integrity Score рдХреЗ рд╕рдВрдХреЗрдд рдЗрдВрдЯрд░рд╡реНрдпреВ рдХреЗ рд╕рд╛рде рдЖрдкрдХреА рд╕рдореАрдХреНрд╖рд╛ рдХреЗ рд▓рд┐рдП рд╕рдмреВрдд рд╣реИрдВ, рдЕрдкрдиреЗ-рдЖрдк рд▓рд┐рдпрд╛ рдЧрдпрд╛ рдирд┐рд░реНрдгрдп рдХрднреА рдирд╣реАрдВред

рдЗрд╕ рдЯреЗрд╕реНрдЯ рдХрд╛ рдореБрдлрд╝реНрдд рдореЗрдВ рдЗрд╕реНрддреЗрдорд╛рд▓ рдХрд░реЗрдВ

Test integrity signals

Each candidate receives a different set of questions from large pools. Question order changes between attempts, and answer options are shuffled. The browser shows one question at a time, while answer keys stay on HireValidтАЩs servers. Timing runs on the server, so reloading restores the same question with only the time left. Question text cannot be copied or selected. HireValid records signals such as time away from the test tab, pastes into answers, and answers submitted faster than a question can be read. These appear in an Integrity Score and evidence timeline for the employer to review; the system never decides on its own. With candidate consent, an employer can add random webcam photos. Learn more in How we build our tests.

Use the score as evidence

Review the score alongside a work sample and a structured interview; do not use it alone as a hiring decision or pass mark. A work sample can give you a chance to see how a candidate approaches a database task in context. The SQL Coding: Querying test offers a separate focus on querying. Compare the evidence with the jobтАЩs needs and the candidateтАЩs explanation of their choices.

Structured interview questions

  1. Tell me how you would review a proposed schema change before it is made.

    Listen for a clear process for reviewing the schema and planning the change, including how they explain the decisions they would make.

  2. A production database needs to be restored after an interruption. How would you approach the situation?

    Listen for practical reasoning about keeping data available and restorable, and how they would work through the situation.

  3. Walk me through how you would investigate a slow query using the information available to you.

    Listen for how they use query-related evidence, such as a query plan, to reason about performance.

рдирд┐рд╖реНрдкрдХреНрд╖рддрд╛ рдФрд░ рдЬрд╝рд░реВрд░реА рд╕реБрд╡рд┐рдзрд╛рдПрдБ

Questions are vendor-neutral and use standard SQL, so a candidate's experience with one particular product gives no advantage, and no question turns on product-specific syntax or menu names. Scenarios come from ordinary businesses such as stores, clinics, warehouses and booking services. They use plain US English, names from many backgrounds, no money symbols and no local knowledge, and every number needed is shown in the question.

рдЖрдк рдХрд┐рд╕реА рднреА рдЙрдореНрдореАрджрд╡рд╛рд░ рдХреЛ рд╕реБрд╡рд┐рдзрд╛ рдХреЗ рддреМрд░ рдкрд░ рдЕрддрд┐рд░рд┐рдХреНрдд рд╕рдордп рджреЗ рд╕рдХрддреЗ рд╣реИрдВред рдирддреАрдЬреЗ рдХрд┐рд╕реА рд╡реНрдпрдХреНрддрд┐ рджреНрд╡рд╛рд░рд╛ рд╕рдореАрдХреНрд╖рд╛ рдХреЗ рд▓рд┐рдП рд╕рдмреВрдд рд╣реИрдВ, рдХрднреА рднреА рдЕрдкрдиреЗ-рдЖрдк рд▓рд┐рдпрд╛ рдЧрдпрд╛ рдлрд╝реИрд╕рд▓рд╛ рдирд╣реАрдВред

Provisional: no norms exist yet. Reliability will be reported once 200 candidates have completed the test.

рд╣рдорд╛рд░рд╛ рдирд┐рд╖реНрдкрдХреНрд╖рддрд╛ рджреГрд╖реНрдЯрд┐рдХреЛрдг рдкрдврд╝реЗрдВ

рдЯреЗрд╕реНрдЯ рдХреА рдЬрд╛рдирдХрд╛рд░реА

A ten-minute check of the judgment that day-to-day database work calls for. It covers reviewing schemas and planning changes, keeping data available and restorable, tuning slow queries, protecting data and keeping it consistent, and running a data warehouse. Questions are short work scenarios built around small tables, query plans and SQL snippets, and they do not depend on any one database product.

  • рдкреНрд░рд╢реНрди English рдореЗрдВ рд╣реИрдВред
  • рдЕрдиреБрдордд рд╕рд╣рд╛рдпрдХ рд╕рд╛рдзрди: рд░рдлрд╝ рдкреЗрдкрд░ред
  • рд╣рд░ рд╕рд╡рд╛рд▓ рдХрд╛ рдЬрд╡рд╛рдм рдХреНрд░рдо рд╕реЗ рдПрдХ рд╣реА рдмрд╛рд░ рджрд┐рдпрд╛ рдЬрд╛рддрд╛ рд╣реИред рдкрд┐рдЫрд▓реЗ рд╕рд╡рд╛рд▓ рдкрд░ рд╡рд╛рдкрд╕ рдирд╣реАрдВ рдЬрд╛ рд╕рдХрддреЗред
  • рд╕рдордпрдмрджреНрдз рдЯреЗрд╕реНрдЯ рд╕реЗ рдкрд╣рд▓реЗ 4 рдЕрднреНрдпрд╛рд╕ рдкреНрд░рд╢реНрди, 4 рдорд┐рдирдЯред

рдЕрдХреНрд╕рд░ рдкреВрдЫреЗ рдЬрд╛рдиреЗ рд╡рд╛рд▓реЗ рд╕рд╡рд╛рд▓

How does the Database Management and Administration test handle different database products?+

The test is vendor-neutral and uses standard SQL. Questions do not depend on product-specific syntax or menu names, and the scenarios include small tables, query plans, and SQL snippets. If you also want to assess a specific product, see the separate [PostgreSQL test](/tests/software-skills/postgresql).

Who is the Database Management and Administration test designed for?+

It is an intermediate assessment for people who look after production databases or the data built on them: DBAs, data platform and analytics engineers, backend developers who own their schemas and migrations, and leads of database operations teams. Questions on planning schema changes and on running a data warehouse suit people who own migrations or analytics data as well as live systems.

What can candidates use during the Database Management and Administration test?+

Candidates may use scratch paper, and every number a scenario needs is shown in the question. The 15 questions are in English and answered once each, in order, with no going back, on a phone or a desktop. A separate practice set has 4 questions and takes 4 minutes.

What does the Database Management and Administration test's current reliability information mean?+

The test is provisional and has no norms yet. Reliability will be reported once 200 candidates have completed it. Treat a score as evidence to review with a work sample and structured interview, not as a standalone verdict.

рд╕рдВрдмрдВрдзрд┐рдд рдЯреЗрд╕реНрдЯ

рднреВрдорд┐рдХрд╛-рд╡рд┐рд╢рд┐рд╖реНрдЯ рдХреМрд╢рд▓

рдбреЗрдЯрд╛рдмреЗрд╕ рдбреЗрд╡рд▓рдкрдореЗрдВрдЯ

10 рдорд┐рдирдЯ, рднреВрдорд┐рдХрд╛-рд╡рд┐рд╢рд┐рд╖реНрдЯ рдХреМрд╢рд▓

рдЬрд╛рдиреЗрдВ
рдкреНрд░реЛрдЧреНрд░рд╛рдорд┐рдВрдЧ рд╕реНрдХрд┐рд▓реНрд╕

NoSQL рдбреЗрдЯрд╛рдмреЗрд╕

10 рдорд┐рдирдЯ, рдкреНрд░реЛрдЧреНрд░рд╛рдорд┐рдВрдЧ рд╕реНрдХрд┐рд▓реНрд╕

рдЬрд╛рдиреЗрдВ
рд╕реЙрдлреНрдЯрд╡реЗрдпрд░ рд╕реНрдХрд┐рд▓реНрд╕

PostgreSQL

10 рдорд┐рдирдЯ, рд╕реЙрдлреНрдЯрд╡реЗрдпрд░ рд╕реНрдХрд┐рд▓реНрд╕

рдЬрд╛рдиреЗрдВ
рд╕реЙрдлреНрдЯрд╡реЗрдпрд░ рд╕реНрдХрд┐рд▓реНрд╕

MongoDB

10 рдорд┐рдирдЯ, рд╕реЙрдлреНрдЯрд╡реЗрдпрд░ рд╕реНрдХрд┐рд▓реНрд╕

рдЬрд╛рдиреЗрдВ
рд╕реЙрдлреНрдЯрд╡реЗрдпрд░ рд╕реНрдХрд┐рд▓реНрд╕

Microsoft SQL Server

10 рдорд┐рдирдЯ, рд╕реЙрдлреНрдЯрд╡реЗрдпрд░ рд╕реНрдХрд┐рд▓реНрд╕

рдЬрд╛рдиреЗрдВ
рдкреНрд░реЛрдЧреНрд░рд╛рдорд┐рдВрдЧ рд╕реНрдХрд┐рд▓реНрд╕

MySQL

10 рдорд┐рдирдЯ, рдкреНрд░реЛрдЧреНрд░рд╛рдорд┐рдВрдЧ рд╕реНрдХрд┐рд▓реНрд╕

рдЬрд╛рдиреЗрдВ

рдЕрдкрдиреА рдЕрдЧрд▓реА рднрд░реНрддреА рдореЗрдВ рдбреЗрдЯрд╛рдмреЗрд╕ рдореИрдиреЗрдЬрдореЗрдВрдЯ рдФрд░ рдПрдбрдорд┐рдирд┐рд╕реНрдЯреНрд░реЗрд╢рди рдЯреЗрд╕реНрдЯ рдХрд╛ рдЗрд╕реНрддреЗрдорд╛рд▓ рдХрд░реЗрдВ

рд╣рд░ рдкреНрд▓рд╛рди рдореЗрдВ, Free рд╕рд╣рд┐рдд, рдЯреЗрд╕реНрдЯ рдХреА рдкреВрд░реА рд▓рд╛рдЗрдмреНрд░реЗрд░реА рд╢рд╛рдорд┐рд▓ рд╣реИред

рдЗрд╕ рдЯреЗрд╕реНрдЯ рдХрд╛ рдореБрдлрд╝реНрдд рдореЗрдВ рдЗрд╕реНрддреЗрдорд╛рд▓ рдХрд░реЗрдВFree рдкреНрд▓рд╛рдиред рдХреНрд░реЗрдбрд┐рдЯ рдХрд╛рд░реНрдб рдХреА рдЬрд╝рд░реВрд░рдд рдирд╣реАрдВред
Free рдкреНрд▓рд╛рдиред рдХреНрд░реЗрдбрд┐рдЯ рдХрд╛рд░реНрдб рдХреА рдЬрд╝рд░реВрд░рдд рдирд╣реАрдВредрдЗрд╕ рдЯреЗрд╕реНрдЯ рдХрд╛ рдореБрдлрд╝реНрдд рдореЗрдВ рдЗрд╕реНрддреЗрдорд╛рд▓ рдХрд░реЗрдВ

рд╕рдВрдкрд╛рджрдХреАрдп рдЯреАрдо рдХреЗ рдмрд╛рд░реЗ рдореЗрдВ

HireValid рдХреА editorial team рджреНрд╡рд╛рд░рд╛ рд▓рд┐рдЦрд╛ рдФрд░ fact-check рдХрд┐рдпрд╛ рдЧрдпрд╛ред рдЬрд╛рдБрдЪреЗ рдЧрдП рд╕реНрд░реЛрдд . рд╕рдВрдкрд╛рджрдХреАрдп рдиреАрддрд┐ рдкрдврд╝реЗрдВред