Skip to content

Yuqin Shan

Transportation/Database Administrator

2024 Salary — last year on the list

$152,238

Total compensation $152,474, including $236 in taxable benefits.

Source: Ontario’s Public Sector Salary Disclosure — names paid $100,000 or more that year. How we build this · Report an error on this page

At a Glance
2024

Employer Rank

#74

Transportation

Years on List

11

2014–2024

Peak Salary

$156,006

2021

Full 2024 roster at Transportation →·See where $152,238 ranks →

Total Compensation History

Total compensation by yearLine chart of 11 yearly values of total compensation, from $102,305 in 2014 to $152,474 in 2024.$100K$120K$140K$160K201420162018202020222024
Total compensation, 2014–2024. Axis starts at $100,000, the Sunshine List disclosure threshold.

Full History
2014–2024

$102,116 in 2014 is worth about $133,925 in 2025 dollars.

Full salary history, by year
YearPositionSalary
2024Database AdministratorTransportation$152,238Benefits $236Total $152,474
2023Database Administrator / Administratrice de bases de donnéesTransportation / Transports$131,978Benefits $225Total $132,203
2022Database AdministratorTransportation$149,384Benefits $222Total $149,606
2021Database AdministratorTransportation$156,006Benefits $219Total $156,225
2020Database AdministratorTransportation$114,337Benefits $215Total $114,552
2019Database AdministratorTransportation$108,373Benefits $217Total $108,590
2018Database AdministratorTransportation$108,122Benefits $232Total $108,354
2017Database Administrator / Administratrice de bases de donnéesTransportation / Transports$112,835Benefits $233Total $113,069
2016Database AdministratorTransportation$109,812Benefits $210Total $110,022
2015Database Administrator / Administratrice de bases de donnéesTransportation$100,747Benefits $195Total $100,941
2014Database Administrator / Administratrice de bases de donnéesTransportation$102,116Benefits $190Total $102,305

Take-Home Pay
(After Tax) · 2024 estimate

Take-home on Yuqin Shan's 2024 salary of $152,238 comes to roughly $104,567 once federal and Ontario income tax (about 28.0% effective) is deducted. At Transportation, 1,580 people made the 2024 list with a median salary of $118,464; Yuqin Shan's total compensation of $152,474 ranked #74. It is up about 15% on the $131,978 paid in 2023. Pension contributions — likely PSPP or OPTrust in the Government of Ontario – Ministries sector — would typically trim another 7–10% off that figure.

Estimated net pay
~$104,567
Effective income-tax rate (excl. CPP/EI)
~28.0%
CPP + EI contributions
~$5,105
All-in deduction rate (incl. CPP/EI)
~31.3%
vs. 2024 Database Administrator median
+24%

Where does $152,238 rank on the Sunshine List? →

Estimate only: 2024 federal and Ontario rates, basic personal amounts, Canada employment amount and CPP/EI credits; single, employment income only, salary treated as full-year income. Ignores pension contributions (OMERS, HOOPP, OTPP, OPTrust and similar plans lower actual take-home), union dues, RRSPs and benefits.

Also at Transportation
2024

View all 1,580 employees at Transportation (2024) →