We are seeking an experienced SQL Server Database Administrator to manage and maintain our production SQL Server Platform as a Service (PaaS) databases.
The ideal candidate will have a proven track record of optimizing database performance in a high-concurrency transaction environment and will play a critical role in ensuring the reliability and efficiency of our database systems.
Key Responsibilities :
- Maintain and support production SQL Server PaaS databases, ensuring high availability and performance.
- Implement and manage database partitioning strategies for large tables in live environments.
- Optimize and reduce the number of indexes on high I / O tables based on usage analysis.
- Work with and optimize .NET Entity Framework queries to enhance application performance.
- Perform query plan analysis and maintenance to ensure efficient execution of database queries.
- Utilize Azure portal features for database maintenance, monitoring, and automation.
- Conduct index maintenance, analyze disk fragmentation, and monitor database size for optimal performance.
- Collaborate with developers, DevOps, and technical leads to effectively implement, test, and deploy database updates.
Qualifications :
- Minimum of 7 years of experience in maintaining production SQL Server databases.
- Advanced knowledge of SQL Server PaaS management and performance tuning techniques.
- Proven experience with database partitioning, index optimization, and query performance tuning.
- Familiarity with Azure portal features related to database management.
- Strong analytical skills with experience in query plan analysis and database performance monitoring.
- Excellent communication skills, with the ability to work collaboratively across teams.
- Experience managing Production databases in a similar high-concurrency environment.
Nice to Have :
- Knowledge of data warehousing concepts and best practices.
19 hours ago