Blue Mantis Logo

Blue Mantis

Senior SQL DBA - Blue Mantis Canada - Toronto

Posted 10 Days Ago
Be an Early Applicant
Remote
Hiring Remotely in USA
Senior level
Remote
Hiring Remotely in USA
Senior level
Manage, monitor, and optimize SQL Server databases across multiple customer environments, ensuring high availability, performance, backups, and disaster recovery. Troubleshoot issues, perform upgrades, implement HA solutions (AlwaysOn, clustering, replication), tune queries and capacity, document procedures, and provide mentoring and cross-team collaboration. Support deployments and ensure security/compliance.
The summary above was generated by AI
We are seeking a skilled and experienced Senior SQL Server Database Administrator (DBA) to join our team. This individual will manage and optimize SQL Server databases for our customers, ensuring high availability, performance, and reliability. The role involves maintaining existing implementations, troubleshooting issues, implementing new robust SQL solutions and performing upgrades. Additionally, experience with Ansible automation, PowerShell scripting, Git workflows, and Infrastructure as Code (IaC) practices is considered an asset. This role will entail supporting databases and implementing database solutions for multiple customer environments.

Key Responsibilities
Database Administration and Support
  • Manage, monitor, and support SQL Server databases across all environments to ensure availability and performance.
  • Troubleshoot database issues and determine root cause analysis and corrective action recommendations
  • Implement and configure SQL Server high-availability (HA) solutions, including AlwaysOn, clustering, and replication.
  • Oversee database backups, restores, and failover strategies to ensure data integrity and quick recovery.
Performance Optimization
  • Troubleshoot and optimize database queries and stored procedures for better performance and responsiveness.
  • Analyze database and server logs to diagnose and resolve bottlenecks.
  • Conduct capacity planning and tuning for databases to meet performance objectives as systems scale.
Database Implementation and Configuration
  • Design and implement SQL Server database systems, ensuring adherence to best practices in security, HA, and disaster recovery.
  • Provide guidance and support for installations, configurations, upgrades, and patching.
  • Collaborate with other IT teams and developers to ensure seamless database integration with applications.
Database Security and Compliance
  • Ensure database environments are compliant with data security policies and industry standards.
  • Implement and maintain access control policies, including role-based access and data encryption.
Documentation and Knowledge Sharing
  • Document configurations, procedures, and processes in a clear, concise manner.
  • Provide mentoring and knowledge transfer to team members to increase cross-functional expertise.



Skills, Knowledge & Expertise
  • Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
  • Minimum of 7 years of experience as a SQL Server DBA, with a strong emphasis on high-availability solutions.
  • Experience with Ansible automation is a requirement.
  • Advanced expertise in Microsoft SQL Server (2019 and newer), with experience in clustering, AlwaysOn Availability Groups, and replication.
  • Strong skills in T-SQL scripting, query optimization, and performance tuning.
  • Hands-on experience with database backup, recovery, and disaster recovery planning.
  • Familiarity with PostgreSQL databases is a plus.
  • Proficiency in database monitoring tools and techniques to ensure uptime and performance.
  • Strong problem-solving skills with the ability to work independently and within a team.
  • Excellent communication skills, both verbal and written, to articulate technical issues and solutions effectively.
  • Detail-oriented, proactive, and well-organized, with a commitment to quality and continuous improvement.
Nice to Have
  • Experience with cloud-based database services (e.g., Azure SQL, AWS RDS).
  • Certifications in SQL Server or database management (e.g., Microsoft Certified DBA) are advantageous.
We consider all qualified applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
 
Reasonable accommodations will be made to enable employees with disabilities to perform the essential functions of the job. This job description is intended to describe the general nature of work being performed by employees in this job. It is not intended to be a complete list of all responsibilities, duties, and skills required.
 
Agencies/3 Parties may not solicit to any employee of Blue Mantis. Any candidate information received from any Agency/3 Party will be considered a gift and property of Blue Mantis, unless the Agency/3 Party is an Authorized Vendor of Blue Mantis with an up-to-date Blue Mantis Contract in hand signed by Blue Mantis Talent Acquisition. No payment will be made to any Agency/3 Party who is not an Authorized Vendor, nor has specific approval in writing from Blue Mantis Talent Acquisition to engage in recruitment efforts for Blue Mantis. At this time, we have no interest in onboarding any new staffing partners.

About
Blue Mantis is a leading strategic digital technology services provider with a 30+ year history of successfully helping clients achieve business modernization by applying next-generation technologies including managed services, cybersecurity and cloud. Headquartered in Portsmouth, New Hampshire, the company provides digital technology services and strategic guidance to ensure clients quickly adapt and grow through automation and innovation. Blue Mantis partners with more than 1,200 leading mid-market and enterprise organizations in a multitude of vertical industries and is backed by leading private equity firm Recognize.

Similar Jobs

2 Hours Ago
Remote or Hybrid
45K-85K Annually
Junior
45K-85K Annually
Junior
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Handle inbound and warm insurance sales leads remotely, consult with customers to recommend Property & Casualty coverage, close sales, complete paid licensing and training, meet schedule and workspace/connectivity requirements, and use provided equipment to maintain performance and quality.
Top Skills: CableDslFiberHigh-Speed Internet (100 Mbps Down/20 Mbps Up)Pc
4 Hours Ago
Remote or Hybrid
156K-281K Annually
Senior level
156K-281K Annually
Senior level
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Lead the evolution of Anaplan into a cohesive enterprise planning platform. Define architecture standards, integrations (Snowflake/IDMC/AWS), governance, roadmaps, and mentor teams. Provide technical oversight, incident support, and drive adoption of best practices, security, reliability, and AI inclusion in planning.
Top Skills: AnaplanAWSCRMData WarehouseErpIamIdmcOneglS3Snowflake
4 Hours Ago
Remote or Hybrid
45K-85K Annually
Junior
45K-85K Annually
Junior
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Handle inbound and warm insurance leads, consult customers on coverage needs, match products to convert sales, complete paid licensing and training, work remote with set shift schedule, meet work-at-home technical requirements, and pursue sales targets with integrity and customer focus.

What you need to know about the Seattle Tech Scene

Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.

Key Facts About Seattle Tech

  • Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Amazon, Microsoft, Meta, Google
  • Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
  • Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Madrona, Fuse, Tola, Maveron
  • Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account