Position Title: Database Developer
Location: Toronto, Canada
About the Role
For the past century, Deluxe Entertainment Services Group has been committed to providing content owners and creators with the tools and talent they need to bring the most compelling and exciting stories to life. The Deluxe ecosystem offers an end-to-end collective of flexibility, efficiency, quality and value that encompasses a breadth of service and technology innovation, all of which has grown in response to the needs of our customers. Deluxe Entertainment Services Group is the industry’s leading provider of digital media and entertainment services. We offer our clients fully integrated solutions for the entire content lifecycle. Deluxe’s world class post-production and distribution services are unique and unmatched by any company globally. Our business has evolved from leading film lab services to a global content solutions provider for the entertainment, advertising and media sectors.
We are looking for a self-motivated, multi-talented individual to provide the necessary technical experience to coordinate, design, develop, implement, and maintain a large database system. Development will include providing critical data reporting to the who’s who of the Hollywood entertainment industry. This position will be located in Toronto, ON.
Key Responsibilities
• Perform database design, modeling, and implementation of new databases both clustered and non-clustered environments on Microsoft platforms including MS SQL Server, and MS SQL Server hosted on AWS RDS.
• Will be responsible for writing advanced SQL queries, stored procedures and/or triggers, analyzing and optimizing queries including unit testing.
• Expertly create, maintain and support ETL processes for existing and future data sources.
• Performs database design and integration of systems, including client/servers’ communication and web services.
• Data analysis and data modelling, using Tableau, SSRS, and Power BI.
• Provide production database administration and support integration with development members and third parties during the application development lifecycle.
• Perform quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.
• Provide support of mission critical systems and serves as primary point of contact for coordination and resolution of SQL Server issues with Microsoft.
• Design and develop web applications using Python/Flask, JavaScript/React stacks in collaboration with UI/UX developers.
• Maintain and enhance legacy applications built with PHP.
• Write clean, maintainable, scalable code, and perform unit and integration testing.
• Use version control systems such as Git for collaborative development and code management.
Qualifications
The ideal candidate will possess the following knowledge, experience, and skill-set:
Technical expertise includes:
• Database expertise including MS SQL Server, SQL Queries, clustering technologies both clustered and non-clustered environments.
• Experience in Oracle and PostgreSQL a plus.
• Hands-on experience with AWS services such as RDS, EC2, and S3.
• Proven background in web technologies including complete definition from infrastructure to software technologies.
• Experience in HTML, JavaScript, PHP, Python, Visual Studio, API and git.
• Platform expertise including Windows Server. Experience on Linux would be a plus.
• Web server technologies including IIS (ISAPI components and filters) with Apache and Tomcat a plus.
• Experience in ASP .NET, C#, Java, C++ would be a plus.
• Proven experience with database monitoring and tuning tools.
• Experience in maintaining high-reliability web deployments (geographical distribution, server farms, DNS management).
• Minimum 5+ years of database development with experience in database management systems including MS SQL Server, implementing data warehouse projects/programs, including both logical designs and physical implementation.
• BS degree or higher in Computer Science and/or Electrical Engineering.
• Should be able to effectively document all processes, designs, and data flows.
• Ability to provide database technical leadership and support to management, peers, and developers. Solid troubleshooting, problem solving, and analytical skills, and the ability to reach innovative options quickly required.
• Ability to communicate, in both oral and written form, effectively to upper level management and peer engineers internally, and externally to customers with various backgrounds either technical staff or marketing personnel.
• Ability to work well under pressure and tight deadlines.
If you're an independent thinker with a high level of ingenuity and the above qualifications, then we'd like you to join our team!
About the Company
Deluxe, a subsidiary of Platinum Equity, is a global leader in media and entertainment services for film, video and online content. Since 1915, Deluxe has been the trusted partner for the world’s most successful Hollywood studios, independent film companies, TV networks, exhibitors, advertisers and others, offering best-in-class solutions in post-production, distribution, asset and workflow management, and cloud-based technologies.
With headquarters in Los Angeles and offices around the globe, the company employs over 3,500 of the most talented individuals, developers, and industry veterans worldwide. For more information, please visit www.bydeluxe.com.
Diversity Statement
Deluxe is committed to inclusivity, fostering an environment where every employee feels comfortable bringing their full selves to work. It is our policy to provide equal employment opportunities to all applicants and employees. Applicants will receive consideration for employment without regard to, and will not be discriminated against, on the basis of race, color, religion, creed, national origin or ancestry, sex, age, physical or mental disability, veteran status, sexual orientation, gender identity or expression, genetic information or any other legally recognized protected basis under federal, state or local laws, regulations or ordinances. Deluxe will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable local, state and federal law.
Applicants with disabilities may be entitled to reasonable accommodation under the terms of the Disabilities Act and certain state or local laws. A reasonable accommodation is a change in the way things are normally done which will ensure an equal employment opportunity without imposing undue hardship on Deluxe. Please inform the company's HR representative if you need assistance completing any forms or to otherwise participate in the application process.