Senior PostgreSQL Administrator Needed for Performance Tuning Workstream

Northbay Systems

Project-based · Remote · Flexible hours

About the role

Northbay Systems is enhancing a multi‑tenant B2B product with advanced data isolation features. We need a PostgreSQL Administrator to design, implement, and tune tenant‑specific schemas while ensuring high availability and security.

Key responsibilities

• Architect and deploy separate PostgreSQL instances for each tenant
• Write migration scripts and automate schema versioning
• Monitor performance, conduct capacity planning, and resolve bottlenecks
• Implement backup, restore, and disaster‑recovery procedures
• Collaborate with developers to integrate PostgreSQL with existing micro‑services

Must-have skills

• 5+ years managing PostgreSQL in production environments
• Strong knowledge of multi‑tenant architecture and security best practices
• Experience with replication, sharding, and high‑availability setups
• Proficiency in SQL tuning, indexing, and query optimization

Nice to have

• Familiarity with MongoDB and MySQL for cross‑database reporting
• Automation tools such as Ansible, Terraform, or Docker
• Background in B2B SaaS platforms