Jay Gunderson, Developer in Livermore, CA, United States
Jay is available for hire
Hire Jay

Jay Gunderson

Verified Expert  in Engineering

Software Developer

Location
Livermore, CA, United States
Toptal 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.

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,

Work Experience

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

Discover Schema Repository

I developed an MVC controller repository routine that connects and makes API calls to Oracle and SQL Server stored procedures to discover, consolidate, and pass all database environment schemas to the discovery view page in SchemaTrack.

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, Development

Languages

T-SQL (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)

1985 - 1987

Master of Business Administration (MBA) Degree in Business Administration

San Jose State University - San Jose, CA, USA

1980 - 1982

Associate's Degree in Computer Programming

De Anza College - Cupertino, CA, USA

1972 - 1976

Bachelor's Degree in Business Administration

University of New Mexico - Albuquerque, NM, USA

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring