Recruiting database: how to build one you'll search first

What belongs in a recruiting database, how to tag and clean it, the record-keeping rule to know, and how to search it before you source from scratch

Written by Mihailo Bozic
Recruiting database: how to build one you'll search first

A recruiting database is the searchable record of every candidate you've met, with notes on skills, status, and when you last talked.

It matters because the people you already know can be the fastest route to a shortlist when a new opening lands. If you can't find them in seconds, you pay to source them again, and last year's runner-up ends up working for someone else.

Key takeaways

  • Store skills, seniority, location, source, last contact, outcome, and consent for every candidate.
  • Tag runners-up in their own pools so you can find them for the next similar opening.
  • Clean your records on a schedule and follow the retention rules that apply to you.
  • Search your own records first, then source externally to fill the gaps.

What a recruiting database is

A recruiting database is the central store of candidate records that you can search, filter, and return to across many openings. It can live inside your applicant tracking system (ATS), the software that moves applicants through each step of a hiring process. SHRM's HR technology overview lists collecting CVs and applications into a central database as a core ATS function.

It can also live in a candidate relationship management (CRM) tool, which is built for staying in touch with people before they ever apply. SHRM Online wrote in December 2021 that CRMs are used to collect, track, and nurture prospects such as potential job applicants. A recruitment CRM suits agency and independent recruiters who place the same kinds of people with several different clients.

Where records liveWho is in itBest use
ATSApplicants to your own openingsTracking people through a hiring process
Recruiting CRMProspects and past candidatesStaying in touch before an opening exists
Job board resume databaseAnyone who posted a resume thereFinding new names you've never met

The difference that matters most is ownership of context. A job board's resume database is shared with every recruiter who pays for access, so your competitors see the same people you do. A recruitment database you build yourself carries your own notes on fit, pay expectations, and timing.

What to store and how to tag it

Store enough on each person to answer one question fast: could this candidate fit the opening in front of me? These are the fields that make that answer possible:

  • Contact data: email, phone, and the channel the person prefers, so your next message reaches them on the first try.
  • Skills and seniority: the same skill words every time, such as payroll or forklift certified, plus a level like junior, mid, or senior.
  • Location and mobility: city, remote preference, willingness to relocate, and work authorization or visa status when the candidate has shared it.
  • Source: where you found the person, such as a referral, a job post, a career fair, or a past client search.
  • Last contact and outcome: the date you last spoke and how far they got, for example a final round or a declined offer.
  • Consent: whether the person agreed to be contacted later and to have their details kept on file.

Tags only work when everyone on the team uses the same words. Write a short tag list and keep it somewhere every recruiter can see it before they save a record. A nurse tagged "RN" by one recruiter and "registered nurse" by another won't show up in the same search, and that gap costs you a candidate.

Candidate database hygiene

A candidate database stays useful when you merge duplicates, refresh contact dates, and prune records nobody can act on. Merge records whenever the same person applies twice or arrives from two different sources. Keep the newest contact details and the full history of notes, so you don't lose context from an earlier process.

Runners-up deserve their own home in your records. SHRM Online advised in November 2024 that silver medalists, the finalists who didn't get the offer, be identified and tagged in talent pools built for runners-up. That way you can engage them for months or even years after the first search closes. Reaching out with a role that fixes what went wrong last time is how silver medalist candidates can turn into hires.

Put a "last verified" date on each record and recheck the contact details whenever you reach out. Grouping cleaned records into pools by role family is the core of talent pool management, and it keeps each search short and focused. Prune records with no working contact, no consent, or no fit with the roles you fill, but check retention rules first.

Keep the records you have to

You must keep certain employment records even when you'd rather clear them out of your system. EEOC regulations require employers to keep all personnel or employment records for one year. In-house recruiters should ask HR which candidate records their process creates.

Agency and independent recruiters should ask the client and their own counsel how the rule applies to the records they hold. Until you've confirmed what you must keep, archive a stale record instead of deleting it. Archiving keeps your search results clean without throwing away something you may need to produce later.

Search your recruiting database before you start sourcing

When a new opening comes in, search your own records before you spend time or money on new sourcing. Work through it in this order:

  • Turn the intake into tags: translate the hiring manager's or client's must-haves into the same skill, level, location, and work authorization tags you store.
  • Search pools first: start with runners-up and past finalists for similar roles, then widen to everyone tagged with the core skills.
  • Sort by last contact: reach out to the people with the most recent notes first, since their details and goals are fresher.
  • Log the source: record where every candidate who moves forward came from, so you can compare sources over time.

That last step tells you which parts of your database to search first next time. A talent acquisition director quoted by SHRM Online in June 2016 made this point about source quality. How far candidates from each source get might matter more than how many applicants a source provides.

Say your referral candidates reach final rounds while job board applicants stall at the phone screen. Then the referral pool is where your next search should start.

After that internal search, fill the gaps with outside sourcing. If you find too few people with the must-have skills, or nobody in the right location, those gaps become your sourcing brief. External channels, including resume search, now target only what your own records couldn't supply.

Find the gaps before you source

Book a demo

Check what's missing before you buy more data

Before you pay for another data source, check which openings your own records could have filled. Pull the last few roles you closed and look at where each hire came from. Then look for strong candidates who were sitting in your records but never surfaced in a search.

If those people were there but untagged, fix your tagging before you spend anything on new data. If your records were thin for a role family, such as warehouse supervisors or backend engineers, that's where outside data earns its cost. Then build the habit: search first, tag every new contact the same day, and clean one pool every week.

Add opt-in candidates to your search

Book a demo

Frequently asked questions

Is a spreadsheet good enough as a recruiting database?

A spreadsheet can work for a solo recruiter with a small list of candidates. It gets hard once you need shared tags, search across notes, and a history of every contact. Move to an ATS or CRM when people on your team start keeping their own copies of the list.

Who owns the candidates in an agency recruiter's database?

That depends on your contracts with clients and the consent you collected from candidates. Review your client agreements and your privacy notice with counsel, and record consent for every person you store.

Should I keep candidates who were rejected?

Yes, if they agreed to stay on file and the rejection was about fit for that one role. Tag the reason so you can tell which future roles might suit them better.

How do I get candidates to keep their details current?

Ask them to confirm their details every time you contact them, and send a brief check-in when there's no active role. A short note about their market gives them a reason to reply with a new email, phone number, or job change.

About the author

Mihailo Bozic
Mihailo Bozic

Founder & CEO @ Rotto

Founder & CEO of Rotto, building tools that help tech recruiters source better candidates, faster.

Related articles

Rotto

Built for recruiters who work from a brief, not a boolean.

rotto.com