City and County of San Francisco / District Attorney

Agency file

District Attorney

Source file: City and County of San Francisco — Employee Compensation / ingested Jun 17, 2026

The District Attorney handles legal functions of government — prosecution, legal advice, and representing the state in court.

In 2025, this agency had 360 employees with median total compensation of $198,316; the highest distinct record was $462,815.

Year: 2025
Total payroll: $74.3M
Employees: 360
Median total: $198,316
Highest record: $462,815

What the records show

Compensation analytics

These summaries compare pay within the agency before listing individual records.

Salary distribution

$1,550$384,493+

Hover a bar for its range; click to filter the list below.

How 2025 total compensation is spread across the 360 employees. Each bar is a pay range; taller bars mean more people earn in that range. The amber line marks the median ($198,316) — half earn less, half more. The far-right bar collects the highest earners.

Average pay composition

Base — $152,577 (74%)
Overtime — $1,025 (0%)
Other — $3,921 (2%)
Benefits — $48,833 (24%)

What an average paycheck here is made of — base salary versus overtime, other pay (bonuses, allowances), and benefits. A large overtime or other-pay share means take-home often exceeds base salary.

Pay percentiles

10th

25th

Median

75th

90th

$64,508

$141,244

$198,316

$279,481

$349,095

The pay ladder for this department. Someone at the 90th percentile earns $349,095 — more than 90% of the department; the 10th percentile earns $64,508. The shaded band is the middle half of employees (25th–75th percentile).

Largest job titles

Attorney (Civil/Criminal)

139 · $248,030

Legal Assistant

36 · $168,657

Victim/Witness Investigator 1

28 · $127,577

District Attorney Investigator (Sfers)

26 · $211,387

Victim/Witness Investigator 3

18 · $179,807

The most common job titles in this department by headcount, with the median total compensation for each. Click a title to see everyone who holds it.

Trend

Year over year

How this department's total payroll, headcount, and median pay changed across the 2 published years.

Year	Total payroll	Employees	Median pay
2024	$75.5M —	372 —	$199,339 —
2025	$74.3M ▼ 1.6%	360 ▼ 3.2%	$198,316 ▼ 0.5%

Compare

Similar departments

Departments elsewhere with the most similar mix of roles — a proxy for the same kind of agency, matched by workforce composition rather than name. Pay is not cost-of-living adjusted.

Office of Public Utility Counsel Texas60% match
Public Defender City and County of San Francisco60% match
Office of Administrative Law California57% match
District Attorney Allegheny County, Pennsylvania50% match
Public Defender Council, Georgia Georgia50% match
Attorney General's Office South Carolina47% match

Record list

Employees

Page 1

Adrianna Loomis

Public Service Aide-Admin/District Attorney

2025 total comp

$64,508

Sub-department: Public Service Aide
Organization group: Public Protection
Base pay: $52,032
Overtime: $0
Other pay: $0
Benefits: $12,476
Total compensation: $64,508
Employment type: Temporary Exempt
Union / bargaining unit: SEIU, Local 1021, Misc
Full-time equivalent (FTE): 0.96

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Job Code: 9914
Job Family Code: 9900
Organization Group Code: Public Protection
Other Benefits: $4,072
Retirement Contribution: $8,404

Adrianna Loomis works as a Public Service Aide-Admin for District Attorney within Public Service Aide. Their status is temporary exempt, 0.96 FTE. Adrianna earned $64,508 in 2025. Their bargaining unit is SEIU, Local 1021, Misc.

Katie Vasquez

Public Service Aide-Admin/District Attorney

2025 total comp

$63,928

Sub-department: Public Service Aide
Organization group: Public Protection
Base pay: $52,848
Overtime: $315
Other pay: $300
Benefits: $10,464
Total compensation: $63,928
Employment type: Temporary Exempt
Union / bargaining unit: SEIU, Local 1021, Misc
Full-time equivalent (FTE): 0.98

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Job Code: 9914
Job Family Code: 9900
Organization Group Code: Public Protection
Other Benefits: $4,179
Retirement Contribution: $6,285

At District Attorney, Katie Vasquez serves as a Public Service Aide-Admin within Public Service Aide. They work temporary exempt, 0.98 FTE. Their 2025 pay totaled $63,928. Their bargaining unit is SEIU, Local 1021, Misc.

Gerlanda Gelin

Victim/Witness Investigator 1/District Attorney

2024 total comp

