
Vertica Professional
1 week ago
**Job Title **:Vertica Professional - Freelancer
We are seeking a talented and experienced Vertica professional
**Responsibilities**:
**For Vertica Database Administrator (DBA)**:
- Install, configure, and maintain Vertica database instances in on-premises and cloud environments.
- Perform routine database maintenance tasks such as backup and recovery, monitoring, performance tuning, and capacity planning.
- Implement and enforce database security policies and procedures.
- Troubleshoot and resolve database-related issues and incidents in a timely manner.
- Collaborate with developers, data engineers, and other stakeholders to optimize database performance and ensure data integrity.
- Stay updated on the latest releases, updates, and best practices related to Vertica database technology.
- Provide technical guidance and support to internal teams and clients on Vertica database administration.
**For Vertica Developer**:
- Design, develop, and optimize ETL (Extract, Transform, Load) processes and data pipelines using Vertica SQL and other relevant technologies.
- Write and optimize complex SQL queries for data analysis, reporting, and visualization.
- Develop and maintain data models, schemas, and structures in Vertica database environments.
- Collaborate with data engineers and data scientists to integrate Vertica data solutions into larger analytics and data science projects.
- Implement data quality and data governance processes to ensure data consistency and accuracy.
- Stay updated on the latest Vertica features and tools to leverage them effectively in development projects.
- Provide technical guidance and support to internal teams and clients on Vertica development best practices.
**Requirements**:
- Bachelor's degree in Computer Science, Information Technology, or related field.
- 5 years of experience working with Vertica database technology.
- Strong understanding of database concepts and principles, including SQL, indexing, optimization, and data modeling.
- Hands-on experience with Vertica database administration and/or development.
- Proficiency in Vertica SQL, including query optimization and performance tuning.
- Experience with data integration tools and techniques (e.g., ETL, data pipelines).
- Excellent communication and interpersonal skills.
- Ability to work independently and collaboratively in a dynamic environment.
**Job Types**: Part-time, Freelance
Pay: ₹15,000.00 - ₹20,000.00 per month
Expected hours: 15 per week
**Experience**:
- total work: 8 years (preferred)
- Vertica: 5 years (preferred)
Work Location: Remote