This job board retrieves part of its jobs from: Emploi Étudiant | Toronto Jobs | Work From Home

Tech jobs every day in Canada!

To post a job, login or create an account |  Post a Job

   Canadian Tech jobs   

Website updated every day with fresh jobs in the IT industry

Slide 1
Slide 2
Slide 3
previous arrow
next arrow

SQL Server Database Administrator

Genoa Design International

This is a Contract position in Toronto, ON posted September 13, 2022.

SOCAN is a not-for-profit copyright collective dedicated to ensuring music creators and publishers receive what they have rightfully earned for the use of their work.

SOCAN supports and represents more than 180,000 songwriters, composers, and music publishers.

Through licensing, global royalty collection and advocacy, we help creators to keep making the music that entertains, moves, and inspires us OUR COMMITMENT TO DIVERSITY, EQUITY, INCLUSION, AND ANTI-RACISM SOCAN thrives with a variety of viewpoints, identities, and backgrounds, and we are committed to anti-racism.

Everyone is welcome to apply for our wide range of roles, regardless of gender identity, gender expression, ethnicity, race, age, culture, sexual orientation, religious belief, or physical ability.

Learn more about SOCAN’s commitment to Inclusion & Anti-Racism .

WHY WORK WITH US?

Make a difference by supporting and collaborating with a vibrant and creative community Enjoy many options for workplace flexibility and work-life balance Get involved in the rapidly changing creative space Advocate for and empower the creative community Together, we’ll help music creators earn more income and make a living WHAT WE OFFER 35-hour workweek schedule(possible flexible work options i.e., 4-day work week (position based) Twelve paid sick days annually (including five personal days) Virtual My Wellness program, including access to SOCAN fitness facility Annual Performance Incentive bonus (dependent on a personal and company performance) Defined contribution Pension Plan Comprehensive, health and dental benefitsprogram Inclusive and collaborative working environment ABOUT THE ROLE The SQL Server Database Administrator will actively work with the DBA team to provide database support across SOCAN’s business critical SQL server system.

This role reports to the Manager, Database and Release Management.

WHAT YOU’LL DO / KEY RESPONSIBILITIES Provide support on database architectural design of existing and new systems, database administration, performance monitoring tuning, troubleshooting problems and expansion Evaluate and implement products to enhance existing database solutions (reduce costs, improve efficiency, improve performance) Review, enhance and develop backup and recovery strategies depending on SLA requirements Capacity planning and monitoring database growth.

Maintain, and administer SSIS and SSAS environments.

Design, maintain and ensure High Availability solutions including replication, clustering, etc.

Design, implement and document Disaster Recovery strategies for critical business servers Perform capacity planning work on Production, UA, QA, DEV environments.

Research improvements to improve overall system performance.

Participate in after-hours support of production environment and mission-critical applications with the DBA team on a rotational schedule Communicate and coordinate with other IT teams to successfully resolve support and maintenance issues Develop and enforce database standards and best practices including performance, security, policy and procedure monitoring Deliver on assigned SQL Server Infrastructure projects, including, but not limited to new software releases, patch upgrades, feature exploitation, security, and audit, with participation throughout the project lifecycle Establish and maintain written best practices and operational procedures as build books and checklists Other duties as assigned WHAT YOU WILL BRING / QUALIFICATIONS & EXPERIENCE Education Undergraduate degree in computer science or a related field Experience 6-8 years of progressive experience as SQL Server DBA Excellent knowledge and experience in building and maintaining high availability clusters and all the associated components as replication, log shipping and always on and CDC Experience with creating database documentation including ERD’s, data dictionaries and architecture diagrams Experience in Performance Tuning Query Optimization using Performance Monitor SQL Profiler and other related monitoring and troubleshooting tools (preferably SQL Sentry and Solarwinds) Experience on database migrations upgradation and patching (including Azure SQL) Experience in implementing operational automation Ability to troubleshoot SQL Server in a VMware environment Experience in administering Oracle and MySQL and MongoDB atlas databases preferred and a definite asset Excellent listening and interpersonal skills Strong written and verbal communication skills Strong attention to detail and requirements with the ability to meet deadlines.

Ability to collect, organize, analyze, and disseminate significant amounts of information ACCESSIBILITY & ACCOMMODATION SOCAN is committed to providing an inclusive workplace environment that meets the accessibility needs of employees with disabilities.

Should you require accommodations please contact us directly at hrsocan.com and we will make the necessary accommodations.

Applications submitted to this email address will not be accepted.

EQUAL EMPLOYMENT OPPORTUNITY SOCAN is an Equal Opportunity Employer.

Hiring and other employment decisions at SOCAN are made without regard to race, colour, religion, sex, ancestry, national origin, ethnic origin, age, disability, citizenship, veteran status, sexual orientation, record of offences, marital status, family status, or any other characteristic protected by federal, provincial, or local law, regulation, or ordinance.

If you don’t see yourself fully reflected in every job requirement listed on the posting above, we still encourage you to reach out and apply.

Research has shown underrepresented groups often only apply when they feel 100% qualified.

We are committed to creating a more equitable, inclusive, and diverse company and we strongly encourage applicants of all genders, ages, ethnicities, cultures, abilities, sexual orientations, and life experiences to apply Thank you for your interest in our company; we will be in touch with those candidates we wish to interview.

To learn more about SOCAN, go to www.socan.com .

You can also follow us on LinkedIn, Twitter, Instagram, and Facebook (SOCANmusic/SOCANmusique).