$63,577

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $43,590
Overtime: $0
Other pay: $205
Benefits: $19,782
Total compensation: $63,577
Employment type: Permanent Exempt
Union / bargaining unit: SEIU, Local 1021, Misc
Full-time equivalent (FTE): 0.53

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $9,878
Job Code: 8129
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $3,064

Gerlanda Gelin works as a Victim/Witness Investigator 1 for District Attorney within Legal & Court. Their status is permanent exempt, 0.53 FTE. Gerlanda earned $63,577 in 2024. They are represented by SEIU, Local 1021, Misc.

Alex Bernstein

Attorney (Civil/Criminal)/District Attorney

2024 total comp

$62,654

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $39,227
Overtime: $0
Other pay: $10,477
Benefits: $12,950
Total compensation: $62,654
Employment type: Permanent Exempt
Union / bargaining unit: Municipal Attorneys Assoc
Full-time equivalent (FTE): 0.15

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $3,141
Job Code: 8177
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $3,847

Alex Bernstein works as a Attorney (Civil/Criminal) for District Attorney within Legal & Court. Their status is permanent exempt, 0.15 FTE. Alex earned $62,654 in 2024. They are represented by Municipal Attorneys Assoc.

Susana Ramirez

Victim/Witness Investigator 1/District Attorney

2025 total comp

$62,645

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $42,608
Overtime: $0
Other pay: $660
Benefits: $19,377
Total compensation: $62,645
Employment type: Permanent Exempt
Union / bargaining unit: SEIU, Local 1021, Misc
Full-time equivalent (FTE): 0.5

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $9,900
Job Code: 8129
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $3,187

Susana Ramirez holds the role of Victim/Witness Investigator 1 at District Attorney within Legal & Court. Their status is permanent exempt, 0.5 FTE. In 2025, their total compensation was $62,645. Union affiliation: SEIU, Local 1021, Misc.

Melissa Guzman

Public Service Aide-Admin/District Attorney

2024 total comp

$58,935

Sub-department: Public Service Aide
Organization group: Public Protection
Base pay: $36,591
Overtime: $0
Other pay: $2,018
Benefits: $20,326
Total compensation: $58,935
Employment type: Temporary Exempt
Union / bargaining unit: SEIU, Local 1021, Misc
Full-time equivalent (FTE): 0.7

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $13,050
Job Code: 9914
Job Family Code: 9900
Organization Group Code: Public Protection
Other Benefits: $3,018

Melissa Guzman works as a Public Service Aide-Admin for District Attorney within Public Service Aide. Their status is temporary exempt, 0.7 FTE. Melissa earned $58,935 in 2024. Union affiliation: SEIU, Local 1021, Misc.

Robert Guzman

Pr Distatty Invstgtor,Specunit/District Attorney

2025 total comp

$58,756

Sub-department: Management
Organization group: Public Protection
Base pay: $11,304
Overtime: $0
Other pay: $38,025
Benefits: $9,427
Total compensation: $58,756
Employment type: Permanent Exempt
Union / bargaining unit: Municipal Exec Assoc, Misc

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $1,783
Job Code: 8150
Job Family Code: 0900
Organization Group Code: Public Protection
Other Benefits: $774

Robert Guzman is a Pr Distatty Invstgtor,Specunit at District Attorney within Management. They work permanent exempt. 2025 total compensation came to $58,756. Union affiliation: Municipal Exec Assoc, Misc.

Jonathan Baez

Public Service Aide-Admin/District Attorney

2024 total comp

$56,916

Sub-department: Public Service Aide
Organization group: Public Protection
Base pay: $38,180
Overtime: $305
Other pay: $0
Benefits: $18,431
Total compensation: $56,916
Employment type: Temporary Exempt
Union / bargaining unit: SEIU, Local 1021, Misc
Full-time equivalent (FTE): 0.73

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $13,506
Job Code: 9914
Job Family Code: 9900
Organization Group Code: Public Protection
Other Benefits: $3,001

Jonathan Baez holds the role of Public Service Aide-Admin at District Attorney within Public Service Aide. Their status is temporary exempt, 0.73 FTE. In 2024, their total compensation was $56,916. Union affiliation: SEIU, Local 1021, Misc.

Cynthia Tran

Legal Assistant/District Attorney

2024 total comp

$55,801

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $37,536
Overtime: $0
Other pay: $3,324
Benefits: $14,942
Total compensation: $55,801
Employment type: Permanent Civil Service
Union / bargaining unit: Prof & Tech Eng, Local 21
Full-time equivalent (FTE): 0.33

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $5,919
Job Code: 8173
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $3,133

