MS SQL Developer

Job Description
We are seeking an experienced MS SQL Developer to design, optimize, and maintain our enterprise Microsoft SQL Server database environments. You will build robust database architectures, write high-performance T-SQL code, and manage data integration processes. The ideal candidate ensures maximum database uptime, speed, scalability, and security.

Core Responsibilities

T‑SQL Development:
Write, debug, and optimize complex stored procedures, triggers, views, and user‑defined functions.

Database Tuning:
Analyze execution plans, profile query activity, and resolve deadlocks or CPU bottlenecks.

ETL Pipeline Management:
Build and maintain data pipelines.

Schema Design:
Develop relational data models, configure table partitioning, and implement advanced indexing strategies.

Reporting Solutions:
Develop stored procedures to pull data formatted for Reporting Services.

Required

Skills & Qualifications

Education:

Bachelor's degree in Computer Science, IT, or equivalent experience.

Experience:

5+ years of dedicated experience using Microsoft SQL Server environments.

Syntax Mastery:
Deep understanding of Transact‑SQL (T‑SQL) extensions and relational logic.

Tool Proficiency:
Mastery of SQL Server Management Studio (SSMS), SQL Profiler, and Extended Events.

Integration

Skills:

Familiarity with programming languages like C#, .NET, or Python for database connectivity.

The base compensation range for this role in the posted location is: 79,000 to 90,000.

The company provides compensation range information in accordance with applicable national, state, provincial, and local pay transparency laws. The base compensation range listed for this position reflects the minimum and maximum target compensation the company, in good faith, believes it may pay for the role at the time of this posting. This range may be subject to change as permitted by law.

The actual compensation offered to any candidate may fall outside of the posted range and will be determined based on multiple factors legally permitted in the applicable jurisdiction.

These may include, but are not limited to:
Geographic location, Education and qualifications, Certifications and licenses, Relevant experience and skills, Seniority and performance, Market and business consideration, Internal pay equity.

It is not typical for candidates to be hired at or near the top of the posted compensation range.

In addition to base salary, this role may be eligible for additional compensation such as variable incentives, bonuses, or commissions, depending on the position and applicable laws.

Benefits

Paid time off based on employee grade (A‑F), defined by policy:
Vacation: 12‑25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave

Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)

Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)

Life and disability insurance

Employee assistance programs

Other benefits as provided by local policy and eligibility

Important Notice
Compensation (including bonuses, commissions, or other forms of incentive pay) is not considered earned, vested, or payable until it becomes due under the terms of applicable plans or agreements and is subject to the company’s discretion, consistent with applicable laws. The Company reserves the right to amend or withdraw compensation programs at any time, within the limits of applicable legislation.

Disclaimers
The company is an Equal Opportunity Employer encouraging inclusion in the workplace. The company also participates in the Partnership Accreditation in Indigenous Relations (PAIR) program which supports meaningful engagement with Indigenous communities across Canada by promoting fairness, accessibility, inclusion and respect. We value the rich cultural heritage and contributions of Indigenous Peoples and actively work to create a welcoming and respectful environment.

All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.

This is a…