Job Database Engineer in Toronto

CanadaHelps is looking for an innovative, goal-oriented, and focused Database Engineer with a passion for social change to join our team. This is an opportunity to join one of Canada’s first and North America’s most successful social technology organizations. We are a fast-growing, dedicated team of entrepreneurial-minded peers who have a passion for helping small- and medium-sized charities succeed, while engaging with donors to increase giving in Canada.

We believe technology and data are transformational game-changers for generating social profit. We democratize access to technology by providing best-in-class, easy-to-use online fundraising software and training to more than 25,000 registered charities across Canada (and the number of charities is rapidly growing). We are the market leader and over the past 20 years we’ve helped over 3 million Canadians donate over $2B to Canadian charities.

About the Role

This is a unique opportunity to support our donors and charities and make sure their data remain secure. As a Database Engineer, you will be responsible for managing all of our SQL Servers to ensure our databases are operating optimally in a 24/7 environment. This responsibility includes installation, maintenance, configuration and access control for databases. Making sure Developers are following the best practices while writing scripts which are going to execute in our production environment that will have a direct impact on our customers. The Database Engineer will work closely with the Solution Architect and DevOps team, ensuring the company infrastructure is functioning at all times. You will share responsibility for deploying code to production, helping ensure only authorized changes are promoted to our production environment. As part of this support, you are expected to coordinate with the Solution Architect, DevOps team and the CTO to ensure that someone is always available 24/7 to handle escalations.

Responsibilities

Responsibilities will include but are not limited to:

• Design, implement, and maintain our production database infrastructure, including backups, replication, and disaster recovery;
• Work closely with the Solution Architect to identify opportunities for future architecture improvements, and contribute to the development of long-term technology strategies;
• Coordinate with other members of the Technology team, including developers, team leads, and infrastructure specialists, to ensure that backend/DB changes are rolled out each release;
• Provide technical expertise and support to the Technology team, helping to ensure that the backend data model meets the current and future requirements and improvements;
• Monitor the database performance and identify areas for improvement, including potential areas for automation or process optimization;
• Work closely with our engineering team to design data models and schema for new features and projects;
• Create and maintain documentation related to the backend database model, ER Diagrams and also process diagrams;
• Develop and maintain scripts and automation tools to manage and monitor our databases;
• Perform regular database maintenance tasks, including optimizing indexes and analyzing database storage;

Required Skills and Experience

• 5+ years of DBA experience supporting MSSQL, MySQL and PostgreSQL;
• Azure cloud experience (e.g. Azure SQL Database services, Compute, networking, Storage and security);
• 3+ years of experience installing and configuring Windows servers in a virtualized environment (VMWare experience a plus);
• 1+ years of experience supporting Active Directory;
• Advanced proficiency with SQL and database query optimization;

You will excel in this role if you:

• Have a passion for continuous improvement and learning;

• Are comfortable with ambiguity and a fast paced environment;

• Understand the performance management process and are dedicated to your team members’ growth;

• You own the deliverables;

• You enjoy working with different teams and understand that accountability is key;

Here is what we have to offer:

• A chance to make a difference with a unique opportunity to add major value as a key member of a small team;

• A Not-For-Profit and a forward-thinking, technology-focused business, (we’re a unicorn! )

• A full-time, permanent position with flexible work, Growth & Development stipend, Health & Dental benefits and RRSP matching

• The opportunity to work with super nice people who want to change the world for the better! (and highly respected professionals)

• A Mission driven, “get things done”, open, collaborative and flexible environment

• A lifestyle friendly, work-life balance

Accommodation: CanadaHelps is an equal opportunity employer, and welcomes and encourages applications from all persons including those with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process. If you require accommodation at any stage of the recruitment process, please contact accessibility@canadahelps.org so that appropriate accommodations can be made.