Trevor is available for hire

Trevor N Hayward

Verified Expert in Engineering

Database Developer

Visalia, United States

Toptal member since November 4, 2022

Expertise

Oracle Development Linux SQL XML Windows Development Database DevOps ETL GIS Jira

Bio

A proven architect, database developer, and leader, Trevor focuses on enterprise systems solving complex process and data challenges across a diverse array of fields, including aerospace, telecom, law enforcement, and electric utilities. His broad technical perspective and years of full lifecycle experience drive practical approaches to architectural decisions.

Portfolio

Aloft UAV

Oracle Cloud, Oracle Application Express (APEX), Jira, Atlassian Suite...

ITSoft

Linux, PostgreSQL, MySQL, Kubernetes, Apache Maven, Jira, Hyper-V, Networking...

CaseIntel Corporation

Oracle, Oracle DBA, Oracle RAC, Oracle Data Guard, Oracle PL/SQL...

Experience

Oracle - 20 years
Oracle DBA - 20 years
Data Modeling - 20 years
Architecture - 20 years
Oracle PL/SQL - 20 years
Oracle Application Express (APEX) - 15 years
DevOps - 15 years
Jira Administration - 14 years

Availability

Part-time

Preferred Environment

Oracle, Linux, Windows, Jira, Atlassian Suite, Oracle Cloud

The most amazing...

...thing I've developed is NetGIS, an application using AutoCAD and Oracle Spatial for electric utilities to manage their distribution networks.

Work Experience

Chief Technology Officer (CTO)

2018 - 2022

Aloft UAV

Created spatial mapping, air operations, and imagery management apps for agricultural UAVs, encompassing mission plans, flight log data, and multispectral NDVI geo-raster imagery. Used Oracle Spatial, Oracle Cloud Infrastructure, and Oracle APEX.
Built real-time UAV telemetry sharing data network using MAVLink over dedicated and long-term evolution (LTE) connections. Provided network for mission control, telemetry, and imagery.
Configured and used Jira, Jira Service Desk, Confluence, and Bitbucket for product planning, project management, issue tracking, documentation delivery, build automation, and customer support.
Configured site monitoring and alerting using Oracle Enterprise Manager, Snort, Nagios, and Checkmk.

Technologies: Oracle Cloud, Oracle Application Express (APEX), Jira, Atlassian Suite, Oracle DBA, PL/SQL, Oracle Spatial, GIS, ArduPilot, MAVLink, Oracle PL/SQL, Oracle SQL Developer, Data Modeling, Oracle SQL Data Modeler, Process Flows, Process Design, DevOps, Agile DevOps, Jira Administrator, Linux, Windows System Administration, Architecture, SQL, Kubernetes, Docker, Bamboo, GitOps, VPN, XML, Graphs, Oracle, IT Consulting, Data Architecture, Agile Practices, Jira Administration, Entity-relationships Model (ERM), ETL, Database Administration (DBA), Databases, Oracle Database

DevOps Consultant

2019 - 2019

ITSoft

Designed and implemented a multi-cluster Kubernetes or Rancher environment for a managed service provider (MSP) application delivery.
Completed cloud and cluster migration of multiple PostgreSQL, MySQL, and SQL Server instances.
Administered multiple instances of PostgreSQL, MySQL, and SQL Server.
Updated and improved DevOps processes with a development team to support migration to the cloud.
Created and managed an internal multi-national and multi-site network.

Technologies: Linux, PostgreSQL, MySQL, Kubernetes, Apache Maven, Jira, Hyper-V, Networking, Rancher, Agile DevOps, Docker, Istio, Splunk, NGINX, Grafana, VyOS, Jenkins, Bamboo, Bitbucket, GitOps, Git, VPN, Oracle SQL Developer, Process Flows, DevOps, Windows System Administration, Architecture, SQL, Windows, IT Consulting, Database Performance, Agile Practices, Entity-relationships Model (ERM), Database Administration (DBA), Databases, Microsoft SQL Server

Practice Manager

2002 - 2017

CaseIntel Corporation

Acted as the architect for NetGIS, an application for electric utilities that maps their complex redundant downtown electrical distribution networks using AutoCAD and Oracle Spatial and Graph.
Managed NetGIS product development. Developed complex PL/SQL and Java Oracle applications and used Oracle Spatial, Network, Graph, Oracle AQ, Java, and Native XML in the database and CQN.
Built an Oracle Native XML-based CIM data hub (IEC 61968-100 compliant) for electric utilities to support IEC 61968 and 61970 standard CIM requests, transactions, and events.
Developed CaseIntel, a criminal intelligence data mining system based on Oracle. Used a data lake to extract models of criminal networks, inter and intra-case linkages between suspects, phones, weapons, vehicles, and communication records.
Created multiple business intelligence applications for the maintenance and operations of electrical distribution equipment. Facilitated predictive and preventative maintenance planning and equipment fault analysis.
Designed an Oracle Streams-based memory replication architecture and system for an automated fingerprint identification system (AFIS) to support cache coherence of an application object cache across Oracle MAA architecture utilizing Oracle RAC.
Implemented dashboards using Oracle Warehouse Builder, BI Publisher, and OBIEE for utility network management.
Conducted Oracle database security hardening. Worked with Morpho Trak to modify the minimum baseline security standard (MBSS) AFIS in support of FBI and DHS implementations to achieve DoD STIG and DHS secure configuration standards.
Architected and implemented Oracle RAC and Active Data Guard (MAA) distributed platforms for Hexagon Intergraph outage management systems at several US-based utilities.
Completed many setups, administration, and tuning consulting engagements using Oracle Real Application Clusters (RAC), Oracle Data Guard, Oracle ASM, and Oracle Advanced Queuing (AQ) on Windows, Linux, HP, Sun, IBM, and VM. Versions 6-19c.

