Entertainment One

Database Administrator

CA-ON-Toronto | CA-ON-Brampton
1 month ago
# of Openings
1
Category
Information Technology
Type
Permanent Full-Time

About Entertainment One

Entertainment One Ltd. (LSE:ETO) is a global independent studio that specialises in the development, acquisition, production, financing, distribution and sales of entertainment content. The Company’s diversified expertise spans across film, television and music production and sales, family programming, merchandising and licensing, and digital content. Through its global reach and expansive scale, powered by deep local market knowledge, the Company delivers the best content to the world.


Entertainment One’s robust network includes film and television studio The Mark Gordon Company; content creation venture Amblin Partners with Steven Spielberg, DreamWorks Studios, Participant Media, and Reliance Entertainment; newly-launched MAKEREADY with Brad Weston; leading feature film production and global sales company Sierra Pictures; unscripted television production company Renegade 83; world-class music labels Dualtone Music Group and Last Gang; and award-winning digital agency Secret Location.

The Company’s rights library is exploited across all media formats and includes more than 100,000 hours of film and television content and approximately 40,000 music tracks.

www.entertainmentone.com

Position Summary

Based in our office in Brampton, the MSSQL Server Database Administrator’s role is to design, develop, install, monitor, maintain, and performance tune production databases while ensuring high levels of data availability. This individual is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

Responsibilities

  • Assume enterprise-wide ownership of all MS SQL Server performance tuning and maintenance
  • Monitor SQL Server health, growth, and proactively manage enterprise data systems toward 100% uptime
  • Hands-on management of BI/Data Analytics tools and jobs running on SQL Server
  • Hands-on development of strategic performance dashboards & reports using SSIS, SSRS & SSAS
  • Provide day-to-day oversight and support of production databases, data warehouse/data marts
  • Assist in design, development, implementation and maintenance of application systems (web and non-web)
  • Extract, load and join data from multiple databases
  • Administer SQL Server user accounts, roles and permissions
  • Create, maintain and organize knowledge base of existing data systems documentation
  • Efficiently produce ad-hoc SQL based reports in an on-demand environment
  • Gather functional specifications and business requirements for new programming tasks including DTS packages, stored procedures, triggers etc.

Key Competencies

  • 5+ years of MSSQL database administration and development
  • 3+ years of data analysis and reporting
  • Proficient in T-SQL, Stored Procedures, Triggers, Multidimensional Expressions (MDX), Cubes
  • Knowledge of Replication, DTS/SSIS, index management, and statistics
  • Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
  • Solid knowledge of relational database design
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server
  • Strong SSRS report writing experience
  • Experience in implementing operational automation using scripts
  • Ability to prioritize tasks and work independently
  • Strong interpersonal, communication and analytical skills
  • Knowledge of computer security procedures and protocol
  • Demonstrated strong organizational, analytical, and problem-solving skills.
  • Strong documentation skills
  • Comfortable completing technical exam

Knowledge & Experience

  • Bachelor's Degree (preferably in computer science or business) or equivalent combination of education and work experience
  • Knowledge of VMware and SAN disk configurations as it relates to MSSQL is a plus

 

 

We thank everyone for their interest but only those candidates selected for an interview will be contacted.

 

We are committed to providing accommodations for persons with disabilities. If you require accommodation, we will work with you to meet your needs.