Database Engineer
Previous Job
Previous
Database Engineer
Ref No.: 18-02649
Location: New York, New York
Position Type:Direct Placement
Start Date: 03/13/2018
Title: Database Engineer
Start: ASAP
Location: NYC
Interview Process: PS, F2F
Duration: Full Time/Perm


Key Responsibilities
  • Involved in all aspects of the application development lifecycle: Ideation, Development, QA, Documentation, Implementation, and Maintenance.
  • Design and maintenance of key pieces of the Complex Data Warehouse.
  • Ownership of Amazon Redshift clusters, Google BigQuery implementation, and other databases on a variety of platforms.
  • Issue detection and resolution.
  • Guidance to analysts, enterprise shareholders and IT.
  • Documentation of processes and procedures.
  • Adhere to project schedules and effectively report progress to meet deadlines.

Must haves
  • 3+ years with SQL-based data storage experience.
  • Hands on knowledge with MySQL, Amazon RDS and Amazon Redshift. Must have a solid understanding of Redshift and MySQL distribution and sort keys and column encodings.
  • Strong knowledge of data modeling, database design, optimization and performance. (Writing and executing DDL statements is a must).
  • Hands on knowledge with AWS services and infrastructure. (Must have experience spinning up and resizing Redshift clusters, be familiar with RDS, and know how to manage a database on an ec2 instance).
  • Google BigQuery experience is a big plus.
  • Working knowledge of Linux
  • Comfort with SQL, Python, BASH scripting and job schedulers such as cron.
  • Experience configuring, debugging and maintaining third party APIs.
  • Working knowledge of backup and recovery procedures.
  • Demonstrable experience with issue detection and resolution; be ready to provide examples.
  • Experience with Agile product development environment. (Scrums, Jira PM, Slack, etc)