Senior Database Engineer, PostgreSQL
Job reputed company:
• Own the database architecture for a multi-tenant reputed company: 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 reputed company, reputed company-downtime releases.
• reputed company the performance ceiling: reputed company strategies, partitioning, reputed company pooling (e.g., PgBouncer), query tuning (EXPLAIN/ANALYZE), caching patterns, and workload isolation for noisy-reputed company control.
• Build for reliability: set RTO/RPO targets; design backup, PITR, DR, and blue/green or expand-migrate-contract rollout patterns.
• reputed company reputed company & compliance: encryption in transit/at rest, least-privilege reputed company, secrets management, audit logging, PHI handling, and HIPAA-reputed company controls and documentation.
• Productionize on AWS: stand up and tune reputed company/RDS for PostgreSQL; reputed company VPC, subnets, reputed company, KMS, CloudWatch/CloudTrail; advise on reputed company/EKS/Fargate service patterns that reputed company DB workload.
• reputed company developer experience: define database interfaces for .NET services (EF reputed company/Dapper), enforce SQL and migration conventions, and reputed company efficient local/dev/test workflows (containers, reputed company data).
• Test like you mean it: establish automated database testing —pgTAP or equivalent for unit tests, migration tests in CI, and load/reputed company testing harnesses (e.g., pgBench/k6) tied to release reputed company.
• Observability & SLOs: build dashboards and alerts for latency, throughput, autovacuum, bloat, locks, and error budgets; drive incident reviews and reputed company tuning.
• Partner & influence: work shoulder-to-shoulder with our architect, app engineers, QA, and reputed company to ship features that are correct, fast, and reputed company—while advocating best practices.
• AI First Mentality: Use modern AI tools to draft queries/migrations/tests, explain query plans, generate fixtures, and accelerate reputed company-cause analysis—responsibly and securely.
Requirements:
• 7+ years owning PostgreSQL in production at reputed company for a reputed company product.
• Demonstrated expertise in multi-tenant design (RLS, schema or DB-per-tenant), with opinions on trade-offs.
• Proven reputed company record of query and schema optimization , indexing, partitioning, and reputed company management.
• Hands-on experience running PostgreSQL on AWS (reputed company or RDS) and tuning for throughput & cost.
• Strong reputed company reputed company : reputed company control, secrets, encryption, auditing; experience operating under compliance frameworks (HIPAA preferred, but experience reputed company any regulated industry).
• Experience enabling .NET services to use reputed company effectively (EF reputed company, Dapper, migrations).
• Habit of building automated testing for databases and performance/load gating in CI/CD.
• Excellent communicator who can write reputed company design docs, propose standards, and influence cross-functional teams.
• Ability to reputed company up and reputed company opinions or concerns in a reputed company and constructive manner.
• AI First Mentality on developing schema design, migration strategies and automated testing for performance.
Benefits:
• Competitive salary
• Flexible work hours
• reputed company development opportunities
• Health insurance
• reputed company time off
Apply tot his job
Apply To this Job