Skills Required: AWS, EC2, ELB, EMR, SQL, PostgreSQL, Redshift, Linux,
Experience with Amazon AWS development
Exposure to PostgreSQL and preferably Redshift knowledge
Exposure to Hadoop or Elastic MapReduce framework
Familiarity with AWS cloud computing environment (EC2, ELB, EMR)
Proficient in Linux
Prepare design documents and functional specifications including test cases.
Formulate and design software and use scientific analysis and mathematical modeling to predict and measure outcome and consequences of design.
Consult with engineering staff to evaluate interface between software modules, develop specifications and performance requirements and resolve customer problems.
Write and tune SQL queries for OLAP Applications
Create data warehouse and datamarts using Amazon ETL and Business Objects Universe.
Evaluate software components and tools to be used in software applications.
Administer SQL Server, including setting up SQL Clusters
Advise in the design of table schema, indexes, and partitions
Tune SQL queries and database performance for OLAP Applications
Participate in Database design and SQL code reviews, implementation of methodologies to ensure high quality implementation