DistantJob Logo

DistantJob

Senior SQL DBA

Posted One Month Ago
Remote
Hiring Remotely in CAN
Senior level
Remote
Hiring Remotely in CAN
Senior level
Serve as the primary DBA contact for critical production issues across customized, multi-tenant SQL Server environments. Diagnose performance and availability problems, optimize queries and stored procedures, monitor database health, build alerting and runbooks, maintain test-environment readiness, review database-related code changes, perform backups and patching, and document operational procedures. Collaborate closely with developers while providing production support during US business hours.
The summary above was generated by AI

Q - What did the DBA say to the Developer?
A - It doesn't matter, he wasn't listening anyway
Q - What did the Developer say to the DBA?
A - It doesn't matter, the answer is "No".

Enough with the humor! Let's get to the point. 

DistantJob is hiring a Senior SQL DBA for one of our clients, a growing US-based SaaS company serving 150+ enterprise clients on a highly customized, multi-tenant platform.

This isn't a "big data" role — the databases themselves are modest in size. The real challenge is complexity: each client runs on their own database instance, and while most of the schema and logic is standardized, a meaningful portion is customized per client. That means no two performance issues look exactly alike, and a one-size-fits-all runbook doesn't cut it here.

What you'll do:

  • Serve as the primary point of contact for critical database issues during US business hours, diagnosing and resolving performance, reliability, and availability problems
  • Partner with developers to design, review, and optimize SQL queries, stored procedures, and database logic — and coach the team on performance best practices
  • Proactively monitor database health across client environments, building alerting thresholds, runbooks, and dashboards to catch risks before they become incidents
  • Own the database side of test-environment readiness — syncing test databases, validating configuration, and building automation to reduce manual setup work
  • Review and approve database-related pull requests, maintaining coding standards and evaluating changes for performance, risk, and backward compatibility
  • Perform routine database maintenance (backups, patching, capacity planning) during business hours to avoid production disruption
  • Document recurring issues, resolutions, and operational procedures for the team

What we're looking for:

  • 7+ years of experience as a DBA, with real production support experience — not purely development-side database work
  • Strong SQL Server / T-SQL skills, including query optimization and execution plan analysis
  • Comfort working across highly customized, multi-instance environments rather than a single standardized database
  • Genuine interest in both reactive incident response and proactive, collaborative dev support — this role is a mix of both, and that balance is expected to shift over time as processes mature
  • Azure and .NET/ORM familiarity a plus

Schedule: Primarily CST hours (EST also considered) — this role exists specifically to extend coverage into the US afternoon.

Why this role: You'll join a team that's intentional about long-term growth for this position — not just filling a support ticket queue, but building someone into a trusted, embedded part of the development process.


If you meet these qualifications and are ready to contribute your expertise to a dynamic team, we encourage you to apply!

Similar Jobs

An Hour Ago
Remote
Ontario, ON, CAN
Entry level
Entry level
Artificial Intelligence • Cloud • Information Technology • Consulting
Leads HPE’s Canadian Presales Engineering organization, setting strategy, managing budgets and resources, developing technical sales leaders, and driving revenue growth. Builds executive customer and partner relationships, aligns presales teams with sales and product organizations, influences product direction, and ensures operational excellence across Canada and global counterparts. The role requires strong business acumen, enterprise technology expertise, cross-functional leadership, and travel across Canada, the United States, and internationally.
Top Skills: AIEnterprise TechnologyHybrid CloudNetworking
3 Hours Ago
Remote
Canada
Junior
Junior
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Build REST APIs, customer-facing React components, backend monitoring, CI/CD pipelines, and content-management integrations. Collaborate with engineering, UX, and visual design teams while developing full-stack solutions using JavaScript or TypeScript, React, Node.js, server technologies, and cloud platforms. The role is fully remote but limited to candidates located in Canada within the PST or MT time zones.
Top Skills: AWSCi/CdContent Management SystemsCSSDockerEs6ExpressFreemarkerGitHTMLJavaJavaScriptNginxNode.jsNpmReactRest ApisRustSassTypescript
3 Hours Ago
Remote
Canada
Senior level
Senior level
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Lead complex backend engineering projects from design through launch, solve architecture and high-risk technical problems, conduct code reviews, develop scalable microservices and distributed systems, mentor engineers, and collaborate across teams. The role requires strong experience with backend applications, prominent programming languages, public cloud platforms, databases, software architecture, agile development, and performance trade-offs. Candidates must be located in Canada within the PST or MT time zones.
Top Skills: AgileAWSAzureCassandraDistributed SystemsDynamoDBGCPGoIaasJavaKotlinMicroservicesOraclePaasPostgresPythonSaaSScalaScrumXp

What you need to know about the Montreal Tech Scene

With roots dating back to 1642, Montreal is often recognized for its French-inspired architecture and cobblestone streets lined with traditional shops and cafés. But what truly sets the city apart is how it blends its rich tradition with a modern edge, reflected in its evolving skyline and fast-growing tech industry. According to economic promotion agency Montréal International, the city ranks among the top in North America to invest in artificial intelligence, making it le spot idéal for job seekers who want the best of both worlds.

Key Facts About Montreal Tech

  • Number of Tech Workers: 255,000+ (2024, Tourisme Montréal)
  • Major Tech Employers: SAP, Google, Microsoft, Cisco
  • Key Industries: Artificial intelligence, machine learning, cybersecurity, cloud computing, web development
  • Funding Landscape: $1.47 billion in venture capital funding in 2024 (BetaKit)
  • Notable Investors: CIBC Innovation Banking, BDC Capital, Investissement Québec, Fonds de solidarité FTQ
  • Research Centers and Universities: McGill University, Université de Montréal, Concordia University, Mila Quebec, ÉTS Montréal

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account