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

MassMutual • Springfield, MA

43d

About The Position

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.

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.

Nice To Haves

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

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. Apply advanced troubleshooting skills to stabilize and optimize database operations.
• 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.
• Design and implement automation for database monitoring and alerting. Drive continuous improvement by developing and standardizing operational procedures.
• 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.

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
• Your ethics and integrity will be valued by a company with a strong and stable ethical business with industry leading pay and benefits

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees