Tribune Company Sr Admin, Database in Chicago, Illinois
This DBA position is for a “lean in” and self-motivated individual looking to operate in an organization that believes in using information for a competitive advantage. Manage and secure enterprise data stored in SQL server as well as other contemporary data sources. Install, support, manage and troubleshoot the "data layer" services supporting ERP, Collaborative, Web and Business Intelligence Applications. Work collaboratively with Engineering as well as Applications development to deliver flexible, resilient and scalable solutions that fit within the budget and architecture. Install and configure new SQL Servers and SQL Server applications including layout of databases and disk requirements. As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies.
Work in a leading edge environment; Virtualized SQL servers, SDN Based Datacenters, Master Data, Big Data, and Data Visualization
Ensure backup and recovery strategies meet the business’ Recovery Requirements and Time Objectives
Work with compliance group to ensure databases meet audit and security standards
Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
Monitor and Manage applications within the SQL environment
Configure and maintain SQL Server monitoring utilities
Deploy database change scripts provided by third party vendors
When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
Document the database environments
Work with Technology Development group to implement new technologies and systems
Automate processes with tools internal and external to SQL Server
Familiarity with Visual studio and SSIS packages
Familiarity with SSAS and SSRS
Data modeling and database design
Metadata management and repository usage.
Database creation and management.
Backup and recovery.
Ensuring data integrity.
Performance management and tuning.
TSQL code reviews and walk-throughs
General systems management and networking knowledge
Enterprise Resource Planning
Tribune Media Company (NYSE: TRCO) is home to a diverse portfolio of television and digital properties driven by quality news, entertainment and sports programming. Tribune Media is comprised of Tribune Broadcasting’s 42 owned or operated local television stations reaching more than 50 million households, national entertainment network WGN America, whose reach is approaching 80 million households, Tribune Studios, and Gracenote, one of the world’s leading sources of video, music and sports metadata, powering electronic program guides in televisions, automobiles and mobile devices. Tribune Media also includes Chicago’s WGN-AM and the national multicast networks Antenna TV and THIS TV. Additionally, the Company owns and manages a significant number of real estate properties across the U.S. and holds other strategic investments in media. For more information please visit www.tribunemedia.com.
Job Number: 2016-44918