Worked on the keycloak/keycloak repository to enhance group-based role management by delivering a targeted Direct Role Assignment Query within the GroupAdapter component. This involved overriding the hasDirectRole method to implement a more efficient query, reducing overhead when checking direct-role assignments for large groups. The approach improved authorization decision speed and aligned with ongoing improvements to the GroupAdapter. Leveraged Java and JPA for backend development and database management, demonstrating a focus on optimizing query performance. The work included end-to-end ownership from code changes through to issue closure, reflecting a methodical and results-driven approach to feature delivery within the project.