Jonas Software

Senior Database Engineer, PostgreSQL

Jonas Software

full-time

Posted on:

Location Type: Remote

Location: Remote • California • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AWS.NETPostgresSQL

About the role

  • Own the database architecture for a multi-tenant SaaS: select and implement tenancy model(s), design schemas, and define migration/versioning strategies for safe, zero-downtime releases.
  • Raise the performance ceiling: index strategies, partitioning, connection pooling, query tuning, caching patterns, and workload isolation for noisy-neighbor control.
  • Build for reliability: set RTO/RPO targets; design backup, PITR, DR, and blue/green or expand-migrate-contract rollout patterns.
  • Embed security & compliance: encryption in transit/at rest, least-privilege access, secrets management, audit logging, PHI handling, and HIPAA-aligned controls and documentation.
  • Productionize on AWS: stand up and tune Aurora/RDS for PostgreSQL; integrate VPC, subnets, SGs, KMS, CloudWatch/CloudTrail; advise on ECS/EKS/Fargate service patterns that affect DB workload.
  • Level-up developer experience: define database interfaces for .NET services, enforce SQL and migration conventions, and enable efficient local/dev/test workflows (containers, seed data).
  • Test like you mean it: establish automated database testing —pgTAP or equivalent for unit tests, migration tests in CI, and load/perf testing harnesses tied to release criteria.
  • Observability & SLOs: build dashboards and alerts for latency, throughput, autovacuum, bloat, locks, and error budgets; drive incident reviews and continuous tuning.
  • Partner & influence: work shoulder-to-shoulder with our architect, app engineers, QA, and security to ship features that are correct, fast, and safe—while advocating best practices.
  • AI First Mentality: Use modern AI tools to draft queries/migrations/tests, explain query plans, generate fixtures, and accelerate root-cause analysis responsibly and securely.

Requirements

  • 7+ years owning PostgreSQL in production at scale for a SaaS product.
  • Demonstrated expertise in multi-tenant design (RLS, schema or DB-per-tenant), with opinions on trade-offs.
  • Proven track record of query and schema optimization, indexing, partitioning, and connection management.
  • Hands-on experience running PostgreSQL on AWS (Aurora or RDS) and tuning for throughput & cost.
  • Strong security mindset: access control, secrets, encryption, auditing; experience operating under compliance frameworks (HIPAA preferred, but experience within any regulated industry).
  • Experience enabling .NET services to use Postgres effectively (EF Core, Dapper, migrations).
  • Habit of building automated testing for databases and performance/load gating in CI/CD.
  • Excellent communicator who can write clear design docs, propose standards, and influence cross-functional teams.
  • Ability to speak up and express opinions or concerns in a positive and constructive manner.
  • AI First Mentality on developing schema design, migration strategies and automated testing for performance.
Benefits
  • Health insurance
  • Flexible work arrangements
  • Professional development opportunities

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
PostgreSQLmulti-tenant designquery optimizationindexingpartitioningconnection managementautomated testingschema designmigration strategiesperformance testing
Soft skills
excellent communicationinfluencing cross-functional teamspositive expression of opinionscollaborationadvocating best practices
Certifications
HIPAA compliance