DBA III

CalAmp; Carlsbad (CA); On-site; USD 140,000 - 190,000; Full time

Job summary

CalAmp’s K-12 transportation platform tracks the buses that move ~1 million students across 400+ North American districts, with 9 production SQL Server instances on AWS EC2 and 600+ customer databases.

We’re hiring a hands-on Database Engineer who will grow into architecture, automation, and modern engineering practices. Expect on-call rotation, collaboration with developers, and a focus on performance and data architecture.

Qualifications

• 4–8 years of hands-on DBA / Database Engineering experience with a meaningful share on SQL Server.
• Database SME mindset with participatory design reviews and collaboration with developers.
• Proficiency in PostgreSQL or willingness to develop it for future reporting architecture.
• Cloud database experience on AWS; self-hosted SQL Server on EC2 today; RDS familiarity a plus.
• Strong SQL: query writing, plan reading, index design, locking and isolation.
• Ability to script in Python or PowerShell for automation.
• Experience with HA / replication topologies (Always On, log shipping).
• Excellent written communication; able to defend proposals in an opinionated engineering team.
• Bachelor’s in CS, Information Systems, or equivalent practical track.

Responsibilities

• Diagnose and fix slow queries and plan regressions across multiple SQL Server instances.
• Lead design for reporting replica architecture, separating analytical workload from operational SQL Server.
• Define archival strategy and automation for data retention across 600+ customer databases.
• Identify cost-saving opportunities in AWS (RAI, sizing, replication strategies).
• Automate schema-change processes across all customer databases with low risk.
• Review schema changes from developers and provide actionable design insights and optimization.
• Participate in on-call rotation (light by industry standards, with defined hours).
• Collaborate with AI-enabled tooling to improve development and operational workflows.

Skills

SQL Server

Performance tuning

Python/PowerShell

Linux/Windows

Always On/Replication

Index design

SQL plan analysis

Communication

Education

Bachelor’s in CS / Information Systems or equivalent

Tools

AWS EC2

AWS RDS (plus)

PostgreSQL (plus)

Job description

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.

Equal Employment Opportunity
CalAmp is an Equal Opportunity Employer. We are committed to providing equal employment opportunities to all applicants and employees and do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, protected veteran status, genetic information, or any other characteristic protected by applicable federal, state, or local law. Employment decisions are based on qualifications, merit, and business needs.

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.

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.