Senior Database Engineer, PostgreSQL

Job not on LinkedIn

November 25

🏄 California – Remote

Although this job is listed in California, this company may be open to hiring remote in other states.

⏰ Full Time

🟠 Senior

🔙 Backend Engineer

Apply Now

Receive Emails with Similar Jobs

Jonas Software

WebsiteLinkedInAll Job Openings

Enterprise • SaaS • B2B

Jonas Software is a prominent acquirer of vertical market software companies, with a rich history of over 20 years. The company focuses on mission-critical software solutions across various industries, aiming to provide business tools and a network for growth. Jonas Software operates under a decentralized structure, allowing acquired companies to maintain their autonomy while tapping into Jonas's extensive experience and best practices. They adhere to a 'buy & hold forever' strategy, ensuring long-term stability and a permanent home for acquired businesses. With more than 130 successful acquisitions under its belt and being part of Constellation Software, Jonas Software emphasizes preserving the legacy and culture of the companies it acquires, fostering a culture of sharing and leveraging expertise in vertical market software.

1001 - 5000 employees

🏢 Enterprise

☁️ SaaS

🤝 B2B

📋 Description

• 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