Worked on the coder/coder repository to optimize workspace agent lookup performance by introducing a targeted database index. Focused on improving the GetWorkspaceAgentByInstanceID query, the developer implemented a new index on the workspace_agents table using SQL, which reduced query execution time from over 230 milliseconds to under 0.05 milliseconds. The approach involved analyzing query plans, validating index usage through manual production and test queries, and confirming the shift from sequential scans to more efficient bitmap heap scans. Demonstrated expertise in SQL indexing, database optimization, and performance tuning, resulting in faster workspace provisioning and improved scalability under concurrent workloads.