John N
Senior Database Administrator
Weinfelden, Thurgau, Switzerland
Summary
👤
SeniorJohn N is a Senior Database Administrator based in Weinfelden, Switzerland with over 10 years of hands-on experience managing MS SQL Server, Oracle, PostgreSQL and MySQL in mixed Windows and Linux environments. He currently leads database operations for the Canton Thurgau IT office, brings VMware, IIS and SharePoint administration skills, and serves on the enterprise architecture board while mentoring apprentices. His open-source contributions to the widely used BrentOzarULTD SQL Server First Responder Kit demonstrate practical expertise in performance tuning and in identifying maintenance-related bottlenecks such as shrink operations. A former team manager and longtime systems manager, he combines deep legacy systems knowledge (from VMS/Natural and Java era work) with current enterprise database best practices.
10 years of coding experience
26 years of employment as a software developer
English, German, French
Stackoverflow
159reputation
7kreached
4answers
0questions
Github Skills (16)
health-check10
microsoft-sql-server10
sql-server10
database-administration10
sql10
first-responder9
stater-kit9
responder9
starter-kit9
responders9
sp-blitz9
blitz7
windows6
windows-kernel6
oracle6
Programming languages (6)
Github contributions (5)
BrentOzarULTD/SQL-Server-First-Responder-Kit
May 2017 - May 2017
sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.
Role in this project:
Database Engineer / Database Administrator
Database Engineer / Database AdministratorContributions:9 commits, 1 PR, 8 comments in 15 days
Contributions summary:John's commits primarily involve modifications to `sp_Blitz.sql`, a script designed for SQL Server health checks and performance tuning. Their contributions focus on enhancing the script to prioritize maintenance plans and jobs related to shrink database operations. These changes appear to improve the accuracy of performance analysis and reporting related to database maintenance tasks, specifically identifying and highlighting potential performance bottlenecks linked to shrinking databases. The commits also include fixes to fully qualified object names (FQON).
health-checkssp-blitzsql-serverserver-scriptsmicrosoft-sql-server
JohnKNess/ETS2_Mods_zionid_Transmission
Feb 2016 - Jul 2020
Contributions:30 commits, 28 pushes, 4 branches in 4 years 5 months
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.