Software Principal Engineer - DBA

How You’ll Make An Impact

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.

What You’ll Do

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

Database Operations & Performance:

• 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

High-Availability & Disaster Recovery:

• Maintain Global Database clusters for cross-region replication and disaster recovery
• Execute database failovers and rollbacks with zero data loss
• Implement and test backup/restore strategies for multi-TB databases

Database Upgrades & Migrations:

• Plan and execute major version upgrades 
• Design blue-green deployment strategies for zero-downtime migrations
• Validate upgrade paths across QA, ProdClone, and Production environments
• Develop rollback procedures for critical database changes

Incident Response:

• Lead database recovery efforts during production outages
• Work with Cloud vendors, third party DB experts, and internal teams to resolve complex database issues
• Provide expert guidance on database-related incidents

Security & Compliance:

• Manage database access controls and privilege management
• Implement security best practices for multi-tenant database environments
• Conduct regular security audits and vulnerability assessments
• Ensure compliance with data protection regulations

The Experience You Bring

Technical Expertise:

• 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)

Problem-Solving:

• Proven track record handling large-scale database incidents
• Ability to make critical decisions under pressure during outages
• Strong analytical skills for root cause analysis
• Solve complex problems at a massive scale.

Collaboration:

• Partner with architects, Platform, SRE, and Engineering teams
• Clear communication during incidents and post-mortems

Nice to Have:

• Percona Toolkit experience
• Experience with database automation and IaC (Terraform)
• Knowledge of Kubernetes StatefulSets for database workloads
• Prior experience in SaaS/PaaS environments

Bonus Points If You Have

• 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

Aren’t sure if you’re a match? We know that impostor syndrome and the confidence gap can prevent us from meeting spectacular candidates — so don’t hesitate to apply; you could be the perfect fit!

Location

Conshohocken, PA (preferred) or Denver, CO (Hybrid)

Compensation and Benefits 

Boomi is committed to fair and equitable compensation practices. Base compensation for this position in our corporate headquarters in Conshohocken, PA begins at $155,520. This position is remote-friendly and, as such, final compensation will be determined by various factors including the candidate’s knowledge, skills, experience, and geographic location. An overview of our benefits can be found here. 

#LI-ES1