EPRO Services, Inc.

DB2 DBA with Vertica

Posted 11 Days Ago

Be an Early Applicant

Charlotte, NC, USA

In-Office

Mid level

Professional Services • Industrial • Manufacturing

The Role

DB2/Vertica DBA responsible for data warehouse design, data modeling (star schema), and database administration. Must have hands-on experience with Vertica, DB2 (DPF) or Hadoop, in-database processing (SAS), performance tuning, query optimization, and working with developers to build database tools and establish best practices. Full-time onsite role.

Summary Generated by Built In

Company Description

E*Pro Consulting service offerings include contingent Staff Augmentation of IT professionals, Permanent Recruiting and Temp-to-Hire. In addition, our industry expertise and knowledge within financial services, Insurance, Telecom, Manufacturing, Technology, Media and Entertainment, Pharmaceutical, Health Care and service industries ensures our services are customized to meet specific needs. For more details please visit our website www.epro-tech.com

Job Description

Job Title: DB2 DBA with Vertica

Job Location: Charlotte, NC or Newark, DE

Job Length: Full Time / Permanent Position

Required Skills:

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

Skills:

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

Thanks

Gayathri S

E*Pro, Inc

T - (732) 283-0499 Ext 220

Additional Information

FULLTIME/ PERMANENT & ONSITE

Skills Required

Experience in Database Administration.
Design and development of complex data warehouse systems.
Creation of data models and familiarity with star schema design patterns.
Hands-on experience with Vertica, DB2 (DPF) or Hadoop.
Systems engineering skills in database design and development of database tools (stored procedures, functions).
Familiarity with SAS and in-database processing for data transformation.
Comfortable working with Big Data technologies (Hadoop, Cassandra, Vertica) and traditional databases (DB2, Teradata, Oracle, SQL Server).
Experience with performance tuning, query re-writing, and collaborating with application developers.
Scripting and Linux experience.

View all jobs at EPRO Services, Inc.

View EPRO Services, Inc. Profile

Report Job

Am I A Good Fit?

beta

Get Personalized Job Insights.

Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company

6 Employees

Year Founded: 2011

What We Do

EPRO Services, Inc. is a leading provider of superior waterproofing and contaminant protection systems designed to keep building structures dry and safe. Founded in 1993, the company specializes in building envelope protection, offering a comprehensive range of solutions including vapor intrusion mitigation, air barrier systems, and leak repair services for a variety of site conditions across the United States and Canada.