Select Website 

Recruitment Directory's Blog - Australia's #1 Recruitment Technology Blog!

Back to Menu Back to Menu

Are you adding value to your database? Effective database management tips

Posted By: Thomas Shaw, 10:30am Tuesday 28 July 2009    Print Article

Every recruitment agency has some sort of database to store candidate/client contact information, notes, conversations, jobs, resumes, files, invoices etc. A properly designed and well maintained database can help improve internal efficiencies, provide accurate data, cut costs and speed up the recruitment lifecycle.

Managing and maintaining confidential data is not only good business practice - it's a legal requirement! Here are some of my top tips to manage and maintain your database.
  • Appoint an internal user to champion and implement correct database management processes.
  • Enforce and maintain proper user access. Regularly conduct data access audits to ensure users are not accessing data they are not supposed to. Never allow users the ability to delete records or access unauthorised data.
  • What kind of information are you collecting? Is it necessary, valuable, important or legal?
  • Ensure that everyone in the organisation (including external stakeholders) are educated in the importance of maintaining good-quality data. Hold regular review meetings to ensure that your data quality processes are up to date, efficient and effective, and remain so.
  • Are you correctly capturing, inserting and validating data? Depending on the system, it may be possible to enforce rules on the type of data entered eg. length & type of data (letters, numbers & special characters).
  • Before adding a new contact into the database, check to see they are not already on the database. This may sound like common sense, but unfortunately there is not always a "unique" contact identifier - users can have more than one email address, and can be known by variations of their full name. If you create duplicate records, ensure that they are merged as soon as possible.
  • Files should always be stored as read only. You do not want a user to accidently overwrite someone’s resume!
  • Measure data quality. No matter how good the systems and processes you put in place to capture data across all touch points, it is essential that you have a way of measuring the quality of the data over time.
  • Never delete data! Deactivate (or hide) the record and record a file note. You never know if you need it in the future.
  • Review potential threats (internal/external) to information stored in databases. How secure is your database?
  • Regularly repair, optimize and backup your database.
  • Create a disaster management plan. You never know if something may happen.



Article URL: http://www.recruitmentdirectory.com.au/Blog/are-you-adding-value-to-your-database-effective-database-management-tips-a237.html

Article Tags: database candidate database database management recruitment database data integrity data capture data validation data quality information management information systems tips

Comments Hide Comments (0)

Feel free to join in on the conversation. All comments are moderated before publishing. Comments posted by subscribers don't necessarily reflect the views of Recruitment Directory.

Your Name: * Required
Your Email Address: * Required
Website URL:
Comments: * Required
Refresh
Enter the code you see in the image above (case sensitive). Click on the image to refresh it.
 


Back to Menu Back to Menu



Random Blog Articles

OWASP Top 10 and your Recruitment Website - Part 2
Published: 4:37pm Thursday 09 December 2010

Facebook Advertising - Part 2
Published: 1:58pm Saturday 03 January 2009

How cybermule jobs work
Published: 2:08pm Sunday 25 April 2010

RCSA needs your help
Published: 11:17pm Sunday 31 May 2009

RCSA releases Quarterly Research report Nov 2008
Published: 12:11am Tuesday 25 November 2008