Find JobsSalary EstimateCareer AdviceUpload ResumeEmployers / Post JobProfileMessage Center

Software Principal Engineer - DBA

Boomi

San Diego, CA

Apply
JOB DETAILS
SKILLS
Access Control, Amazon Relational Database Service (RDS), Amazon Web Services (AWS), Architectural Services, Automation, Best Practices, Capacity Management, Cloud Computing, Communication Skills, Computer Security, Data Partitioning, Data Recovery, Database Administration, Database Clustering, Database Optimization, Database Technology, Disaster Recovery, Failover, High Availability, Information/Data Security (InfoSec), Maintain Compliance, MySQL, Performance Tuning/Optimization, Platform as a Service (PaaS), PostgreSQL, Problem Solving Skills, Query Optimization, Regulatory Compliance, Replication and Remote Mirroring, SQL (Structured Query Language), Software Engineering, Software as a Service (SaaS), Standards Development, Systems Scalability
LOCATION
San Diego, CA
POSTED
30+ days ago

As a DBA, you will lead database administration for Boomis 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 Boomis 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 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

The Experience You Bring

• 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

Bonus Points If You Have

• 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

About the Company

B

Boomi