This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Database Administrator (MS SQL) based in Canada. This temporary remote role offers the opportunity to manage and optimize high-volume Microsoft SQL Server environments supporting globally distributed digital products. You will work with databases ranging from tens of terabytes, tackling complex performance, reliability, and scalability challenges. The position combines advanced T-SQL development with deep database administration and SQL Server architecture expertise. You will investigate execution plans, optimize queries and indexes, and address bottlenecks across memory, disk, locking, and system performance. You will also maintain high-availability infrastructure and help technical teams access and work with critical data. This role is well suited to an experienced SQL professional who enjoys solving complex database problems and working independently in a high-load environment. This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Database Administrator (MS SQL) based in Canada. This temporary remote role offers the opportunity to manage and optimize high-volume Microsoft SQL Server environments supporting globally distributed digital products. You will work with databases ranging from tens of terabytes, tackling complex performance, reliability, and scalability challenges. The position combines advanced T-SQL development with deep database administration and SQL Server architecture expertise. You will investigate execution plans, optimize queries and indexes, and address bottlenecks across memory, disk, locking, and system performance. You will also maintain high-availability infrastructure and help technical teams access and work with critical data. This role is well suited to an experienced SQL professional who enjoys solving complex database problems and working independently in a high-load environment. Accountabilities: - Develop advanced T-SQL scripts and solutions for Microsoft SQL Server environments spanning versions 2008 through 2019. - Review SQL code developed by other engineers, analyze execution plans, and identify and resolve performance issues, including procedures running at extremely high execution volumes. - Optimize database performance across queries, stored procedures, indexes, locking, disk utilization, memory, and related database resources. - Identify and resolve system bottlenecks, including urgent production issues that require rapid investigation and remote troubleshooting. - Support and maintain an AlwaysOn availability group consisting of primary and mirror servers. - Provide data access and retrieval support to analysts and machine learning engineers. - Perform routine database administration and maintenance activities, including archiving, recovery strategies, security policies, and data integrity checks. - Manage and support high-load databases with data volumes reaching tens of terabytes. - Monitor database and server performance proactively, identifying potential issues and taking preventive action before they result in incidents. Requirements: - Hands-on professional experience working with Microsoft SQL Server 2008–2019. - Deep understanding of Microsoft SQL Server architecture, internals, and database behavior. - Advanced T-SQL skills with extensive developer-level scripting experience, including stored procedures, user-defined functions, triggers, and distributed transactions. - Strong understanding of relational database fundamentals and data structures. - Proven ability to optimize complex SQL queries, stored procedures, and functions for performance and scalability. - Ability to analyze execution plans and identify the underlying causes of database performance issues. - Strong code-reading skills, with the ability to understand and troubleshoot SQL code written by other developers. - Ability to independently identify logic and data-related issues by analyzing database structures and source code. - Strong analytical and problem-solving skills, with the ability to investigate complex technical issues independently and respond effectively to production challenges. Benefits: - Temporary, full-time remote opportunity. - Initial compensation level or salary range shared with candidates during the recruitment process and before employment begins. - 28 calendar days of vacation per year. - 7 wellness days per year that can be used for personal recovery, household matters, or other needs without using sick leave. - Bonuses of up to $5,000 for successful employee referrals. - 50% reimbursement for professional training, international conferences, and professional meetings. - Corporate discounts for English-language lessons. - Health support of up to $1,000 gross per year per employee when corporate medical insurance is not available, which can be used toward personally purchased health insurance or eligible medical expenses for the employee and close relatives. - Workplace equipment and workspace support, including reimbursement of up to $1,000 gross once every three years for eligible home-office or coworking expenses. - Internal gamified recognition system where colleagues can receive bonuses that can be exchanged for merchandise, team-building activities, massage certificates, and other rewards. How Jobgether works: We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team. We appreciate your interest and wish you the best! Why Apply Through Jobgether? Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time. #LI-CL1

Data Base Administrator (MS SQL)

similar openings