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

MassMutual Financial Group•Springfield, MA

36d

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

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

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

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume