Database Architect / Data Science

Position at Corporate Technology

The Data Services team at Hearst, part of Corporate Technology, is responsible for a number of big data sources that power products used throughout the organization. The Database Administrator will be a key member of the team, having responsibility for the design and maintenance of key pieces of the Hearst Data Warehouse. We ingest many terabytes of data each day from a wide variety of internal and external sources; virtually all of that data is stored in databases at some point. The DBA will take ownership of a number of Amazon Redshift clusters, our Google BigQuery implementation, as well as other smaller databases on a variety of platforms, and will ensure their integrity and resilience. Skills & Requirements

  • 3+ years experience with Amazon Redshift; experience with MySQL is a plus, experience with Google BigQuery is a big plus
  • AWS management and usage is required.
  • Must include significant experience with database design and optimization including writing and executing DDL statements
  • Understanding of database performance and tuning. Must have a solid understanding of Redshift distribution and sort keys and column encodings.
  • Strong working knowledge of AWS – must have experience spinning up and resizing Redshift clusters, be familiar with RDS, and know how to install a database on an ec2 instance
  • Demonstrable experience with issue detection and resolution; be ready to provide examples
  • Working knowledge of backup and recovery procedures
  • Ability to provide guidance to data scientists, engineers and other team members
  • Documentation skills for processes and procedures
  • Experience with NoSQL databases such as Cassandra, DynamoDB, and MongoDB is a big plus
  • Working knowledge of Linux
  • Comfort with Python, BASH scripting and crons

Meet Some of Hearst Magazines's Employees

Nana

Assistant to the Editor-In-Chief

Whether she is making travel arrangements or managing Glenda Bailey’s extraordinarily busy calendar, Nana helps keep the editor-in-chief of Harper’s Bazaar on track with every task she undertakes.

Danielle

Editorial Assistant

Danielle assists the editor-in-chief of Hearst’s Food Network Magazine, performing a full range of administrative tasks in addition to researching, reporting, writing, and editing four pages in every issue.


Back to top