Company Overview:
Join our dynamic team at Scale Insights, a fast-growing SaaS company managing over 2,200 Azure SQL Server databases with 10 TB of data across 6 elastic pools. This role ensures our databases are highly optimized, reliable, and cost-efficient, delivering blazing-fast experiences to our users.
Role Overview:
We seek an experienced Azure Database Performance and Optimization Engineer passionate about performance optimization, database efficiency, and cost reduction in the cloud. In this role, you will address complex challenges like connection pool limits, high database CPU usage, and query timeouts. You'll work on refactoring database structures, optimizing queries, and ensuring scalable, reliable, and fast user experiences.
Key Responsibilities:
- Index and Query Optimization: Conduct regular audits of database indexes to identify and remove redundant or low-value indexes. Implement optimization techniques such as partial indexes, indexed views, and partitioning to improve performance and reduce storage costs.
- Connection and Resource Management: Explore and implement advanced connection pooling strategies and manage alternative connection techniques to prevent connection pool limits and maintain high availability. Optimize session and connection management to avoid long-held connections and reduce resource bottlenecks.
- Database and Code Refactoring: Work closely with development teams to refactor C# code for improved load balancing, query optimization, and efficient connection handling. Redesign database structures to support better performance, scalability, and efficient resource usage.
- Automation and Scalability: Implement automated scaling mechanisms or processes to dynamically adjust database pools based on load patterns and performance thresholds. Use Azure SQL tools to monitor, diagnose, and proactively address performance issues to ensure databases run efficiently.
Qualifications and Skills:
- Azure SQL Insights and Performance Analytics: Strong expertise with Azure SQL performance tools such as Query Performance Insight, SQL Database Advisor, and Azure Monitor to identify, diagnose, and resolve performance bottlenecks.
- Connection and Session Management: Proficiency in Entity Framework Core, strategies for efficient connection pooling, handling, and session management.
- Load Balancing and Multi-Tenant Optimization: Experience with best practices in multi-tenant applications, including horizontal scaling and load distribution techniques to optimize databases for high-demand usage patterns.
- SQL Optimization: Skilled in using database profiling and query optimization tools like SQL Profiler and Extended Events. Knowledge of advanced query rewrite techniques, indexing strategies, and performance tuning for highly efficient SQL databases.
- Problem Solving and Analytical Skills: Strong problem-solving skills and an analytical mindset to systematically identify and address performance issues.
What We Offer:
- Impactful Work: Directly influence the performance and cost-efficiency of our SaaS platform, ensuring our systems remain blazing fast and cost-effective.
- Professional Growth: Impact the company's technical infrastructure and customer experience.
- Collaborative Environment: Join a team that values technical excellence and is committed to delivering a great user experience.
If you're a database optimization enthusiast passionate about Azure SQL and performance engineering, we'd love to meet you!
