Jay is currently unavailable
Jay Gunderson
Verified Expert in Engineering
Software Developer
Livermore, CA, United States
Toptal member since November 14, 2019
Bio
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.
Portfolio
PrepareLink, LLC
JavaScript, Ajax, jQuery, CSS, HTML, C#, ASP.NET MVC 5, Microsoft SQL Server...
Orion Governance (Hayward, California)
Java, IBM Db2, Microsoft SQL Server, Oracle
Kaiser Permanente (Walnut Creek, California)
Microsoft SQL Server, Oracle
Experience
- PL/SQL Developer - 20 years
- Oracle - 19 years
- Oracle DBA - 19 years
- Back-end - 19 years
- Transact-SQL (T-SQL) - 3 years
- ASP.NET MVC - 3 years
- CSS3 - 3 years
- Razor Pages - 3 years
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
Project History
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.
Education
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
Skills
Libraries/APIs
jQuery
Tools
Visual Studio .NET
Platforms
Oracle, Linux
Storage
PL/SQL Developer, Oracle DBA, Microsoft SQL Server, SQL Server 2014, SQL Server DBA, IBM Db2
Languages
Transact-SQL (T-SQL), HTML, CSS, Java, Visual Basic for Applications (VBA), CSS3, JavaScript, C#
Frameworks
ASP.NET MVC, Razor Pages, ASP.NET, ASP.NET MVC 5
Paradigms
Model View Controller (MVC)
Other
Back-end, SS, Front-end, Ajax, Front-end Design, Front-end Development, Development
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