Job Description :
Strong knowledge in PL/SQL and DBMS concepts. Should have few years of hands-on experience in databases like Oracle or Teradata.
Should have good knowledge and experience in scripting using Unix shell or Python.
Should be strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies
Should have 2-3 years of experience on Vertica database as a developer in various projects and good work experience and knowledge on Vertica DB and architecture.
Knowledge on Projections, Super-Projections, Buddy-Projections and Pre-Join Projections in Vertica
Understanding & knowledge on High Availability, Replication and K-Safety in Vertica.
Understanding on segmentation, compression techniques and encoding, load balancing techniques in Vertica
Creation of schemas, data bases, users, nodes and grants on tables, users, databases
Performance tuning the queries in Vertica
Work closely with business stakeholders, understand the requirements, address problems with most optimal solution
Should be able to do multitasking in a highly dynamic work environment to efficiently contribute to project.
Take ownership in systematically designing and executing activities and processes to ensure required support is provided to the client
Proactively brainstorm and come up with new ideas to improve processes and improve client satisfaction
Volunteer to develop the overall subject matter expertise of our team by conducting internal knowledge sharing sessions etc.
Being an active member to learn and share expertise
Should have good communication skills

Client : Confidential