Senior Database Developer (PostgreSQL)

As a Senior Database Developer, you will own the databases behind a federal enterprise data platform, designing and maintaining them to ensure performance, reliability, and data integrity. You will work alongside developers, engineers, and data scientists to deliver a database layer that analysts and systems can trust at scale.

What You Will Do

Your primary responsibilities will include designing and maintaining databases that scale, building and supporting extract, transform, and load (ETL) and extract, load, and transform (ELT) pipelines, and securing databases with least-privilege access and keeping them auditable.

Why It Might Be a Fit

We are looking for a skilled and motivated individual who has a combination of intellectual curiosity and intellectual courage. You will have the opportunity to help shape the company we become and work on challenging problems that require sound judgment and adaptability.

Requirements

• 7+ years of hands-on database development and database engineering experience in support of enterprise applications
• Expertise in Amazon Aurora (PostgreSQL-compatible), covering schema design, stored procedures and functions, indexing, and execution-plan analysis
• Experience with Amazon DynamoDB, covering data modeling, partition and key design, and Global and Local Secondary Indexes (GSIs and LSIs)
• Advanced SQL skills across complex queries, views, stored procedures, and functions, together with relational design, normalization, and data modeling
• Performance and query tuning that resolves slow queries, locking, and deadlocks through indexing and execution-plan work
• ETL and ELT development and data integration across Amazon Web Services (AWS) data services, such as Amazon Relational Database Service (RDS), S3, and data migration services
• Data security controls such as encryption, access management, auditing, and compliance
• Support for cloud-native applications in AWS through CI/CD and development, security, and operations (DevSecOps) practices, including monitoring, backup and recovery, high availability, and disaster recovery
• Proficiency in writing, PowerPoint, and Excel
• AWS certification at the level of Database Specialty, Developer Associate, or Solutions Architect
• Federal information technology experience with systems that require security controls and compliance frameworks
• Experience with high-volume transaction processing, large-scale data platforms, or regulatory reporting
• Experience with database observability and monitoring tools such as Amazon CloudWatch, Performance Insights, Datadog, or Splunk
• Experience with Amazon Redshift, AWS Glue, AWS Database Migration Service (DMS), or AWS Lake Formation
• Experience with infrastructure as code, including Terraform, CloudFormation, and the AWS Cloud Development Kit (CDK)
• Experience with artificial intelligence (AI)-assisted development tooling

Benefits

• Medical, dental, and vision with the employee premium fully paid and half of dependent premiums
• Employer-paid life, accidental death, and short-term and long-term disability insurance
• 401(k) matched 100% up to 4% of salary, vesting immediately
• Unlimited paid time off
• Sponsored professional certifications and continuing education