Vertica Admin/dba Job in Aptus Data Labs

Aptus Data Labs is a promising Decision Science and Advanced Analytics company. We are a mission-focused team of Data Analysts, Technology Experts, Business Domain Experts, Data Science Researchers, and Technology Architects, who have great knowledge in the field of Advanced Analytics.

To enable our growth and technology breadth, Aptus is looking for the Vertica Admin/ DBA (4-5 years) with the following skills and job descriptions. If you have the right skill, energy, and interest to work for a technology start-up firm, please respond with your profile and contact coordinates to staffing@aptusdatalabs.com

Location: Hyderabad

Solution & Development Platform: Vertica, SQL, PL/SQL, Linux commands and Shell scripting.

Industries: Banking and Financial, Healthcare, Retail and Manufacturing

Job Description:

4+ years of experience working with HP Vertica Database systems

Deep knowledge of database architecture and internals like WOS, ROS, Delete Vectors, trouble shooting and capacity planning.

Experience managing large scale (50+ Terabytes) and high transaction volume database systems on Unix/Linux platforms.

Able to design, architect and provide reference architecture and best practices on Vertica platform.

Hands on role with a focus on Database Management, DB design, SQL and performance tuning, SQL best practice and memory allocation.

Should have excellent debugging skills to investigate query and application performance issues.

Strong proficiency in SQL, PL/SQL, Shell Scripting and working knowledge of application development using Java

Working knowledge of storage solutions and networking protocols and components such as SAN, TCP/IP, UDP, and DNS is a plus

Ability to troubleshoot unix/linux system logs and understand and determine issues at OS/DB level and fixes.

Strong communication and presentation skills

Great analytical and critical thinking skills

Experience with monitoring tools HP Vertica Management console and other UNIX monitoring is highly preferred.

Willing to work on 24*7 rotation at client location with different constraints.

Experience:5+ years of experience in SQL, PL/SQL, Linux commands and Shell scripting.

Qualification: B.E, B.Tech, M.sc, M.Tech in computer science

Vertica certification a plus.