Jay Gunderson, Software Developer in Livermore, CA, United States
Jay Gunderson

Software Developer in Livermore, CA, United States

Member since June 18, 2020
Jay has over 25 years of experience in programming and DBA consultations with both engineering companies and IT organizations in Silicon Valley. As an expert back-end developer, he delivers high-performance Oracle and SQL Server data APIs that are a dream for any front-end team working on web/RDBMS solutions. Jay also excels at coding front-end web applications, most recently, working with the ASP.NET platform with the MVC framework.
Jay is now available for hire

Portfolio

Experience

Location

Livermore, CA, United States

Availability

Part-time

Preferred Environment

Front-end, Model View Controller (MVC), ASP.NET, SS, Oracle

The most amazing...

...project role would be creating ERD from a requirements document, then physicalize the database (multiple RDBMS), then build the APIs to support front-end apps,

Employment

  • Lead Software Developer

    2015 - PRESENT
    PrepareLink, LLC
    • Designed and developed an ASP.NET MVC 5 front-end web app and API back ends for Oracle and SQL Server for the DBA tool, SchemaTrack. This tool keeps IT projects in front of planned, deployed, and historic database changes across IT initiatives.
    • Designed and developed the public-facing website, SchemaTrack.com, to market and distribute SchemaTrack software.
    Technologies: JavaScript, Ajax, jQuery, CSS, HTML, C#, ASP.NET MVC 5, Microsoft SQL Server, Oracle
  • Database Administrator | Developer

    2017 - 2018
    Orion Governance (Hayward, California)
    • Wrote APIs (stored procedures) for Oracle, SQL Server, and IBM DB2 to identify and create index filters used to access structured data in IT data centers.
    • Integrated APIs into Orion’s Meta Warehouse tool, a solution to manage sensitive data for organizations preparing for GDPR compliance.
    • Converted Orion's warehouse filter routines (above) from stored procedures to a Java string and array search architecture to avoid the need to have database accounts created for the warehouse tool.
    • Migrated the above-mentioned APIs into a Java JAR solution to fit into the Orion Governance’s GDPR Linux appliance.
    Technologies: Java, IBM Db2, Microsoft SQL Server, Oracle
  • Database Administrator

    2013 - 2015
    Kaiser Permanente (Walnut Creek, California)
    • Served as a DBA for SQL Server databases supporting Kaiser’s network services applications: HP Network Automation (HPNA), video telepresence, and network usage/performance data warehouses.
    • Developed database monitoring scripts and database mirroring for primary/standby high availability.
    • Built Kaiser’s custom HPOO locations database including data loads and API for the HPNA front-end application.
    • Acted as a DBA for an Oracle 11G RAC database on a two-node Linux platform to support HPNA. Kaiser's separate DBA group completed the RAC setup.
    • Composed scripts for database builds including physical standby for development, product, and disaster recovery (DR) environments using Oracle RAC 11g.
    • Served as a DBA for Oracle 11g for a Windows front end to VcWizard, Kaiser’s VIDEO conference scheduling application.
    • Created a physical Oracle standby for high availability and provided production support.
    Technologies: Microsoft SQL Server, Oracle
  • Staff Software Engineer

    2012 - 2013
    Epicor Software (Dublin, California)
    • Served as an Oracle DBA and lead programmer for Epicor’s warehouse-management-system products in the auto-parts aftermarket supply chain industry.
    • Provided DBA support on 12 Oracle 10g and 11g instances on a clustered Linux platform with a data volume of 15TB.
    • Created PL/SQL and SQL programs for nightly scrubs, builds, and publishing of member inventory and sales uploads to data warehouse fact tables.
    • Developed stored procedures to support a front-end ASP.NET web application for Epicor's auto-parts retail store application.
    • Acted as a technical lead for Epicor’s offshore (India) ASP.NET development team.
    Technologies: Oracle
  • Programmer | Oracle DBA

    2010 - 2012
    Kaiser Permanente (Pleasanton, California)
    • Produced a requirements analysis and definition for the implementation of a Sarbanes-Oxley database hardening to Kaiser's professional profile liability (PPL) system.
    • Served as an Oracle DBA and implemented programming development and support to bring PPL and the research management system (RMS) into SOX compliance.
    • Developed a source coded generation job to dynamically code and create on-insert, on-delete, and on-update triggers for Kaiser's PPL and RMS Oracle primary tables and log tables.
    Technologies: Visual Basic for Applications (VBA), Oracle
  • Technical Manager | Project Manager

    2008 - 2009
    Cognizant Technologies, Inc. (San Ramon, California)
    • Served as a senior Oracle DBA and project manager for Cognizant's database hardening project at Washington Mutual Bank.
    • Implemented database hardening for 20 Oracle development, test, and production environments.
    • Stabilized and automated migration of 80 production, development, and QA Oracle databases to Sarbanes-Oxley (SOX) compliance.
    • Provided SOX compliance planning and documentation in support of stabilizing a database-hardening project with the client.
    • Turned around the under-performing project and achieved completion after two previous Cognizant consulting teams had failed.
    Technologies: Oracle
  • Oracle DBA

    2005 - 2008
    Mervyn's, LLC (Hayward, California)
    • Served as an Oracle DBA and member of the systems architecture team at Mervyn's, a large retail company.
    • Implemented and managed Oracle databases in AIX and Windows environments.
    • Trained and supervised junior DBAs.
    • Successfully installed 28 development, test, and production Oracle 9i instances.
    • Configured databases to support multiple retail applications for planning, allocation, logistics, workforce management, and knowledge management.
    • Designed and implemented central pricing management data warehouse in Oracle 10g environment.
    • Brought Oracle expertise to this new IT organization following its separation from Target, Inc.
    • Provided all database development and support related to retail packaged applications.
    • Developed a fraud-and-recovery client-server application for Microsoft Access and the SQL Server solution.
    Technologies: Oracle
  • Senior Oracle DBA

    2004 - 2005
    John Muir | Mt. Diablo Health Systems (Walnut Creek, California)
    • Served as an Oracle DBA and developer for the implementation of Facets claims management systems for a healthcare organization.
    • Acted as the technical lead for Facets sequel performance tuning project.
    • Installed Oracle 9i, created all Oracle instances, and migrated the data for development, test, and production databases.
    • Developed custom hot-backup scripts (before RMAN) for the production of the Facets database.
    • Created an Oracle standby for the back-end of the Facets reporting system.
    Technologies: Oracle
  • Oracle DBA | Team Lead

    1997 - 2004
    Concert Global Communications (San Jose, California)
    • Developed all ERDs and Oracle database environments in support of Orion's order entry, order fulfillment, and network profile systems.
    • Acted as the DBA team lead of a small group of Oracle DBAs in support of Orion.
    • Provided DBA support for 24 Oracle instances on Solaris/Unix machines.
    • Carried out 16 quarterly upgrades with a 100% on-time delivery.
    • Developed an enterprise application integration (EAI) to support the API integration with the ordering systems.
    Technologies: Oracle
  • Oracle Financials DBA

    1996 - 1997
    Zitel Corporation (Fremont, California)
    • Performed the DBA installation and implementation of Oracle applications.
    • Carried out performance tuning and capacity preparation.
    • Installed Oracle Smart Client modules.
    • Served as the DBA lead for a small team of junior DBAs as Zitel was brand new to Oracle technologies.
    • Helped to deploy and implement full financial and manufacturing modules in Oracle Smart Client.
    Technologies: Oracle
  • Principal Consultant

    1992 - 1996
    Oracle Corporation (Redwood Shores, California)
    • Carried out Oracle programming, installation, support, and database administration for federal and state government projects.
    • Installed and customized Oracle application project accounting for Lawrence Livermore National Laboratory to replace the legacy engineering maintenance accounting systems.
    • Led the project of the development of the custom accounting report.
    • Consulted on the Oracle Designer/2000 toolset.
    • Established CASE v5.1 development environment for Unisys Corporation.
    • Reverse-engineered the Medicaid information system and created an Oracle warehouse application.
    • Created reports and forms using Oracle toolset.
    • Programmed and developed transaction processing applications for the US Postal Service eCommerce and digital signature applications.
    • Developed migration programs to convert and distribute mainframe tables to the new Oracle databases at the US Postal Service.
    Technologies: Oracle

Skills

  • Platforms

    Oracle, Linux
  • Storage

    PL/SQL Developer, Oracle DBA, Microsoft SQL Server, SQL Server 2014, SQL Server DBA, IBM Db2
  • Other

    Back-end, SS, Front-end, Ajax, Front-end Design, Front-end Development
  • Languages

    Transact-SQL, HTML, CSS, Java, Visual Basic for Applications (VBA), CSS3, JavaScript, C#
  • Frameworks

    ASP.NET MVC, Razor Pages, ASP.NET, ASP.NET MVC 5
  • Libraries/APIs

    jQuery
  • Tools

    Visual Studio .NET
  • Paradigms

    Model View Controller (MVC)

Education

  • Master of Business Administration (MBA) Degree in Business Administration
    1985 - 1987
    San Jose State University - San Jose, CA, USA
  • Associate's Degree in Computer Programming
    1980 - 1982
    De Anza College - Cupertino, CA, USA
  • Bachelor's Degree in Business Administration
    1972 - 1976
    University of New Mexico - Albuquerque, NM, USA

To view more profiles

Join Toptal
Share it with others