Jess Pomfret
Data Platform Engineer
Eastleigh, England, United Kingdom
Summary
🤩
Rockstar🎓
Top SchoolJess Pomfret is a Data Platform Engineer and Dual Microsoft MVP with nine years' experience designing, automating, and hardening SQL Server estates across finance and enterprise environments. Based in Eastleigh, UK, she specialises in PowerShell-driven automation, DSC, dbatools and dbachecks to deliver repeatable builds, migrations, backup validation and security hardening at scale. At Quilter she led audits, large migrations and certificate/service-account rotations for hundreds of servers, and her open-source contributions include test automation and improvements to prominent projects like SqlServerDsc, dbatools and dbachecks. She blends hands-on DBA skills with test-first automation and has a track record of introducing Pester-tested processes to guarantee reliability during high-risk operations. Outside work she balances engineering with a passion for proper football and fitness, reflecting a disciplined, team-oriented approach to solving complex platform problems.
9 years of coding experience
6 years of employment as a software developer
MBA, Management, MBA, Management at The University of Akron
Stackoverflow
146reputation
6kreached
5answers
0questions
Github Skills (23)
unit-testing10
pester10
validations10
tsql10
testing10
database-administration10
dsc10
validation10
sql-server10
automation10
backup10
powershell10
re-store10
automations10
test-automation10
Programming languages (13)
Github contributions (5)
dataplat/dbachecks
Jan 2018 - Nov 2022
✔ SQL Server Environmental Validation
Role in this project:
Database Engineer / Database Administrator
Database Engineer / Database AdministratorContributions:13 reviews, 72 commits, 49 PRs in 4 years 10 months
Contributions summary:Jess primarily contributed to database validation and configuration checks within the dbachecks repository, focused on SQL Server. Their work included fixing grammatical errors in existing tests, adding new tests for features like database mail profiles, and enhancing checks related to database compatibility levels, virtual log files, and backup verification. The user also addressed bugs, such as fixing an instance name issue in a network latency test. These changes indicate a focus on ensuring the reliability and proper configuration of SQL Server instances.
sql-serversqlserverpesterpowershelldba
dataplat/dbatools
Apr 2017 - Sep 2022
🚀 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:86 reviews, 304 commits, 183 PRs in 5 years 6 months
Contributions summary:Jess's contributions focused on enhancing the `dbatools` repository, a project centered around SQL Server automation. The commits added new functionality to the `Test-DbaLastBackup` function, specifically a `$CopyDestination` switch that facilitates copying and removing backup files to a destination server's default backup directory. Further development included modifications to `Get-DbaBackupHistory` and `Export-DbaCertificate` to enhance backup handling and certificate export capabilities, adding features such as handling multiple files and implementing various error handling techniques.
automationsql-serverpowershelldatabase-administrationmigrations
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.