Post a Job Sign in

Jeremy Donson

Software Architect, Data Engineer, IT & Tech Team Manager and Back End Web Developer

New York, NY

-

I seek full time on site roles in New York City that utilize my proven expertise as an OSS architect, 
data engineer, tech team manager and lead web developer.

Work Experience

LAMP and MEAN Software Architect

Adprime Media
-
New York, NY
-

October 2014 to February 2015

Responsibilities 
Supported puppet/salt automated deployments. Worked on back end support tickets on Drupal 6 site. Paved the way for migration to Drupal 7 with managers and dev team. Located in New York City's Downtown Financial District, Adprime Media is a rapidly growing leader in online healthcare and pharmaceutical marketing campaigns. 
 
Adprime Media's Health Marketing Exchange Network allows advertisers to optimally target publisher traffic with highly strategic web marketing campaigns. Sales, IT, Internal Web App and Web Developer requirements were escalating rapidly, and their technical staff needed to quickly grow.  
 
Accomplishments 
In addition to working through regularly scheduled support and developer requests, we standardized their LAMP and MEAN stacks and trained their development team to use git/github and also leverage database technologies. 
 
Skills Used 
I was hired as a short-term LAMP Engineer and Drupal Developer, and this contract extended further than we had planned. 
PHP MySQL git bash

Software Architect, Engineer, Developer, Trainer

The Economist Magazine
-
New York, NY
-

July 2014 to October 2014

Responsibilities 
Technical project management. Sprint planning. Team training. Software development. Platform migration to newer isp, including migration to git/github. 
 
Accomplishments 
Helped this enormous and high-profile web site with large distributed dev team move to git / github from bzr, including dev support and training. Supported puppet/salt automated deployments. Worked on back end support tickets on Drupal 6 site. Paved the way for migration to Drupal 7 with managers and dev team. 
 
Skills Used 
PHP 
MySQL 
git 
bzr 
bash 
Selenium 
Salt

MySQL Database Architect, Engineer, Developer, Administrator

Google / RightsFlow
-
New York, NY
-

March 2014 to July 2014

Responsibilities 
Every day I helped the development team learn to leverage MySQL for their core data services. We also used PHP and Python for web application development. The goal was to implement data solutions for the music rights division of Google Play. 
 
Accomplishments 
Complete MySQL fail over data center testing and support. All recoding required for MySQL instance upgrades from version 5.1.x to version 5.5.37. Additionally, all recoding required for MySQL instance upgrades to SQL_MODE='TRADITIONAL' and INNODB STRICT mode. 
This included many stored procedures, bash and python scripts. Percona and Common Schema dba tools used. All production changes were of no adverse impact to the business. 
 
Skills Used: 
Project Management • Data Systems Engineering • Database Development • Database Design and Administration • Database Migration •Software Development.

Hands-On Client Drupal CMS Architect + Internal IT Manager

Centric Digital, NYC
-
New York, NY
-

October 2013 to February 2014

Responsibilities 
Architected custom enterprise Drupal 7 Content Management System solutions for two giant non-profit organizations. Gathered all tech reqs from client Marketing, IT and Dev staff for federated sites from 6+ large sites in two nations. Working directly with clients, completed all technical deliverables for the first Statement of Work (SOW 1). Provided technical sales support and engineering for Open Source Software (OSS) Content Management System (CMS) platforms. CMS custom solutions include distributed event fundraising campaign workflows, with federated and local strategies for print, web, email, social networking, mobile messaging. Designed logical data models for federated governance of distributed campaign content. Created CMS-CRM technical enterprise integration project plans across heterogenous LAN/WAN network environments, including LAN and WAN monitoring tools. 
 
Accomplishments 
Proposed Second Statement of Work (SOW 2) with complete detailed technical project planning for highly distributed systems, software, engineers and developers. Provided detailed schematics with budgeted tasks to pave roadmap with open source hardware, software, and services. Supported custom Drupal 7 CMS theming template creation. Assembled required custom CMS features into build for proper choice of Drupal modules, themes and staff workflow tools. 
 
Made business case for OSS support/migrations/management and for integrated Dev Ops + Production LAMP stacks. Compared CMS platforms and hosting vendors with wide range of Marketing and IT criteria, including Gardner Group Study reviews. Proposed custom non-profit Drupal 7 distribution for CMS-CRM integration testing: OpenOutreach.org Additionally, as tech lead for Centric Digital's CTO, forged Centric Digital's first internal IT dept by providing all hardware and software support for Apple OS X systems and mobile devices, including Android. Trained and supported Centric Digital IT Manager in all aspects of Apple systems management. 
 
