Lead Database Architect
Resume:
Dr. John Trumbul Jr. Austin, TX **@***********.*** 479-***-**** Page 1 of 4
John Trumbul Jr.
MCSE, MCITP, MCM SQL Server
Lead Database Architect
Contact:
**@***********.***
Austin, TX
Objectives:
My job is end-to-end database solutions. Including but not limited to: database architecture / processes: The ability to see through architecture, development, scalability, and performance tuning of high volume OLTP/OLAP databases & data warehouses with a “Big Data” foundation (800GB - 1TB+) ensuring database availability 24/7. Creating processes for mission critical database systems such as: Backup / Restore, Machine, Server, Instance, and Database level monitoring to be proactive in foreseeing issues with these systems, and deploying processes to prevent them from becoming issues. Documentation for the overall good of the company including onboarding new members of the database group, and providing the leadership and mentoring they need to hit the ground running and exceed expectations.
Data Availability: Consuming, processing and reporting on data regardless of source, and making it available for analytics, decision making, sophisticated reporting, ensuring the data delivery ahead of time with complete accuracy; above all, making it fast and eliminating fluff. With over 17 years dedicated specifically to the database field, designing and implementing database systems for some of the largest data sets in every industry (Large Retail: Wal-Mart, Clorox, Universal Studios, Government: Army, FEMA, DoHD, Casino / Gaming : MGM, Stations, Borgata) data models, ETL processes, data warehouses, systems architectures, relational databases, with a constant concern for efficiency as a certified Database Administrator, I enjoy putting all this experience together to design, develop, and deploy infinitely scalable database solutions.
Experience:
Lead Database Architect
Trailstone Group LLC Austin, TX
August 2016 – Present
Summary: Responsible for all database platform development supporting the end to end profit and loss system for a multibillion dollar hedge fund. Automated process flow and moved it on to next generation technologies using SQL 2016 with “poly-base” technology to offload cold data, and query processing to cloud based servers. Minimized traffic across the web ensuring traders get accurate data in real-time before their trading day starts, with ample time for analysis. Designed and Developed “DataSmart” a platform used by our traders to perform point in time analytics, predictive analysis, and time series analysis to provide key decision-making metrics. Database performance tuning, indexing patterns, stored procedures, triggers, and architecture are all part of my position making sure the data is always ready and available and ensuring a 3-5 second return time on 100+ TB databases for all reports, requests, and queries. Explore budget and forecast new database server specifications, tooling for process automation, and directing development for next generation solutions.
Highlights: Brought report deliver times down through a complete indexing overhaul from over 2 hours to under 10 minutes. Forecasted, budgeted, developed and delivered “DataSmart” under budget which provided both a new archival strategy removing system threatening growth, and provided a new robust platform to give traders current and predictive analytic capabilities increasing the hedge fund value by 19% through said analytics. Overhauled and refactored systems which were struggling to run 10,000 transactions per second to now running 188,000 transactions Dr. John Trumbul Jr. Austin, TX **@***********.*** 479-***-**** Page 2 of 4 per second on average with no hardware cost increase. Saved the company $800,000 annually by tuning existing systems allowing for a reduction in over 100 cores on existing databases machines saving the 8k per core license fee. Principal Database Architect
Play Studios Austin, TX
February 2012 - April 2016
Summary: Responsible for the entire architecture of the Rewards Platform, Analytics Platform and associated teams: I directly migrated the rewards platform from an unstable pre-productions proof of concept in Django / MySQL to a full MS-SQL Server solution. Taking its capacity from struggling to support 10,000 users, 10 GB Size, and 1500 concurrent processes, to its current abilities in production. 1.8 million daily active users, 900GB – 1TB Size, and 800,000 concurrent processes and transactions. Built the reporting system out from ad-Hoc scripts taking near 17 hours and delivering incomplete information to a full reporting system being utilized by over 30 analysts across 2 offices and countries, with zero down time.
Architecture: Both Traditional RDBMS (SQL SERVER 2008, 2008 R2, 2012 R2 including “Always-On” availability group functionality, NoSQL solutions : Couch Base, BI-Tools : Tableau and Directed the company to move reporting into Red Shift) I lead the technology suggestions, under the hood administration of each, process and database / data modeling, deployment, and hired (from resume vetting, to phone screen, to technical interview design, trained, and lead the database group) to get them up and running with minimal downtime and learning curve narrowing. Highlights: Took Play Studios from a company with no products in the market place to the second highest rated social gaming company in the casino space within four years. Leading all database related operations along the way. Interfaced with the business, in house technical staff, and external domestic and international partners to make sure all of the company’s data needs were met. Scheduled meetings, brown bags, lead talks, and brought innovative suggestions to the table in order to make sure the company stayed current and ahead of its growth. In my tenue with the company there was never a data breech, corrupted backup, need to restore, or any issues in any of the database / data sector as I did whatever it took to get the job done. Director of Database Services
Lumidata INC Bentonville, AR
November 2010 – February 2012
Summary: Directed the architecture and development, acted as the lead on “sETL” a fully automated ETL solution for the import of data into the companies SOLYS tool, and delivery of data for BI, Reporting, Auditing, and Decision Making to the world’s largest retailers. The system handled Terabytes of CPG and POS data for all Wal-Mart and Target stores, with retailer integration from Wal-Mart’s Retail Link, Targets 10/10 and various other data sources and formats.
Architected and coded import formats for the following data types and sources: MDB, XLS, SQL, XML, EDI, BLOB, IMAGE, and Binary data with no proprietary format, automated all of the company’s imports, and made sure the decision making and reporting data was available to the world’s largest retails. Super Valu, Target, Dollar General, Hershey, Wal-Mart, and Clorox to name a few.
Created database security roles and schema to endure cross retailer data security. Developed and deployed monitoring, alerting, and reporting systems for the company’s internal infrastructure. Hit milestone of zero downtime during my tenure of both the ETL processes and internal databases. Architecture: SQL Server 2008, SQL Server 2012 R2, C#, CLR Integration, SSIS, SSRS, VBA. Lead all development of back end databases on the Microsoft stack. Created, tested, and deployed CLR functionality in C# to leverage libraries necessary for custom ETL processes. Took legacy imports that were build using VBA, optimized the process keeping the same business rules and functionality, and delivered a process 22 times faster Senior Database Administrator
Dr. John Trumbul Jr. Austin, TX **@***********.*** 479-***-**** Page 3 of 4 The Clorox Company Bentonville, AR
November 2009 – November 2010 (contract)
Summary: Brought in to audit, create, deploy and train on new processes for importing all sales data for Clorox, and all product sales data for its subsidiaries’ doing business with Wal-Mart global. Highlights: Created an automated process to pull down over the company intranet all of the Clorox sales cubes for the close of Wal-Marts sales week, month, year to date data, aggregate and generate over 1,000 custom reports that were mission critical to be available by Monday for the sales team to use and product placement to act on when making decision on placement and sales. Turned what was a 10 person 40 hour a week manual set of tasks, into an automated system that ran over the course of 24 hours on Saturday saving the company over $750,000 annually. Directed the decision-making process on database scalability for the acquisition of other products under the Clorox umbrella, and developed dynamic processes so the source data would all meet the same flow with no manual transformation steps. Developed entire system on a limited budget, over a cable modem in a satellite office in Bentonville, AR
Director of Engineering
SDI Govt. Solutions DoHD, ARMY, FEMA South Plainfield, NJ Fort Smith, AR January 1998 – November 2009
Summary:
Lead Developer on a disaster management & Continuity of Operations system for US ARMY / FEMA and DoHD called ContinuityNow®.
Highlights: Architected Databases using mirroring, replication, and partitioning technologies to support Unicode data from each adaptation of the system around the world. Worked with SQL Server, tSQLt, ASP.NET, C#, and CLR. Led code review to ensure all sprints would pass, and the code was up to our standards and military requirement. Acted as the lead for the database, BI, engineering team and was the civilian point of contact with top secret clearance between all the departments which included: server engineering, infrastructure services, client engineering, and military intelligence. Developed various in-house tools using .NET / C# / VB.NET working on all every layer of each n- tier system the company developed. Developed System Monitoring Tools and Mentored Program Directors on working with specs based on “need to know” information. Skillset:
Databases:
• SQL Server 2016
• SQL Server 2014
• SQL Server 2000-2012R2
• Sybase IQ
• Oracle
• Teradata
• AWS
• CouchDb / CouchBase
• Polybase / Azure blob storage
Data Integration:
• ETL
• ELT
• SSIS
• SSRS
• Datastage
• Informatica
• SSAS
Programming / Scripting
languages:
• TSQL
• PLSQL
• Power Shell
• C++
• C#
• VB.Net
• VBA
• R
Source Control:
• TFS / TFVC
• SVN
Operating Systems:
• Linux: Ubuntu
• Unix: Solaris, AIX
Methodologies:
• Agile
• Waterfall
Dr. John Trumbul Jr. Austin, TX **@***********.*** 479-***-**** Page 4 of 4
• Git
Expertise:
• High Volume OLTP / OLAP
systems
• T-SQL / Query Tuning / Indexing
• Sliding Window Partitioning
• VLDBs processing millions of
concurrent transactions per sec
• Scalable Database Architecture
• Database / Systems Engineering
• Windows
• Ralph Kimball (DWH)
• Bill Inmon (DWH)
Education:
Ph.D. Computer Engineering New York University – 2007 M.S. Computer Engineering New York University – 2004 B.S. Computer Science New York University – 2002 Certifications:
Microsoft Certified Master (MCM) – Database Architecture Score: 94% Microsoft Certified Solutions Engineer (MCSE) – Data Platform, BI Score: 97% Microsoft Certified IT Professional (MCITP) – DB Administration, Database Developer Score:99%
Contact this candidate