Resumen:
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.
**Responsabilidades**:
**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.
**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’re not hiring “AI experience” as a checkbox. We’re hiring people willing to rethink their craft.
Calificaciones:
**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.

📌 Sr. Database Administrator (Dba) / Sr. Database Engineer (Ciudad de México)
🏢 LoJack
📍 Ciudad de México