Database Developer, AWS, PostgreSQL

Jobtailor

Washington (District of Columbia)

On-site

USD 110,000 - 160,000

Full time

3 days ago
Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Jobtailor is seeking a Database Developer for a federal agency's enterprise data platform in Washington, DC. You will craft SQL, stored procedures, and views on Amazon Aurora, transforming data across DynamoDB, S3, and Iceberg.

The role requires 4+ years of database development, a Bachelor's degree, US citizenship, and eligibility for a Public Trust. You will collaborate with cross-functional teams and grow toward owning physical design within a governance framework.

Qualifications

  • 4+ years of database development experience.
  • Bachelor’s degree required.
  • SQL on Amazon Aurora (PostgreSQL-compatible), working with DynamoDB, S3, and Iceberg tables.
  • Stored procedures, views, and query tuning.
  • Data loading (S3 into the platform stores) and ODBC/JDBC connectivity.
  • Basic proficiency in writing, PowerPoint, and Excel.
  • Sole United States citizenship.
  • Ability to obtain a Public Trust determination.
  • Ability to commute into DC regularly.

Responsibilities

  • Build and maintain queries, stored procedures, and views for a federal agency’s enterprise data platform.
  • Work on Amazon Aurora and adjacent platform stores under a senior developer’s design.
  • Develop reliable SQL, stored procedures, and views on Amazon Aurora (PostgreSQL-compatible).
  • Work with DynamoDB, S3, and Apache Iceberg tables to transform raw data into usable data.
  • Perform query tuning, S3 data loads into platform stores, and connectivity under governed access.
  • Grow toward owning physical design.
  • Help develop new capabilities, tools, and lines of business.
  • Collaborate with developers, engineers, data scientists, architects, and strategists.

Skills

SQL Development on Aurora
Stored Procedures
Views
Query Tuning
Data Transformation
DynamoDB
Collaboration
Communication

Education

Bachelor's degree

Tools

Amazon Aurora
DynamoDB
S3
Apache Iceberg
PowerPoint
Excel
PostgreSQL

Job description

  • Build and maintain queries, stored procedures, and views for a federal agency’s enterprise data platform
  • Work on Amazon Aurora and adjacent platform stores under a senior developer’s design
  • Develop reliable SQL, stored procedures, and views on Amazon Aurora (PostgreSQL-compatible)
  • Work with DynamoDB, S3, and Apache Iceberg tables to transform raw data into usable data
  • Perform query tuning, S3 data loads into platform stores, and connectivity under governed access
  • Grow toward owning physical design
  • Help develop new capabilities, tools, and lines of business
  • Collaborate with developers, engineers, data scientists, architects, and strategists
Requirements
  • 4+ years of database development experience
  • Bachelor’s degree
  • SQL on Amazon Aurora (PostgreSQL-compatible), working with DynamoDB, S3, and Apache Iceberg tables
  • Stored procedures, views, and query tuning
  • Data loading (S3 into the platform stores) and ODBC/JDBC connectivity
  • Basic proficiency in writing, PowerPoint, and Excel
  • Sole United States citizenship
  • Ability to obtain a Public Trust determination
  • Ability to commute into DC regularly
  • Preferred: Physical-design ownership of the Aurora and Iceberg stores, or the drive to grow into it
  • Preferred: Apache Ranger-governed access
  • Preferred: Federal information technology or high-volume transaction experience
  • Preferred: Familiarity with AI-assisted developer tooling
Core Competencies

Demonstrates expertise in SQL development on Amazon Aurora, including stored procedures, views, and query tuning. Capable of transforming raw data using DynamoDB, S3, and Apache Iceberg while collaborating effectively with cross-functional teams.

Highest-signal resume keywords
  • SQL Development on Amazon Aurora
  • Stored Procedures and Views
  • DynamoDB and S3 Data Transformation
  • Query Tuning and Data Loading
  • Physical Design Ownership
Hard Skills
  • SQL
  • Stored Procedures
  • Views
  • Query Tuning
  • Data Loading
  • ODBC Connectivity
  • JDBC Connectivity
  • PostgreSQL
  • Apache Iceberg
  • Amazon Aurora
Soft Skills
  • Collaboration
  • Communication
Industry Keywords
  • Federal Information Technology
  • High-Volume Transaction Experience
  • Public Trust Determination
  • Governed Access
  • AI-Assisted Developer Tooling
Tools & Technologies
  • Amazon Aurora
  • DynamoDB
  • S3
  • Apache Iceberg
  • PowerPoint
  • Excel
Get your free, confidential resume review.
or drag and drop your file here.
Similar jobs

Similar jobs worth comparing

Senior Database Developer, AWS, PostgreSQL
Senior Database Developer, AWS, PostgreSQL

Jobtailor • Washington

On-site
USD 120,000 - 180,000
Database Developer, AWS/PostgreSQL
Database Developer, AWS/PostgreSQL

Peregrine Advisors • Washington

Hybrid
USD 115,000 - 155,000
Health insurance
401(k) with match
Unlimited PTO
+2
Database Developer
Database Developer

Inadev • Reston (VA)

Hybrid
USD 120,000 - 150,000
Junior Database Developer
Junior Database Developer

Inadev-Corporatio • Reston (VA)

Hybrid
USD 85,000 - 110,000
Aurora PostgreSQL DB Developer - SQL & Iceberg Data
Aurora PostgreSQL DB Developer - SQL & Iceberg Data

Jobtailor • Washington

On-site
USD 110,000 - 160,000
Junior Database Developer
Junior Database Developer

Inadev • Reston (VA)

Hybrid
USD 70,000 - 100,000
Junior Data Platform Engineer - AWS DB & ETL
Junior Data Platform Engineer - AWS DB & ETL

Inadev • Reston (VA)

Hybrid
USD 70,000 - 100,000
Database Developer Expert (CockroachDB experience)
Database Developer Expert (CockroachDB experience)

MAS Global Consulting • Wilmington (DE)

On-site
USD 90,000 - 130,000
Senior Software Development Engineer, Aurora PostgreSQL
Senior Software Development Engineer, Aurora PostgreSQL

Amazon • Redmond (WA)

On-site
USD 168,100 - 227,400
Health insurance
401(k) matching
Paid time off
Aurora PostgreSQL Database Administrator (DBA)
Aurora PostgreSQL Database Administrator (DBA)

TALENT Software Services • Seven Hills (OH)

On-site
USD 120,000 - 170,000