• Find preferred job with Jobstinger
  • ID
  • Job type
  • Salary
  • Source
    Cloudious LLC
  • Date
  • Deadline

Vacancy expired!

Vertica Database Engineer Location: Sunnyvale, CA Need 6+ years experience 1. Sound Knowledge of Vertica Architecture (column orientation, compression, projections, segmentations, partitions, high availability and security) Hands-on Vertica implementation 2. Expertise in installing/upgrade and maintaining Vertica clusters. 3. implementing backup and recovery processes 4. Experience in Performance Tuning in Vertica which includes creation of projection, partition swapping etc, performance monitoring and tuning, data management and resource management for analytics use cases 5. Hands-on experience with database optimization, tuning DBA specific activities for Vertica. 6. Provide Vertica design and development for large enterprise solutions 7. Design, implement, and optimize Vertica database with optimal database configuration (e.g. Vertica configuration parameters) that support real-time customer use-cases for high scale 8. Work in customer environment to optimize system performance using Vertica tuning tools and manual techniques 9. Maintain Vertica databases with regular patching, upgrades, updating stats and other maintenance activities 10. Monitor Vertica cluster health and perform necessary tuning 11. Identify poorly performance queries, create projections and other measures to improve application performance 12. Allocate workloads to resource pools and deliver optimal performance for application workloads 13. Troubleshoot and resolve Vertica system issues 14. Maintain database service levels and availability goals, database monitoring and performance tuning, database backup and recovery, and resolving production database incidents 15. Collaborate in evolving overall development and technology strategies and establish database design and administration standards and best practices around performance tuning and query optimization improvements 16. Manage data governance and security 17. Work with IT security teams to track access, audit, and approvals for Big Data platform 18. Plan best practices and standards for data access, audit tracking, segmentation of data through security standards (kerberos, LDAP, authentication and authorization) 19. Working knowledge of Vertica ecosystem like Hadoop/kafka etc. 20. Able to write/modify shell/python scrip for database maintenance

Vacancy expired!

Report job

Related Jobs