Staff Database Engineer

Job Description
Please note: Due to Government of Canada regulatory requirements, this position requires the successful completion of a Government of Canada Reliability Status screening as a condition of employment. The screening process requires 5 years of verifiable background history. This includes identity verification, education verification, a criminal record check, and a credit check. Candidates must be eligible to obtain and maintain Reliability Status, which generally requires Canadian citizenship or Canadian permanent resident status. Employment is contingent upon successful completion and maintenance of the required screening.
Our SWAT (Software Action Team) ensures the production stability of our customer application(s) and infrastructure services from an operations perspective. Our engineers are responsible for production stability and "champions at all service levels” and act as the last level of support for our customers (internal and external).
The ideal candidate for this position is a software engineer with a strong background in database technologies, performance analysis, and strong troubleshooting skills. The candidate must have a passion for chasing issues of complex systems running under dynamic, real-world loads. You will work in a fast-paced, innovative environment that allows direct influence on the organization and all our customers. In this role you will support the infrastructure by learning the platform from end to end.
What you get to do in this role:
Become an SME in production database troubleshooting, ServiceNow instance performance issues and Linux performance analysis on prem and on Hyperscaler
Own complex incident RCA across multi-tenant PostgreSQL/MariaDB fleets at scale
Develop observability and automation to prevent recurrence of critical issues
Influence infrastructure decisions that shape our multi-tenant cloud platform
Mentor and collaborate with engineers across operations, support, and developmen
Strong experience with performance and stress testing tools and approaches for driving realistic customer simulations
5+ years of database management and performance tuning
5+ years of experience supporting or testing large scale web-based distributed applications on containers such as Apache/Tomcat, JBoss, Web Logic, and Web Sphere in a Unix environment
3+ years of experience developing on a SaaS, PaaS, or Cloud Infrastructure product/solution
Proven experience with concurrency, multithreading, and distributed system architectures
Unix skills: including development, navigation, file manipulation, permissions, searching/finding files and text contents, and administrative actions
Strong problem-solving and analytical skills with an aptitude for learning new technologies
developing and deploying mission critical software
Bachelor's degree in Computer Science or Information Systems or equivalent technical discipline, or similar work experience.
Eagerness to learn everything about the ServiceNow Platform
To be successful in this role you have:
Experience in leveraging or critically thinking about how to integrate AI into work processes, decision-making, or problem-solving. This may include using AI-powered tools, automating workflows, analyzing AI-driven insights, or exploring AI's potential impact on the function or industry.
6+ years of experience on multiple relational databases (especially on Postgres database)
The database experience should include but not limited to MVCC, transaction management, vacuum mechanics, database and query performance tuning, buffer management, WAL architecture, backup/restore etc.
Desired skills:
Scripting: basic shell scripting, Python, Javascript, Ansible
Formal experience on a DevOps(Kubernetes and CICD pipeline) or Performance or support team supporting a Web-Based application is desired
Demonstrated experience leading individual projects, including scheduling and reporting
Formal experience on a DevOps or Performance or support team is desired
For positions in this location, we offer a base pay range of CAD 109,400-191,500 plus equity (when applicable), variable/incentive compensation and benefits. Sales positions generally offer a competitive On Target Earnings (OTE) incentive compensation structure. Please note that the base pay shown is a guideline, and individual total compensation will vary based on factors such as qualifications, skill level, competencies and work location.
We also offer health plans, an RRSP Plan with company match, ESPP, matching donations, family and medical leave programs and Annual vacation: 20 days per year, accrued every pay period at 6.67 hours.
Compensation is based on the geographic location in which the role is located and is subject to change based on work location.
JV20

Employment type
Full-time

Work arrangement
Hybrid