Vertica Database Administrator (DBA) - Data & BI Platform Engineering

Job Description

Vertica Database Administrator (DBA) Data & BI Platform Engineering EIS

Full time - Springfield or Boston

The Opportunity

We are seeking a highly skilled Vertica DBA to join our team and help support multiple Vertica EON clustered environments. This role is pivotal in ensuring the reliability, scalability, and security of our data infrastructure. The ideal candidate will combine deep technical expertise with a collaborative, solutions-driven mindset, supporting mission-critical operations and driving continuous improvement across our database landscape.

• Production Support & Monitoring:
  Provide 24/7/365 support for Vertica database systems, ensuring high availability, rapid incident response, and proactive performance monitoring across clustered environments.
• Database Administration:
  Oversee all aspects of Vertica database technology, including backup and recovery, server architecture, performance tuning, security, encryption, auditing, metadata management, optimization, statistics, capacity planning, connectivity, and other data solutions for mission-critical systems.
• Problem Solving & Optimization:
  Tackle complex business challenges related to data processing, loading, performance improvements, storage, and replication. Apply advanced troubleshooting skills to stabilize and optimize database operations.
• Technical Leadership:
  Collaborate closely with technical teams, providing expert guidance on best practices for database technology and distributed deployments. Mentor peers and contribute to a culture of knowledge sharing.
• Automation & Process Improvement:
  Design and implement automation for database monitoring and alerting. Drive continuous improvement by developing and standardizing operational procedures.
• Capacity & License Management:
  Monitor Vertica capacity planning and license management to ensure efficient resource utilization and compliance.
• Data Integrity & Utility Management:
  Maintain data integrity through effective utility and disk management procedures, safeguarding the reliability and accuracy of enterprise data.

The Team

Our team is comprised of two project managers and three specialized squads: DBA, BI Platform Engineering, and Cloud Engineering. Collectively, these squads include seven onshore and eleven offshore engineers, each bringing a high level of expertise to support the stability and reliability of our data and business intelligence platforms. We maintain a highly collaborative culture, unified in our commitment to operational excellence. Regardless of experience level, team members consistently demonstrate professionalism and a willingness to support one another. Through our shared dedication, we ensure robust systems and deliver exceptional service to our customers, continually striving for secure, stable, and reliable operations.

The Impact:

• User support - We have as many as 1,500 Vertica users and many thousands more that use BI tools to access the database. User support through ticketing and a direct Slack channel highly impact user experience and satisfaction.
• Collaboration - Our team is highly collaborative and supportive of one and other. We celebrate success as a team and together foster a culture of continuous improvement.
• Monitoring and Alerting - Automated and manual monitoring of our systems help ensure availability and reliability.
• A Sense of Urgency - When the inevitable incidents occur, the sense of urgency demonstrated by the team helps reach our KPI and SLA goals.

The Minimum Qualifications

• Bachelor's Degree in Computer Engineering, Computer Science, Information Systems or related technical field
• 8+ years of hands-on experience with Enterprise Data Warehousing.
• 5+ years of experience in SQL, with a track record of writing and optimizing complex queries.
• 3+ years of Vertica-specific database support, management, and administration.

The Ideal Qualifications

• Proven experience supporting mission-critical applications in dynamic enterprise environments.
• Demonstrated expertise supporting Vertica in cloud environments (preferably AWS).
• In-depth knowledge of Vertica physical and logical architecture.
• Familiarity with optimization techniques such as projections and partitioning.
• Solid understanding of ETL processes, data structures, metadata, and workflow management.
• Strong Linux OS skills, including proficiency with tracing and performance tools.
• Experience with resource pool tuning for optimal performance.
• Innovative mindset with a passion for problem-solving and process improvement.
• Team-oriented approach, prioritizing collaboration and shared success.
• Experience with Voltage encryption solutions.
• Proficiency in AWS infrastructure, including:
  • Terraform
  • Python
  • EC2
  • IAM
  • Autoscaling
  • Cost management
• Hands-on experience with New Relic for monitoring and alerting.

What to Expect as Part of MassMutual and the Team

• Regular collaboration with Data & BI Platform Engineering
• Focused one-on-one time with your manager
• Networking opportunities including access to Asian, Hispanic/Latinx, African American, women, LGBTQIA+, veteran and disability-focused Business Resource Groups
• Access to learning content on Degreed and other informational platforms
• Your ethics and integrity will be valued by a company with a strong and stable ethical business with industry leading pay and benefits

#LI-RK1

MassMutual is an equal employment opportunity employer. We welcome all persons to apply.

If you need an accommodation to complete the application process, please contact us and share the specifics of the assistance you need.

California residents: For detailed information about your rights under the California Consumer Privacy Act (CCPA), please visit our California Consumer Privacy Act Disclosures page.