Technologies: Oracle, Oracle DBA, Oracle RAC, Oracle Data Guard, Oracle PL/SQL, Oracle Designer, Oracle SQL Developer, Data Modeling, Oracle SQL Data Modeler, Process Flows, Process Design, DevOps, Agile DevOps, Jira Administrator, Confluence, Java, Linux, Windows System Administration, Architecture, SQL, Hyper-V, Bamboo, GitOps, VPN, Atlassian Suite, Oracle Spatial, Windows, XML, Graphs, Management Consulting, IT Consulting, Engineering, Database Performance, Data Architecture, Oracle Forms, Oracle Data Miner, Agile Practices, Jira Administration, Entity-relationships Model (ERM), PL/SQL, Business Intelligence (BI), ETL, Data Lakes, Database Administration (DBA), Databases, Oracle Database, Microsoft SQL Server, Data Engineering

Practice Director

1986 - 1999

Oracle

Led and worked as a data architect on a project to automate the manufacturing process at an aerospace manufacturer's sheet metal fabrication plant. Managed the team architecting and building a data integration hub for the shop floor plan data.
Worked as a data architect for a customer service division of Boeing for an SGML-based technical document authoring and production system responsible for producing and managing highly complex technical documentation.
Developed a retail sales snowflake dimensional data warehouse for grocery store beer sales for Anheuser-Busch.
Acted as a founding member of the Oracle Business Process Reengineering (BPR) consultancy. Wrote the Oracle BPR methodology, a streamlined reengineering methodology that leverages modern process engineering tools and agile development processes.
Conducted training for hundreds of internal Oracle consultants and external clients around the US and globally on data architecture, data modeling, process modeling, and Oracle development methodologies.
Re-engineered procurement processes for the Ford electronics assembly plants in Sao Paulo and Lisbon.

Technologies: Oracle, Data Architecture, Database Performance, Engineering, IT Consulting, Management Consulting, Oracle PL/SQL, Oracle8i, Oracle RAC, Oracle Designer, Oracle SQL Data Modeler, Process Flows, Process Design, Java, Linux, Architecture, SQL, Oracle Spatial, XML, Graphs, Oracle Forms, Oracle Data Miner, Agile Practices, Entity-relationships Model (ERM), PL/SQL, Business Intelligence (BI), ETL, Database Administration (DBA), Databases, Oracle Database, Data Engineering, Roadmaps

Experience

NetGIS Utility Distribution Mapping

The product utilized AutoCAD on the front end, with an Oracle Spatial and Graph database to manage model semantics, spatial data, electrical connectivity, network analysis, equipment data, etc. This solved a critical need for the electric utility distribution management space, as existing systems could not adequately manage redundant downtown core networks. I was a principal architect and development manager for CaseIntel NetGIS.

Cloud Migration

I built a multi-cloud, multi-cluster Rancher Kubernetes platform for an MSP to enable their cloud migration. Assisted development teams in re-architecting their applications to micro-service-based architecture.

Electric Utility XML Data Interchange Hub

I built a data interchange hub for utilities employing IEC 61968 and 61970 standard CIM requests, transactions, and events. I also utilized Oracle Native XML processing and Oracle AQ to enable rapid integration with heterogeneous systems.

CaseIntel Criminal Intelligence System

A case management and data mining system for law enforcement to manage and coordinate investigative activity among detectives across divisions. I automated case management workflow and, through link analysis and data mining, uncovered and modeled criminal networks and inter and intra-case linkages between suspects, phones, weapons, vehicles, and communication records.

Beverage Sales Data Warehouse

I built a grocery shelf space/coupon/retail sales data warehouse for Anheuser-Busch. I also supported dimensional analysis of ad and coupon activity and sales to identify causal factors and patterns in US and international markets.

Aerospace Factory Data Hub

I architected and managed the development of a data hub for the interchange of shop floor control data, manufacturing process plans, changes, and rework data for the sheet metal factory of a major aerospace manufacturer.

I then implemented it in Oracle. It provided a data interchange hub for Baan manufacturing apps and a wide array of in-house applications.

Skills

Libraries/APIs

AutoCAD API

Tools

Oracle RAC, Oracle Designer, Oracle Application Express (APEX), Oracle SQL Data Modeler, Jira, Confluence, NGINX, Bamboo, VPN, Atlassian Suite, GIS, Oracle Forms, Hyper-V, Bitbucket, Git, AutoCAD, Apache Maven, Istio, Splunk, Grafana, Jenkins, DataHub

Languages

SQL, XML, Java, XSL, XSD

Paradigms

DevOps, ETL, Business Intelligence (BI), Dimensional Modeling, OLAP

Platforms

Oracle, Linux, Rancher, Docker, Windows, Oracle Database, Kubernetes

Storage

Oracle PL/SQL, Oracle DBA, Oracle SQL Developer, PL/SQL, Oracle Cloud, Database Performance, Database Administration (DBA), Databases, PostgreSQL, MySQL, Data Lakes, Microsoft SQL Server

Other

Oracle8i, Oracle Data Guard, Data Modeling, Process Flows, Process Design, Agile Practices, Agile DevOps, Jira Administrator, Jira Administration, Entity-relationships Model (ERM), Windows System Administration, Networking, Architecture, VyOS, Oracle Spatial, ArduPilot, MAVLink, Data Architecture, Engineering, IT Consulting, Management Consulting, Oracle Data Miner, Graphs, Data Engineering, Roadmaps, GitOps, Data Warehouse Design, Message Bus

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.

Share your needs

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

Choose your talent

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

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