Senior SQL DBA

Blue Mantis

Senior SQL DBA managing and optimizing SQL Server databases for Blue Mantis. Troubleshooting issues and implementing high-availability solutions in customer environments.

Posted 7/16/2026full-timeRemote • 🇨🇦 CanadaSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates advanced expertise in Microsoft SQL Server, including high-availability solutions, performance tuning, and disaster recovery planning. Proficient in T-SQL scripting and database monitoring, with a strong focus on compliance and security best practices.

Highest-signal resume keywords

Microsoft SQL Server (2019 And Newer)High-Availability SolutionsT-SQL ScriptingAnsible AutomationDatabase Backup And Recovery

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQL Server Database ManagementPerformance TuningQuery OptimizationDisaster Recovery PlanningDatabase MonitoringCapacity PlanningStored Procedure OptimizationRoot Cause AnalysisData EncryptionRole-Based Access Control

Soft Skills

Problem-SolvingCommunicationDetail-OrientedProactiveOrganizational

Tools & Technologies

AnsibleAlwaysOnClusteringReplicationPostgreSQLAzure SQLAWS RDS

Certifications & Qualifications

Microsoft Certified DBA

Industry Keywords

Data Security PoliciesDisaster RecoveryDatabase IntegrationCompliance StandardsBest Practices

Tech Stack

Tools & technologies

AnsibleAWSAzureCloudMS SQL ServerPostgresSQL

About the role

Key responsibilities & impact

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.
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.
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.
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.
Document configurations, procedures, and processes in a clear, concise manner.
Provide mentoring and knowledge transfer to team members to increase cross-functional expertise.

Requirements

What you’ll need

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.

Benefits

Comp & perks

Job Benefits 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score