John Thorpe Email & Phone Number

San Francisco

San Francisco

Maintain databases, backups, and disaster recovery.Work with developers to review changes and suggest alternatives as necessary. Monitor, maintain and upgrade databases. Provide on-call support. Provide documentation of systems and procedures. Build and configure Atlas Mongodb databases and work with developers to resolve issues.

San Francisco

Ensured that the MySQL and Vertica production database clusters were available 24/7/365 with no downtime, that they performed optimally, and that they had recent backups at all times. Set up high availability, including replication MySQL instances in the Amazon Cloud. Ensured that all database monitoring was set up.Provided all maintenance of the MySQL and Vertica clusters including on-call support 24/7/365.Upgraded MySQL cluster from 5.1 to 5.5, which included migrating all data to new hardware.Ensured that documentation of database descriptions and procedures were up to date.Worked closely with DevOps, Data Engineer, Data Architect, and developer teams.Participated in the DevOps group including an on-call rotation for all servers 2013-2015.Managed and provided oversight and training for the other DBAs 2014-2016.

Implemented the high availability WolframAlpha.com database cluster when WolframAlpha went live in May 2009, then provided all management of the cluster until late 2011, which included being on-call 24/7/365. Set up three co-located database clusters, which were replicated from the main site.Upgraded the entire cluster from 5.0 to 5.5 with no downtime.Provided user support on all machines: handled database and table designs, optimizations, and other user database and query questions.Wrote scripts to perform out-of-replication data updates to the cluster, and wrote many other scripts to handle one-off data transformations and monitoring.Worked on a customer relationship database backend system, SugarCRM, using a MySQL implementation.Worked closely with system administrators, web developers, managers and my fellow DBA.

Wrote and implemented the Wolfram employee paid time off management system for both UK, US, and Japanese employees. This ran without issues after it went live in 2005.Created Oracle forms, reports, stored procedures, and concurrent requests to implement business plans.Performed query and application optimizations. Maintained data and ran mass data updates as required.Maintained the MySQL database, automated backups, and performed upgrades.Collaborated with developers in creation of library.wolfram.com.Worked remotely, full time from California, from Aug 2004 and after.

Champaign, Illinois Us

Created all of the software for this business, which included a database-driven web site that allowed members to enter orders, save and edit previous orders, view account statements, and view the catalog online. Managed all financials for organization, which also included writing the backend software in MS Access and Visual Basic.

Develop embedded software for dedicated WAN/LAN communication devices.Develop and maintain databases and database applications for internal manufacturing and technical support. Product QA and desined/implemented automated product testing.

Ph.D., Physics

Performed X-ray, temperature, and pressure measurements on crystals of solid Helium-4 in order to determine the fraction of vacant lattice.

B.S., Physics

Physics