Senior Database Developer / Administrator

Our client, an independent financial firm, is one of Canadas leading multi billions dollars investment managers. They deliver customized multi-asset solutions across public and private market asset classes to institutional, financial intermediary and private wealth clients across North America, Europe and key markets in Asia. They strive to be at the forefront of investment-management science, and we are passionate about creating sustainable wealth for clients. Our client is recognized for the talented people. Their teams collaborate and seek to draw on the global industries most innovative and diverse offerings to craft strategies that meet the needs of any client, anywhere they are located.

Why join:

• Inclusive workplace and diverse background of employees
• Growth and development opportunities
• Entrepreneurial industry-leading company with a purposeful mission
• Flexible work arrangements, competitive compensation and benefits
• Collaborative approach, innovative and culture of integrity
• Ambitious organization who strives for excellence
  
  

What we are looking for:

The candidate will be responsible to deliver database services within the Application Services team providing DBA expertise and support to all services leveraging database technologies. This will include database design, performance optimisation and ETL processes. The candidate will have the opportunity to bring ideas to make the most out of our current system architecture and participate in its evolution.

Your responsibilities:

As part of your duties, you will be assigned the following responsibilities:

• SQL programming (Views, Functions, Stored Proc, SQL CLR);
• Design and development of data migration and data consolidation between various databases;
• Work with technology teams in data modeling, database design, efficient SQL for fast application performance, including advanced architectural techniques;
• Build high-quality reusable code that can be used as a framework for data integration;
• Design and deliver ETL and related components (SSIS);
• SQL Server Administration (installation, configuration, maintenance, security);
• Administration of backup procedures and disaster recovery plans;
• Responsible for the monitoring and management of systems ensuring all systems checks are completed and documented and any service incidents are managed, resolved or escalated in a timely manner;
• Troubleshooting of operational problems;
• Proactively put forward ideas that speak to project objectives.
  
  

Must have requirements to be successful in this role:

• Have a bachelor's degree in IT or equivalent;
• At least 3 years of experience as a Database Developer/Administrator;
• Knowledge and working experience of the Azure Cloud Platform;
• Excellent verbal and written communication skills in French and English;
• Excellent ability to document requests;
• Aptitude for problem solving, and strong analytical and synthetic thinking skills;
• Innovation, initiative, creativity, organization, thoroughness, self-sufficiency; and a team player;
• Ability to work in a production support environment;
• Knowledge of Data Warehousing an Asset;
• Knowledge of REST API, JSON, XML an Asset;
• Knowledge of C# and/or Java an Asset.
  
  

This role requires your physical presence (hybrid) at our client offices. In accordance with their Pandemic Workplace policy (except where prohibited by law), proof of full vaccination will be required in order to access the offices of our client and its affiliates, unless you have been granted reasonable accommodation based on documented medical or religious grounds, or as otherwise required by applicable law. Should an applicant demonstrate that the vaccine cannot be administered on medical or religious grounds, or as otherwise required by applicable law, our client will assess on a case-by-case basis, whether reasonable accommodation can be provided.

Our client subscribes to the principle of employment equity. Their staff is their most valuable asset and our goal is to create an inclusive and equitable environment where everyone can reach their true potential.

They are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability, genetic information, or any other federal, state or local protected class. Our client will not tolerate any form of discrimination or harassment.

All staffing decisions, including hiring and promotion decisions, will be based on merit, skills, performance and business needs. They are pleased to receive applications from qualified individuals from a variety of backgrounds. Job applicants who are individually selected for an interview will be notified that accommodations are available upon request. If a selected participant requests accommodation, Our client shall consult with the applicant and provide, or arrange for the provision of a suitable accommodation in a manner that takes into account the applicants accessibility needs due to disability.

We thank all applicants for their interest in a career with our client. We will only communicate with those selected for an interview.