Senior Database Developer​/Administrator

About the job 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.

• 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

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.

• 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);
• 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.

• 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…