John Roos
Technical Specialist at Advania - Knowledge Factory
Stockholm, Stockholm County, Sweden
Summary
👤
Senior🎓
Top SchoolJohn Roos is a Technical Specialist based in Stockholm with 10 years of hands-on experience automating cloud and database operations using PowerShell, Azure, and Infrastructure-as-Code. He architects Azure Landing Zones and CI/CD pipelines while delivering rapid, production-ready solutions—often bridging solution architecture, test automation and team-facing tooling. A long history in BI, SQL Server and DevOps practices gives him deep operational insight, exemplified by contributions to the widely used dbatools project where he improved PowerShell↔SQL Server data type conversions. Comfortable working with outsourcing and international teams, he translates complex technical topics for both engineers and stakeholders. Known for a pragmatic, toolmaker mindset, he combines rapid delivery with careful handling of edge cases like TimeSpan and null-value conversions.
11 years of coding experience
9 years of employment as a software developer
Systemteknik, System technology, Systemteknik, System technology at StudiecentrumTyresö Gymnasium
English, Swedish
Stackoverflow
166reputation
26kreached
5answers
0questions
Github Skills (19)
mssqlserver10
databases10
database-administration10
sql-server10
mssql10
microsoft-sql-server10
powershell10
database10
datatypes9
server-migration9
database-migrations9
migration9
data-migration9
db-migration9
migrate9
Programming languages (4)
Github contributions (5)
dataplat/dbatools
Apr 2017 - Oct 2017
🚀 SQL Server automation and instance migrations have never been safer, faster or freer
Role in this project:
Database Engineer / Database Administrator
Database Engineer / Database AdministratorContributions:26 commits, 5 PRs, 7 comments in 6 months
Contributions summary:John primarily contributed to the `Out-DbaDataTable` and `Write-DbaDataTable` PowerShell functions within the `dbatools` repository, focusing on improving data type conversion and table creation for SQL Server interactions. They added support for special data types like `TimeSpan` and enhanced the conversion logic to prevent incorrect data types. The contributions included adding a hash table for PowerShell and SQL Server data type conversion and fixing issues related to null values and script properties to enhance accuracy and performance.
automationsql-serverpowershelldatabase-administrationmigrations
JohnRoos/PowerShell
Feb 2016 - Jan 2020
A collection of useful PowerShell modules and scripts.
Contributions:47 commits, 6 PRs, 52 pushes in 3 years 11 months
powershell-modulepowershelldsccmdletpowershell-modules
Find and Hire Top DevelopersWe’ve analyzed the programming source code of over 60 million software developers on GitHub and scored them by 50,000 skills. Sign-up on Prog,AI to search for software developers.