Redshift DBA

4 months ago

Windsor Locks, United States eTeam Full time
  • 8+ Years of experience in Information Technology, with focus on Data Warehousing development and Administration .
  • Candidate must work in several areas of Data Warehouse including Analysis, Requirement Gathering, Design, Development, Testing, Implementation and Administration.
  • Expert DBA skills in Redshift , SQL Server , Oracle / Teradata & Matillion (Good to have).
  • Expertise in database programming like writing Stored Procedures ( SQL ), Functions , Triggers , Views , Shell scripting .
  • Expertise in performance tuning from design architecture to application development.
  • Also, Worked in remediation (Performance Tuning) team for improving query performance of user queries and production SQL's.
  • Should have good experience in working with big data technologies like Hadoop, Yarn, MapReduce, Pig, Hive, Spark and other associated technologies.
  • Worked on Data Mining techniques for identifying claims on historical data
Experience:
  • Min 2+ years of Redshift DBA experience
  • Min 6+ years of DBA experience.
  • Must know basic concepts of RDBMS.
  • Should be familiar with system tables
  • Should be familiar with AWS console
  • Should be familiar with WLM