Vertica DBA

Job description: Vertica DBA

Location: Bangalore

Mandatory skills:

• Must have working knowledge of Vertica database architecture (column orientation, compression, projections, segmentations, partitions, high availability and security);
• Understanding of Vertica architecture & migrate, install, configure, manage Vertica system and managing Vertica backup, recovery and restore operations.
• Demonstrates in-depth knowledge of database internals and data structures.
• Strong debugging skills to investigate query performance.
• Node management/cluster management/Workload management.
• Experience migrating data across multiple platforms.
• Experience in troubleshooting Vertica database server and cluster issues.
• 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.
• Providing performance tuning and assisting in business process integration with various data sources.
• Performing pro-active and reactive performance analysis, monitoring, troubleshooting and root-cause analysis of Vertica database related issues in support of critical day-to-day business operations.
• Experience in Vertica installation, Cluster Upgrades, Database Upgrades and OS Patch level upgrade.
• Should have good knowledge on Unix, Shell Scripting and Python Scripting.

Good to Have:
• Experience in Vertica EON Mode
• Hands on experience in Cloud technologies like Azure, AWS, GCP, etc.,
• Hands on experience in Big data and emerging BI technologies.
• Hands on experience in Linux System Admin area.
• Team player, self-learner, who can work under pressure

Education and Experience Required :
• 2+ years Vertica administration experience