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.