Printing tool Download PDF

Work experience

Aug 2005Jun 2008

Sr. Software Architect

As the ninth employee of EnterpriseDB, I’ve been fortunate enough to have designed, prototyped, participated in, or led the development of many successful projects which have enabled the company to grow and succeed. While acting primarily as a Sr. Software Architect focusing on database internals, my experience and proven ability to lead has led me to have been tasked with porting, project management, sales, performance, and services projects.
  • Prior to its acquisition, I performed technical due diligence of ExtenDB (now GridSQL) on behalf of EnterpriseDB.
  • Selected to independently port SugarCRM Enterprise to EnterpriseDB.
  • Selected to independently port a Fortune 500’s COBOL application to EnterpriseDB.
  • Selected as one of four project members to design, develop, test, and deliver EnterpriseDB Postgres.
  • Performed real world testing as a primary and ongoing member of EnterpriseDB’s Advanced Testing Group.
  • Performed post-sales work for several major clients.
  • Performed sales engineering tasks for several major clients.
  • Performed both public and customer-oriented database training sessions.
  • Performed database benchmarking and performance regression analysis.
  • Participated in the design and development of EnterpriseDB and Postgres training materials and labs.
  • Participated in the design of the EnterpriseDB Procedural Language Debugger.
  • Led the design and development of an Oracle Call Interface (OCI) drop-in library replacement.
  • Led the development of an Oracle-compatible SQL precompiler suite for COBOL.
  • Designed and prototyped an update-in-place storage engine replacement for PostgreSQL supporting in-memory UNDO and functionality similar to Oracle Flashback Database.
  • Designed and prototyped Oracle-compatible PL/SQL bulk operations support (FORALL/BULK COLLECT).
  • Designed and prototyped Oracle-compatible implicit DDL commit support.
  • Designed and prototyped a modular SQL compatibility framework.
  • Designed and prototyped asynchronous I/O support.
  • Designed and prototyped Oracle-compatible query hinting.
  • Designed and prototyped several built-in Oracle packages.
  • Designed and prototyped a web-services gateway for database functions, packages, and procedures.
  • Designed and prototyped a T-SQL to PL/SQL translator using ANTLR.
  • Designed, prototyped, and implemented an adaptive background writer.
  • Designed, prototyped, and implemented an improved hybrid LRU/Clock-sweep buffer manager.
  • Designed, prototyped, and implemented EnterpriseDB DynaTune; a dynamic tuning engine for PostgreSQL.
  • Designed, prototyped, and implemented a shared query caching framework.
  • Designed, prototyped, and implemented Oracle-compatible public synonyms.
  • Designed, prototyped, and implemented Oracle-compatible hierarchical queries.
  • Designed, prototyped, and implemented several Oracle-compatible catalog views.
  • Designed, prototyped, and implemented SQL data type mappings.
  • Designed, prototyped, and implemented an Oracle-compatible runtime instrumentation and tracing architecture.
  • Designed, prototyped, and implemented Oracle-compatible database links.
  • Designed, prototyped, and implemented Oracle-compatible ROWID support.
Dec 2004Aug 2005

Sr. Web Administrator (Webmaster)

