Senior AWS PostgreSQL DB Architect (Iceberg/Scale)

Jobtailor; Washington (District of Columbia); On-site; USD 120,000 - 180,000; Full time

Job summary

Jobtailor in Washington, DC is seeking an experienced database developer to own the enterprise data platform layer for a federal agency. You will design physical structures, tune large-scale queries, and develop robust data models while implementing schema migrations and secure access.

Responsibilities include coordinating with engineers, data scientists, and architects to tackle complex client problems and to evolve capabilities within the data platform environment.

Qualifications

• 7+ years of database development and administration experience.
• Bachelor’s degree required.
• Sole United States citizenship with ability to obtain a Public Trust determination.
• Hands-on experience with Amazon Aurora (PostgreSQL-compatible), DynamoDB, and S3 with Apache Iceberg tables.
• Physical design at scale: partitioning, indexing, and storage layout.
• Query and EXPLAIN-plan tuning on large datasets.
• Logical and physical data modeling.
• PL/pgSQL stored procedures.
• S3 load patterns into relational and Iceberg stores.
• Familiarity with Schema migration tooling such as AWS SCT.

Responsibilities

• Own the database layer of a federal agency’s enterprise data platform.
• Design physical database structures, including partitioning and indexing at scale.
• Tune queries and execution plans on large datasets.
• Develop durable logical and physical data models.
• Build and maintain schema migrations.
• Implement S3 load patterns into relational and Iceberg stores.
• Develop stored procedures.
• Establish governed access using Apache Ranger controls.
• Contribute to new capabilities, tools, and lines of business.
• Collaborate with developers, engineers, data scientists, architects, and strategists on complex client problems.

Skills

Database Development

Physical Design

Query Tuning

Data Modeling

Schema Migration

S3 Load Patterns

Partitioning

Indexing

Execution Plans

Access Controls

Education

Bachelor’s Degree

Tools

Apache Ranger

AWS Schema Conversion Tool

Neptune

Neo4j

Job description

Jobtailor in Washington, DC is seeking an experienced database developer to own the enterprise data platform layer for a federal agency. You will design physical structures, tune large-scale queries, and develop robust data models while implementing schema migrations and secure access.

Responsibilities include coordinating with engineers, data scientists, and architects to tackle complex client problems and to evolve capabilities within the data platform environment.