Database Administrator (DBA) / Database Engineer

CalAmp is a company that operates a K-12 transportation platform tracking buses for over 1 million students across North America. They are seeking a hands-on Database Engineer with strong production experience to manage and optimize their SQL Server databases, lead architectural improvements, and implement automation and modern engineering practices.

Responsibilities:

• Diagnose and fix slow queries, plan regressions, and locking storms across 9 SQL Server instances supporting customer-facing operations
• Lead the design of reporting replica architecture, likely AWS DMS feeding a multi-tenant Aurora PostgreSQL store
• Define and own the automation of a sound data retention strategy across 600+ customer DBs
• Identify cost-saving opportunities related to SQL Server EE licensing on EC2
• Make schema-change processes across all customer DBs automated, reliable, and low-risk
• Review every schema change from developers and provide actionable design insight
• Profile and optimize queries and stored procedures alongside engineers
• Participate in an on-call rotation that runs once every five weeks, with on-call hours from 6 AM to 11 PM Eastern

Requirements:

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