Experience: 3-6 years
Description:
You will be responsible for optimizing and maintaining the performance of our single/multi-tenant SaaS database environment. You'll proactively identify and resolve bottlenecks caused by indexing issues, inefficient queries, and suboptimal database schemas. You'll have the opportunity to work in a dynamic environment where database configurations and usage patterns evolve as the demands of our clients change.
Key Responsibilities:
- Proactive monitoring and analysis of Azure SQL databases to identify potential performance issues.
- Diagnose and resolve database performance problems, including query tuning, index optimization, and schema refactoring.
- Develop and implement strategies to ensure the continued high performance of our SaaS environment as it scales.
- Collaborate with development teams to optimize database interactions and design, ensuring long-term scalability.
- Document and maintain clear knowledge transfer within the team.
Required Skills:
- Proficiency in Azure SQL Database administration. This includes a strong understanding of Elastic Pools, database tuning, and performance optimization techniques.
- Expert-level knowledge of T-SQL, query performance tuning, indexing strategies, and schema design.
- Experience in troubleshooting and resolving complex database performance issues in a multi-tenant environment.
- Strong problem-solving and analytical skills, with the ability to quickly identify the root cause of performance bottlenecks.
Bonus Skills:
- Experience with NoSQL databases
- Understanding of SaaS architecture and database multi-tenancy concepts.
- Proficiency in Azure SQL Database administration. This includes an understanding of Elastic Pools, database tuning, and performance optimization techniques.
