OPENDataJobs
OPENDataJobs
OPENDataJobs is a recruitment and career platform focused on connecting AI, data, and software professionals with federal-sector opportunities. It publishes current openings from its recruiting system and organizes them across seven categories and 25 standardized roles, with guidance on responsibilities, key skills, and career paths. The platform covers hiring across federal agencies, contractors, consulting firms, and technology providers, and supports applications through a secure recruiting system. OPENDataJobs operates as a division of Peregrine Advisors Benefit, Inc.

Database Developer (SQL) — Hybrid in Washington

Design and develop SQL databases, data pipelines, and scalable models for Peregrine Advisors’ federal AI and data platforms. Improve the performance, security, and auditability of AWS database systems handling high-volume workloads.

Description

  • Create database schemas and develop views, stored procedures, functions, and SQL queries
  • Develop and support ETL/ELT pipelines, including data loads from Amazon S3
  • Tune databases and queries for high-volume processing
  • Contribute to data modeling across AWS services such as Amazon Aurora, DynamoDB, and S3
  • Protect data quality and security through controlled access and auditable changes
  • Define data access patterns and integrations in partnership with developers, architects, and data engineers
  • Apply AI-assisted tools to query development, pipeline work, and troubleshooting when appropriate, and verify their results
  • Manage assigned database components throughout design, implementation, and maintenance
  • Automate routine data-loading and validation tasks
  • Develop scalable data models for a federal enterprise platform

Requirements

  • At least four years of experience in database development
  • Bachelor’s degree
  • Hands-on expertise with Amazon Aurora for PostgreSQL, including schema design, stored procedures, functions, and indexing
  • Experience modeling data in Amazon DynamoDB, including Global Secondary Indexes and Local Secondary Indexes
  • Strong SQL capability covering complex queries, views, stored procedures, functions, relational design, normalization, and data modeling
  • Experience improving performance through indexing and execution-plan analysis
  • Experience developing ETL and ELT workflows and integrating AWS data services such as Aurora, DynamoDB, and S3
  • Experience applying data-security controls, including encryption, access management, and auditing
  • Experience loading data from S3 and connecting through ODBC and JDBC
  • Experience making logical data-modeling and database-design decisions within an established platform architecture
  • Proficiency with written communication, PowerPoint, and Excel
  • United States citizenship is required for the initial engagement
  • Ability to obtain a Public Trust determination
  • Preferred: AWS associate-level certification, such as Developer Associate or Solutions Architect Associate
  • Preferred: Experience tuning queries affected by locking and deadlocks
  • Preferred: Familiarity with AWS CI/CD and DevSecOps practices
  • Preferred: Experience owning physical Aurora and DynamoDB schema and index design, or willingness to develop that capability
  • Preferred: Experience in federal information technology or high-volume transaction environments
  • Preferred: Familiarity with AI-assisted developer tools

Benefits

  • Medical, dental, and vision coverage with the employee premium fully paid and half of dependent premiums covered
  • Employer-paid life, accidental death, and short- and long-term disability insurance
  • 401(k) contributions matched at 100% up to 4% of salary, with immediate vesting
  • Unlimited paid time off
  • Sponsored professional certifications and continuing education
  • Comprehensive onboarding program
  • Cross-functional rotations to broaden skills and perspective

Related Jobs

Tapcheck

Senior Performance Marketing Manager - Tapcheck Hybrid

Tapcheck
51 – 200 Employees
FinanceFintechHR Tech

Lead Tapcheck’s paid acquisition strategy across Google Ads, Microsoft Ads, and LinkedIn Ads for its on-demand pay platform. Own pipeline growth, conversion optimization, attribution, and revenue efficiency.

Open
IGS Energy

Residential Solar Services Partner | IGS Energy | Ohio Remote

IGS Energy
1,001 – 5,000 Employees
eCommerceEnergy

IGS Energy is hiring a remote Residential Solar Services Partner in Ohio to coordinate maintenance services, contractors, customers, and invoicing. The role manages service cases, documentation, payments, and customer experience from initiation through completion.

Open
Reserve Bank of New Zealand

Senior Licensing and Authorisations Analyst – Wellington Onsite

Reserve Bank of New Zealand
201 – 500 Employees
BankingFinanceGovernment

Support the Reserve Bank of New Zealand’s deposit-taker licensing work under the Deposit Takers Act. Help build regulatory processes, define business requirements, and monitor risks for a new licensing capability.

Open