Vertica Database Administrator (DBA)

Role:Vertica Database Administrator (DBA)
Company Name: WillWare Technologies
Experience: 6-8 Years
Location: PAN India

Role Overview
We are looking for an experienced Vertica Database Administrator (DBA) with strong hands-on experience in administering and maintaining high-performance massively parallel processing (MPP) columnar databases.
The ideal candidate should have expertise in Vertica database administration cluster management performance tuning projection design backup/recovery user and privilege management and Linux-based database operations. Experience with SQL Server Database Administration will be an added advantage.

Key Responsibilities
Administer and maintain Vertica database clusters in production and non-production environments.
Start stop monitor and troubleshoot Vertica nodes using Vertica Administration Tools and command-line utilities.
Manage cluster health node availability failover recovery and node additions/removals.
Design create and optimize Vertica projections to improve query performance.
Use Vertica Database Designer for projection design and workload optimization.
Perform database performance tuning query optimization and capacity management.
Manage Vertica resource pools and database resource utilization.
Administer database users roles privileges and access controls.
Work with Verticas native user/access concepts including DBADMIN object owners and PUBLIC.
Perform routine catalog backups database backups restores and recovery activities.
Manage epochs and perform routine database maintenance activities.
Troubleshoot database node query and performance-related issues.
Monitor database health resource utilization storage and overall cluster performance.
Participate in database upgrades patching migrations and configuration changes.
Maintain operational documentation and follow database administration standards.
Collaborate with application infrastructure development and support teams to resolve database issues.

Mandatory Skills
Strong hands-on experience as a Vertica DBA / Vertica Database Administrator.
Experience with HP Vertica / Vertica Analytics Platform.
Strong knowledge of Vertica cluster administration.
Hands-on experience with Vertica projections and Database Designer.
Experience in node management failover recovery and cluster troubleshooting.
Knowledge of Vertica backup and restore procedures.
Experience with resource pools and database performance tuning.
Strong SQL skills.
Good experience working with Linux/Unix environments.
Understanding of database security users roles and privileges.
Desirable Skills
SQL Server Database Administration
MS SQL Server / MSSQL
T-SQL
SQL Server performance tuning
SQL Server backup and recovery
Experience supporting large-scale enterprise database environments.
Preferred Candidate Profile
6-8 years of overall database administration experience
Strong hands-on experience specifically in Vertica DBA
Experience supporting high-volume high-performance MPP databases
Strong troubleshooting and analytical skills
Good communication and collaboration skills
Ability to work in production environments and handle critical database incidents.

Required Skills:

SQL SERVERVERTICAUNIXHP VERTICALINUX