Scott Klasing Email & Phone Number

San Mateo, California, Us

Senior Database Engineer assisting Backblaze in designing, building, implementing Vitess / MySQL systems. Working on a 5 person Database team where we recently ansible built / deployed 6 Vitess 19.0.5 clusters to 6 private cloud data centers, soon adding a 6th. Percona 8.0.36. Revised the ansible to install 19.0.5 and then followed with ansible vitess upgrade backup playbook, upgrade Vitess to 20.0.1 playbook, as well as, Rollback upgrade playbook to assist next steps. Worked with SRE and documentation teams to harden respective runbooks, processes, procedures prior to going live. Continuing to rollout Vitess clusters for other applications.

Salt Lake City, Utah, Us

Lead Database Administrator chartered with designing and implementing SMULE's BC/DR Data Architecture. Phase 1 currently managing Vitess/MySQL sharded clusters and MySQL application sharded clusters on-premise synchronized with Google GCE cloud nodes. Phase 2 writes to the cloud will allow SMULE executives to fall back to on-premise infrastructure per microservice by reverse replication synchronization. Also responsible for managing and migrating existing Cassandra databases to Vitess/MySQL. On-premise uses CHEF provisioning while in cloud utilizes Terraform/Ansible provisioning. Databases are Vault managed encrypted. Currently using BASH scripting to provision Vitess clusters with unlimited shards / nodes either on-premise or identically in multiple clouds, currently on GCE nodes, Future phases will transition same to GKE.

Working as a Senior MySQL DBA/SME for the Database Services Branch U.S. Patent & Trademark Office, Department of Commerce. Managing, monitoring, addressing operational /performance issues regarding Percona based PXC clusters 5.7 and 8.x utilizing Proxysql 2.0.x, Haproxy 1.8.x, Cluster Control automation 8.x, Monyog, and various MySQL 5.7 and 8.x source / replicas (M/S), Ansible scripts, as well as, AWS RDS MySQL databases.

Kochava's systems capture mobile advertising traffic (impressions, clicks, installs, upgrades, and post events) world wide to assist advertisers in proper attribution of ad spend. Responsible for DEVOPS DATABASE on metal performance, provisioning, configuration, implementation and administration of the company's core revenue databases encompassing 39 extreme high volume master/slave pairs, using Maria DB MySQL 10.2.14 and Percona MySQL 5.6.x databases.* The multi-tenant 1/3 petabyte database architecture handles loads upwards of 600K QPS.* Alterations are rolled out across twenty thousand plus application schemas while live.* Wrote BASH scripts to alter tables directly, with or without copying data, or indirectly using pt-online-schema-change.* Responsible for DB performance / locking issues. * Responsible for live backups, delayed backups, and restorations.* Designed, implemented schemas, indexes, and performance queries. * Designed and coded PHP user interface and batch routines to scan all systems and ensure a customers application is no longer active prior to the drop,* Designed and coded PHP User Interface / Python parallel batch routines to migrate a specific customer application databases to other existing clusters. * Manage and maintain a custom written DB monitor that reflects the company's manner of doing business, in addition to Data Dog and Pager Duty.Responsible for provisioning and maintaining the same db architecture as 37 disaster recovery VM based cent-OS nodes in Google Cloud. Assisted in a Google Spanner PoC.Currently designing the core revenue databases to better horizontally scale in a Sharded Architecture POC. Technologies used: Ansible, Go, Python, PHP, BASH, Maria DB, & Percona MySQL, Ubuntu and CentOS in-house metal and GCLOUD VM based systems. Data Dog, Pager Duty, and custom PHP/Python monitoring. Signal 18 Relication Manager and MaxScale for HA, Proxy purpose. Spider/Vitess sharding under evaluation.

Developed mobile phone / tablet based software that integrates with legacy systems. Mobile applications developed to date utilize either a hybrid HTML5/CSS3 JavaScript PhoneGap architecture or a native Android Java application with SQLite3 database and Google Maps. Trained in MongoDB.

Armonk, New York, Ny, Us

