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.
Senior Data Analyst converting data into strategic insights at Introhive. Collaborating with teams to enhance data quality and creating actionable reports for clients.
Senior Analyst supporting the development of reporting solutions within the Chief Data Office at RBC. Building dashboards, ensuring data quality, and collaborating with business users.
Research & Data Analyst supporting Alberta's health system through data analysis and collaboration. Engaging with stakeholders to enhance public health initiatives and improve care outcomes.
Senior Data Analyst at Jane responsible for building financial datasets and dashboards. Collaborating with Finance and Payments teams to provide actionable insights for critical decision making.
Clinical Data Analyst developing analytical solutions for clinical study data reporting and analytics at Alimentiv. Collaborating with stakeholders and providing operational quality through performance metrics analysis.
Manager of Analytics leading data analytics function across multiple game titles in a fully remote gaming studio. Managing and developing a team of analysts to deliver insights and improve methodologies.
Manager of Data Analytics leading a team to drive insights at Voldex, a leading gaming company. Ensuring high standards in analytics methodologies and team development.
Data Analyst seeking to provide personalized tutoring and lessons in analytics and data interpretation. Educators engage with students to enhance analytical skills through various modern data tools.