Hybrid Vertica Database Administrator – Data & BI Platform Engineering

at MassMutual

• Job title: Vertica Database Administrator – Data & BI Platform Engineering
• Job type: Full Time
• Experience level: Senior, Lead
• Salary: $131,100 - $172,000 per year
• Degree requirement: Bachelor's Degree
• Tech skills: AWS, Cloud, EC2, ETL, Linux, Python, SQL, Terraform
• Location requirements: Hybrid, Springfield, United States

About the role

• Vertica Database Administrator overseeing Vertica systems operations at MassMutual. Providing 24/7 support while ensuring data reliability and security across clustered environments.

Responsibilities

• Provide 24/7/365 support for Vertica database systems, ensuring high availability, rapid incident response, and proactive performance monitoring across clustered environments.
• 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.
• Tackle complex business challenges related to data processing, loading, performance improvements, storage, and replication.
• Collaborate closely with technical teams, providing expert guidance on best practices for database technology and distributed deployments.
• Design and implement automation for database monitoring and alerting.
• Monitor Vertica capacity planning and license management to ensure efficient resource utilization and compliance.
• Maintain data integrity through effective utility and disk management procedures, safeguarding the reliability and accuracy of enterprise data.

Requirements

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

Benefits

• 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
• Industry leading pay and benefits