Job Details
1Sound Knowledge of Vertica Architecture (column orientation, compression, projections, segmentations, partitions, high availability and security) Hands-on Vertica implementation2Expertise in installing/upgrade and maintaining Vertica clusters3Implementing backup and recovery processes4.
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 cases5Provide Vertica design and development for large enterprise solutions6Maintain Vertica databases with regular patching, upgrades, updating stats and other maintenance activities7Monitor Vertica cluster health and perform necessary tuning8Identify poorly performance queries, create projections and other measures to improve application performance9.
Allocate workloads to resource pools and deliver optimal performance for application workloads10Troubleshoot and resolve Vertica system issues11Working knowledge of Vertica ecosystem like Hadoop/kafka etc12Able to write/modify shell/python scrip for database maintenance13.
Plan best practices and standards for data access, audit tracking, segmentation of data through security standards (kerberos, LDAP, authentication and authorization)14Work in customer environment to optimize system performance using Vertica tuning tools and manual techniques15Collaborate in evolving overall development and technology strategies and establish database design and administration standards and best practices