Description

You will design, develop, and maintain Vertica databases to support complex business applications and analytics.

Responsibilities

• Design and perform advanced data modeling to support new and existing projects.
• Optimize database performance using advanced tuning and query optimization techniques.
• Lead database migration and upgrade projects while ensuring minimal downtime and data loss.
• Implement and manage database security measures to ensure data integrity and compliance.
• Monitor and troubleshoot database systems to resolve incidents and performance issues.
• Collaborate with data scientists, analysts, and cross-functional teams to integrate databases with applications.

Required Skills

• 10+ years of experience in database architecture and management.
• Extensive experience working specifically with Vertica databases.
• Expertise in SQL and advanced database performance tuning.
• Proficiency in Linux/Unix environments and shell scripting.
• Strong background in data warehousing and big data solutions.
• Proven ability in data modeling and database design.
• Experience with ETL processes and BI tools.
• Deep understanding of the IT SDLC lifecycle and Agile principles.
• Technical expertise in managing highly available systems with large, continuous data volumes.

Preferred Skills

• Experience working in multi-vendor environments.
• Project management experience.

Key Skills

Education

Bachelor's degree