Albuquerque Technical Vocational Institute
As the Senior Web Administrator (Webmaster) of TVI, it was my responsibility to manage a six-person web team in custom development, support, and administration of TVI s SunGard SCT Luminis Portal and CMS products as-well-as build custom interfaces to our Banner ERP system.
  • Led the institution-wide TVI Web Team.
  • Led the CIT Web Services Team of 6 web developers/designers.
  • Acted as a key member of the TVI Web Strategic Team.
  • Presented projects and demonstrations to TVI s Executive Team and Information Technology Strategic Team.
  • Acted as Project Manager of the TVI Website Redesign Project.
  • Worked directly with directors, managers, senior-level techs, and departments on institutional web projects.
  • Acted as Technical Lead for our custom-developed web application for TVI s T2-based parking system.
  • Led a team in defining standards for look-and-feel, accessibility, development, and naming conventions.
  • Modeled, designed, and led development of TVI s PHP/PostgreSQL-based Technical Equipment Database (TED).
  • Modeled, designed, and led development of TVI s PHP/PostgreSQL-based Firewall Change Request System (FCRS).
  • Modeled, designed, and led development of TVI s PHP/PostgreSQL/Java-based Automated Password Reset System (APR) which provided identity management and account provisioning services across disparate TVI systems.
  • Designed the Web Service architecture used by the Automated Password Reset system.
  • Trained web developers and DBAs on PostgreSQL and Oracle SQL syntax, stored procedures, and triggers.
  • Designed and implemented TVI s PostgreSQL-based ANDREW search engine.
  • Worked with the CIT director, security officer, and managers to define TVI’s project management process.
  • Led an open source initiative to release APR, TED, and FCRS to the public under the GPL.
  • Worked with Oracle DBAs to integrate several web-based systems with Banner.
  • Assisted fellow developers in optimizing SQL queries, stored procedures, and views.
  • Deployed PostgreSQL as our first-line database for all non-Banner data.
  • Worked with CIT directors, managers, UNIX administrators, and DBAs on the Oracle Redesign Project to define TVI s new Oracle, iAS, and Banner environment.
  • One of four reviewers on TVI s RFP review panel for the Network Storage Project.
Aug 2003Dec 2004

UNIX Administrator

Albuquerque Technical Vocational Institute
My position as UNIX Administrator at TVI has given me the ability to work with various individual teams in CIT. Additionally, it has given me the opportunity to become familiar with several systems being used at TVI.
  • Worked directly with seniors and managers on critical TVI projects.
  • Successfully led the deployment of the INB platform on Solaris.
  • Successfully maintained the production INB environment for the past nine months.
  • Developed documentation, checklists, and standards for an OFA-compliant installation of Oracle Database and Oracle Internet Application Server at TVI.
  • Took a leadership role in leading a team to identify and resolve critical issues with TVI s mail gateways after the deployment of the Luminis system.
  • Took a leadership role in identifying and fixing TVI s student signup system.
  • Successfully led the migration of INB from Solaris to Linux.
  • Worked with DBAs and programmers to develop the form synchronization process used for INB.
  • Designed, developed, and deployed a system used to maintain UNIX and Luminis account synchronization using Java, PostgreSQL, and LDAP.
  • Developed an online system used by TVI s Public Information Office to review Luminis account statistics and activity.
  • Planned and implemented the migration of the login system from NIS to LDAP as well as developed maintenance utilities for managing accounts from LDAP.
  • Submitted a patch for uPortal 2.1 so the web team could test uPortal channel removal functionality.
Apr 2003May 2004

Chief Information Officer (Interim Chief Technology Officer)

OasisJet Fuel Inc. & OasisJet, Inc.
OasisJet was a contract fuel company that partnered with Fixed Base Operators (FBOs) to provide low-cost jet fuel. OasisJet s pricing model allowed corporations, air ambulance companies, cargo companies, and private citizens to purchase JET-A fuel at prices cheaper than unleaded gas. As I had initially worked on the OasisJet software for a consulting firm, they brought me on full-time to continue development and lead their IT strategy.As a startup company, my position at OasisJet encompassed various aspects of business, technology, and the application of technology to solve business problems and drive efficiency. Efficiency improvements included the streamlining of information, data, and reporting flows to accounting and administration. The data flow implementation I designed gave us the ability to make decisive business decisions more quickly and more accurately.
  • Worked closely with accounting department on architecting information flow between disparate IT systems.
  • Solely set up, tuned, and maintained the company s database instances.
  • Managed, designed, and assisted development of the company s custom ERP & CRM system.
  • Worked closely with our Director of Marketing & Sales to develop a single, consistent, and well-planned direction for both print and electronic marketing.
  • Solely developed an information flow strategy with our company s insurance partners.
  • Based on information provided by our insurance business partners, I solely developed an insurance qualification system for our customers, which included pilots, aircraft, and certain health information.
  • Developed business system interface strategies including SOAP-based web services with our nationwide business partners.
  • Developed OasisJet openNav, an application similar to NavPak, which allowed pilots to enter waypoints and aircraft information. Based upon the information, the system would dynamically map trip legs on a United States map using data gathered by the US Geological Survey (USGS) with topology rasters from the US National Atlas. By interfacing with our FBO provider tables, the system would then plot the locations within 1/10th of their trip duration.
  • Designed and added initial support for flight following and real-time graphical weather mapping based on METAR data to openNav.
  • Worked with insurance partners to increase the effectiveness and security of the netIdent system to meet their needs and requirements.
  • Planned the company s strategy and trust relationship for the netIdent system between all business partners and clients.
  • Redesigned the OasisJet website layout, making it more user-friendly and user-customizable.
Jul 2003Apr 2004

Lead Developer

PatchWork Systems LLC.
Similar in functionality to RingMaster, PAT provided automated Oracle Applications patch analysis and installation on all supported Oracle Applications platforms.PAT was PatchWork Systems flagship product and was originally designed to meet the needs of the Oracle Applications (version 10) administrators at Sandia National Labs. Later, it was licensed from Sandia by PatchWorks, upgraded for use with 11i, and sold to commercial Apps users. Initially developed as a set of PL/SQL packages and several C applications, we were moving toward using 100% Java when I left.
  • Designed the PatchWork Systems logo.
  • Designed the PatchWork Systems web site.
  • Solely designed and developed the PAT Java Installer and batch/shell scripts.
  • Wrote the initial PAT installation documentation for the Java Installer.
  • Rewrote the C-based PAT FTP patch download utility in Java.
  • Rewrote the C-based queue monitoring & execution daemon in Java.
  • Rewrote the C-based form analysis utility in Java.
  • Rewrote the PL/SQL menu system in Java.
  • Debugged and fixed several Pro*C applications.
  • Improved the performance of several analysis tools.
Oct 2001Sep 2002

Senior Lead Developer

Ethicon Endo-Surgery, Inc.--A Johnson & Johnson Company
Ethicon Endo-Surgery manufactures minimally invasive surgical products that are used by physicians worldwide. When they decided to migrate their internal ERP system (Symmetry) from a client-server PowerBuilder application to a web-application in PHP, I was contracted to be senior lead developer of the first migration, the Automated Quality Record ( AQR ) module. AQR, an ISO 9000 compliant quality system, had to be completely redesigned due to major business changes derived from new requirements after their acquisition of a vascular access company. I acted as a senior lead developer by working with our project manager, key business partners, and fellow developers in researching, planning, and designing the implementation.
  • Led a team of 6 developers for a multilingual, mission-critical ISO 9000 quality system rewrite from PowerBuilder to PHP (used in 5 sites within the US and Mexico)
  • Led the design and development of an effective and user-friendly web-based UI.
  • Played an active role in database architecture and data modeling.
  • Personally executed load testing and transaction cost analysis of the web environment and provided detailed reports of the results.
  • Personally designed, modeled, and developed a multi-language translation method for both static and dynamic text/data using XML and database tables.
  • Led the design and development of a role-based security model.
  • Personally designed custom application graphics and logos.
  • Solely developed the application prototype.
  • Worked with Senior Software Analysts to design and develop an electronic signature system compliant with 21 CFR Part 11.
  • Assisted in the design and development of triggers, stored procedures, and packages for Oracle8i.
  • Participated in developing solutions to HP-UX, Apache, PHP, and other related problems.

Skills

PostgreSQL
I ve began using Postgres in 1999 as a DBA and a developer. Starting in 2001, I started doing internal development on Postgres and, in addition to several community-related patches, I ve done significant architectural and development work with Postgres for EnterpriseDB.
Oracle Database
I’ve been using Oracle since 1996 and am intimately familiar with every version of Oracle since version 7. While I’ve used Oracle as both a DBA and a developer, I specialize in Oracle Internals and performance-related tuning.

References

Roy L. Kelly

Jonah was recommended to me as a web designer when I needed to get the Worldwide Nutrition site going. He was fast and professional at meeting our needs, and provided a great deal of information to us in planning our course of action. I ve found him a pleasurable young person to work with and look forward to working with him again in the future.

David Massey

I worked with Jonah Harris from November of 2002 to April of 2003. Jonah helped organize and finish a large database web integration project utilizing many features found in large scale enterprise database applications. He also designed many web layouts that were ultimately used by organizations such as Sandia National Laboratories. Coming from a fairly vast programming/computer background myself I have seen and experienced Jonah’s vast knowledge of many computer software and hardware systems first hand. Including his expertise for database development/theory, web design skills utilizing the latest CSS offerings, and interfacing web applications with enterprise level databases. I believe Jonah would be an excellent choice for any position in IT, his experience in Internet/Database development and deployment is only exceeded by his passion for technology. If you have any further questions regarding my experiences working with Jonah Harris you can contact me directly.

Robert Todd Edgel

It has been my pleasure to work with Jonah Harris for the last two years. Jonah is (without question) the brightest, most helpful, and most highly motivated co-worker that I have had the privilege to work with in my entire career. Jonah has repeatedly demonstrated superior problem solving ability and completes all projects in a timely and exemplary manner.He has been instrumental in implementing an identity management solution at TVI that required the integration of several LDAP and relational database technologies. Jonah s proposed solution to this problem resulted in a single identity for every Student, Staff, and Faculty at TVI and greatly simplified the management of system access for the entire institute (over 30,000 users). This is just one of many examples of projects that Jonah designed, coordinated, and implemented with great success. Jonah is always seeking out opportunities for process improvement and has added enormous value to the information systems offerings here at TVI. He has a knack for communicating difficult concepts in a manner that is understandable and agreeable to his teammates. I am confident that Jonah would make a fine contribution to any team. I enthusiastically recommend Jonah Harris for this or any opportunity.

Craig A. Vedder

I ve worked with Jonah for about a year now and whether we re discussing electronic marketing plans, our web site, or our extremely large databases, Jonah has always been able to accept the responsibility and exceed our expectations with the result. I look forward to working with him again on many other business plans and he has been a pleasure to work with. His experience and knowledge is far beyond his years and I would recommend him for any job in business development or information technology.

Donna Campbell

I am very happy to be asked to provide references for Jonah Harris.Jonah worked with me during the start-up phase of my company, PatchWork Systems. While working for me, he displayed personal integrity, honesty, and a high degree of professionalism. Jonah provided expertise and detailed knowledge of the Oracle 11i Application Vision installation and configuration, Oracle PL/SQL, Java and C language skills, as well as UNIX and Linux System Administration and operating systems shell scripting, and excellent technical skills in internet and web development. Jonah s technical expertise and support was crucial in PatchWork Systems meeting project deadlines and delivery of code to our customers. I would not hesitate to work with Jonah again.

Toni Neil

Jonah was a great asset to OasisJet. We relied on the software he maintained for our entire business operations. Many times we d need a modification and he could deliver flawlessly. Also, his assistance in taking over OasisJet Fuel, Inc. was invaluable. I would personally recommend him for any business or computing position.

John E. Springrose

I met Jonah while working with OasisJet. He was able to quickly derive valuable business and sales information from the raw data I gave him. When we decided to move forward with OasisJet, Inc., Jonah was able to migrate all the old OasisJet accounts and handle all technical challenges the take-over presented. Any time that I ve ever needed any help with my computer systems, Jonah was able to help me fix them. Aside from being a smart IT guy, Jonah has a lot of business talent and was the first to start on our new business plan. Jonah also worked with Toni to confront the owner of OasisJet Fuel, Inc. and notify him of the takeover. He also handled all of our customer support and registration calls. Jonah is a versatile guy and I would recommend him in any technical or business capacity.

Jim Snyder

Jonah has been our in-house IT Director for a year and has brought our technology up to date, educated employees, and setup systems that allow us to do our jobs more effectively. We are very pleased with his performance thus far and have found him to be very reliable.

Harlen Campbell

I worked with Jonah Harris at Ethicon Endo-surgery (EES) while he was engaged on the port of our AQR (Automated Quality Record) system from a client server environment to a web-based application. During my time working with him, I found him to be extremely qualified and knowledgeable in a wide variety of programming environments and languages, from Unix through Windows 2000 and C through SQL. In addition to his basic competence, Jonah s work was characterized by persistence and dedication to both short-term solutions to the immediate problem he was given and to the long-term interests of the company. It is a pleasure to recommend Jonah for any position in information management or technology, and I would welcome an opportunity to work with him in the future.

Portfolio