Senior Backend Developer, French Services
Radio-Canada
JavaScript.NETNode.jsReactTypeScript
Senior Database Developer
The Conference Board
full-time
Posted on:
Location: 🇨🇦 Canada
Visit company websiteSalary
💰 CA$80,793 - CA$109,308 per year
Job Level
Senior
Tech Stack
AzureCloudERPETLMS SQL ServerPythonSQLSSIS
About the role
- Maintain, monitor, and support our on-premise Microsoft SQL databases for sales, marketing and research data.
- Manage existing SQL Agent jobs, SSIS integration packages and stored procedures
- Conduct performance tuning of SQL queries for automated job primarily backup and mirroring.
- Support website database replica for Power BI and SQL reporting used by internal users.
- Assist in setup and ongoing maintenance of big data environment for our research team.
- Design and manage end-to-end solutions for both current and future state data systems.
- Setup, configure and manage Microsoft Fabric for enterprise use and data governance.
- Create ETL between on prem databases and the Dataverse for CRM, ERP and Microsoft SaaS.
- Develop a technology data model and schema to support new systems
- Propose path forward for Cloud based database setup from MS SQL to Azure.
- Automate database processes, tasks, and procedures using SQL, Azure and power automate.
- Setup role-based access to safeguard the security and integrity of databases and applications.
- Prepare monthly report on database utilization, capacity usage and actionable recommendations.
- Manage tracking sheet of all database issues, status and how we plan to mitigate.
- Develop technical workplans for roadmap project assignments.
- Collaborate with business units to collect application and database requirements for new applications
- Conduct Proof of Concepts for new database technology and provide recommendations to the Director, IT.
- Demonstrate a strong commitment to delivering high-quality and professional values
Requirements
- Post-secondary degree – Bachelor of Science, Computing /Engineering, or a related field
- Minimum of 5 years of relevant experience in database management and data engineering.
- SQL Expertise: Strong knowledge of efficient data extraction from legacy systems (e.g., SQL Server, e-data) and cloud databases for Azure Cloud.
- Write queries for reporting dashboards; develop stored procedures to perform business processes, automate tasks using jobs and agents.
- ETL Tools (SQL SSIS): Seamless data movement from transactional systems to the data warehouse.
- Build SSIS packages to extract data from ERP systems and load into Azure Fabric for analytics.
- Data Modeling & Design: Normalize and optimize schemas for scalability and performance.
- Design star schemas for BI reporting; refactor legacy schemas to reduce redundancy.
- Cloud Data Services (Azure Cloud): Support hybrid cloud architecture, migrate on-prem SQL databases to Azure Cloud where feasible; configure backups and proactive monitoring.
- Scripting (PowerShell, Python, Notebooks): Automate maintenance tasks and enable advanced analytics.
- Create PowerShell scripts for nightly backups; use Python for data validation scripts.
- Soft Skills (Communication, Mentoring): Ability to communicate effectively through MS Teams, Email and SP collaboration tools. This includes being responsive, reaching out when assistance is required, seeking feedback in alignment with growth mindset.
- Availability to work outside of regular hours/occasional weekends is required
- Nice to Haves: Azure DevOps or Git for tracking changes to database objects and scripts, managing stored procedures and schema changes
- Experience working with CD/CI pipelines, AI/ML, security tools and frameworks.
- Microsoft and ITIL Certification
- Bilingualism in English and French
Similar jobs on JobTailor
Intermediate Java Developer
Horizon Software International, LLC
AndroidAWSCloudDynamoDBJavaRedisSQL
Stagiaire en Génie Logiciel – Développeur Python
SOGECLAIR
CloudPythonSQL
Senior Backend Product Software Engineer, Storage Management
Dropbox
Specialist Java Backend Developer
RBC
CloudJavaMicroservicesSpringSpring BootSpringBoot