First IT Solutions 

Location: Charlotte, NC or Newark, DE

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

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