Position: Vertica Database Admin
Location:SCV, CA(Day1 Onsite)
Duration:Full Time
Required Skills:
Sound Knowledge of Vertica Architecture (column orientation, compression, projections, segmentations, partitions, high availability and security) Hands-on Vertica implementation
Expertise in installing/upgrade and maintaining Vertica clusters.
Implementing backup and recovery processes
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
Hands-on experience with database optimization, tuning DBA specific activities for Vertica.
Provide Vertica design and development for large enterprise solutions
Maintain Vertica databases with regular patching, upgrades, updating stats and other maintenance activities
Monitor Vertica cluster health and perform necessary tuning
Identify poorly performance queries, create projections and other measures to improve application performance
Working knowledge of Vertica ecosystem like Hadoop/kafka etc.
Able to write/modify shell/python scrip for database maintenance