Resume : John McCall

Background

About

Passionate, driven, and detail oriented when it comes to data and reliability engineering. I have a genuine curiosity in the efficiency and utilization of aggregate of data to bring value to a wide gamut of business, political, and social causes when properly leveraged. Specializing in modernizing, scaling, and tuning complex data systems. See Github profile for latest projects and contributions. I do not work with Oracle or SQL Server Reporting Services.

Work Experience

Senior Database Engineer, Collectors
Sep, 2022 - Present
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

lowlydba/sqlserver
Apr, 2022 - Present
🥄 A cross-platform Ansible collection using PowerShell to configure and maintain SQL Server. Included in the official Ansible community collection.
TSQLLint Action
Sep, 2022 - Present
✅ Github Action to run TSQLLint.
DBA MultiTool
Jan, 2018 - Present
🛠️ T-SQL scripts for the long haul: optimizing storage, on-the-fly documentation, and general administrative needs.
expressdb.io
Feb, 2019 - Present
📚 Guides for getting the most out of the free SQL Server Express edition.

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

Information Technology w/ concentration in Databases, BS, Rochester Institute of Technology
Sep, 2008 - May, 2012

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

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.
Mentor, Minds Matter
Sep, 2014 - Jun, 2017
- Three year mentorship of a highschool student

Interests

🌳 Moss art
🏃 Distance running
🆓 Open source software

John McCall

A lot of my work is just kintsugi on a computer