David Isser

Profile

Devops and Database Engineer with 10 years experience in:

• Data Engineering
• DevOps
• Linux
• Python
• Cloud Infrastructure
• Containerization
• Kubernetes
• CI/CD

AWS Certifications: Systems Operations Associate, Cloud Practitioner

Experience: Ecommerce, Airline, Start-up, Non-Profit.

Work Experience

2020-Present

Senior Database/Devops Engineer at Recharge Payments (Los Angeles, CA)
* Built a build tools container running in linux that set up automated dynamic credentials for main apps * Upgraded all the suite of the MySQL databases to MySQL8 from MySQL5.7 * Led a project to establish data integrity for the data model and enabled the development teams to fix ongoing bugs * Build a python class to enable developers to build reports and have exports write to slack * Migrated all of the cronjobs running inside containers in VMs to k8s cronjobs using helm/skaffold in GCP
* Set up monitoring service in Signalfx to track slow queries and output logs to Splunk * Migrated 2 TBs in real time from one MySQL to another to horizontally scale monolith. * Wrote customized python integrated with haproxy and kubernetes with 0 downtime. * Migrated a new SMS application from Heroku into cloudsql in real time with 0 downtime. * Worked on a POC with vitess and their operator in kubernetes. Sharded a large table. * Created a slow query dashboard to analyze and aggregate slow queries and wrote a process to escalate bad queries to development * Wrote a helm chart for build buddy and set up an internal cache for coding against MYSQL * Wrote a PGHero helmchart that scales pghero in kubernetes to optimize bad queries in postgres database * Enabled Auto CI/CD for databases changes using liquibase and gitlab enabling 30 developers to have new DDL reviewed * Reduced all unplanned read replica outages by writing maxscale helm chart and deploying maxscale into kubernetes * Set up partitioning on multiple tables with scheduled kubernetes cronjob written in python to remove partitions greater than 90 days. * Wrote terraform that enforced dynamic application credentials and users/privileges with vault * Enabled all developers to log into database via vault database module and set up process for all oncoming databases * Wrote long running query daemon that analyzed long running queries and killed pids based on business logic criteria * Set up ephemeral postgres and mysql environments for all developers to test code and for unit tests to run on. * Fixed hundreds of problematic queries and supported 10+ development teams * Led the DR project for both MySQL and Postgres and set up replicas in AWS from GCP

2019-Present

Developer/Architect at Guidestar Attendance (Remote)

• Architected a python web application using flask for attendance and meal tracking for daycare systems.
• Designed a Postgres database schema using Alembic to manage schema migrations.
• Modified the application such that the database automatically shuts down during periods of inactivity without an outage, saving thousands every month.
• Quickly pivoted to add new features to aid the adoption of the system during a pandemic, and provide useful features to the clients to help them re-open.
• Efficiently reduced costs during closures to provide relief to closed daycares, reduced cloud spend from 85% a month without any outages or perceived loss of functionality.

2017-2020

Senior DevOps Engineer at Allegiant Air (Las Vegas, NV)

• Led team of engineers to migrate all of Allegiant microservices into containers using Openshift.
• Built out Terraform infrastructure that integrated with both AWS and VRA.
• Designed a Jenkins CI/CD pipeline that migrated all of the springboot applications off of bamboo.
• Built out many ansible roles and playbooks:
  • AD auth in AWS
  • Installing and configuring DB2, MySQL, MongoDB in AWS
    
  • Installing and configuring consul, traefik, springboot, rabbitmq
    
• Built out F5 VIPS, IRules, Pools, etc.
• Built Python application capable of integrating with git and creating automated Pull-Requests

2015-2017

Senior DBA at Allegiant Air (Las Vegas, NV)

• Managed thousands of databases by automating backups, replication, mirroring, installations, refreshes, and deployments
  
• Set up, built, and maintained customized flyway configuration system
• Wrote the data extract logic in T-SQL for the legality 117 application to ensure pilots could fly
  
• Architected several data models including new hotel data model, check-in data model, seat data model, web search data model

2014-2015

DBA at Caesars Entertainment (Las Vegas, NV)

• Primary responsibility was to write bteq and tpump scripts for TerraData and maintain legacy ETL/BI applications

2012-2014

Database Engineer at Wealth Engine (Bethesda, MD)

• Built several PL/SQL jobs in Oracle to do data mining of wealth information

• Designed ETL from several data sources to load ongoing data into new Exadata system

2010-2012

Consultant at IBM (Herndon, VA)

• Pfizer- developed data model to capture supply chain metrics for corporate leadership

2009-2010

Operations Research Analyst at Northrop Grumman (Fairfax, VA)

• Authored 10-page mathematical section on Kalman filters for government confidential study