Trevor is available for hire
Hire TrevorTrevor N Hayward
Verified Expert in Engineering
Database Developer
Location
Visalia, United States
Toptal Member Since
November 4, 2022
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
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.
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
Languages
SQL, XML, Java, XSL, XSD
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
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
Libraries/APIs
AutoCAD API