SQL Developer

Date Posted: May 03, 2021
Application Deadline: May 16, 2021
Start Date: Jul 01, 2021

Salary From: 60K To 65K
Province: Ontario
Region: Metro Toronto Area
City: Toronto
Employee Benefits: Health, Pension, Other (e.g. flex time, comp tickets, etc.)
Check Additional Info section for more Employee Benefits
Organization's Field/Discipline: The Arts
Job's focus: Administrative
Job Type: Full-time
Career Level: Intermediate

Organization Description

The National Ballet of Canada

One of the top international ballet companies, The National Ballet of Canada was founded in 1951 by Celia Franca. A company of 70 dancers with its own orchestra, the National Ballet has been led by Artistic Director Karen Kain, one of the greatest ballerinas of her generation, since 2005.
 
Renowned for its diverse repertoire, the company performs traditional full-length classics, embraces contemporary work and encourages the creation of new ballets as well as the development of Canadian choreographers. 



Job Description

The National Ballet of Canada is one of the most exciting, innovative arts institutions in Canada, and is regularly ranked among the top ten ballet companies in the world. Established by founder Celia Franca in 1951, The National Ballet of Canada presents a full range of traditional full-length classics and has been an innovative commissioner of new contemporary work by some of the most important choreographers and designers in the world. The National Ballet is deeply committed to the values of equity, diversity and inclusion across the organization, and through community education programs that bring dance to the broadest possible community.  
 
The ideal candidate will be a member of a collaborative team working on customization, integration and support of existing company CRM application in a multi-sales-channel environment including desktop, web and mobile. Primary responsibility includes creation, update and optimization of SQL stored procedures, functions, views, ad-hoc queries, and SSRS based reports & dashboards. Excellent verbal and written skills are a requirement. During season occasional weekend support may become necessary.
 
 
General Responsibilities Include:
  • Create/update custom screens, reports, dashboards using T-SQL & SSRS
  • Write stored procedures, functions, views, etc. database objects/entities for in-house applications
  • Write SQL queries to extract, process and deliver data for different company projects
  • Troubleshoot and provide end user support for Tessitura and MS Dynamics SL 2018
  • Support and troubleshoot backend SQL database for various in-house and vendor supplied custom solutions/applications including Tessitura Analytics, N-Scan, WordFly (Tessitura Email Marketing Software), National Ballet Electronic Leads System (NBELS), National Ballet Electronic Tax Receipts, Tessitura Network Web (TNEW) and National Ballet Website


Requirements:

Technical Skills:

a.Must have:

  • Strong knowledge and experience with Microsoft SQL database (2012 and above)
  • Ability to build, enhance and support complex reports using SQL server Reporting Services (SSRS)

b.Highly desirable:

  • Knowledge in Tessitura CRM and MS Dynamics

c.Nice to have (any/some of the following):

  • Report writing experience in Sybase InfoMaker
  • Knowledge of.NET Core, C#, REST/SOAP Web Service, LINQ, Entity Framework, MVC, Razor, Blazor
  • Experience using tools and apps - Visual Studio/VS CODE, GitHub, ZenDesk, Asana, Slack
  • Work experience as an Agile Scrum team member
  • Knowledge of JavaScript, jQuery, HTML, CSS, Bootstrap, JSON
  • Cloud computing experience in AWS
  • Familiar with DevOps and CI/CD concept and tools
  • Familiar with the concept of Big Data and related databases
  • Knowledge of MS SharePoint development
  • Excel macro and Power Query for Data Analysis 

Soft skills:

  • Punctual, prepared, organized, self-starter and self-disciplined
  • Results oriented, thorough, analytical and conceptual thinker
  • Team player, strong collaboration skills and ability to work with non-technical staff
  • Able to multi-task and produce under high pressure situations

Experience:

  • Minimum 3-4 years experience working with SQL Server database and query writing using SQL server 2012 and above
  • Minimum 3-4 years of hands-on experience in building reports and dashboards using SSRS 

Education:

  • Degree in Computer Science, Engineering or any other subject with major in Information Technology

Certification:

  • Nice to have - Microsoft SQL Server related developer certifications


Additional Info:

Employees are currently working from home offices and will continue to do so until Fall 2021.

The National Ballet of Canada is committed to fostering an inclusive, accessible, and equitable environment where employees feel valued and respected.  We are committed to reflect the diversity of our community, our city and our country. We strive to ensure our recruitment and selection processes are bias-free.  We welcome and encourage submissions from Indigenous, Black and People of Colour, the Deaf and disabled as well as individuals of all genders, cultures, ethnicities, sexual orientations, and abilities.  We are committed to accommodating applicants with disabilities throughout the hiring process, in accordance with the Accessibility for Ontarians with Disabilities Act (AODA). The Human Resources department will work with applicants requesting accommodation at any stage of the hiring process.
 

How to Apply:

Qualified candidates are to forward their resume, cover letter and salary expectations as a single PDF document to HR@national.ballet.ca with the subject heading: "SQL Developer" by no later than May 16, 2021.  Resumes will be reviewed as soon as they are received. We thank all applicants for their interest; however, only those selected for an interview will be contacted.  Successful candidates will be subject to a criminal background check.  This position offers competitive compensation and benefits package commensurate with experience.
 

Please Note: 

Podcasts

Listen to JobBoard Success Stories Podcasts and learn how to navigate work in arts and culture. 

Have a JobBoard success story you'd like to share in a podcast? Contact mona(at)workinculture.ca
 
Job Post Tips
For tips on how to write or read a job post visit:
Tip 1 on salary ranges
Tip 2 on highlighted sections
Tip 3 on job benefits
Tip 4 on career levels
 
DiscoveryBoard

Looking for work? Consider volunteering. Check out DiscoveryBoard for positions. 
According to StatCan, "volunteers can make key contacts that may help them improve their performance or even lead to other employment opportunities."

JobBoard Policy