Computrition, Inc. · 1 day ago
Senior Database Engineer (PostgreSQL)
United States
Full-time
Remote
Senior Level
7+ years expComputrition, part of Jonas Software, is focused on building a cloud-native SaaS platform for hospitals and healthcare providers. The Senior Database Engineer will be responsible for owning the database architecture for a multi-tenant SaaS and ensuring performance, reliability, and security within the PostgreSQL environment on AWS.
Customer ServicePoint of SaleSoftware
Responsibilities
Own the database architecture for a multi-tenant SaaS: select and implement tenancy model(s) (e.g., RLS per tenant, schema-per-tenant, or database-per-tenant), design schemas, and define migration/versioning strategies for safe, zero-downtime releases
Raise the performance ceiling: index strategies, partitioning, connection pooling (e.g., PgBouncer), query tuning (EXPLAIN/ANALYZE), 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 (EF Core/Dapper), 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 (e.g., pgBench/k6) 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
Qualification
Required
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
Preferred
Healthcare/HIPAA domain experience or any regulated industry (BAAs, audit readiness, PHI data handling)
Experience with zero-downtime migration patterns, logical replication, change data capture
Exposure to data warehousing/analytics pipelines or near-real-time eventing
PostGIS, TimescaleDB, or other Postgres extensions in production
Oracle experience as current database schema resides within Oracle
Migration experience from one database system to another
Company
Computrition, Inc.
As the leading provider of foodservice and healthcare software solutions, Computrition’s resonant products and services help food and nutrition professionals meet and manage the critical objectives of their operations by the efficient usage of resources, food, time and labor.
51-200 employees
Funding
Current Stage
Growth StageRecent News
Company data provided by crunchbase