Skills Used: 
Technical Project Management • Enterprise Integration Architect • Business Analyst • Logical and Physical Data Architect • CMS Workflow Developer • LAMP Engineer

Director of Web and Data Services

LocalVox, Inc.
-
New York, NY
-

April 2013 to July 2013

• Data-driven local web marketing for rapidly-growing businesses 
• Complete software architecture and integration across environments.

Senior Systems Engineer / Drupal Architect / LAMP Engineer

CPX Interactive, Inc.
-
New York, NY
-

February 2013 to April 2013

• Cloudera Enterprise Manager Admin and Dev Training 
• Amazon, Puppet, Aegir, Drupal and Git enterprise integration.

Back End Drupal Developer and LAMP Web Systems Engineer

New Jersey Institute of Technology
-
Newark, NJ
-

December 2012 to February 2013

• Network, Systems and Application Architect 
• Drupal 7 Migrations and Module Development

Web Services Engineer

Columbia University Medical Center
-
New York, NY
-

December 2012 to January 2013

Drupal 6/7/8 roadmap planning and migrations. 
 
Database, apache, php, git, Linux.

Drupal Developer & Architect / LAMP Engineer

ThinkDrop Consulting
-
New York, NY
-

August 2012 to October 2012

Custom application modeling, design and development. 
Drupal Aegir, Drupal and Git enterprise integration.

Drupal Developer and Architect

American Media, Inc.
-
New York, NY
-

June 2012 to August 2012

Supporting migrations from Drupal 6 to Drupal 7. 
Architecting and developing several custom Drupal 6 and 7 modules for publishing.

Drupal Architect, DBA, LAMP Dev Ops Engineer

Penton Media
-
New York, NY
-

February 2012 to May 2012

Focus on scale-up of Data Center Operations MySQL. 
Regular OS/database deployment, testing, recovery and query tuning. 
Replication and network clustering. 
Migrating about 75 large sites to Drupal 7.x in ~6 months, sans adverse impact.
 
MySQL database migrations and custom platform integrations. 
Coordinating better change management policies.
 
Architect stored routines in Core Drupal 7 API to reduce PHP code complexity and improve performance. 
Support operations staff to ensure optimum system stability and performance.

Software Architect and Operations Engineer    

Wendr, Inc.
-
New York, NY
-

January 2012 to April 2012

-  Wendr is the iPhone Net App that helps you & friends plan what you are doing tonight. 
- MySQL Operations Data Center infrastructure design. 

- iPhone iOS 5 ObjC Application Architecture and Testing 
- LAMP Server REST OOP API Architect 

- Big Data Warehouse Analytics Engineering 

- Operations Stats, Thresholds and Notifications. 
- Systems Testing: Benchmarks and Load Tests 
- Network, Systems and Database Engineering

Database Systems Engineer & Data Warehouse Architect

Barnes & Noble, Inc.
-

January 2011 to October 2011

Clustered MySQL Engineer: Architected, deployed & migrated dozens of MySQL instances. Drupal-LAMP-Java Team Dev Ops Engineer: Testing logic & performance while promoting code thru git repos. Multi-Petabyte Data Warehouse Engineer/DBA: Aster nCluster & MicroStrategies data analytics. Search Engine Marketing & Optimization Project: Logical & physical data architect for semantic retail search analytics project.

Network MySQL DBA, PHP Dev, Data Warehouse Architect

adMarketplace, Inc
-

August 2010 to December 2010

All Network Data Operations, 24-7. 
PHP + Stored Procedures + SEO-SEM API. 
Provided all back-end network architecture & dev team support for online search keyword exchange. MySQL & R Stats Data Warehouse Automation: InfoBright + R.

MySQL Replication DBA, Software Architect, Project Manager

Yahoo, Inc and RightMedia, Inc
-

February 2010 to July 2010

Advanced Drupal 6.x & PHP 5.x Team Dev Web App API Integration. MySQL 5.1 / 5.5 Upgrades; Advanced Stored Procedure Dev and Tuning. Designed benchmarks for massive scaling of network grid data operations. Supported Drupal and LAMP apps for many dev teams, including several software localization and internationalization teams.

Senior Network Database Admin & LAMP Developer

Athena Capital Research LLC
-

January 2009 to February 2010

Network Database Engineering for Multi-Petabyte Financial Service Trading Systems. Trading Systems Data API Architecture & Performance Monitoring Tools. C++/Ruby Dev Team Code Testing & Back End Renovation Sans Production Impact.

Senior Database Administrator & PHP Developer

Hearst Digital Media
-

February 2008 to September 2008

