C

CDPQ

Global pension fund manager and investor

Conseiller – Principal - ère, E, Administration de bases de données SQL

Database AdministrationConfirmed live in the last 24 hours
Full-timeMontreal, QC, Canada

About the Job

Requirements

  • A minimum of five years of experience as an application database administrator on Microsoft SQL Server 2012 and 2016 platforms.
  • Proficiency with related tools and technologies, including SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Structured Query Language, stored procedures, PowerShell, and SQL Server Agent.
  • Experience with information environments, including data warehouses and data marts.
  • Availability to provide rotating support, including evenings and weekends.
  • Fluency in French, both spoken and written.

Responsibilities

  • Administer and manage database environments for development, testing, and production.
  • Ensure the performance, capacity, security, and reliability of transactional databases.
  • Recommend and optimize database-environment practices and configurations.
  • Develop application-required functionality within database environments.
  • Optimize existing components, including stored procedures, scripts, and scheduling.
  • Perform physical data modeling.
  • Act as a technical reference and advisor for application-development teams.
  • Document deployment procedures.
  • Support production systems during deployments, releases, and incidents.
  • Participate in testing with developers to ensure solution quality and stability.
  • Evaluate, recommend, and contribute to the evolution of database tools and environments.
  • Contribute to platform-continuity and modernization initiatives, including migration projects.

Desired Qualifications

  • Experience in finance, financial services, or a highly regulated environment.
  • Knowledge of DevOps practices, including continuous integration and continuous delivery pipelines and deployment automation.
  • Experience with Apache Iceberg, Oracle, and Sybase.
  • Knowledge of hybrid environments, including on-premises and cloud environments.
  • Experience in development and scripting, particularly with Python, SQL, and other scripting languages.

About the Company

CDPQ

Global pension fund manager and investor

La Caisse manages the funds for Québec’s public and parapublic pension and insurance plans and invests globally to generate long-term returns that support the province’s economy. It allocates capital across asset classes like private equity, stocks, bonds, private credit, real estate, and infrastructure, using subsidiaries such as Ivanhoé Cambridge and Otéra Capital to build a diversified portfolio. It is government-backed with a mandate to balance returns and public development, operating with a global network of offices and a governance framework focused on transparency and responsibility. Its goal is to maximize long-term value for Québec’s pension and insurance plan members while promoting economic growth in Québec and advancing climate-related investments, including a carbon-neutral portfolio by 2050 and about $400 billion in climate action investments by 2030.

Company size
1,001-5,000
Company stage
Not listed
Total funding
$10.9B
Headquarters
Montreal, Canada
Founded
1965

Recently Posted Jobs

Explore more opportunities at CDPQ

See more jobs