3-5 years of experience on HP Vertica database administration
Understanding of Vertica architecture & migrate, install, configure, manage Vertica system and managing Vertica backup and recovery and restore Should have proven experience in handling min of 6 node cluster with 10TB data should have strong knowledge of vertica internals, capacity planning and troubleshooting Should be well versed with shell scripting Should have hands-on experience on DB design, query development, backup, recovery and performance tuning Sound have strong debugging skills to investigate query performance Node management/cluster management/ work load management Ability to troubleshoot unix/linux system logs and understand and determine issues at OS/DB level and fixes. Ability to understand tcp/kernel parameter and able to relate it to Vertica parameter setting and effect. ... Ability to understand tcp/kernel parameter and able to relate it to Vertica parameter setting and effect. Ability to tune kernel parameter Ability to understand network configuration/socket configurations.