Note: The job is a remote job and is open to candidates in USA. Kaseware is a rapidly growing start-up located in the Denver metro area that builds state-of-the-art software for law enforcement and corporate security customers. They are seeking a Senior Database Administrator to own the health, performance, and design of their data visualization tier, primarily Metabase using PostgreSQL.
Responsibilities
- 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
Skills
- Bachelor's degree in Computer Science, Computer Information Systems, Engineering, or a related field, or equivalent professional experience
- 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
- 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
- Language: English
- Due to the nature of our business, you must be able to pass a full CJIS compliant fingerprint based background check, which is required for individuals needing access to criminal justice information (CJI)
- 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
- Active DoD Secret clearance, or eligibility to obtain one, is a plus
Benefits
- Excellent health, dental, and vision insurance with generous company contribution
- Flex Spending Accounts
- Unlimited paid vacation
- 12 paid company holidays
- Paid Sick Time
- Paid Parental Leave
- 401k with company matching
- EcoPass provided for Colorado-based employees
Company Overview