Database Developer

i360technologies, Inc.•Washington, DC

About The Position

At i360technologies, we deliver business consulting and technology solutions that support the mission of federal agencies. We are seeking a Database Developer to design and implement the data architecture supporting the federal agency’s BOAT low-code platform. This role is responsible for data modeling, integration, migration, and ensuring secure, scalable data operations aligned with federal data and security requirements. The Database Developer will implement the data model, data platform read/write, external API consumers, file metadata schema, and Data Migration Plan if applicable. This role supports data security controls and ATO data-handling artifacts. The Database Developer will own the data and integration backbone of the BOAT platform for the client. This includes designing and implementing the data model, file metadata schema, data platform read / write integrations, and external API consumers that connect BOAT to the pilot Program and the broader registration, inspection, compliance, and enforcement data ecosystem (SafeSpect, State PCR Repository, ELD data, TruData, CCFP Analysis Datamart). The role also involves producing the Data Migration Plan when applicable and leading all data-handling artifacts that support Authority to Operate (ATO).

Requirements

Minimum 7 years of hands-on database development experience across relational engines (PostgreSQL, Oracle, SQL Server) and at least one document or non-relational store (MongoDB, DynamoDB, Cosmos DB, or equivalent).
Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related discipline (or equivalent professional experience).
Demonstrated hands-on experience with AWS data services — RDS, Aurora, DynamoDB, S3, Glue, Lambda, or comparable — operating inside an AWS Virtual Private Cloud (VPC).
Demonstrated data migration experience on regulated federal systems — including source profiling, schema mapping, transformation, validation, and rollback.
Strong API design and integration experience — REST / JSON, OAuth, API gateways, message-based integration patterns.
Working knowledge of federal data security and privacy requirements: FISMA, Privacy Act of 1974, NIST SP 800-53, NIST SP 800-122, DOT Order 1351.37, and Sensitive PII handling.
Experience supporting Authority to Operate (ATO) — producing data-layer evidence for system security plans, control narratives, and continuous monitoring.
Experience with APIs and data integration pipelines
Experience working in agile development environments
Ability to obtain and maintain a federal Public Trust (suitability) clearance
Must be able to pass a federal background investigation
U.S. Citizenship or Permanent Residency required (no visa sponsorship available)

Nice To Haves

Hands-on experience with the proposed BOAT platform's data layer (Power Platform / Dataverse, Unqork, Appian, ServiceNow, or equivalent).
Experience with regulated mission data sets.
Familiarity with Login.gov or other federated identity solutions and how they propagate into row-level / role-based data access.
Performance-tuning expertise on Oracle 19c PL/SQL, SQL Server, or PostgreSQL for high-volume federal workloads.
Familiarity with SAFe Agile, two-week sprint cadence, and the JIRA / Confluence toolchain.

Responsibilities

Design and implement the BOAT data model supporting case management, dynamic data collection, role-based access, and persona-based reporting and analytics for the pilot Program.
Build read / write integrations with the client data platform; implement external API consumers to ingest data from SafeSpect, State PCR repositories, ELD feeds, and other authoritative sources.
Implement the file metadata schema for narrative reports, images, video, and other artifacts uploaded through the BOAT submission interface; ensure metadata associates each file to the correct case record.
Author the Data Migration Plan when applicable — source-system profiling, mapping, transformation rules, validation, and rollback strategy — with delivery at the end of Discovery (Week 2).
Implement and document data-security controls aligned to client policy, NIST SP 800-53, NIST SP 800-122 PII protection, and FIPS 140-2 encryption; produce data-handling evidence for the A&A artifact pack.
Cross-train on BOAT platform configuration during Discovery and pair regularly with the Senior Software Developer to mitigate single-point-of-failure risk on platform-specific work.
Support performance testing in Sprint 5 — query optimization, indexing, data volume profiling, concurrency tuning — and execute remediation in Sprint 6.
Contribute to the Detailed Technical Design Document and the User Guide with data-layer architecture, schemas, integration contracts, and operations guidance.
Sustain the data layer across option periods — refactor only where unique business rules require it; reuse and normalize patterns across applications to reduce long-term maintenance cost.