Database Architect / Data Science
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
Hearst Magazines is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected veteran status, age, or any other characteristic protected by law.
Pay Transparency Nondiscrimination Provision
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)