Database Administrator (DBA) / Database Engineer at CalAmp

Detroit, Michigan, United States -

Full Time

Start Date

Immediate

Expiry Date

17 Oct, 26

Salary

158587.0

Posted On

19 Jul, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Microsoft SQL Server, PostgreSQL, AWS EC2, Performance Tuning, Python, PowerShell, High Availability, Database Architecture, AWS DMS, Aurora PostgreSQL, Schema Migration, ETL, Query Optimization, Linux, Windows, Multi-tenant SaaS

Industry

Software Development

Description

Overview CalAmp’s K-12 transportation platform tracks the buses that move ~1 million students every school day across 400+ North American school districts. We run Microsoft SQL Server self-hosted on AWS EC2 — 9 production instances, 600+ customer databases, more than a billion rows of operational data, and growing. (An eventual move to AWS RDS is on the table as a future direction, not a near-term plan.) We’re hiring a hands-on Database Engineer with strong production experience who is ready to grow into architecture, automation, and modern engineering practices. Responsibilities What you'll work on Performance — the daily craft. Diagnose and fix slow queries, plan regressions, and locking storms across 9 SQL Server instances supporting customer-facing operations. You’ll inherit a decade of accumulated SQL — your first 90 days are about understanding it before re-architecting it. Reporting replica architecture. We need to separate analytical workload from operational SQL Server before it costs us customer SLAs. You’ll lead the design — likely AWS DMS feeding a multi-tenant Aurora PostgreSQL store, but the call is yours after scoping. This is a flagship project, not a maintenance task. Archival. Sound data retention strategy across 600+ customer DBs that doesn’t degrade restore-from-backup integrity. You’ll define the policy and own the automation. AWS cost. SQL Server EE licensing on EC2 isn’t cheap. There’s measurable savings on the table for a DBA/Database Engineer who knows where to look — edition choice, reserved instances, right-sizing, replica strategy. Schema migrations and ETL. Schema-change process across all customer DBs. Today this is partially manual; the goal is to make it automated, reliable, and low-risk. Database SME for engineering — a core part of this role. You’re the subject-matter expert who reviews every schema change from developers before it ships, and you bring actionable design insight — not just approvals. Profile and optimize queries and stored procedures alongside the engineers writing them. You’re the “is this going to scale?” voice in design reviews — adding insight where it counts, not gatekeeping for the sake of it. On-call rotation. Light by industry standards: rotation runs once every five weeks, with on-call hours from 6 AM to 11 PM Eastern. We try to keep paging events rare; we expect you to push us toward making them rarer. What's different about this team We use AI tools across the development lifecycle — including query analysis, schema changes, runbook authoring, and operational workflows. Our engineers ship more code per sprint with Claude Code as a pair-programmer, and we expect our DBA to do the equivalent for database work. We value candidates who are open to integrating AI into their workflow to improve speed and quality. If it means restructuring how you operate, we want to talk. We’re not hiring “AI experience” as a checkbox. We’re hiring people willing to rethink their craft. Qualifications Must-haves 4–8 years of hands-on DBA / Database Engineering experience, meaningful share on SQL Server Database SME mindset — you’ve reviewed engineering schema changes, contributed design insight in code/architecture reviews, and partnered with developers (not gatekept them). This is a core part of the role, not a side responsibility. PostgreSQL proficiency — or willingness to develop it (aligned to future reporting architecture) Cloud database experience on AWS — self-hosted SQL Server on EC2 today; RDS familiarity is a plus given a possible future migration Performance tuning track record — you can talk through specific queries you fixed and how Strong SQL: query writing, plan reading, index design, locking and isolation Comfort scripting in Python or PowerShell for automation Linux and Windows both HA / replication topologies (Always On, log shipping, transactional) Strong written communication — this is an opinionated engineering team; you’ll write proposals and defend them Bachelor’s in CS, Information Systems, or equivalent practical track Strong pluses Multi-tenant SaaS data architectures (per-customer databases or shared schemas) AWS DMS or other CDC replication experience Aurora PostgreSQL AWS cost optimization (Reserved Instances, Savings Plans, sizing) Datadog, Dynatrace, or similar APM Experience using AI-assisted development tools (helpful but not required) Background in operationally-critical SaaS (transportation, healthcare, finance) What we don’t expect You don’t need K-12 domain experience. You don’t need MongoDB. You don’t need IoT background. Show up curious; we’ll teach the domain. Logistics Applicants must be legally authorized to work in the US on a permanent basis. We are unable to sponsor at this time. If this is the right fit, apply now — interviews this week and next. Market Minimum USD $92,509.00/Yr. Market Maximum USD $158,587.00/Yr.

Responsibilities

The role focuses on optimizing performance, managing archival strategies, and reducing AWS costs for a large-scale SQL Server environment. The candidate will also lead the design of a reporting replica architecture and serve as the database SME for engineering schema reviews.