Database architect Jobs in East York, ON

Job

Database Developer

Description

Position Title : Database Developer

1 Year Contract

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 industrys leading provider of digital media and entertainment services. We offer our clients fully integrated solutions for the entire content lifecycle. Deluxes 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 whos 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 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 youre an independent thinker with a high level of ingenuity and the above qualifications then wed 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 worlds 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 3500 of the most talented individuals developers and industry veterans worldwide. For more information please visit .

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 companys HR representative if you need assistance completing any forms or to otherwise participate in the application process.

Key Skills

Databases,SQL,Database Development,PL / SQL,Microsoft SQL Server,ssrs,Database Design,SSIS,T Sql,Sybase,Data Warehouse,Oracle

Employment Type : Full-Time

Experience : years

Vacancy : 1