Sql server Jobs in Cole Harbour, NS

At Stantec, we have some of the world’s leading professionals passionate about enabling our business to be its best. Our business teams include finance, procurement, human resources, information technology, marketing, corporate development, HSSE, real estate, legal, and practice services. We bring diverse backgrounds, skills, and expertise and create a caring culture where everyone can thrive. Through teamwork and collaboration, we’re building a stronger, more resilient Stantec every day.

We are seeking a seasoned Senior Full Stack Developer to join our engineering team. This role is designed for a technical powerhouse who excels in building modern web applications, balancing the power of robust Python backends with sophisticated frontends and emerging AI-driven architectures.

Key Responsibilities

• Design and maintain robust, scalable web applications using Python (Django or similar frameworks).

• Build dynamic, responsive user interfaces utilizing Angular for complex SPAs, or HTMX and Alpine.js for modern, high-performance reactive workflows.

• Develop and maintain comprehensive end-to-end testing suites using PyTest and Playwright to ensure cross-browser reliability. Implement and execute load testing strategies using Locust.io to validate system scalability.

• Optimize and manage large-scale databases Oracle, MS-SQL Server and Postgres, ensuring data integrity and high performance.

• Deploy and manage applications in secure, privately hosted containerized environments, specifically OpenShift or Kubernetes (K8s).

• Design and implement agentic development approaches, integrating LLMs and autonomous agents into application workflows to enhance automation and user experience.

Required Qualifications

• Experience: 5+ years of professional software development experience.

• Python Mastery: Expert-level knowledge of Python and at least one mainstream framework (e.g., Django, FastAPI, or Flask).

• Front-End Proficiency: Highly desirable experience with Angular, HTMX, and Alpine.js. You should be comfortable choosing the right tool for the specific UI/UX requirement.

• Testing & Validation: Proven experience with PyTest, Playwright, and Locust.io.

• Database Expertise: Extensive experience with Oracle, MS-SQL Server PostgreSQL, including advanced querying, schema design, and performance tuning.

• Proven track record of working with Docker and orchestration platforms like Kubernetes or OpenShift.

• Past experience with Java (JSF, ADF) or C# is a significant plus, providing valuable context for system migrations.

Preferred Skills (Nice to Have)

• Experience working in high-velocity, Full Stack Agile environments.

• A passion for guiding junior developers and conducting constructive code reviews.

• Ability to take ownership of projects and work independently with minimal supervision.

Education

Bachelor’s degree in Computing Science or equivalent required

Why Join Us?

Stantec is a place where talented people come together to build meaningful solutions, innovate boldly, and make a lasting impact. You’ll work with modern technologies, contribute to AI‑driven architectures, and help shape the future of our digital platforms. Join us and redefine your personal best.

Pay Range:

• Locations Outside of Lower Mainland - BC & Various locations in Ontario-$74,400.00 - $107,900.00 Annually

• Locations in Lower Mainland - BC, GTA & Ottawa Ontario-$78,900.00 - $114,400.00 Annually

Pay Transparency: In compliance with pay transparency laws, pay ranges are provided for positions in locations where required. Please note, the final agreed upon compensation is based on individual education, qualifications, experience, and work location. At Stantec certain roles are bonus eligible. Actual compensation for part-time roles will be pro-rated based on the agreed number of working hours per week.

Benefits Summary: Regular full-time and part-time employees (working at least 20 hours per week) will have access to health, dental, and vision plans, a wellness program, health care spending account, wellness spending account, group registered retirement savings plan, employee stock purchase program, group tax-free savings account, life and accidental death & dismemberment (AD&D) insurance, short-term/long-term disability plans, emergency travel benefits, tuition reimbursement, professional membership fee coverage, and paid time off.

Temporary/casual employees will have access to group registered retirement savings plan, employee stock purchase program, and group tax-free savings account.

The benefits information listed above may not apply to union positions because benefits for such positions are governed by applicable collective bargaining agreements.

Primary Location: Canada | AB | Edmonton
Other Locations: Canada | NS | Halifax
Organization: BC-1374 IT Services-CA Corporate
Employee Status: Regular
Business Justification: Replacement
Travel: No
Schedule: Full time
Job Posting: 26/05/2026 12:05:18
Req ID: 1005854