SQL Database Administrator

Role: SQL Database Administrator Location: Canada(Remote) Responsibilities: Administer, monitor, and maintain SQL Server database environments. Manage database backups, restores, disaster recovery processes, and high availability configurations. Diagnose and resolve database performance issues, blocking, deadlocks, failed jobs, and capacity constraints. Optimize queries, indexes, and execution plans in partnership with development teams. Configure and maintain database security, user access, roles, permissions, and privileged access controls. Support PAM and BeyondTrust onboarding activities for database accounts, access workflows, and privileged credential management. Implement and support data masking solutions for sensitive and regulated data sets. Develop and maintain automation scripts for routine DBA tasks, monitoring, deployments, and operational support. Support patching, upgrades, migrations, and environment refresh activities. Create and maintain operational documentation, maintenance plans, and recovery runbooks. Monitor database health, storage growth, and system performance using standard DBA tools. Ensure data integrity, system availability, and compliance with internal security and operational standards. Provide production support, incident response, and root cause analysis as needed. Required Skills: 10+ years of hands-on SQL Server DBA experience in production environments. Hands on expertise in migration of SQL Server from 2016 to latest SQL version in an Always on setup. Strong experience with Microsoft SQL Server administration, backup and recovery, disaster recovery planning, and performance tuning. Solid knowledge of indexing, statistics, query optimization, and execution plan analysis. Experience with SQL Server Agent, replication, Always On Availability Groups, or clustering and CDC. Proficiency in T-SQL scripting, automation, and troubleshooting. Experience with database security, privileged access management, and auditing practices. Experience with PAM solutions and BeyondTrust onboarding for privileged database access. Experience implementing or supporting data masking for sensitive data protection. Familiarity with Windows Server environments and infrastructure coordination. Ability to work independently, prioritize effectively, and communicate clearly with technical and non-technical stakeholders. Experience supporting cloud-hosted SQL environments such as Azure SQL or SQL Server on Azure/AWS. Experience with monitoring tools such as Redgate, SolarWinds, SentryOne, or similar. Background in regulated, security-sensitive, or high-availability environments. Experience with CI/CD pipelines, deployment automation, and release support for database changes. Regards Praveen Kumar R (Praveen) Talent Acquisition Group – Strategic Recruitment Manager [email protected]| Themesoft Inc

The SQL Database Administrator will administer, monitor, and maintain SQL Server database environments, ensuring data integrity and system availability. Responsibilities include managing backups, diagnosing performance issues, optimizing queries, and supporting disaster recovery processes.

Candidates must have 10+ years of hands-on SQL Server DBA experience in production environments, with expertise in migration and performance tuning. Strong knowledge of database security, privileged access management, and experience with cloud-hosted SQL environments is also required.

Identified from the job description. Confirm important requirements above.

• SQL Server DBA
• Database Administration
• Backup and Recovery
• Disaster Recovery
• Performance Tuning
• T-SQL Scripting
• Database Security
• Privileged Access Management
• Data Masking
• Automation
• Monitoring Tools
• Cloud-hosted SQL
• CI/CD Pipelines
• Indexing
• Query Optimization
• Execution Plan Analysis

Minimum experience

10+ years