SQL Server Database Administrator

**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.
• 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.

Pay: $100,000.00-$125,000.00 per year

Additional pay:

• Bonus pay
• *Benefits**:
• Dental care
• Extended health care
• Paid time off

Flexible language requirement:

• English not required

Schedule:

• Monday to Friday

Application question(s):

• Are you open to working Hybrid, 3-4 times a week in North York?

Work Location: Hybrid remote in North York, ON M2N 5Y7