Software Principal Engineer - DBA
About The Position
Are you ready to work at a fast-growing company where you can make a difference? Boomi aims to make the world a better place by connecting everyone to everything, anywhere. Our award-winning, intelligent integration and automation platform helps organizations power the future of business. At Boomi, you’ll work with world-class people and industry-leading technology. We hire trailblazers with an entrepreneurial spirit who can solve challenging problems, make a real impact, and want to be part of building something big. If this sounds like a good fit for you, check out boomi.com or visit our Boomi Careers page to learn more. As a DBA, you will lead database administration for Boomi's multi-region, high-availability Aurora MySQL/PostgreSQL infrastructure supporting millions of integration processes and billions of transactions monthly. You will work with product management, other engineering teams, customer success and support on developing cutting edge new product features and enhancements across various areas of Boomi offerings.
Requirements
- 7+ years production DBA experience with wide variety of databases and technologies
- Deep knowledge of AWS Aurora RDS, replication, and failover mechanisms
- Strong SQL optimization and performance tuning skills
- Experience with 40+ TB databases and high-transaction environments
- Proficiency with database monitoring tools (New Relic, CloudWatch, PMM)
- Proven track record handling large-scale database incidents and ability to make critical decisions under pressure during outages
- Solve complex problems at a massive scale
- Clear communication during incidents and post-mortems
Nice To Haves
- Experience with database automation and IaC (Terraform)
- Knowledge of Kubernetes StatefulSets for database workloads
- Prior experience in SaaS/PaaS environments
- Experience with MySQL Cluster or Group Replication
- Knowledge of AWS Database Migration Service (DMS)
- Familiarity with monitoring and alerting tools (New Relic, etc.)
- Experience with automated backup and failover solutions
- Understanding of database capacity planning and resource optimization
Responsibilities
- Lead database administration for Boomi's multi-region, high-availability Aurora MySQL/PostgreSQL infrastructure supporting millions of integration processes and billions of transactions monthly.
- Lead design and architectural discussions to strategize, define, and implement highly scalable backend database systems that provide exceptional resilience and contribute to 99.999% (5-9s) uptime.
- Define database standards, patterns, and best practices across the organization.
- Manage extremely large and wide variety of databases in production across multiple regions
- Optimize database performance for RedSky and Shard databases, perform index optimization, query tuning, and capacity planning to support growing workloads
- Monitor and resolve database performance issues during incidents working with Cloud vendors, third party DB experts, and internal teams to resolve complex database issues
- Maintain Global Database clusters for cross-region replication and disaster recovery
- Execute database failovers with zero data loss while maintaining zero-downtime with robust roll-back procedures in place
- Implement and test backup/restore strategies for multi-TB databases
- Manage database access controls and privilege management by implementing security best practices for multi-tenant database environments. Ensure compliance with data protection regulations
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
