DB2, Vertica DBA Charlotte (Full Time)

TecTammina; Charlotte (NC); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading technology solutions provider in Charlotte, NC is seeking an experienced Database Administrator. The role requires 7-10 years of experience and involves the design, development, and maintenance of complex data warehouse systems. Candidates must have detailed experience with Vertica, DB2, or Hadoop, and possess systems engineering skills for database design. This position offers an opportunity to work with both traditional and Big Data technologies in a full-time capacity.

Qualifications

• 7-10 years experience in Database Administration.
• Experienced with design and development of complex data warehouse systems.
• Familiar with star schema design patterns.

Responsibilities

• Participate in on-going initiatives and establish best practices.
• Work with application team for performance tuning and code development.

Skills

Database Administration

Data Modelling

Performance Tuning

Scripting

Linux

Tools

Vertica

Hadoop

DB2

Teradata

Oracle

SQL-Server

Job description

Position Summary and Key Responsibilities

• 7-10 years experience in Database Administration.
• Experienced with the design and development of complex data warehouse systems.
• Experienced in the creation of data models and familiar with star schema design patterns.
• Detailed knowledge and hands on experience working with Vertica, DB2(DPF) or Hadoop.
• Systems engineering skills in database design, development of database tools like stored procedures and functions.
• Familiar with technologies like SAS and in-database processing for transformation of data.
• Comfortable working with multiple technologies and capable of learning and working with Big Data technologies like Hadoop, Cassandra, Vertica as well as traditional technologies like DB2, Teradata, Oracle, and SQL-Server.
• Participate in on-going initiatives and establish best practices.
• Experience with working with the developers/application team for performance tuning, query re-writing, and code development.

Required Skills

• Database Administration (Distributed Platform/Data Warehouse: Vertica/DB2/Hadoop), Data Modelling, Performance Tuning, Data Warehouse, Big Data, Scripting, Linux, Scripting

Desired Skills Databases

• Vertica, Hadoop, DB2 (DPF)
• Experience with working with the developers/application team for performance tuning, query re-writing, and code development.
• Experience with UDTF/UDF and in-database processing

Additional Information

• Job Status: Full Time
• Share the Profiles to mdanish(at)1stitsolutions.com
• Contact: 703-349-1004
• Keep the subject line with Job Title and Location