Vertica Admin

TCS has been a great pioneer in feeding the fire of Young Techies like you. We are a global leader in the technology arena and there's nothing that can stop us from growing together.We are Hiring For

Vertica Admin

Job Description

Required Information Details

Role**Vertica Admin

Desired Experience Range**6-10+

years

Location of Requirement Delhi/NCR

Vertica Admin

1. Sound Knowledge of Vertica Architecture (column orientation, compression, projections, segmentations, partitions, high availability and security) Hands-on Vertica implementation2. Expertise in installing/upgrade and maintaining Vertica clusters.3. implementing backup and recovery processes4. 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 cases5. Hands-on experience with database optimization, tuning DBA specific activities for Vertica.6. Provide Vertica design and development for large enterprise solutions7. Design, implement, and optimize Vertica database with optimal database configuration (e.g. Vertica configuration parameters) that support real-time customer use-cases for high scale8. Work in customer environment to optimize system performance using Vertica tuning tools and manual techniques9. Maintain Vertica databases with regular patching, upgrades, updating stats and other maintenance activities10. Monitor Vertica cluster health and perform necessary tuning11. Identify poorly performance queries, create projections and other measures to improve application performance12. Allocate workloads to resource pools and deliver optimal performance for application workloads13. Troubleshoot and resolve Vertica system issues14. Maintain database service levels and availability goals, database monitoring and performance tuning, database backup and recovery, and resolving production database incidents15. Collaborate in evolving overall development and technology strategies and establish database design and administration standards and best practices around performance tuning and query optimization improvements16. Manage data governance and security17. Work with IT security teams to track access, audit, and approvals for Big Data platform18. 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

Minimum Qualification:15 years of full-time education

Disclaimer: We encourage you to register at

for exploring an exciting career with TCS. At the time of your application to TCS, the personal data contained in your application and resume will be collected by TCS and processed for the purpose of TCS's recruitment related activities.Your personal data will be retained by TCS for as long as TCS determines it is necessary to evaluate your application for employment as per our retention policy. You have the right to request TCS for temporary/permanent exclusion of your candidature from any recruitment related communication. For any such request you may write to careers.tcs.com.

---