Digital Media Solutions (DMS) is a performance-driven digital marketing company that connects consumers and brands through data, technology, and proprietary media solutions. The Transactional Database Engineer will own the reliability, performance, and compliance of production database systems while working closely with backend, data, and infrastructure teams.
Responsibilities:
- Operate and optimize production MySQL, PostgreSQL, Elastic, and DynamoDB
- Design and manage binlog and logical replication strategies
- Support safe ELT / ETL pipelines and CDC workflows
- Integrate transactional systems with Kafka streams
- Optimize performance (queries, indexing, locking, scaling)
- Manage backups, failover, and disaster recovery (PITR)
- Monitor and reduce infrastructure costs
- Enforce data integrity, security, and compliance standards
- Lead database-related incident response
Requirements:
- 5+ years of database engineering experience
- Deep production experience with MySQL and/or PostgreSQL
- Experience with binlog or logical replication
- Experience integrating OLTP systems with Kafka
- Experience supporting ELT / ETL pipelines safely
- Strong understanding of ACID and isolation levels
- Experience debugging locking, replication lag, and indexing issues
- Familiarity with AWS-managed database services
- Ability to balance performance, cost, and compliance
- CDC implementation experience
- Large-scale database migrations
- OLTP vs OLAP workload separation experience
- Infrastructure-as-code (Terraform)
- Experience in high-volume transactional environments