Previous Job
Previous
AWS Redshift Architect - NYC, NY
Ref No.: 18-00946
Location: NYC, New York
AWS Redshift Architect
Location: NYC, NY
Position type: Contract   W-2 only (Visa sponsorship may be available for Right candidate - no third-party c2c)
 Rate: DOE
 

 
•         Must have managed AWS Redshift database (knows performance tuning, clustering, data allocation, snapshots, restore etc.).
•         Design, development of Redshift schema and tables
•         Design, development, automation of the process to load data into AWS
•         Hands-on experience on Redshift schema design, performance optimization, capacity planning
•         Experience with various data structures, information management concepts and big data concepts in order to determine the appropriate implementation of the solution
•         Data architecture and design and document Best Practice for Redshift
•         Knowledge of internal architecture of Redshift and MPP technology
•         Worked extensively in performance tuning, load distribution, defining sort keys, distribution keys, query performance
•         Be able to project RedShift costs and propose actions for cost optimizations.
•         Able to design and implement automation of the process using scheduling tools like data pipeline or SWF
•         Design Redshift based BI solution platform for optimized performance and usability Define, monitor RedShift database performance metrics and resolve bottlenecks
•         Should be comfortable with Redshift concepts like DISTKEY, SORTKEY, COMPRESSION, VACUUM etc.
•         Experience working with Amazon Web Services RDS, SNS/SQS/SWF, Pig and/or Hive is preferred
•         Exposure on AWS Services EC2, EMR, SQS, SNS, Lambda, S3, Glacier a plus.
•         Solid understanding of SQL and have worked extensively with SQL
•         Able to design and implement automation of the process using scheduling tools like data pipeline or Swift