Senior Data Engineer (Developer DBA)

Fundserv has been the indispensable hub for the Canadian investment industry for over 30 years, connecting manufacturers, distributors, intermediaries, and service providers to build solutions that simplify business interactions and promote innovation in the industry. We do this by focusing on our corporate values of Collaboration, Adaptability, Integrity, and Respect. We are looking for a Senior Data Engineer who will be responsible for designing and developer database systems, data models and schemas, as well as building data pipelines assembling large, complex data sets for analytical purposes. In this role, you will… Work in an Agile team while collaborating with other teams across product lines to define database requirements and technical specifications. Develop and optimize SQL and PL/SQL scripts, procedures, packages, and functions. Support database design, schema changes, and data model improvements to enhance performance, scalability, and data integrity. Install, configure, and maintain Oracle databases and related components. Build and support ETL processes and data pipelines for reporting and downstream integrations. Monitor database health, troubleshoot Oracle performance issues, and implement tuning improvements. Manage database security, access controls, backup/recovery processes, and deployment support. Create and maintain technical documentation and track database development activities. Why you are the person we’re looking for… You’ve demonstrated the ability to do the following, gained through education and/or experience: Strong understanding of relational database design and logical/physical data modeling. Practical experience using SQL and PL/SQL for database operations, scripting, and automation. Strong working knowledge of relational database platforms, especially Oracle 19c/23ai and Exadata Cloud Customer (ExaCC) familiarity with cloud technologies, including Oracle OCI and Azure, is a strong plus. Experience with Oracle Forms and Oracle APEX for maintaining, supporting, or developing database-driven applications. Comfortable working in Unix/Linux environments, including shell scripting and automation. Proven ability to build and optimize data pipelines and workflows using technologies such as Talend, Azure Synapse, or Microsoft Fabric. Experience in automated database deployment experience using Liquibase The following is not required but will be a bonus: AI-assisted database development is a nice-to-have capability that may help streamline development and maintenance activities. Starting base salary range: $120,000 - $130,000/year AI Statement Fundserv leverages the use of artificial intelligence (AI) to support our recruitment process through assistance with initial resume screening. However, AI is not used to make final assessment, selection or hiring decisions, and the hiring team maintains oversight over the end-to-end recruitment process. This job posting is for an existing vacancy. Fundserv's total compensation package includes a competitive performance pay program, employer-paid group benefits, an RRSP matching program, and more. We recognize that there are different paths to gaining skills, so if you have diverse experience which doesn’t match the criteria exactly but you think you would be great in this role, we invite you to apply! Why Work Here Our Benefits and Perks We’ve consistently been recognized as a GTA Top Employer and a Canada Top Small & Medium Employer. Below are some of the reasons why: Employer-paid premiums for group health plan, including a Healthcare Spending Account Up to $2,000 per year for mental health practitioners and corporate-wide mental health days per year Wellness benefit for gym memberships, workout equipment, meditation and wellness apps, and more! RRSP matching program $500 one-time stipend for home office equipment and monthly home-internet subsidy Access to tools like LinkedIn Learning and Pluralsight and additional training opportunities EI top-up programs for maternity and parental leave, family medical, and family caregiver leave Ability to work out of province for 20 days after 2 years of employment Our Hybrid Work Policy We recognize the importance of flexibility and work-life balance, and as such our hybrid model is purpose-led – we come in for a reason, not to fill a quota.

The role involves designing and developing database systems, data models, and complex data pipelines for analytical purposes. Key duties include optimizing SQL/PLSQL scripts, maintaining Oracle databases, and managing database security and recovery processes.

Candidates need strong experience in relational database design and proficiency with Oracle platforms, including OCI and ExaCC. Experience with ETL tools like Talend or Azure Synapse and automated deployment via Liquibase is required.

• Group health plan • Healthcare spending account • Mental health practitioner coverage • Corporate-wide mental health days • Wellness benefit for gym and apps • RRSP matching program • Home office equipment stipend • Home-internet subsidy • LinkedIn Learning and Pluralsight access • EI top-up programs for leave

Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.

• SQL
• PL/SQL
• Oracle 19c/23ai
• Exadata Cloud Customer
• Oracle OCI
• Azure
• Oracle Forms
• Oracle APEX
• Unix/Linux
• Shell scripting
• Talend
• Azure Synapse
• Microsoft Fabric
• Liquibase
• Data Modeling
• ETL Pipelines
• Office Equipment
• Relational Database Design
• Hybrid Model
• Oracle Database 19c
• Backup and Recovery System
• Database Systems
• Workflow Management
• Azure Synapse Analytics
• Microsoft Access
• Adaptability
• Agile Methodology
• Artificial Intelligence
• Automation
• Microsoft Azure
• Mental Health
• Unix
• Data Engineering
• Data Integrity
• Extract Transform Load (ETL)
• Relational Databases
• Database Deployment Management
• Database Design
• Database Development
• Database Security
• Linux
• Oracle Exadata
• Scalability
• Innovation
• Operations
• Oracle Databases
• Caregiving
• Oracle Apex
• Resume Screening
• Shell Script

• Data & Analytics
• Technology
• Software
• Engineering
• Finance & Accounting
• Developer/Engineer
• Data Engineer
• Software Developers
• Database Administrators

Expérience minimale

5+ ans

Langue de l’offre

anglais

Heures de travail

40 heures par semaine