New York, NY
Please consider this cover letter and resume, as I seek a full time salary or contract position in New York City that combines technical and business challenges. Below I detail 15+ years of working as an Open Source Architect, Data Systems Engineer and Back End Developer, with both large distributed teams and independently. While in those hands-on technology roles focused on technical systems, data and dev-ops infrastructure, and test-driven application development, my professional business responsibilities grew to include project management, agile sprint planning and resource allocation, plus strategic technical marketing initiatives for multiple industries. This has enabled me to perform many business-related technical tasks, such as the creation of statements of work, technical training, managing teams of engineers and agile developers, as well as coordinating cutting-edge technical initiatives regarding infrastructure, analytics and marketing initiatives with stakeholders, clients and vendors.
Prior to these emerging strategic business advantages around web and data services, I offer a proven track record in LAMP stack software development supporting environments including production, dev ops and data warehouse (ETL/BI) environments for large corporate networks, data centers and web services. I provided complete logical and physical technical database solutions around custom high-performance data clusters, implementing Linux, MySQL, Oracle, and Postgres. After being certified as an Oracle DBA early on, I am now a Certified MySQL DBA and Developer of nearly ten years. I have used PHP for back end web development since 2005, and since 2009 I have enjoyed deploying, managing and developing the Drupal CMS. Lately, I have implemented puppet and salt scripts for automated Linux host deployments. My next language will probably be python.
To summarize, I have filled the following technical positions:
1. Data Systems Engineer, Data Architect, DBA, Lead Developer, Technical Project Manager
2. LAMP Systems Engineering & Dev Ops / Scripting ( bash / git / php / mysql / drush / puppet ).
3. Drupal 7 Module Developer, Architect & Administration; PHP web app focus.
4. Technical Marketing Initiatives and Strategic Business Implementations
Please keep all preliminary correspondence to email. Thank you.
Thank you very much for your time and efforts.
My LinkedIn profile: http://www.linkedin.com/in/jjdonson/
FaceBook Techie Groups I Run:
Software Architect, Engineer, Developer, Trainer
July 2014 to Present
Technical project management. Sprint planning. Team training. Software development. Platform migration to newer isp, including migration to git/github.
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.
MySQL Database Architect, Engineer, Developer, Administrator
March 2014 to July 2014
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.
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.
Project Management • Data Systems Engineering • Database Development • Database Design and Administration • Database Migration •Software Development.
Hands-On Client Drupal CMS Architect + Internal IT Manager
October 2013 to February 2014
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.
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.
Technical Project Management • Enterprise Integration Architect • Business Analyst • Logical and Physical Data Architect • CMS Workflow Developer • LAMP Engineer
Director of Web and Data Services
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
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
December 2012 to February 2013
• Network, Systems and Application Architect
• Drupal 7 Migrations and Module Development
Web Services Engineer
December 2012 to January 2013
Drupal 6/7/8 roadmap planning and migrations.
Database, apache, php, git, Linux.
Drupal Developer & Architect / LAMP Engineer
August 2012 to October 2012
Custom application modeling, design and development.
Drupal Aegir, Drupal and Git enterprise integration.
Drupal Developer and Architect
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
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
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
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
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
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
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
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
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
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
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
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.
Unix and Oracle Enterprise Application Development in Database Analysis, Design, Development, DBA, Technical Documentation and Curriculum Design
January 2000 to January 2002
BS in Molecular Medicine & Biochemistry
January 1993 to January 1993
Pre-Med in Biochemistry & Molecular Genetics
January 1990 to January 1993
BA in Philosophy, Math and History of Science
January 1986 to January 1990
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.
Apple OS X Certified Admin
RedHat 6 Linux Systems Administrator
Oracle 8i Database Administrator
MySQL 5.x Database Administrator
OSS CMS Drupal Meetup
Interests: Team Web Dev, MySQL, Drupal, Jazz, Software, Education, Math, Biochemistry