Data Analyst – Expert DBA

Tagline: Are you an experienced Data Analyst ready to optimize large-scale Azure SQL environments? Apply Now!

Working with one of our top financial clients, this role calls for a Data Analyst – Expert DBA. This position involves managing and optimizing performance of large-scale Azure SQL databases within a high-demand enterprise banking environment, focusing on ensuring stability, efficiency, and scalability of critical data platforms.

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
Desired Skill-Set

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