Senior Database Administrator
About The Position
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. 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.
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
- English language proficiency
- Must be able to pass a full CJIS compliant fingerprint based background check
- U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.
Nice To Haves
- Broader Azure data services experience is a plus
- 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
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
Benefits
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
