×
John McCall

John McCall

Sr. Database Reliability Engineer at Flatiron Health

Brooklyn, New York, US
English

Background


About

About

Passionate, driven, and detail oriented when it comes to data 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 legacy database environments top to bottom. See Github profile for latest projects and contributions.

Work Experience

Work Experience

  • Senior Database Reliability EngineerFlatiron Health

    May, 2020 - Present

  • Data Engineerjet.com / Walmart eCommerce

    Apr, 2019 - May, 20201 year 1 month

  • Application Database AdministratorJetBlue Airways

    Jul, 2017 - Mar, 20191 year 8 months

  • Database AdministratorNew Classrooms

    Apr, 2015 - Aug, 20172 years 4 months

  • Database AdministratorArup

    Jul, 2014 - Apr, 20159 months

  • Technology Analyst / DBAJPMorgan Chase

    Jun, 2011 - Jul, 20143 years 1 month

Projects Experience

Projects Experience

  • lowlydba/sqlserver

    Apr, 2022 - Present

    A cross-platform Ansible collection using PowerShell to configure and maintain SQL Server.

  • 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

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

Education

Education

  • Information Technology w/ concentration in Databases, BS, Rochester Institute of Technology

    Sep, 2008 - May, 2012

Certificates

Certificates

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.

  • Mentor, Minds Matter

    Sep, 2014 - Jun, 2017

    • Three year mentorship of a highschool student

Interests

Interests

  • 🌳 Moss art

  • 🏃 Distance running

  • 🆓 Open source software