Digital Media Solutions (DMS) is a performance-driven digital marketing company that connects consumers and brands through data, technology, and proprietary media platforms. They are seeking a Software Engineer III (Database Engineer) to ensure the reliability, performance, and scalability of production database systems, focusing on high-availability OLTP environments and integration with downstream data systems.
Responsibilities:
- Operate and optimize production database systems including MySQL, PostgreSQL, DynamoDB, and Elastic
- Design and manage binlog and logical replication strategies
- Support ELT/ETL pipelines and CDC workflows to ensure safe data movement
- Integrate transactional systems with Kafka-based streaming architectures
- Optimize database performance through query tuning, indexing, and scaling strategies
- Manage backups, failover processes, and disaster recovery (PITR)
- Monitor system health and drive infrastructure cost efficiency
- Enforce data integrity, security, and compliance standards
- Lead and support database-related incident response
Requirements:
- 5+ years of database engineering experience in production environments
- Deep hands-on experience with MySQL and/or PostgreSQL
- Experience owning and supporting high-availability OLTP systems
- Experience with binlog or logical replication
- Experience integrating OLTP systems with Kafka or similar streaming platforms
- Experience supporting ELT/ETL pipelines and data workflows
- Strong understanding of ACID principles and transaction isolation levels
- Experience troubleshooting performance issues (locking, replication lag, indexing)
- Familiarity with AWS-managed database services (RDS, Aurora, DynamoDB)
- Ability to balance performance, cost, and data integrity in production systems
- Experience implementing CDC workflows
- Experience with large-scale database migrations
- Understanding of OLTP vs OLAP workload separation
- Experience with infrastructure-as-code tools such as Terraform
- Background in high-volume, transaction-intensive environments