For over thirteen years Scott worked on many long term IBM assignments as an Architect, Database Integration Lead, or Lead Designer / Developer. A description of many successful IBM assignments follow:Feb 2012 April 2013 (1 year 3 months)As lead developer directed remote development teams in Egypt and Russia. Agile rapid application development methods were used to quickly prove 27 architecture proof points resulting in project completion on-time within budgeted 7 months. Project progress was measured by pre-planned development iterations where the actual application was demonstrated as progressing weekly and allowing for continuous feedback. The team designed a Backup, Sync, and Share application to run initially on WIN7 / XP platforms with the ability to port to mobile phone and tablet architectures. Key technologies used were HTML5, CSS3, Java, PlayFramework, CouchDB, and Phone Gap, Casper, Tivoli CDP, and internal IBM cloud. Sept 2011 Jan 2012 (5 months)Lead an integration effort preparing the Solution Outline and Preliminary Detail Design for a Enterprise Service Bus (ESB) integration of a Retail Merchandising System and existing legacy systems. Jan 2007 Aug 2011 (4 years 8 months)As a Senior Application Factory Engineer participated in the design, development, testing, and multiple actual project implementations of IBM's Application Assembly Optimization (AAO); a Rational Team Concert "Software Factory work distribution" platform. Focus was on designing scalable work processes and specific work templates as configurable software, and assisting over one thousand (1000) IBM projects worldwide in the use of the work distribution platform. IBM work (2000-2006) continued in next job profile, see below

Armonk, New York, Ny, Us

This a continued job description for IBM employment 2000-2013 Jan 2003 Dec 2006 (4 years)As a Grid Architect designed and implemented grid application architectures for computational and data solutions. Highlight telecom project proved telephone event rating could be off-loaded from 64 way processors to commodity based 1, 2, and 4-way servers significantly improving TPS 2.5x and significantly lowering costs. In 2005 was promoted to Lead Grid Architect for the Americas. Sept 2001 Dec 2002 (1 year 4 months)Integration Architect responsible for designing, estimating, and proposing a message broker solution for a PeopleSoft Human Resource Personnel/Payroll system that consolidated 160 separate personnel / payroll systems using Oracle DB.Feb 2001 Aug 2001 (7 months)Integration Architect for IBM Adapter Factory that produced hub and spoke based message systems for Insurance clients. Mentored and developed road maps for 8 junior architects. Mar 2000 Jan 2001 (11 months)Technical lead for major automotive e-commerce site. Also served as emergency lead developer responsible for developing and implementing an independent set of business components (Vehicle Selection / Configuration). Automotive industry ratings of the web site improved from twenty-eighth place to number four within two months of going live. Challenges involved replacing two critical business components with COTS equivalents and rewriting the COTS UI with an advertising custom UI in the last three months of extremely tight ten month deadline.

Team Lead Developer / Performance Analyst for 2.5 year design, development, through implementation of an ObjectStar Database (O*) Insurance Claims Processing System for a major Insurance Carrier. Key responsibilities and challenges involved salvaging the fourth effort at rebuilding this core system. Upon hire, the team was immediately converted from waterfall methodology to using rapid application development, Agile-like methods. The team quickly proved to the client over the course of many live application demonstrations that the effort was progressing and on schedule.Also designed and developed critical key distributed system components, such as, distributed transaction logging / performance debug monitor, distributed cache manager for triggered CICS transactions, distributed audit trail for managing 75 plus transactions, and database locking mechanism to force poorly developed transactions to identify themselves early in an applications development life cycle.Also served one year through production implementation as a Lead Administrator, Developer Performance Analyst for a major hotel chain Frequent Traveler ObjectStar system. The client server Windows based O* application integrated to mainframe O* and legacy CICS / DB2 / VSAM based systems.

Specialized in ObjectStar's Database using Rapid Application Development, Agile-like methodologies. Taught all client / server and mainframe classes worldwide for Huron / Object Star technology. Subjects ranged from systems administration, application and database design, rules development to integrating with legacy systems. Also served as a Designer / Developer Implementation Consultant on multiple DB2 or IDMS integration implementations.

Designed and developed multiple third party IBM DB2 based products.

Led Product Development for Industry Leading mainframe DB2 tool – ProEdit. Also DB2 Performance Consultant.

Mainframe Database 2 (DB2) consultant for a major Rail Road client and Public Power Utility client assisting design and development of Project Engineering Management Systems to manage their 1000's of on-going projects to maintain railroad tracks and utility public power distributions systems. Designed the database structures for project bill of materials supporting BOM explosion / implosioncapabilities, as well as, wrote the application for viewing, maintaining, copying / pasting BOMrelationships, and performing project impact assessment.Developed and taught 8 DB2 Courses from programming, database design and administration, to systems and security administration. Assisted design and development of DB2 Product- ProAlter. Sold the training(1986) and consulting(1987) divisions to On-line Software, Intl.

Developed mainframe IDMS Network Database and IDMS/R applications for a multi-billion dollar major hospital corporation (Purchase Order / Inventory / Accounts Receivable Systems). Developed IDMS Database Credit / Retail management applications for a major credit card processing company.

Developed mainframe based COBOL IDMS Network Database / VSAM based systems for a major Oil and Gas company.

Master Of Business Administration, Graduate In Corporate And Personal Finance

Bachelors Of Science, Undergraduate In Finance, Minor In Economics