Senior Database Engineer, PostgreSQL

Job not on LinkedIn

November 25

Apply Now

Receive Emails with Similar Jobs

CORA Group

WebsiteLinkedInAll Job Openings

SaaS • Enterprise • B2B

CORA Group is a company specializing in acquiring, strengthening, and growing vertical market software companies. With extensive experience on both sides of the acquisition process, CORA Group focuses on nurturing its portfolio companies to accelerate their growth and build sustainable long-term value. The company boasts over 25 transactions, an expansive employee base, and operations in more than 150 countries across 10+ markets. CORA Group integrates new companies into its ecosystem through a detailed understanding of operational nuances and an emphasis on maintaining the unique identity of its acquisitions. Their strategy underscores long-term stability, aiming to ensure continued innovation and legacy preservation for each company within their portfolio.

501 - 1000 employees

☁️ SaaS

🏢 Enterprise

🤝 B2B

📋 Description

• 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.

🎯 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

• Competitive salary • Flexible work hours • Professional development opportunities • Health insurance • Paid time off