toptal.com
Contact us: +1.888.867.7001
Trevor N Hayward, Database Developer in Visalia, United States
Trevor N Hayward

Database Developer in Visalia, United States

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.
Trevor is now available for hire
Hire Trevor

Portfolio

  • Aloft UAV
    Oracle Cloud, Oracle Application Express (APEX), Jira, Atlassian Suite...
  • ITSoft
    Linux, PostgreSQL, MySQL, Kubernetes, Maven, Jira, Hyper-V, Networking...
  • CaseIntel Corporation
    Oracle, Oracle DBA, Oracle RAC, Oracle Data Guard, Oracle PL/SQL...

Experience

Location

Visalia, United States

Availability

Full-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.

Employment

  • 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, Oracle Graph, 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, 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, Oracle Graph, Management Consulting, IT Consulting, Process Reengineering, 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, Process Reengineering, 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, Oracle Graph, 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

  • 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, 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, Process Reengineering, IT Consulting, Management Consulting, Oracle Graph, Oracle Data Miner, Data Engineering, Roadmaps, GitOps, Data Warehouse Design, Oracle XML, Message Bus

  • Libraries/APIs

    AutoCAD API

To view more profiles

Join Toptal
Share it with others
Hire the top 3% of freelance developers TM