Vertica DBA

Dear candidate,

We have a Job vacancy for the below mentioned details:

 Vertica DBA:

1. Sound Knowledge of Vertica Architecture (column orientation, compression, projections, segmentations, partitions, high availability and security) Hands-on Vertica implementation 

2. Expertise in installing/upgrade and maintaining Vertica clusters.

3. implementing backup and recovery processes 

4. 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

5. Hands-on experience with database optimization, tuning DBA specific activities for Vertica. 

6. Provide Vertica design and development for large enterprise solutions 

7. Design, implement, and optimize Vertica database with optimal database configuration (e.g. Vertica configuration parameters) that support real-time customer use-cases for high scale

8. Work in customer environment to optimize system performance using Vertica tuning tools and manual techniques

9. Maintain Vertica databases with regular patching, upgrades, updating stats and other maintenance activities

10. Monitor Vertica cluster health and perform necessary tuning

11. Identify poorly performance queries, create projections and other measures to improve application performance

12. Allocate workloads to resource pools and deliver optimal performance for application workloads

13. Troubleshoot and resolve Vertica system issues

14. Maintain database service levels and availability goals, database monitoring and performance tuning, database backup and recovery, and resolving production database incidents

15. Collaborate in evolving overall development and technology strategies and establish database design and administration standards and best practices around performance tuning and query optimization improvements

16. Manage data gover nance and security

17. Work with IT security teams to track access, audit, and approvals for Big Data platform

18. Plan best practices and standards for data access, audit tracking, segmentation of data through security standards (kerberos, LDAP, authentication and authorization)

19. Working knowledge of Vertica ecosystem like Hadoop/kafka etc.

20. Able to write/modify shell/python scripts for database maintenance