Cynthia Tran is a Legal Assistant at District Attorney within Legal & Court. They work permanent civil service, 0.33 FTE. 2024 total compensation came to $55,801. Their bargaining unit is Prof & Tech Eng, Local 21.

Ioana Tchoukleva

Attorney (Civil/Criminal)/District Attorney

2024 total comp

$55,370

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $14,429
Overtime: $0
Other pay: $33,340
Benefits: $7,600
Total compensation: $55,370
Employment type: Permanent Exempt
Union / bargaining unit: Municipal Attorneys Assoc

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $1,727
Job Code: 8177
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $3,680

Ioana Tchoukleva works as a Attorney (Civil/Criminal) for District Attorney within Legal & Court. Their status is permanent exempt. Ioana earned $55,370 in 2024. Union affiliation: Municipal Attorneys Assoc.

James Robbins

Attorney (Civil/Criminal)/District Attorney

2025 total comp

$53,739

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $42,949
Overtime: $0
Other pay: $0
Benefits: $10,791
Total compensation: $53,739
Employment type: Permanent Exempt
Union / bargaining unit: Municipal Attorneys Assoc
Full-time equivalent (FTE): 0.3

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $6,667
Job Code: 8177
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $3,297

James Robbins holds the role of Attorney (Civil/Criminal) at District Attorney within Legal & Court. Their status is permanent exempt, 0.3 FTE. In 2025, their total compensation was $53,739. They are represented by Municipal Attorneys Assoc.

Nasser Banihani

Attorney (Civil/Criminal)/District Attorney

2025 total comp

$53,735

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $42,949
Overtime: $0
Other pay: $0
Benefits: $10,786
Total compensation: $53,735
Employment type: Permanent Exempt
Union / bargaining unit: Municipal Attorneys Assoc
Full-time equivalent (FTE): 0.3

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $6,667
Job Code: 8177
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $3,293

Nasser Banihani is a Attorney (Civil/Criminal) at District Attorney within Legal & Court. They work permanent exempt, 0.3 FTE. 2025 total compensation came to $53,735. Their bargaining unit is Municipal Attorneys Assoc.

Olivia Sanchez

Attorney (Civil/Criminal)/District Attorney

2025 total comp

$53,724

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $42,949
Overtime: $0
Other pay: $0
Benefits: $10,775
Total compensation: $53,724
Employment type: Permanent Exempt
Union / bargaining unit: Municipal Attorneys Assoc
Full-time equivalent (FTE): 0.3

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $6,667
Job Code: 8177
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $3,282

At District Attorney, Olivia Sanchez serves as a Attorney (Civil/Criminal) within Legal & Court. They work permanent exempt, 0.3 FTE. Their 2025 pay totaled $53,724. They are represented by Municipal Attorneys Assoc.

Joshua Ng

Public Service Aide-Admin/District Attorney

2025 total comp

$53,386

Sub-department: Public Service Aide
Organization group: Public Protection
Base pay: $32,009
Overtime: $39
Other pay: $1,596
Benefits: $19,743
Total compensation: $53,386
Employment type: Temporary Exempt
Union / bargaining unit: SEIU, Local 1021, Misc
Full-time equivalent (FTE): 0.6

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $11,895
Job Code: 9914
Job Family Code: 9900
Organization Group Code: Public Protection
Other Benefits: $2,635

Joshua Ng is a Public Service Aide-Admin at District Attorney within Public Service Aide. They work temporary exempt, 0.6 FTE. 2025 total compensation came to $53,386. They are represented by SEIU, Local 1021, Misc.

Lindsey Hom

Attorney (Civil/Criminal)/District Attorney

2025 total comp

$53,089

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $42,419
Overtime: $0
Other pay: $0
Benefits: $10,670
Total compensation: $53,089
Employment type: Permanent Exempt
Union / bargaining unit: Municipal Attorneys Assoc
Full-time equivalent (FTE): 0.3

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $6,582
Job Code: 8177
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $3,261

At District Attorney, Lindsey Hom serves as a Attorney (Civil/Criminal) within Legal & Court. They work permanent exempt, 0.3 FTE. Their 2025 pay totaled $53,089. Their bargaining unit is Municipal Attorneys Assoc.

Aaron Duyan

Attorney (Civil/Criminal)/District Attorney

2025 total comp

$52,743

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $42,154
Overtime: $0
Other pay: $0
Benefits: $10,589
Total compensation: $52,743
Employment type: Permanent Exempt
Union / bargaining unit: Municipal Attorneys Assoc
Full-time equivalent (FTE): 0.3

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $6,540
Job Code: 8177
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $3,223

