Randstad Digital
Modernized Security Infrastructure
Senior SQL Server Database Architect, Administrator, and Lead Developer2022
Situation
Permission management across all environments was handled manually, creating risk of configuration drift, inconsistency, and human error during deployments and environment refreshes.
What I Did
Transformed manual permission management into a fully automated DevOps workflow. Built PowerShell scripts and JSON-based configuration files to manage global server permissions and drive all environment refresh operations from source-controlled definitions.
Result
Eliminated manual permission management, reduced deployment risk, and provided a reproducible, auditable process for all environment changes that could be run by any engineer on the team.
Tools & Tech
PowerShellDevOpsSQL Server