Data Architect

TEKsystems•Ann Arbor, MI

2d•$60 - $80•Remote

About The Position

This project is to establish NetBox as the single source of truth for network device inventory data and to implement bi-directional synchronization between NetBox and our current internal network inventory database (Oracle). The organization is seeking a single contractor for an anticipated 6-month engagement to support discovery, design, development, testing, documentation, and implementation of this synchronization and data migration effort. The selected contractor will work collaboratively with an internal team that has other concurrent responsibilities. Strong NetBox expertise, Oracle integration experience, and the ability to work independently and communicate clearly with a technical team are essential. Additional technical details, data samples, access information, and internal process documentation may be provided under NDA or during a later discovery phase. The project aims to establish NetBox as the single source of truth for all network device inventory data by implementing a bi-directional sync process between NetBox and Oracle (internal network inventory database), eliminating duplicate data entry across systems. This initiative will result in one authoritative source for all network device inventory data, including devices, circuits, IPs, VLANs, prefixes, tenants, and related inventory objects. It will eliminate duplicate data entry between NetBox and Oracle, lay the foundation for future network automation, reduce the risk of data inconsistencies across systems, and improve the visibility and reliability of network device inventory data. Currently, network device inventory data exists across multiple systems, including Oracle and NetBox, with no reliable sync between them, leading to duplicate entry, data inconsistencies, and limiting the team's ability to automate network management tasks. Establishing NetBox as the network device inventory single source of truth and syncing it with Oracle will resolve these issues and position the organization for broader automation efforts in the future. The sync with Oracle remains necessary to support legacy systems and existing business processes that still depend on Oracle for asset, financial, operational, or reporting data, allowing the organization to modernize its inventory management. Desired project outcomes include NetBox being the established primary source for network device inventory data entry, a live and validated bi-directional sync between NetBox and Oracle, elimination of duplicate data entry for in-scope inventory data, documented and maintained schema mapping, an operational development environment for testing, and a foundation in place for future network automation work.

Requirements

NetBox expertise
Oracle integration experience
Ability to work independently
Ability to communicate clearly with a technical team
NetBox architecture, data modeling, APIs, and operational best practices.
Oracle database integration and data extraction.
ETL/data migration design and implementation.
Network inventory data models, including devices, interfaces, IPs, VLANs, prefixes, circuits, tenants, and related objects.
Bi-directional synchronization patterns and conflict handling.
Python or other integration development languages commonly used with NetBox.
Data cleansing, validation, and reconciliation.
Documentation of schema mappings, architecture decisions, and operational procedures.
Working with network engineering teams and translating operational requirements into technical implementation.
Working independently and collaboratively within a team that has other concurrent project responsibilities.

Responsibilities

Support discovery, design, development, testing, documentation, and implementation of synchronization and data migration effort.
Deliver a production-ready sync process.
Deliver validated schema mappings.
Provide migration support.
Provide documentation.
Provide knowledge transfer.
Work collaboratively with an internal team.
Work with a degree of autonomy.
Maintain clear and regular communication.
Assist with planning, design, development, and implementation of a NetBox-to-Oracle synchronization and data migration effort.
Perform data cleansing, validation, and reconciliation.
Document schema mappings, architecture decisions, and operational procedures.
Work with network engineering teams and translate operational requirements into technical implementation.