Aaron Duyan is a Attorney (Civil/Criminal) at District Attorney within Legal & Court. They work permanent exempt, 0.3 FTE. 2025 total compensation came to $52,743. Their bargaining unit is Municipal Attorneys Assoc.

Aareona Miles

Legal Assistant/District Attorney

2025 total comp

$52,479

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $37,348
Overtime: $700
Other pay: $0
Benefits: $14,431
Total compensation: $52,479
Employment type: Permanent Civil Service
Union / bargaining unit: Prof & Tech Eng, Local 21
Full-time equivalent (FTE): 0.31

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $6,070
Job Code: 8173
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $2,893

Aareona Miles works as a Legal Assistant for District Attorney within Legal & Court. Their status is permanent civil service, 0.31 FTE. Aareona earned $52,479 in 2025. Union affiliation: Prof & Tech Eng, Local 21.

Cynthia Farmer

Victim/Witness Investigator 3/District Attorney

2025 total comp

$52,331

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $48,681
Overtime: $0
Other pay: $0
Benefits: $3,650
Total compensation: $52,331
Employment type: Temporary Exempt
Union / bargaining unit: SEIU, Local 1021, Misc
Full-time equivalent (FTE): 0.4

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Job Code: 8133
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $3,650
Total Salary: $48,681

Cynthia Farmer holds the role of Victim/Witness Investigator 3 at District Attorney within Legal & Court. Their status is temporary exempt, 0.4 FTE. In 2025, their total compensation was $52,331. They are represented by SEIU, Local 1021, Misc.

Josiah Bournes

Attorney (Civil/Criminal)/District Attorney

2024 total comp

$52,079

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $12,413
Overtime: $0
Other pay: $33,100
Benefits: $6,566
Total compensation: $52,079
Employment type: Permanent Exempt
Union / bargaining unit: Municipal Attorneys Assoc

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $1,178
Job Code: 8177
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $3,502

Josiah Bournes holds the role of Attorney (Civil/Criminal) at District Attorney within Legal & Court. Their status is permanent exempt. In 2024, their total compensation was $52,079. Their bargaining unit is Municipal Attorneys Assoc.

Chris Mufarreh

District Attorney Investigator (Sfers)/District Attorney

2024 total comp

$51,232

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $15,000
Overtime: $0
Other pay: $32,971
Benefits: $3,261
Total compensation: $51,232
Employment type: Permanent Exempt
Union / bargaining unit: SFDA Investigators Assn

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $143
Job Code: 8550
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $691

Chris Mufarreh works as a District Attorney Investigator (Sfers) for District Attorney within Legal & Court. Their status is permanent exempt. Chris earned $51,232 in 2024. Union affiliation: SFDA Investigators Assn.

Colin Alexander

Attorney (Civil/Criminal)/District Attorney

2024 total comp

$51,092

Sub-department: Legal & Court
Organization group: Public Protection
Base pay: $31,408
Overtime: $0
Other pay: $9,125
Benefits: $10,560
Total compensation: $51,092
Employment type: Permanent Exempt
Union / bargaining unit: Municipal Attorneys Assoc
Full-time equivalent (FTE): 0.13

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $2,748
Job Code: 8177
Job Family Code: 8100
Organization Group Code: Public Protection
Other Benefits: $3,038

Colin Alexander works as a Attorney (Civil/Criminal) for District Attorney within Legal & Court. Their status is permanent exempt, 0.13 FTE. Colin earned $51,092 in 2024. They are represented by Municipal Attorneys Assoc.

Brian Conwell

Public Service Aide-Admin/District Attorney

2024 total comp

$49,626

Sub-department: Public Service Aide
Organization group: Public Protection
Base pay: $32,219
Overtime: $0
Other pay: $0
Benefits: $17,407
Total compensation: $49,626
Employment type: Temporary Exempt
Union / bargaining unit: SEIU, Local 1021, Misc
Full-time equivalent (FTE): 0.62

Source-specific fields

Data As Of: Jun 14, 2026
Data Loaded At: Jun 15, 2026
Department Code: DAT
Health and Dental Benefits: $11,505
Job Code: 9914
Job Family Code: 9900
Organization Group Code: Public Protection
Other Benefits: $2,526

Brian Conwell is a Public Service Aide-Admin at District Attorney within Public Service Aide. They work temporary exempt, 0.62 FTE. 2024 total compensation came to $49,626. They are represented by SEIU, Local 1021, Misc.