Senior Database Administrator

Kaseware, Inc.
Denver, United States of America
28 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 165K

Job location

Remote
Denver, United States of America

Tech stack

Query Performance
Audit Trail
Databases
Data Architecture
Data Visualization
Database Design
Query Languages
Disaster Recovery
Document-Oriented Databases
Graph Database
Identity and Access Management
PostgreSQL
SQL Azure
Neo4j
Operational Databases
Performance Tuning
Query Optimization
Azure
Database Optimization
Caching
Database Migration
Information Technology
Database Monitoring
Sql Tuning

Job description

We are looking for a Senior Database Administrator to join our Engineering organization. You will own the health, performance, and design of Kaseware's data visualization tier, primarily Metabase using PostgreSQL across on-premise, commercial and Government customer environments. You will report into Engineering and partner closely with our Data team, whose work is customer-facing: dashboards, reports, and analytics that our customers see and depend on every day. The role is a blend of hands-on operations, deep performance tuning and query optimization, and architecture-level data work that directly shapes the experience our customers have with the product., * 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

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

Other Requirements:

  • Language: English
  • Active DoD Secret clearance, or eligibility to obtain one, is a plus

Benefits & conditions

Paid parental leave, Parental leave, 401(k) matching, Vision insurance, Dental insurance, Paid sick time, Paid holidays, * Base salary range: $135,000 - $165,000 annually

  • 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

About Kaseware:

Kaseware is a rapidly growing start-up located in the Denver metro area. We build state-of-the-art software for law enforcement and corporate security customers. We serve those that serve our communities and make our world safer.

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

About the company

Do you love working with data at scale, and do you want to know that your work helps keep communities safer? Kaseware builds case management and investigations software trusted by law enforcement, government, and corporate security teams. The data our customers rely on for critical investigative and operational work lives in the databases you will help design, tune, and operate - and that is where you come in.

Apply for this position