DistantJob Logo

DistantJob

Senior SQL DBA

Posted 2 Months 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

4 Hours Ago
In-Office or Remote
Canada
Junior
Junior
Big Data • Information Technology • Software • Analytics • Energy
Provide frontline support for Enverus software applications through phone, email, and virtual screen sharing. Diagnose and resolve technical issues, manage customer cases, document and escalate product problems, educate users on navigation and product value, communicate updates, and relay client feedback to internal teams. The role requires strong communication, troubleshooting, organization, conflict resolution, collaboration, and customer-service skills, with rotating holiday support possible.
Top Skills: Generative AiSaaSVirtual Screen Sharing
Senior level
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Lead a team of enterprise sales engineers supporting cybersecurity platform sales. Explain security architectures, deployments, and solution gaps to prospects and customers, serving as a technical bridge between Sales, Marketing, Support, Engineering, and external stakeholders. The role requires significant endpoint or network security expertise, strong communication and presentation skills, executive-level engagement, technical understanding across major operating systems, and willingness to travel. Montreal residency is required.
Top Skills: Antivirus (Av)Artificial IntelligenceAWSAzureBashDigital ForensicsEndpoint Detection And Response (Edr)FirewallsGCPHips/IdsIncident ResponseLinuxmacOSMalware AnalysisOsi ModelPowershellPythonSandbox AnalysisSIEMThreat IntelligenceVdiVirtualizationWindows
9 Hours Ago
Remote or Hybrid
Canada
Expert/Leader
Expert/Leader
Artificial Intelligence • Cloud • Payments • Software • Business Intelligence • Generative AI • Automation
Leads product operations by enabling AI workflows, owning product tooling and infrastructure, governing integrations and access, managing vendors, standardizing product lifecycle processes, and building measurement systems. The role also stewards the product operating system, drives adoption and change management, facilitates cross-functional feedback mechanisms, and establishes metrics for operational effectiveness.
Top Skills: Ai AgentsAi AutomationsAi ConnectorsAi ToolsDashboardsJira Product DiscoveryPendoSalesforceSession ReplaySystem Integrations

What you need to know about the Toronto Tech Scene

Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account