Vertica Admin

 

 

Role:

Vertica Admin

Core Purpose:

Manage Database technologies including Vertica on Red Hat Linux systems.

 

Must have Skills to support the environment independently.

  • Vertica database administration including configuration, upgrades and Node management
  • Experience in performance tuning and resolve bottlenecks in CPU, memory, disk I/O and network related issues
  • Must have experience to work with analysts on partitioning, segmentation, partition swapping, and query-tuning
  • Must have Shell Scripting experience and Agile environment is a plus
  • Experience in supporting Data Warehouse environments
  • Experience in DB2 with DPF environment would be plus
  • Excellent communication and troubleshooting skills

 

Area of Responsibility:

  • Database Configuration – Physical: including
    • Configure Database objects including tables, clusters, indexes, views, sequences, packages and procedures.
    • Configure Database encryption and security parameters.
    • Perform data conversions as required.
    • Work with the Developers, System and Storage administrators to optimize Database configurations which may include clustered databases.
    • Implementation of replication technologies.
    • Comfortable with complex database performance tuning.
  • Database Support – Physical: including
    • Familiar with Database archive processes and procedures.
    • Perform Database re-indexing, stored procedure rebuilds, Database defragmentation, and purging obsolete Database definitions and procedures.
    • Provide activities including index rebuilds or reorgs, verification of integrity, Database shrinking, and statistics updating.
    • Monitor Database logging systems including Database lock errors and troubleshoot causes.
    • Plan for tablespace utilization and develop migration plans to ensure data integrity prior to anticipated changes, expansions, or migrations to new or changed space allocation.
    • Document unsupported Database versions, where they are used, the Applications that use them and actively seek to either upgrade, retire or migrate them to alternate platforms.
    • Apply latest security patches and perform upgrades.
  • Database Design and Development
    • Evaluate Database designs for all Databases and provide recommendations for improvement.
    • Participate in New Project/Application Development design sessions and provide Database Design recommendations.

 

Knowledge and Skills:

 

  • 7 years of experience on Vertica database Administration.
  • Any of DB2, Oracle, SQL Server, MySQL and Hadoop would be an added advantage.
  • Experience in Vertica Database Administration, Database Refresh, Data Modelling, Data Partitions, Performance Tuning, Production Deployment Support.
  • Analyzing and Resolving Vertica related issues. Working with developers and ETL team to improve their LOAD performance.
  • Experience in VMC tool
  • Good Communication and Analytical skills.

 

Environment:

  • Vertica 8.x, 9.2

 

Basic Education Qualification:

  • Bachelor’s Degree in Engineering

 

Basic Years of Experience:

  • Seven Years

 

 

Submit Resume