SQL Server Database Administrator

Uncharted Talent IncToronto, ON, Canada

18 days ago

Job type

Full-time

Job description

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.