Staff Site Reliability Engineer, House Rx
Mar, 2023 - Present
John McCall
A lot of my work is just kintsugi on a computer
Background
About
About
Passionate, driven, and detail oriented when it comes to data and reliability engineering. Specializing in observability, scaling, and tuning complex systems with specialized data. Extra credit for positions at non-profits, B Corps, and companies that practice altruism. See Github profile for latest projects and contributions. I do not work with Oracle, SQL Server Reporting Services (SSRS), or SQL Server Integration Services (SSIS).
Work Experience
Work Experience
Senior Database Engineer, Collectors
Sep, 2022 - Mar, 20236 months
Senior Database Reliability Engineer, Flatiron Health
May, 2020 - Aug, 20222 years 3 months
Co-lead of AccessAbility ERG
Data Engineer, jet.com / Walmart eCommerce
Apr, 2019 - May, 20201 year 1 month
Application Database Administrator, JetBlue Airways
Jul, 2017 - Mar, 20191 year 8 months
Database Administrator, New Classrooms
Apr, 2015 - Aug, 20172 years 4 months
Database Administrator, Arup
Jul, 2014 - Apr, 20159 months
Technology Analyst / DBA, JPMorgan Chase
Jun, 2011 - Jul, 20143 years 1 month
Projects Experience
Projects Experience
Feb, 2023 - Present
😌 Share this site as your status, out of office email, or on social media when you take a self-care day to normalize and destigmatize mental health.
Apr, 2022 - Present
🥄 A cross-platform Ansible collection using PowerShell to configure and maintain SQL Server. Included in the official Ansible community collection.
Jan, 2018 - Present
🛠️ T-SQL scripts for the long haul: optimizing storage, on-the-fly documentation, and general administrative needs.
Feb, 2019 - Present
📚 Guides for getting the most out of the free SQL Server Express edition.
Skills
Skills
- Databases
SQL Server
Azure SQL
RDS
PostgreSQL
MongoDB
Sybase ASE
MySQL
- SQL
T-SQL
ANSI SQL
tSQLt
- Programming
Python
C#
Javascript
- Scripting
PowerShell
Powershell Core
SMO
- Devops / SRE
Azure
AWS
Jenkins
git
Ansible
Airflow
DataDog
New Relic
Terraform
YAML
GitHub
Education
Education
Information Technology w/ concentration in Databases, BS, Rochester Institute of Technology
Sep, 2008 - May, 2012
Certificates
Certificates
Analytics: Essential Tools and Methods Micromaster Certificate, Georgia Institute of Technology
Issued on: Aug 31, 2020
Exam 462: Administering Microsoft SQL Server 2012/2014 Databases, Microsoft
Issued on: Jul 31, 2015
Exam 461: Querying Microsoft SQL Server 2012/2014, Microsoft
Issued on: Jan 31, 2015
Volunteer Work
Volunteer Work
Contributor, dbatools
Sep, 2017 - Present
dbatools is a free PowerShell module with over 500 SQL Server best practice, administration, development and migration commands included.
Contributor, SQL Server First Responder Kit
Aug, 2019 - Present
sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.
Publications
Publications
How Flatiron employee initiatives are helping the planet—and the bottom line , Flatiron Health Blog
Published on: Jan 26, 2023
In March 2022, Flatiron held a climate change focused hackathon, and a group of employees set out to reduce energy usage by cleaning up Flatiron’s cloud computing infrastructure...
Interests
Interests
🌳 Moss art
🏃 Distance running
🆓 Open source software