Own day-to-day administration of Kaseware’s PostgreSQL and Metabase deployments, including configuration, capacity, backups, and recovery
Lead query and database performance tuning explain plan analysis, index design and review, connection pooling, etc
Partner with the Data team to optimize Metabase performance – query review, dashboard tuning, source-database optimization, caching strategies, and Metabase application database administration
Provide schema design review, data modeling guidance, and migration support to engineering teams shipping new features
Design and maintain backup, restore, and disaster recovery strategies that meet customer and compliance requirements (RPO/RTO)
Implement and operate database monitoring, alerting, and observability – query performance, slow logs, replication health, and capacity trends
Establish and document database standards, runbooks, and best practices; mentor engineering and data team members on database design and SQL performance
Contribute new ideas and improvements to the Kaseware data architecture as the platform and customer footprint grow
Requirements
5+ years of professional database administration experience, including significant time owning production database environments at scale
Expert-level PostgreSQL skills – deep performance tuning, index strategy, query plan analysis, vacuum/autovacuum tuning, replication, partitioning, extensions, and connection pooling (PgBouncer or comparable)
Hands-on experience with Azure Database for PostgreSQL (Single Server, Flexible Server, or Hyperscale/Citus); broader Azure data services experience is a plus
Production experience with Metabase or comparable BI/reporting platforms, including performance tuning of dashboards and the underlying source databases
Schema design, data modeling, and database migration experience for production systems
Experience supporting compliance-driven environments (FedRAMP, SOC 2, ISO 27001, CJIS, or similar), particularly with respect to database controls – encryption, access management, and audit logging – is strongly preferred
Familiarity with graph databases (e.g., ArangoDB, Neo4j, JanusGraph, or comparable) and graph query languages is a strong plus
Strong written and verbal communication; able to translate technical findings into clear guidance for engineering and data team partners
Ability to work independently, prioritize against team objectives, and operate effectively in a hybrid or remote environment
Tech Stack
Azure
Neo4j
Postgres
SQL
Benefits
Excellent health, dental, and vision insurance with generous company contribution