Client Database Administrator

Job Overview

Company: Law office of Soo Park, PLC

Contact: Soonhyun Park, Law Office of Soo Park, PLC, 3055 Plymouth Road, Suite 104, Ann Arbor, MI 48105.

Date Posted: 23 January 2026

 

Responsibilities:

  • Design, implement, and maintain a centralized client and matter database for an immigration law practice; 
  • Create and manage tables for clients, matters, filings, deadlines, dependents, billing items, and documents, defining primary and foreign keys, constraints, and core indexes; 
  • Build operational SQL views and queries to power dashboards and reports covering upcoming filing deadlines and expirations, case tracking and aging, workload by attorney and paralegal, and retainer balance checks; 
  • Develop data entry standards and validation rules to improve data quality and reduce duplicates; 
  • Configure automated alerts and calendar feeds for critical dates and status changes; perform routine backups, restores, and basic performance tuning with change control and SOP documentation;
  • Implement role based access controls, audit logs, encryption, and data retention procedures to safeguard confidential client information and support legal hold requirements; 
  • Integrate the database with office productivity tools for email, calendar, and document storage to streamline intake, tasking, and document management.

Qualifications:

  • Bachelor’s degree or foreign equivalent in Information Systems, Computer Systems, or a closely related field.

 

Job Detail
  • Career LevelEntry Level
  • EducationBachelor's Degree
  • Job ClassDirect
Shortlist Never pay anyone for job application test or interview.