Supported 20+ instances of MySQL 24/7 using InnoDB & Replication, including code testing & change management. All performance tuning and network failover solutions designed for maximum performance, uptime and fast recovery. Built PHP Web Monitoring & InnoDB Stats Tracking Tools. Architected MySQL Data Warehouse for Weekly Analytical Demographics & Statistics Reports

Drupal Architect, Developer, LAMP Engineer

Rodale Publishing
-

April 2007 to January 2008

Giant magazine publisher with no LAMP Experience decides to bring Drupal 6.x in-house. With team of Drupal developers, provided complete migration support from legacy proprietary CMS to LAMP stack. Complete Oracle 10i => MySQL 5.0 Migration Engineering, Features Integration and Testing. Coordinated with Rodale LAN Unix and Java dev teams to bring Drupal / LAMP stack in-house. Taught existing Oracle DBA’s how to manage and troubleshoot network MySQL 24/7.

K-12 Test Prep Trainer & Coach / Math Teacher

Stanley Kaplan, Inc. & NYC Public Unified School System
-

September 2004 to March 2007

Trained principals and faculty across NYC to engage kids in learning K-12 test prep strategies. Built Open Source MySQL statistical data warehouses from raw NY State exam and student performance data.

Network Media, Pub & Tel Test Lab Manager / Engineer / Developer

Miller Freeman
-

June 2002 to September 2004

Designed and managed test laboratory focused on cutting-edge network media, publishing and telephony technology. Engineered all systems testing to improve trade shows, corp infrastructure and tech mag review writers. Coordinated promo vendor tools / frameworks for system load testing, application profiling and benchmarking. Wrote many published articles on network server throughput and parallelization of database server threads.

Morgan / Chase Oracle Warehouse Architect, Analytics Developer & Admin

CitiBank, Inc
-

December 1999 to June 2002

Hired by Marketing Department at CitiBank, Inc. to write SAS auditing scripts to rapidly verify daily Acxiom, Inc. data processing services vendor. After just three months, I was tasked by CitiBank management to migrate all historical data from vendor archives into new in-house Custom Time Series Data Warehouse. This represented about ten years (2 Petabytes) of credit card demographics and financial banking data. 
 
Within about six months, the following tasks were achieved: 
 
Validated all raw archived data in place during evening vendor maintenance windows. 
 
Devised flexible logical models and performant physical models to support ongoing time-series analytics. 
 
Set up a RedHat Linux Data Warehouse system with massively parallelized disk io, running Oracle 9i. 
 
Migrated all raw historical data to dedicated local Linux / Oracle Data Warehouse system. 
 
Developed PL/SQL Time-Series Warehouse REST API + Aggregation Schemes + CSV Export + Browser Tools. 
 
Validated Logical and Performance Requirements to the Satisfaction of Bank Management and Vendor. 
 
Automated daily data migrations, plus all daily, weekly/monthly/quarterly Data Warehouse Analytics reports. 
 
Trained many developers to create consistent and performant tools to leverage historical trends. Trained IT department staff to manage data warehouse validations, loads and scripts. 
 
Next I was sent to JP Morgan / Chase Manhattan Bank, another local Acxiom client, where I basically implemented the same in-house solutions listed above in their Data Processing department. These successful experiences using RedHat Linux for enterprise data process was my first step towards open source platforms and API’s.

Education

Unix and Oracle Enterprise Application Development in Database Analysis, Design, Development, DBA, Technical Documentation and Curriculum Design

Columbia University in the City of New York

January 2000 to January 2002

BS in Molecular Medicine & Biochemistry

University of California, San Francisco - School of Medicine

January 1993 to January 1993

Pre-Med in Biochemistry & Molecular Genetics

University of San Francisco

January 1990 to January 1993

BA in Philosophy, Math and History of Science

Sarah Lawrence College

January 1986 to January 1990

Skills

Drupal, MySQL DBA, Data Warehouse Architecture, Social Networking, Logical Data Modeling, php, PHP Frameworks, Performance Testing, Unit Testing, User Acceptance Testing, Software Project Management, Technical Illustration, Technical Writing, Business Intelligence, Data Analysis, Technical Documentation, bash, oracle, MySQL database design, API, REST, SQLite, SQL, ERD, LAMP, Git, Database Analysis, Test-Driven Agile team LAMP development, integration and API architecture., Project management, prototyping and requirement specifications, roadmaps, code testing and promotion, server architecture, performance scaling, automated network operations and git repository management.

Certifications

Apple OS X Certified Admin

RedHat 6 Linux Systems Administrator

Oracle 8i Database Administrator

MySQL 5.x Database Administrator

Groups

NYLUG.org

OSS CMS Drupal Meetup

Additional Information

Interests: Team Web Dev, MySQL, Drupal, Jazz, Software, Education, Math, Biochemistry