Analyste des données clients chez EDC, société d’État aidant les entreprises canadiennes à réussir à l’étranger. Modernisation des pipelines, tableaux de bord et solutions analytiques marketing.
LP
Data Analyst – Expert DBA
Posted via LinkedIn Recruiter (not a company profile)
Posted 4 months ago
About the role
- Manage and optimize large-scale Azure SQL databases in a banking environment. Focus on performance tuning, stability, and scalability.
Responsibilities
- Monitor and analyze database performance using Query Store and execution plans. Diagnose and resolve complex query and workload performance issues. Tune queries and address resource bottlenecks to improve database efficiency. Collaborate with development teams to optimize application-database interactions. Perform capacity planning and develop scaling strategies for large databases (40TB+). Conduct root cause analysis for critical incidents and system outages. Manage and tune Azure SQL PaaS components, including Hyperscale architecture and resource models (DTU/vCore). Implement best practices for performance tuning, stability, and scalability. Assist with troubleshooting high resource contention and optimizing workload performance. Support database security measures and compliance standards as needed.
Requirements
- 10+ years of experience as a Senior/Expert DBA in Azure SQL environments. Proven expertise managing very large databases (40TB+). Extensive experience in Azure SQL PaaS performance tuning and optimization. Deep understanding of query plan regressions, parameter sniffing, cardinality estimation issues, query timeouts, blocking, and deadlocks. Hands-on experience with Query Store and execution plan analysis. Strong T-SQL performance tuning skills. Knowledge of indexes, statistics, and recompilation strategies. Experience with DTU/vCore models, Hyperscale architecture, and scaling strategies. Troubleshooting and root cause analysis skills for production incidents. Familiarity with Azure Monitor, Log Analytics, and Application Insights (Nice to Have). Understanding of Azure SQL security features (auditing, threat detection, managed identities) (Nice to Have). Experience with disaster recovery and geo-replication strategies (Nice to Have). Exposure to Dynatrace for performance monitoring (Nice to Have). Excellent communication skills, problem-solving abilities, and collaboration skills.
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
No Education Requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Customer Data Analyst modernizing EDC’s customer data ecosystem at Canada’s export - finance Crown corporation. Building Microsoft Fabric pipelines, Power BI assets, and marketing analytics solutions.
Senior Data Analyst building trusted financial metrics, dbt models, and Looker dashboards for Jane’s clinic - management SaaS platform. Partnering with Finance and Payments to guide critical decisions.
Digital media specialist improving campaign tracking, reporting and analytics at a Toronto marketing technology lab. Automating insights with AI while maintaining data quality and measurement accuracy.
Data Analytics Intern analyzing new features and updates for Montreal - based mobile gaming studio Ludia. Building data modules, dashboards, and insights to optimize game operations.
Senior Data Analyst transforming Sun Life insurance and financial - services data into actionable marketing insights. Building SQL, Python, AWS, Adobe Analytics, reporting, and dashboard solutions.
Student Data Analyst supporting Sun Life’s financial security mission through stakeholder insights and Tableau KPI reporting. Building data analysis skills during a four - month hybrid campus placement.
Analyste de données principal modernisant les plateformes et pipelines de données d’EDC, société financière publique canadienne. Traduction des besoins opérationnels en modèles, règles de transformation et récits utilisateurs.
Senior Data Analyst modernizing enterprise data capabilities at Export Development Canada. Translating business requirements into data models, mappings, pipelines and Agile delivery artifacts.
Data Analyst improving Instacart’s online grocery fulfillment quality through operational analytics. Monitoring retailer performance, diagnosing issues, and delivering recommendations to cross - functional stakeholders.