Data Modeler / DBA

  •  

West Point, PA

Industry: IT Consulting/Services

  •  

5 - 7 years

Posted 256 days ago

  by    Cynet Sytems

This job is no longer available.

We are looking for Data Modeler/DBA for our client in West Point, PA

Job Title: Data Modeler/DBA

Job Location: West Point, PA

Job Type: Contract ? 12 Months / Contract to Hire / Direct Hire

Job Description:

Must Have Skills:

  • Have atleast 4year of extensive experience in Redshift including SQL & other features of Redshift as well experience in administration, management of Redshift cluster
  • Have hands on experience in Aqua data studio ER model
  • Excellent communication & written skill is must

Role & Responsibilities:

  • Understand the current source system databases / files and entities within them
  • Identify the PK, FK relationships across the entities and across subject areas
  • Have hands on experience creating & maintaining Physical & Logical model in Aqua data studio
  • Maintain appropriate roles and user group access based on role in model
  • Have extensive experience in reverse engineering existing objects into model
  • Have extensive experience in generating DDL from model and deploy it in different redshift env
  • Should have little Redshift database administrator experience